08-25-2008 10:03 AM
Exporting logged data to Excel loses the original timestamp. The time in the Excel file is the system time at which the Excel file was created. The entry in the spreadsheet for time X0 is just 0. The original log file (within SignalExpress) has the correct starting time for the data but that time doesn't seem to get passed to Excel. I have the timestam option set to 'Absolute'
Thanks,
Dave Detty
08-25-2008 11:36 AM
Hi Dave,
I've been able to track down the issue, and I filed a bug report to have it fixed.
It also looks like the date and time should be that of the timestamp of the first signal, and the X0 is designed to be the offset of each signal in the file from the Date and Time; which is really only useful when there are multiple signals in 1 file.
I wasn't able to find a workaround for this. I'm very sorry...
Phil
08-25-2008 11:50 AM
Hi Phil,
Thanks for taking a look and posting the request for bug fix. The workaround that I'm using is to copy the log file start time from the properties page of the file then paste it into Excel. I can then produce timestamps for each record using the respective record time as an offset.
Dave