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,

On which field map you have used coalesce?

what the import says? how many skipped, inserted, updated, ignored?

Regards

Ankur

[ggg]

i did not use coalesce. i am importing only one record just to get it to work.

import says 0 skipped, inserted, updated, ignored.

so it's not doing anything.

[Ankur Bawiskar]

Hi,

Did you check import set table whether records are getting loaded from excel to it or not?

Regards

Ankur

[ggg]

yes. records are loaded.

try importing into sys_choice.

if successful tell me your configuration