https://netsuiteprofessionals.com logo
#csvimports
Title
# csvimports
r

Roc127

03/24/2022, 8:55 AM
I am having trouble with a column when importing the file into NetSuite, being saved as Scientific Notion instead of as a large number or text. When you open the CSV file in Excel, one column with a large number is shown as Scientific Notation. When you open with a text editor, the large number is shown, which I guess it means that the value is stored as that. However, when importing this CSV in NetSuite, that column is still imported as Scientific Notion. I have tried several methods suggested online, such as this one https://www.teachexcel.com/excel-tutorial/convert-scientific-notation-to-numbers-in-excel_1594.html Any idea on how can I import succesfully this column into NetSuite? In other words, if I open the CSV with a text editor, and the large number is shown (no scientific notation), which I guess it means that the value is stored as that. Is there any chance that during the import NetSuite behaves like excel and somehow transform it to scientific notation?
c

Chris Corcoran

03/24/2022, 9:03 AM
@Roc127 what field type are you mapping it to in NetSuite?
r

Roc127

03/24/2022, 10:08 AM
@Chris Corcoran Free form text is the field type in NetSuite
a

AK47

03/24/2022, 12:46 PM
@Roc127 my guess is that you're saving over the file from excel. Don't even open it in excel. If you see it correctly in notepad, save the file, and import, it should work. Alternatively, you can open in excel and format the column so it no longer shows there as scientific notation and then save. I've never seen netsuite convert anything itself. If my file has scientific notation, that gets imported...if it doesn't, it doesnt
c

Chris Corcoran

03/24/2022, 12:50 PM
@Roc127 use formula text and insert the following formula (hard to read but there are 4 single quotes). CONCAT('''', {name}) substitute name with the field name you need. You can find it using the formula builder.
r

Roc127

03/24/2022, 1:16 PM
Thank you both, I will try your suggestions!
c

Chris Corcoran

03/24/2022, 1:49 PM
NP @Roc127 post an update here if the suggestions work (so others that search or follow will know).
r

Roc127

03/31/2022, 10:02 AM
Hi all, basically seeing the file correctly in notepad, saving the file, and importing it into NetSuite worked fine, as expected. My guess is that the when the issue happened (this action was done by other user), the csv file was open with excel, view with scientific notion, saved it, and then imported, thus the incorrect result we had at the beggining. Thank you for your help!
c

Chris Corcoran

03/31/2022, 10:05 AM
Thanks for the update!
2 Views