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,

yes I am able to load; check screenshots below

1)  excel file

2) existing choice values before loading

3) transform map with field maps; no coalesce field set

4) import set status; 4 inserts

5) choice values after loading data

I hope this helps and you can mark answer as correct and helpful

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?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. Thanks in advance.

Regards
Ankur

[ggg]

I have been busy with work and have not been able to return to this.

I will respond when I get back to working on this.