Skip to main content
Solved

misssing timestap error during ecommerce event import

  • February 28, 2024
  • 3 replies
  • 55 views

Forum|alt.badge.img+4

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?

Best answer by kaila.lawrence

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

View original
Did this topic or the replies in the thread help you find an answer to your question?

3 replies

Forum|alt.badge.img+31
  • Partner
  • 252 replies
  • February 28, 2024

Hello @noobmarket 

 

please check if the timestamp is in this format

YYYY-MM-DD HH:MM:SS


Forum|alt.badge.img+4
  • Author
  • Contributor IV
  • 15 replies
  • February 28, 2024

It’s in the right format:
2014-03-10 08:55:01


kaila.lawrence
Community Manager
Forum|alt.badge.img+31
  • Community Manager
  • 499 replies
  • Answer
  • February 29, 2024

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