mncoppola / ChronoPlotter

Easily generate graphs using recorded data from LabRadar, MagnetoSpeed, and ProChrono chronographs and ShotMarker e-target
MIT License
18 stars 3 forks source link

Garmin Xero C1 compatibility #6

Open memilanuk opened 6 months ago

memilanuk commented 6 months ago

Can we get import compatibility for the CSV files exported by the new Garmin Xero C1 chrono? Can supply sample files if needed.

synfinatic commented 2 months ago

+1. Garmin includes the time for each shot which is also helpful for understanding barrel warmup over long/fast strings.

mncoppola commented 2 months ago

Hi, would either or both of you be able to upload sample files for the Garmin Xero C1 Pro? I don't have a unit available to test with. Preferably multiple sample files containing different series data so I can get an understanding of the file format. Thank you

synfinatic commented 2 months ago

Hi @mncoppola, the Xero supports exporting single series at a time via CSV and multiple series via .xlsx. Here are some samples. Let me know if you'd like more.

105_hybrid_31_0gt_2024-04-06_13-36-10.csv Sessions_May_2024-May_2024.xlsx

Sessions_Apr_2024-Apr_2024.xlsx

useyournose commented 2 weeks ago

Hi @mncoppola found your page while doing research for my project useyournose/xeroconv.

There are 3 4 differerent formats around

For the fit files, get the Garmin FIT SDK and you should have a good start.

For the csv and xlsx files - thanks to the comment above - there are differences in the different languagesettings in the app and if the professional settings were activated and the bullet weight added ... i.e. my csv is in MPS and my xlsx in FPS...

  1. a fit file from my device (pls rename as gh doesn't like fit) 07-02-2024_17-25-16.fit.txt

  2. a single session from shotview as csv Marlin357_153grs_2024-07-02_17-08-09.csv

  3. multiple sesions from shotview as xls Sessions_JULI_2024-JULI_2024_original.xls

And in the meantime, people who are waiting for xero support - you can convert your files into labview format with my tiny tool here https://useyournose.github.io/xeroconv/, and fire this into the cronoplotter. I just need to fix the languagethings https://github.com/useyournose/xeroconv/issues/4 , but fit works already.

useyournose commented 2 weeks ago

Hi mncoppola, the Xero supports exporting single series at a time via CSV and multiple series via .xlsx....

hi @synfinatic have you really exported XSLX ? I just get xlsand that's what the documentation describes here Exporting Shot Data from the ShotView App.

synfinatic commented 2 weeks ago

@mncoppola Just double checked. I really am getting .xlsx. Using an iPhone to macOS via AirDrop.

$ file ~/Downloads/Sessions_Jun_2024-Jun_2024.xlsx
/Users/aturner/Downloads/Sessions_Jun_2024-Jun_2024.xlsx: Microsoft Excel 2007+

$ unzip ~/Downloads/Sessions_Jun_2024-Jun_2024.xlsx
Archive:  /Users/aturner/Downloads/Sessions_Jun_2024-Jun_2024.xlsx
  inflating: [Content_Types].xml
  inflating: _rels/.rels
  inflating: xl/_rels/workbook.xml.rels
  inflating: xl/worksheets/sheet1.xml
  inflating: xl/worksheets/sheet2.xml
  inflating: xl/workbook.xml
  inflating: xl/sharedStrings.xml
  inflating: xl/theme/theme1.xml
  inflating: xl/styles.xml
  inflating: docProps/core.xml
  inflating: docProps/app.xml
useyournose commented 2 weeks ago

nice - mine is from an android phone, and also has slight differences in the formatting...