Hello Community!
I have 3 select box variables. For those variables I have a excel sheet to add question choices nearly 250. Manually we it will take time to add all question choices to variables. So tried to import the excel and add the choices, I am getting below error.
I tried to import excel here
I am trying to import excel is
I think I am miss matching with text, value and Display Name.
Please correct me where I am missing to upload data.
Thanks in Advance.
For the column Text, I think that is not proposed because it's translated Text but you can fix it:
1- Go to the created datasource, it should have the same name as your file + (Uploaded)
2- Check the related Transform map and add field map for Text if missing.
3- Use the data source to import again your file
Regards
In order to import the data correctly, you need to follow the following steps.
1. Create a template first: In order to create the template, use the following steps.
On the column context menu, select the Import option
On clicking Create Excel Template, an excel file would get downloaded on your local machine.
The file would look something like the following.
Now fill the data with appropriate values from your original excel sheet and make sure to fill sys_id of question record within the question column. This will correctly map the choices to the correct question record.
Hope this helps.
