I need help with script to update bulk of records from excel file to form field

[Zuri]

I need to update shipping address of requested items with these data from excel file. I have more than 1000 records

Number	Address	City	State	Zip
RITM0010015	Multiple	Multiple	VA	Multiple
RITM0010016	1007 Green Street Southeast	Conyers	GA	30094
RITM0010017	254 Daniel Webster Highway #4	Nashua	NH	03060

[Oscar Lopez · Accepted solution]

What you need to do is to load the data using Import Sets.

By using a Transform Map you can change the value of the given record by using the Run Script of the transform map, something like:

For Reference field

target.variables.variable_name.setDisplayValue(source.u_incoming_value);

For Simple text field

target.variables.variable_name = source.u_incoming_value;

and don't forget to coalesce using your RITM number.

That should do the work.