How to import category/subcategory combinations into sys_choice table.

[Michael M1]

I have 200 category subcategory combinations for the incident table. These need to be added in 7 languages...so 1400 entries! So I do not want to do this manually. 

When I try and import (insert) the excel sheet with the following columns:
Table; Element; Language; Value; Label; Dependent value; Sequence.

The data uploads but the Table column is empty. 

When I try and export a template (update) from ServiceNow with all columns the Table column still does not show up.

I know I have done this successfully in previous releases -- I am on London now -- but not sure why this doesnt work.

My current workflow is to upload this anyway and sort by 'Updated' and manually change the empty table to Incident. 1400 times. Any help?
 

[Michael M1]

Interesting.

I just got off the phone with SN and the reason this is happening is that the 'Table' column in sys_choice is no longer defined as String, but as Table Name. 

I changed it back to string and it now works on importing just fine.

I would be curious if you could check your dictionary entry for sys_choice:Table.

Thanks

[arielgritti]

Hello Michael

It's "table name"

Please, mark correct or useful if i helped you
Thanks
Ariel

[charlottet]

Hi michael_nj,

Did you find a resolution to this? I might be needing to bulk import and reference the different tables.

Is there a reason the field is defined as Table Name rather than string?