29
WARNING: Some versions of CAM2 export a *.csv file with a time stamp of this format: hh:mm:ss.ddd. Notice that
this includes decimal seconds. A problem can arise if you open the exported *.csv file with Excel and then save
it again before importing into KinAiry. If Excel opens a *.csv file and finds a cell which appears to contain a time
value, but having digits to the right of a decimal point, it can default to a mm:ss.ddd format for that cell. This will
unceremoniously lop off the “hh” (hours) value. Saving the file back again will result in corrupted time data and KinAiry
will object. If you do open a *.csv file with Excel, you can overcome this challenge by reformatting the time column as
hh:mm:ss rather than accepting Excel’s default format interpretation.
APPENDIX B: HOW TO EXPOR T DATA POINTS
FR OM C AM2 (CONTINUED)