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.
![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.](https://media.screensteps.com/images/profilersports/329040/1/rendered/23afcdee-38d3-4d8e-a0fa-9ec9fc34217b_display.png)
The field are blank because the system cannot interpret these formats correctly.
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 [ ]](https://media.screensteps.com/images/profilersports/329040/1/rendered/205f5ede-5e2f-40ba-9180-1b866bab9469_display.png)
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
0 Comments
Add your comment