Date Time Format Requirements for NetSuite CSV Imports

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.

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Category: NetSuite, Technical | Leave a comment

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>