im trying to run a csv import for 10,000 records. i was wondering if there is a way to skip all records that are not changing and only import the ones that need to be updated
p
PNJ
02/23/2021, 7:29 PM
Do a CSV export with all of the fields that are present in the import, and then massage the data in Excel/Sheets so that you only get the changed data
l
Livio
02/23/2021, 7:33 PM
yeah but im trying to avoid that because there is so many different excel sheets that i need to import
s
Sandii
02/23/2021, 7:36 PM
what does this have to do with suitescript?
l
Livio
02/23/2021, 7:37 PM
good question
the reason my import is running slow for these 10,000 records is because im triggering some UE scripts that i need to trigger
i was wondering if there is a way to only trigger the scripts for records that are getting updated
s
Sandii
02/23/2021, 7:39 PM
Yeah its a super common pain point of mass updating data and relying upon UE to manipulate. It's hard to tell the UE to not trigger without giving it some criteria, even then it would still trigger you could just have it exit. If you passed another param to tell it to ignore the UE, then you could probably just could removed the line from the csv as an easier solution
l
Livio
02/23/2021, 7:41 PM
i understand. well thanks for your help
s
Sandii
02/23/2021, 7:49 PM
Really the best for getting the stuff updated is probably import without running scripts, and try to do what the UE need to do in a scheduled or something. Might be more work than it is worth as well, it is quite annoying to have an import running forever especially if other people rely upon the import queue to day to day stuff