Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Need to update records, but can't specify the field to use as an ID
I'm importing a HUGE csv file that has 2 columns;
code
description
code is unique for each record and has the following format: 00.00.00
Because of this format I cannot map the code field to the internalId of the record.
My custom record has 2 fields, as you might have guessed they are:
code
description
Great, I can import this data fine. The problem is when I want to update the records with a revised csv file NetSuite isn't updating, but adding. I'm sure this is because there is no internalId field in my csv. I can't create an internal ID field in my csv file because there is no guarantee I will get the data in the same order again.
Steve Klett | Senior Developer
NetValue Technology
0