import into sys_choice

[ggg]

I am having trouble importing into sys_choice.

when i run the below import I do not have any new rows in the sys_choice table.

below is a simple example just to understand how to configure this:

I have a field on incident, u_car, it is a choice field.

I have an excel spreadsheet with one column,

       row 1 value is "car", (this is my header)

       row 2 value is "toyota". 

i want to add this to the picklist for the car field on incident.

i create my data source so this table has a field, u_car, with a value of "toyota".

my transform map has 4 field maps:

    source field: u_car     target field: label

    source field: u_car     target field: value

    source field: script     target field: table    (returns 'incident')

    source field: script     target field: label    (returns 'u_car')

[Ankur Bawiskar]

Hi,

How many columns are there in excel?

I believe 4 one for storing choice label and 1 for choice value, 1 for choice table, 1 for table field

How your excel look like?

Regards

Ankur

[ggg]

what i need is for you to successfully do an import into sys_choice and tell me your configuration.

[Ankur Bawiskar]

Hi,

For loading data into sys_choice you would require these columns

Table                   Element     Label      Value      Sequence

u_sample_table    u_status    Failure    Failure     1

u_sample_table    u_status    Success  Success   2

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi,

Any update on this?

Regards

Ankur

[ggg]

so you are able to successfully import into sys_choice and the choices are available on your field on your form?