Add Question choices to a select box variable by importing an excel to question_choice?

[Mad3]

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.

[Upsilon]

Hello,

the header is not OK, you can download a template with the right columns. For sys_choice at least you shoud have: Question, value and langage if need translations

I hope, it can help

Regards

[Mad3]

Hello @Sandeep Rajput  and @Upsilon ,

Thanks for the replu!

Tried to export excel filled with data and imported able to get Value, I am failing to get Question, Text and Display name. Can see the below Images. Please make me correct.

Note: I am working in Scoped application. Since question_choice table is on global application.

Tried Like this

Note: I tried without having Question field then only it allowed import Values.

Actually tried with this not able to import even with Values

[Upsilon · Accepted solution]

@Mad3 

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

[Sandeep Rajput]

Question is a reference field, you need to put sys_id of question in excel.