Value field is not populatinginside the sys_choice table after Import the data using the excel

[jlester]

Hello, I am trying to import a record in the sys_choice table. I downloaded the template file first and then filled it up, but when importing, the field value remains blank even if it is populated. I checked the glide.import_template.field_types_to_ignore already where it has these parameters

but there is no value that is being imported. check below.

[Siddhesh Gawade]

Hello @jlester ,

The issue you're facing might be due to the fact that the sys_choice table has a composite key, which is a combination of the fields 'name', 'element', and 'value'. When importing data into the sys_choice table, you need to ensure that these three fields are populated correctly.

1. Check the 'name', 'element', and 'value' fields in your import file. Make sure they are populated correctly and match the corresponding fields in the sys_choice table.

2. Ensure that the 'name' field in your import file matches the table name in ServiceNow. For example, if you're importing choices for the incident table, the 'name' field should be 'incident'.

3. The 'element' field in your import file should match the field name in the ServiceNow table. For example, if you're importing choices for the 'priority' field in the incident table, the 'element' field should be 'priority'.

4. The 'value' field in your import file should contain the actual value of the choice you're importing. For example, if you're importing a priority choice of '1 - High', the 'value' field should be '1'.

5. If you're still facing issues, try importing a single record first to identify any potential issues with your import file.

Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.

Regards,

Siddhesh