importing csv

Hi @martineva,

Importing can be tricky and every situation is different. There are many decision points along the way. Wherever possible, I recommend hiring a programmer. Someone with experience could do it in 1-2 hours, barring any complications.

That said, I will try to help.

1. Have you worked with CSV files before?

2. What’s your favorite code editor?

3. Are you able to test on a development site first?

Please open the CSV file and copy and paste the first two lines here.

Hi !
And thanks for your quick answer and trying to help newbies ??
Soooo ….
1- Nope
2- not very skilled in any. Got some knowledge with html, css but I don’t know if it can help here. I don’t have any favorite code editor .
3 – yep
and the first two lines :

"robin","Message de robin","8","Accueil très chaleureuxRestaurant décoré avec go?tRepas copieux, raffinéUne soirée très réussie. Je vous conseil à tous ce lieu unique dans notre région.Remerciements sincères à la ma?tresse des lieux.","2007-04-24"
"Diane et Pierre","Message de Diane et Pierre","9","Une excellente cuisine ainsi qu'un accueil chaleureux. Ambiance musicale discrète et agréable.Merci pour cette soirée et félicitations aux maitres des lieux. Diane et Pierre

To import the file into WordPress, I recommend Really Simple CSV Importer. It still works well despite not being updated recently.
https://www.ads-software.com/plugins/really-simple-csv-importer/

But first, you will need to edit that file. If you are on a PC, I recommend the free version of Ron’s Editor.
https://www.ronsplace.eu/Products/RonsEditor

Tip: Don’t edit the original file. Always work on a copy.

The first line needs to be a header record that identifies the fields. Here’s an example of a header record and one testimonial:

post_type,post_status,post_date,post_title,post_content,client_name,tax_wpm-testimonial-category

wpm-testimonial,publish,2007-08-31,"The Backstreet DJ's were great.","They kept the party jumping and everyone had a good time. The music was a hit with the guests.",Roma Sison,backstreet-djs

The minimum required fields: post_type, post_status, post_date, post_content.

client_name is a custom field.

tax_wpm-testimonial-category is the testimonial category slug (not the name). That’s optional.

I think this would be your current header record:

client_name,post_title,post_id,post_content,post_date

You will need to delete the post_id field in each record.

You will need to add post_type and post_status for each record like the sample above.

It looks like line breaks and/or list items were stripped during export. For example,
Accueil très chaleureuxRestaurant décoré avec go?tRepas copieux, raffinéUne soirée très réussie.
should have at least a space between chaleureux and Restaurant. Reinstating paragraphs could be done in the file by wrapping each segment in <p>,</p> tags but it’s probably easier to do that in the WordPress post editor where you can just hit Enter to create paragraphs.

When you’re ready to import, make a backup first. If you need it, I recommend BackupGuard for this sort of thing. It allows you to backup the database only which is all you would need to restore if something goes wrong.
https://www.ads-software.com/plugins/backup/

Import the file. Check the testimonials. If something did not import properly, restore the database, fix the import file, try again.

Now THAT was a nice tuto, thank you so much for helping with step-by-step tips ??
Worked well, now I’ve got all my testimonials back, thanks again !

closed ??