ErgData import vs upload should give same values for Elapsed Time

Hi Sander,

I have now analyzed a new (from Saturday) interval session on the erg and I believe I may be up to something. In the attached file I have four sheets. The first sheet (called c2api) is the csv-export from Rowsandall.com of the workout as it looks when imported to Rowsandall.com using the C2-api. The second sheet (called c2csv) is the csv-export from Rowsandall.com of the workout as it looks when uploaded to Rowsandall.com using the C2-csv exported file. Sheet 3 (called diff_api_vs_c2csv) shows the diff (for those columns that exists in both files. Look at K554 in "diff_api_vs_c2csv". It indicates some sort of formatting issue and looks at the difference ABS(c2api.K554-c2csv.F554). Then go to c2api.K554 and you can see that the row is the first row for a new interval, and for K554 the value is non-numerical "inf" (suppose it implies infinite). c2csv.F554 (shows a numerical 0). Scrolling further down in "diff_api_vs_c2csv" shows that there is another such occurrence. Sheet 4 (called "C2 original csv") is an original export from C2.

Exporting the c2api data to SportTracks yields the "missing argument" error. Exporting the workout to SportTracks when it has been uploaded to Rowsandall.com using the c2csv-data works fine. Conclusion: I believe the error may be due to the non-numerical "inf" in the c2api-dataset.

Another strange thing is the constant difference in ElapsedTime and TimeStamp. The ElapsedTime in the "c2api" and in the original C2-csv-file ("C2 original csv") is identical but the c2csv-data which comes from uploading the original C2-data as "C2 original csv" to Rowsandall.com, shows another value. Conclusion: There may be some strange behavior of Rowsandall.com when a csv-file is uploaded (the api-import is fine in this regards).

Regards, Joachim …

Comments (2)