Offline
I'm trying to convert some historical logfiles to the Expedition format for further analysis - two questions:
(a) what format are the timestamps? They look like floating point numbers but aren't Unix timestamps (seconds since January 1, 1970)
(b) When reading logfiles does Expedition parse the header line to determine the set of fields ensuing or does it used a fixed set? I'm using the set from an example file, but there are many, many unused fields.
Offline
It is a Microsoft DATE type. It was selected many years ago as it couldnt' be easily used with Excel etc.
It doesn't look at the header. The columns are currently fixed, as in the UserChannels.h file.
Last edited by Nick (4/22/2022 1:08 pm)
Offline
Wow that did it - 2019 data is playing back with databoxes and everything. Thanks!
Google-programming (aka programming by cliche) for converting Python datetime objects:
def excel_date(date1):
temp = datetime.datetime(1899, 12, 30) # Note, not 31st Dec but 30th!
delta = date1 - temp
return float(delta.days) + (float(delta.seconds) / 86400)