This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I’m trying to do a CSV import where one of the fields is of type Country.  Because some countries have cedillas, importing by name doesn’t work so I am trying with the two-letter country code, which seems to be the id of `country`, but I get this when I try to import:

No familiar with that particular error but countries have:
• Name
• Code
• ID


So 3 different things... maybe you need to get the real internal ID and use that with the import and not the 2 code letter...

<@U4TPAFXEC> when you setup the field mapping if you click on the setting icon next to the csv field there are advanced setting where you can set how you want to lookup the related values. (By Internal ID, Name, etc). Set this to match the values in your csv file
I would recommend using the internal ID and having the internal ID of the country in your csv file. It’s more accurate

I did try with the internal id, didn’t work as it’s non numeric.  It’s ok, saving file as UTF-8 allowed me to go on the name.

Glad it worked
As a note the internal is is different from the ID and is always a numeric value. Sometimes it’s hard to find 