ftp csv import to MySQL

  • 17Views
  • Last Post 2 weeks ago
0
votes
Andreas Steins posted this 2 weeks ago

Hello, 

I'm evaluating the Skyvia service for our services. I'm trying to import csv data created by a datalogger device to bring data into an MySql DB. 

The problem is that the service is unable to read the time channel. The csv is of following format:

"Timestamp","TZ","L1_TEROS31_W_010_1 (%vol)","L1_TEROS31_W_010_2 (%vol)","L1_TEROS31_W_030_1,...

2018/10/31 11:04:03.132,n,16.990384,15.182722,...

I've tried DT_AUTO and others. The conversion says:

An exception has occurred during data processing, the message returned from the provider is: Year, Month, and Day parameters describe an un-representable DateTime.

The account is:

andreas.steins@metergroup.de

Thank you for your Help!

 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

We could not reproduce the issue on our side. Please send us these details:

- DDL script of your MySQL table;

- sample CSV file with several lines in it.

 

Looking forward to your reply.

0
votes
Andreas Steins posted this 2 weeks ago

The problem is the timestamp as you can see in the example row. It uses slash in the data, a space and a : in the Time. Obvious, there is not matching Data type for the importer. 

0
votes
Mariia Zaharova posted this 2 weeks ago

We have contacted you by email.

Close