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?
 

[arielgritti]

Hello Michael

I did reproduce your situation.

I did export the sys_choice entries to an excel. Then in the excel change the value of the language from en to es. Import the excel with load data, create a transform map and transform the data to populate the sys_choice table with the new values and works.

Take a look to the excel generated and tell if works for you.

I did it in a new London developer instance

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

[Michael M1]

Ariel -

Are you saying that the Table column was updated upon import? You verified this?

If so, that is a first - I had several others try on their instance and no one was able to do so.

There is even a YouTube video about this. I have an open INT with ServiceNow.

I took your spreadsheet and uploaded into my London.DEV instance and the table column was empty.

See attached.

and Thanks!

[arielgritti]

Hello Michael

Yes, the table field was populated.

Take a look

Ariel

[arielgritti]

The transform map:

Take a look to the u_table (from the excel) and the name.

When selected in the assitant both are "table"

Ariel