[Resolved] Importing checkboxes field with CSV

[Author]

Posts

[simonC-7]

I am trying to import a csv into a Toolset Custom Post Type using Ultimate CSV Importer Pro.

Everything has imported except the data for 'checkboxes' field types.

I have a column in the csv which contains the name of the checkboxes selected, separated by a comma (see attached).

There are hundreds of posts, so it's not feasible to enter them manually.

Is there a solution for this? I have not found one in the forum.

Many thanks.

[Nigel]

HI Simon

Note, for reference, this is the documentation page about importing content (including Types custom fields) with the Ultimate CSV Importer Pro plugin: https://toolset.com/course-lesson/import-csv-ultimate-csv-importer-plugin/

You'll note the example includes a checkboxes field, as well as instructions for preparing the CSV file (perhaps you saw that already, as it seems to describe the same as you have).

If it's not working, my guess would be that you didn't provide all of the possible options when setting up the Types checkboxes field. The import process won't add options to the checkbox field on the fly if they don't already exist. According to that document the checkboxes options should have the same values for both the option label and option value.

[simonC-7]

Thanks Nigel, I really appreciate you taking time to reply. Your very last sentence was the key to the issue:

'According to that document the checkboxes options should have the same values for both the option label and option value.'

Many thanks.

[simonC-7]

My issue is resolved now. Thank you!