Import & Export Possible Answers
Import and export possible answers using csv files.
Last updated
Import and export possible answers using csv files.
Last updated
For the question types where a list of possible answers must be provided (RADIO, CHECKBOX, DROPDOWN & SEARCH) you can import/export your list of possible answers from/to a CSV file.
The maximum number of possible answers for a single question is 300. Once that limit is reached, additional possible answers will be ignored.
SEARCH question types have an upper limit of 1000, but it is possible to have up to 5 SEARCH questions per project.
Empty values will be skipped.
Invalid symbols like "<" and ">" will be removed.
To import the list, click on the arrow next to the "Add answer button" to open the context menu:
Then click on "Import CSV". The file browser of your machine will open. Pick the csv file with the list you would like to import.
For this example, we are importing a list of world countries found here.
Once you import the file, a dialogue with some options will open up:
Here you need to pick which column in your csv file contains the list of data.
You can also specify if the first row contains headers or not and whether to append the list to the existing possible answers already on that input or to replace them with the newly imported list.
In this example, we are going to import the column "name" and replace all the existing possible answers. Our file has got the headers in the first row so we will leave the "First row contains headers" checkbox checked:
After a column is selected, click on IMPORT to proceed.
The import button is disabled until you select a column.
The list is imported successfully!
When a list of possible answers is replaced, all previous references to that list are removed since they no longer exist.
Behind the scenes, each possible answer is associated with a unique identifier (answer_ref). For example, the original list might look like this:
When the list is replaced, it might change to:
Even though the possible answers may look the same to the user, the unique identifiers (answer_ref) are different. This means there is no longer any reference linking the previous "yes" response to the new "yes" response. The system considers those to be two completely different responses when looking at the anwers_ref identifiers (58d92c2b50435, 58d92c2b50439). The answer_ref 58d92c2b50435 cannot be found anymore, so all those responses are gone.
This principle applies to any software in general. For example, if you replaced a folder with another folder of the same name on your PC, you wouldn't expect to find the previous content in the new folder, despite the folder having the same name.
To correctly add possible answers to an existing list, and therefore preserve existing responses, Epicollect5 provides the option to append possible answers to an existing list when importing the possible answers from a csv file.
As a rule of thumb, we highly recommend taking a backup of your data before making changes to an existing project.
Backing up your data ensures that you have a safety net in case anything goes wrong during the update process. This is particularly important when dealing with complex forms and datasets, as even small changes can sometimes lead to unexpected issues or data loss.
If you have a question with a list of possible answers you need to export, for example, to re-use it across multiple projects, click on the "Export CSV" option in the context menu:
For example, we had a simple list of colours to export:
Save the file where it suits you best and presto! Please note the question text will be used as the column header on the exported file:
