Page 1 of 1
Exporting to CSV from logbook, how to get the date?
Posted: March 21st, 2019, 10:49 pm
by roy649
If I export to CSV, I get a file with a name like concept2-result-37321928.csv. I'm guessing the digit string somehow encodes the date of the workout, but I can't figure out the format. It's certainly not a unix timestamp.
Re: Exporting to CSV from logbook, how to get the date?
Posted: July 5th, 2021, 12:22 pm
by Citroen
It does NOT encode the date. It looks like a randomly assigned sequence number (probably from something like
Code: Select all
CREATE TABLE rowdata(workoutid int NOT NULL AUTO_INCREMENT, ...)
in the SQL database that holds the workout data).