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.
It seems like the CSV import tool should allow you to specify the field to use as the ID when updating. If I could choose 'code' from a drop down list and that would tell the CSV import tool to match new records on the code field everything would be great.
So, am I missing something or is this a limitation to the csv import?
Thanks for any help,
Steve