import choice list from a file

[Community Alums]

I have a spreadsheet with 100+ items that need to be set as a choice list on my incident form. How can I import the file into the choice list so I wont have to type all 100+ items in by hand?

Thank you

[paul_murphy]

If your choice list is going to have over 100 choices in it, you might want to think about just creating a new table and having your field be a Reference to that table.

If you definitely want to go with the choice field, you could do an import to the sys_choice table and set the static values yourself in the import script such as target.table = "incident"

[brozi]

First check out Import Sets if you havent already.

Once you have your field that you would like to add items to right click on it and show choice list. You will see a list view of the choices.

What i like to do is export that to excel, and i have my header row already complete now i can just add my data to this excel sheet. The reason i do it this way is that a choice list needs more that just the label or value. You will see table and element and those are important to match to the data you import.

One last thing you may need to add is if this field is dependent on another, if so add that to your list before you export to excel.

When you are ready to import make sure you import your data to the sys_choice table as that's where all the data is stored for a choice field.

Hope this helps..

Ian

[Community Alums]

I ran the import set using those instructions, but it did not accept the xlsx file. I recreated the file as an xls and ran the import again, which seems to have worked, but I forgot to add the header line to the xls file.

now I have a table with the first row of data as column names, and I can't seem to change the names of the fields, re-import the data over the same table, or delete the table. How do I undo it so I can try again?

Thanks

[rob_phillips]

System Import Sets -> Cleanup