File Export to .csv is changing text fields to date

  • 34Views
  • Last Post 2 weeks ago
0
votes
Net Health posted this 3 weeks ago

We have a very large file we are exporting from Skyvia to .zip/.csv. The file has two fields that are text fields but in the format of yyyy-mm-ddThh:mm:ss.000Z. On export however, Skyvia seems to be changing these to date/time fields in the format of MM/DD/YYYY HH:MM:SS. This does not work for us, we need to format to stick to yyyy-mm-ddThh:mm:ss.000Z.

I have exported directly from the source to .csv and the format sticks correctly. However, I can not export all rows from the source this way and need to use Skyvia.

 

 

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 2 weeks ago

Hello Net.

Thank you for contacting us. 

Your request has been taken in progress. We will return with feedback ASAP.

Best regards,

Yevheniia Bilotserkovska

 

 

0
votes
Yevheniia Bilotserkovska posted this 2 weeks ago

Hello Net.

Thank you for your waiting.

 

Skyvia does not convert text fields when exporting. But if your fields have date and time type, the format of such fields will depend on your locale settings. Please find detailed information about Locale here https://docs.skyvia.com/working-with-csv.html

 

Could you please clarify whether you are talking about fields CREATEDDATE and CLOSEDDATE? As we see on the screenshot below they have date format, not string.

If you were talking about some other fields, please clarify which ones and we will check them too from our side.

 

We are looking forward to your reply.

Best regards,

Yevheniia Bilotserkovska

Close