Contributor IV

Solved

misssing timestap error during ecommerce event import

3 replies
148 views

Hi,

I am trying to follow this guide to import past orders.

Then I keep getting the error “The selected file is missing a timestamp column.” even though my csv file already has that column.

I even tried to import this sample data and got the same error:

What’s going on?

This topic has been closed for replies.

kaila.lawrenceAnswer

Community Manager

Hey @noobmarket! Which type of file are you using? Sometimes the cell type can affect how data parses. Check out this guide on formatting specifically based on file source (like Google Sheets or Excel) and try that.

If it still doesn’t work, try a different acceptable date format:

2014-09-30 13:34:08

2014-09-30 13:34:08+00:00

09/30/2014 13:34:08

09/30/14 13:34:08

09/30/2014 13:34

09/30/14 13:34

2014-09-30T13:34:08

2014-09-30 13:34:08.000001

2014-09-30T13:34:08.000001

2014-09-30 13:34:08.000001-04:00

M

Maxbuzz

Partner

Hello @noobmarket

please check if the timestamp is in this format

YYYY-MM-DD HH:MM:SS

https://theforms.pro

N

noobmarketAuthor