Importing in exported multiple selection fields

If you try and import in exported multiple selection fields. They will not map correctly. The import will look as though it was successful, but the multiple selection fields will be blank when you open the actual record. Please see below for how to reformat these for reimporting.

You cannot import in Multiple selection fields without reformatting the file.

Multiple selection fields are exported with a [] around the field and a comma separates the selected options. However, you cannot import this file back into the system without reformatting these fields (as shown below)

If this data format ([ ] and , ) is imported back into the system the do NOT import correctly; the records show on the reports page with a [ ] around them and the options are not selected when the entry is opened.

To be able to import in multiple selection fields, you need to manually add in a | between the selection options and remove the [ ]

To be able to import in multiple selection fields, you need to manually add in a | between the selection options and remove the [ ]

Select the fields you want and change the comma to a bar "|"

Now save the file as a csv and redo the import

The data should appear on the system with a comma between the options

On opening, the fields will be ticked

On opening, the fields will be ticked

N.B. if you do the import and notice that brackets are appearing, you need to try and reformat the data again. Or, maybe you selected the wrong file

0 Comments

Add your comment

E-Mail me when someone replies to this comment