search

studmuffler / android-mileage

Automatically exported from code.google.com/p/android-mileage
0 stars 0 forks source link

import exported CSV doesn't work; date not recognized #39

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. export existing data to CSV file
2. import data, select spreadsheet, check that the correct file is checked
3. enable erase database
4. Hit "next" a couple of times
5. On the "select date format" page, it shows the saved date as:
10-08-2011
(this is in DD-MM-YYYY format)

Lower on this page (under parsed date), it says:
Could not parse date!

Selecting the correct date format (DD-MM-YYYY HH:MM) doesn't make a difference.

Mileage version: 3.08
Android version: 2.3.3
Device: Samsung GT-I9100 (galaxy S2)

Original issue reported on code.google.com by guus...@gmail.com on 12 Aug 2011 at 9:30

GoogleCodeExporter commented 9 years ago 
I used the export to create a template in Excel as to import existing data.
After some toying with the date formats in Excel the import was successful.

As for the reported bug; i guess this can be solved by changing the export 
format for the date field. As long as it's documented somewhere, it shouldn't 
be a problem.

Original comment by guus...@gmail.com on 12 Aug 2011 at 10:44