[Resolved] How to format Checkboxes for WP All Import File?

[Author]

Posts

[Ronald]

I found that there is an addon for WP ALL IMPORT for Toolset which is awesome! I looked over this following page and even downloaded the example CSV provided on that page, but nowhere did it say how to format checkboxes fields.

https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/

When I export the fields I get this crazy jumble of stuff in the screenshot below. I need a more human-readable way to format these.

[Minesh]

Hello. Thank you for contacting the Toolset support.

As stated with the following Dco - you need to install both WP ALL Import as well as WP All Import – Toolset Types Add-On
=> https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/#installing-the-plugins

Once you install it, you need to prepare your CSV file where the column should hold the checkboxes option value which you want to set selected.

On WP ALL Import screen, once you upload the CSV, it will show you the Toolset Types Add-on section where you can map your CSV field value. Please check the following screenshot: hidden link

[Ronald]

So it looks like you still have to use that long string in the cells, but at least the plugin allows you to map it correctly? If so, how would I dissect the following string into each of its individual options?

a:15:{s:64:"wpcf-fields-checkboxes-option-5fe3dec827bfac7ab1cc0e202fbe71fe-1";a:1:{i:0;s:7:"Shelter";}s:64:"wpcf-fields-checkboxes-option-0e185b64da089344f379bf99a16f2091-1";a:1:{i:0;s:22:"Food Bank/Soup Kitchen";}s:64:"wpcf-fields-checkboxes-option-c197ec6e57b0df3ba2060bc859f1e102-1";a:1:{i:0;s:19:"Clothing Assistance";}s:64:"wpcf-fields-checkboxes-option-3bffaeb6e7e156de0c09aaf0a7cd0965-1";a:1:{i:0;s:24:"Veteran Support Services";}s:64:"wpcf-fields-checkboxes-option-14fd9f4abc0fb34bb0183da485da44e2-1";a:1:{i:0;s:22:"Youth Support Services";}s:64:"wpcf-fields-checkboxes-option-64ab03da0120f3a9b08ab683c2417777-1";a:1:{i:0;s:14:"Medical/Dental";}s:64:"wpcf-fields-checkboxes-option-67ae42cd3b1a0e500ef36e5c11b6b1e6-1";a:1:{i:0;s:22:"Mental Health Services";}s:64:"wpcf-fields-checkboxes-option-e9eea63334398b3a2e0c24ecaa0e1927-1";a:1:{i:0;s:17:"Basic Human Needs";}s:64:"wpcf-fields-checkboxes-option-a74a8a0decfcc17f0fffc49b3fac344b-1";a:1:{i:0;s:9:"Legal Aid";}s:64:"wpcf-fields-checkboxes-option-2acda9aa74a7d3636c9517f2fd32c080-1";a:1:{i:0;s:18:"Employment Support";}s:64:"wpcf-fields-checkboxes-option-98a54cdff5f4ced61fd2cc57a54353e8-1";a:1:{i:0;s:17:"Education Support";}s:64:"wpcf-fields-checkboxes-option-b42ba52222a3198715dd7422df0f76cb-1";a:1:{i:0;s:20:"Life Skills Training";}s:64:"wpcf-fields-checkboxes-option-3ee8527da122296de0761237befa4828-1";a:1:{i:0;s:15:"Household Goods";}s:64:"wpcf-fields-checkboxes-option-29b2c3bfedee9b05eb69888f707ceda6-1";a:1:{i:0;s:9:"Giftcards";}s:64:"wpcf-fields-checkboxes-option-e62eef4d2af7916a3f06bdff28d3a733-1";a:1:{i:0;s:5:"Other";}}

From the block above, is this a single option?

a:15:{s:64:"wpcf-fields-checkboxes-option-5fe3dec827bfac7ab1cc0e202fbe71fe-1";a:1:{i:0;s:7:"Shelter";}}

And this another?

a:15:{s:64:"wpcf-fields-checkboxes-option-0e185b64da089344f379bf99a16f2091-1";a:1:{i:0;s:22:"Food Bank/Soup Kitchen";}}

If so, the beginning part changes in my export (Screenshot below) The first two start with a:15:{ but then there is a:6:{, a:5:{, etc. Is that how many options are selected in that array? If so, then The above snippets should actually be

a:1:{s:64:"wpcf-fields-checkboxes-option-5fe3dec827bfac7ab1cc0e202fbe71fe-1";a:1:{i:0;s:7:"Shelter";}}
a:1:{s:64:"wpcf-fields-checkboxes-option-0e185b64da089344f379bf99a16f2091-1";a:1:{i:0;s:22:"Food Bank/Soup Kitchen";}}

Correct? Start with a:1:{ since there is only one option in that array?

Im just trying to get my head wrapped around it all lol

[Minesh]

You should not worry about a:1 or a:15 as its serialized arrays.

You should focus on a single option like this and map the field as I shown with the screenshot.

a:15:{s:64:"wpcf-fields-checkboxes-option-5fe3dec827bfac7ab1cc0e202fbe71fe-1";a:1:{i:0;s:7:"Shelter";}}