This article is relevant if you are seeking to import date based data using CSV files into NetSuite.
Background
I wanted to share the joy one of our consultants expressed when they have finally pushed through a challenging experience working with the NetSuite tools set.
In this case, one of our senior consultants was importing CSV data into NetSuite. Should be simple enough, right? But as many know, date formats, especially with the time element, can be tricky in NetSuite. Here is the gist of what we learned.
The Excerpt from our Challenged Consultant
“I was having trouble importing a Date/Time field using CSV. No matter how I formatted the field, it rejected it. The CSV Import Guide says that it must be formatted consistently with your user preferences, and I did that, but it still didn’t work.
It turned out that the time portion HAD to have seconds on it.
So this DIDN’T work
08/15/2017 01:45 PM
But this DID work
08/15/2017 01:45:00 PM”
Let’s Help Each Other Get More out of NetSuite
When I talk with our team members about NetSuite learnings, we are never surprised about all the little nuances that “keep it interesting”. When I speak to our clients, many times I need to remember “my mental model of the system is probably right, but I better check my assumptions.” Indeed, the learning never stops when working with NetSuite.
If you have something challenging on your mind about NetSuite, let’s have a conversation.
