Import CSV384
Pages:
1
|
Thanasist2 private msg quote post Address this user | |
| I'm trying to import a csv file but it cannot parse date. The date format is "2015-12-22T00:50:23+02:00" but if i use "2015-12-22T00:50:23Z" runs fine | ||
| Post 1 • IP flag post | ||
|
MikeMills private msg quote post Address this user | |
| Try this pattern for the date parser (paste it into the Date Format combo box field): yyyy-MM-dd'T'HH:mm:ssZ |
||
| Post 2 • IP flag post | ||
|
MThomas private msg quote post Address this user | |
| I had a similar issue. GS exported my data with the datetime in this format: "2016-05-18 08:00:00 PDT" (no quotes). The only option meeting that format when I went to import the data was ISO, but it didn't like it. I had to manually remove the PDT from each point to get it to like it. | ||
| Post 3 • IP flag post | ||
Pages:
1