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.
The field are blank because the system cannot interpret these formats correctly.
0 Comments
Add your comment