Importing csv to checkbox fields?

[LJR +]

I have a csv file containing data from my old email programme.

I'm importing it into Interspire.

All of the csv fields that match custom text fields are imported perfectly.

However, where I have a field in Interspire that is a custom checkbox, the data from the csv does not appear.

For instance, the checkbox, Customer, has one checkbox value of Yes.

I've tried filling the Customer field on the csv with "1" and with "Yes" but neither imports correctly.

So how do I import a csv field into a checkbox?

Also, on the same lines, is it possible to import to radio boxes? I only see the title of the radio box to match up to, not the specific radio buttons options.

Many thanks, Linda

[Teneo +]

Hi LJR

1. Importing Checkbox fields
If you have a checkbox field called "MyCheckboxfield" it will have several possible options to be checked, or at least 1 option. Let's say that you have the options "LIKE" , "DISLIKE" and "MAYBE".
Then your CSV file will have to contain a column called "MuCheckBoxField" which can contain the values "LIKE" "DISLIKE" or "MAYBE". If the importer finds a value that represents one of the options , it will check that option.

If you need to check multiple options you will seperate them by a ";"
example : "LIKE;MAYBE" will check both options in your Checkbox field.

2. Radiobox import

The exact same applies to Radioboxes , except that radioboxes will only allow you to choose 1 option, not multiple.

Hope this solves your question

Bram Van Daele
www.teneo.be

[LJR +]

Thanks for explaining this.

I had three columns in the original csv, (training, marketing and other) all talking to the same checkbox - "area of interest" so the info was overwriting itself as I imported.

Creating one column solved the problem.

Thanks, Linda

[Teneo +]

Glad it's resolved.