Jump to content

CVS file import


This topic is 2741 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Good day FM gurus,

I am having an issue when importing a "CVS" file into FM.

I am receiving a daily file from a PBX, this file is in "CSV", one of the columns contain the start or the call and is formatted "11/9/2016 7:17", but when I do an import into FM it imports its as "2016-11-10 07:44:24", yes the field is formatted as a timestamp.

The only way I can get the import to work, is if I open the file in excel and save it at "xlsl" then it will import it as a time stamp. What am I doing wrong.

Link to comment
Share on other sites

First, we need to know what is the date format being used by your file. We also need to understand the date format of the source file: does "11/9/2016 7:17" represent Nov 9 or Sep 11?

That said, I cannot think of any combination of circumstances that would just import an input of "11/9/2016 7:17" as "2016-11-10 07:44:24". Is it possible you have a script or an auto-entered calculation in place that attempts to convert the date?

Link to comment
Share on other sites

This topic is 2741 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.