question How do I import questions into a choice list for a Catalog Request? in Developer forum

How do I import questions into a choice list for a Catalog Request?

Baggies — Fri, 04 Dec 2015 01:03:49 GMT

I read this post called "How do I import values into a choice list for a Catalog Request?", and for the life of me couldn't get it to work. I went to the question_choice" table, clicked on Import, downloaded the template, but it will not let me write to the TEXT column at all, even if I add the column to the downloaded template.

The attached is what I am trying to import. (See attached file 🙂 ) , but with a few more rows. When I try to upload with the Text column included, it ignored that column completely, yet will create a record using all the other data. But the question is not much use without the Text column. Any help appreciated. Cheers, Mark S.

Re: How do I import questions into a choice list for a Catalog Request?

Mujtaba Amin Bh — Fri, 04 Dec 2015 04:12:59 GMT

Which table are you trying to import in? Did you check if there are any data policies running?

Re: How do I import questions into a choice list for a Catalog Request?

Roq — Tue, 13 Sep 2022 15:10:29 GMT

Have similar experience and just posting this here and hope this can help.

For every import that we do, there should have an existing transform map that is available and similar to the data fields you have.

With fields not auto-populating in the question_choice table, please create a transform map sys_transform_map_list.do and make sure to create source field accordingly.

Re: How do I import questions into a choice list for a Catalog Request?

ricker — Tue, 13 Sep 2022 15:35:27 GMT

Baggies,

Looking at your spreadsheet it looks like you want to load answers to a question on a request....with only a few choices like that it's probably easier to just add them as choices to your question variable.

In order to import your list as is...you need to import your spreadsheet as a data source (Load Data in Filter Navigator) then create a Transform Map to the Target table mapping the fields (Source > Target). You would then go to your Question and point it to the records you just created as the answers (choices).

Unless you want to go through the import exercise you're better off just adding the choices in this situation.

Rick