AnsweredAssumed Answered

Import matching records script

Question asked by K.L on May 29, 2018
Latest reply on Jun 20, 2018 by jbrown

Good afternoon,


I've been having trouble with importing from an excel spreadsheet using matching records and adding remaining as new.

I would like to import a list of items to a portal, the matching field is the JobID.  When I run the script, only the last item on the list is imported, I have to delete the line and run the script again, which then imports the entire list. 


This is the import script:

Set Error Capture [On]

Go to Layout ["ImportItems" (InventoryList)]

Pause/Resume Script [Indefinitely]

Go to Layout ["Items" (InventoryList)]

Show All Records

Import Records [With dialog:off; Update matching; Windows ANSI]

Perform Find []


If anyone can tell me what I'm doing wrong?  Thanks in advance.