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]

not really. Where will the data reside at the end of this process? If the data is going to end up in the sys_choice table, what was the purpose of creating the import set table? Also, how will I then link the choice list to the data?

Thank you

[brozi]

ultimately the data should reside in sys_choice if that indeed is the table the choice field is referring too. If you filled in all the fields needed then you will see the options in the choice list after you finish loading the data.

So the process is really 2 steps, which allow you to check the data before putting it on the target table.

The source table is created upon uploading the data from excel. You can then validate the data before hand. After you know it is correct then you can create the transform and move it to the target table.

While it may seem like it takes longer it is actually a lot easier then dumping the data straight in.

[brozi]

oh, and when you select the correct source table, you will need to map the fields again.

[Community Alums]

the choice field is new, and can refer to any table. I would prefer to keep this data in its own table if at all possible, to make administrating it easier. Is there any way to do that? Am I supposed to create yet another new table to finish the import?

All I need is to have a single column in the table, plus whatever overhead columns the system requires. The data is a list of application names that can be associated with an incident. This is a temporary solution, until we get the full CI module configured.

[#6]

You need to Run the Import each time you want to run a Transform. As soon as you have 'processed' the Import Set, it can't be processed again. This is done through the Load Data module.

You can fast-track the import by changing the Data Source to an existing data source which you have already uploaded. You can do this as many times as you like, but a new Import Set will be created each time (the staging table referred to by someone else.)

The process goes Load Data ..... Run Transform. In fact after you load the data, you will have the option to run the transform from the load status page.