[Resolved] I tried using a Radio Field for a y/n field – is that the best field choice?

[Author]

Posts

[Barney Chastain]

I am trying to: import csv into toolset. import goes fine but the column containing a "y" or "n" was not imported. I'm wondering if that was because a used a radio button for that column. is there a better field type for yes/no columns?

Link to a page where the issue can be seen: staging site is hidden

I expected to see: y/n in the field

Instead, I got: an empty field (unlike the other fields)

[Nigel]

That shouldn't be a problem, because the radio field is a simple field that can only store one value.

You just need to make sure that the stored value according to the field settings correspond to the actual saved value in the database when you import the field. Don't confuse the stored value with the display label.

(Also, be aware that Types custom fields are stored with a 'wpcf-' prefix.)

It should be clear from these two screenshots.

If not, let me know and I'll elaborate further.

[Barney Chastain]

Hello Nigel,

The issue I'm having is importing the data into the y/n field. The original data is in "y" or "n" format. All the other fields (alpha and numeric) are importing correctly, but no y/n data is imported into my y/n field. Setup of types, templates, and relationships - no problem. Importing all the other data I need - no problem.

I'm using this https://toolset.com/learn/how-to-import-a-database-into-wordpress/, this https://toolset.com/learn/how-to-import-a-database-into-wordpress/, this 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/, and am using WP All Import plus WP All Import - Toolset Types Addon.

Best regards,
Barney Chastain