• State Suggested Answer
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 1763 views
  • Users 0 members are here
Options
Related

Noob: How to add options to FitToCSV.bat?

km408
over 3 years ago

I want to add some commandline options to the FitToCSV.bat file.  See developer.garmin.com/fit/fitcsvtool/commandline .

The following did not seem have any effect:

call java -jar %APP_PATH% -b %%b !c! -s -x -deg -iso8601 -e

What am I doing wrong?

When I say "did not have any effect", I mean:  I did not see any changes in the CSV file.

For example:

1. Due to -deg, I expected position_lat 445085808 semicircles to become position_lat 37.30666145682335 degrees.  Even better, I would like to see both.

2. Due to -iso8601, I expected timestamp 1025457505 to become timestamp 2022-06-29T17:18:25.000Z or the equivalent.  Even better:  I would like to see both.

3. I don't know what to expect due to -s -x -e.  But I did not see any changes.

  • 0 over 3 years ago

    Usage for the FIT CSV Tool is:
    java -jar FitCSVTool.jar <options> <file>

    It looks likes you are putting the options after the <file>. Give this a try instead:
    call java -jar %APP_PATH%  -s -x -deg -iso8601 -e -b %%b !c!

  • 0 over 3 years ago in reply to Ben FIT
    Ben FIT said:
    call java -jar %APP_PATH%  -s -x -deg -iso8601 -e -b %%b !c!

    Sorry for the late response.  Life happens!

    Thanks.  That does fix the syntax problem.

    However, the options seem to be ineffective.

    I tried to simplify them as follows:
    call java -jar %APP_PATH% -deg -iso8601 -b %%b !c!

    The result is the same as without the options, for example:
    Data  6  record  timestamp  1025457505  s  position_lat  445085808  semicircles  position_long  -1456159334  semicircles

    I was hoping for something like the following (perhaps in additional "enhanced" fields):
    Data  6  record  timestamp  2022-06-29T17:18:25.000Z  iso8601  position_lat  37.30666145682335  deg  position_long  -122.05386539921165  deg

    (Those converted values come the corresponding Garmin TCX file.)

    If you have any insights, I would appreciate them.  Otherwise, I'll chalk it up to inoperative features.

  • 0 over 3 years ago in reply to km408

    Make sure that you are using the latest version of the SDK and FIT CSV Tool, since the -deg and -iso8601 options were just added in the last release.

    Then from a terminal go to the FitSDKRelease_21.89.00 folder and run this command: 


    java -jar ./java/FitCSVTool.jar ./examples/activity.fit -deg -iso8601

    (Apparently the order of the options does not matter after all.)


    This is what I get for the first record, which is what I expect. 

    Data,0,record,timestamp,"2021-07-20T21:11:20Z",,distance,"0.0",m,speed,"1.0",m/s,heart_rate,"126",bpm,cadence,"0",rpm,power,"150",watts,altitude,"127.0",m,position_lat,"0.00000000",degrees,position_long,"0.00000000",degrees,enhanced_speed,"1.0",m/s,enhanced_altitude,"127.0",m,Heart Rate,"126",bpm,
    This is what I get without the -deg and -ios8601 options
    Data,0,record,timestamp,"995749880",s,distance,"0.0",m,speed,"1.0",m/s,heart_rate,"126",bpm,cadence,"0",rpm,power,"150",watts,altitude,"127.0",m,position_lat,"0",semicircles,position_long,"0",semicircles,enhanced_speed,"1.0",m/s,enhanced_altitude,"127.0",m,Heart Rate,"126",bpm,
    In the sample activity file the first lat/lon value is [0,0], so 0.00000000 is correct when using the -ios8601 option on that file; and [0,0] is correct without it.



  • 0 over 3 years ago in reply to Ben FIT
    Ben FIT said:
    Make sure that you are using the latest version of the SDK and FIT CSV Tool, since the -deg and -iso8601 options were just added in the last release.

    Thanks.  I don't know how to determine what version I have.  But I downloaded it on 5/21/2022.

    I'll look into this when I have time.  But frankly, I've "moved on".  The Garmin TDK file provides converted data.  And now that I've learned how to use XML files (without schemas) in Excel, the TDK file is more convenient.

    Thanks again for all you help.

  • 0 over 3 years ago in reply to Ben FIT
    Ben FIT said:
    v21.89 was released on August 5, 2022

    Thanks.  I'll definitely try it -- when I come up for air.  I'm a little overwhelmed right now.