Can't import CSV using CSV Importer or CSV Importer Improved

This thread is resolved. Here is a description of the problem and solution.

Problem:
Posts were not being imported from a CSV file as expected

Solution:
The file format needed modifying so that the standard WordPress columns were listed first and custom fields listed after.

This was using the CSV Importer plugin.

Relevant Documentation:
https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

This support ticket is created 6 years, 11 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	-
-	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	-

Supporter timezone: Europe/London (GMT+01:00)

Tagged: Import and export

This topic contains 6 replies, has 2 voices.

Last updated by Nigel 6 years, 11 months ago.

Assisted by: Nigel.

Author

Posts

May 16, 2017 at 2:41 am #524548

Jeff Coen

I am trying to: Import data from a CSV into my CPT

I visited this URL:https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

I expected to see:My data get imported successfully

Instead, I got: Imported 0 posts and 0 comments in 0.00 seconds.

May 16, 2017 at 7:01 am #524597

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+01:00)

Hi Jeff

It sounds like you have a problem with how you have formatted your CSV file and headings.

It is not really a Toolset issue, but I don't mind taking a look for you.

Why don't you upload your csv file somewhere like dropbox or Google drive and share the link with me? I'll mark your next reply as private so that only I see the link (you can ignore the template asking for your WordPress site credentials).

May 17, 2017 at 7:26 am #525083

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+01:00)

Hi Jeff

I re-ordered the columns so that you had all the standard WP fields first then your custom fields (matching the order shown in the sample.csv file in the examples folder of the csv importer plugin) and tried again and it worked.

I didn't notice that documented anyway, but testing that it seems to resolve the problem, if you want to give it a try.

May 18, 2017 at 5:07 am #525569

Jeff Coen

Nigel,

Nope. I redid the columns like in sample csv and.....nothing.

Still won't import. So can you upload the file you created and I'll see if I can import it?

Because I'm starting to think the CSV file isn't the real problem.....

May 18, 2017 at 6:09 am #525584

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+01:00)

Hi Jeff

I re-imported the file to be double-sure, and it did work.

Here it is: hidden link

May 19, 2017 at 6:34 pm #526336

Jeff Coen

Cool. It worked. Let me use that in Excel as the base for all the other data and see if it takes. Thank you.

May 22, 2017 at 8:18 am #526918

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+01:00)

No problem Jeff, let me close this ticket, then.

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.