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

[Community Alums]

ok, making progress. The wiki article must be for another version of the software than what we have, but it seems similar enough that I was able to import. The transform map wiki is pretty different though, and it looks like it is trying to map the table into itself. It won't run the transform, the error message is
[QUOTE]No import sets available for the selected transform map, please create an import set first or select another transform map.[/QUOTE]
I created a module within Incident so I could see the table. All the data is there, with a State of pending. Does that mean anything?

Thank you

[Community Alums]

Also, I have mapped the Choice list's Choice table and Choice field to the new table, but I don't see any of the items in the drop down list on the form.

[brozi]

It sounds like you imported the data, but what that does is have it sit in what i call a staging table. It is there in a table, but now you need to map where the data will go.

Thats where the transform comes in, check this out

Transform map

Once you create the transform, then you can import the data, or move really more the data to the target table.

As you create each step in the process you will notice related links at the bottom of each to help you along the way.

[Community Alums]

That is what i tried to do, but when I click Run Transform i get the error. Here are attaching screenshots of the transform and error

[brozi]

Your source table and target are the same.

The source table should be the one you created when you imported the data, the target table in this case would be sys_choice...

Does that make sense?