Fichiers Calibre Biometrics

1

Hello,
I’d like to import files from my Calibre Biometrics tool, but currently I can only access them in CSV format. Is it possible to import them into Intervals or combine them with a .fit file that I save separately? I’m on a Mac, and the online file editing tools aren’t great.
If someone could explain this to me or see if it’s possible, I can send them the original files.
Thanks in advance.

2

I think you can using Download and upload activity streams CSV - #15 by david and a modified version of GitHub - mjcpires/combine_calibre_bio_garmin_csv: combinar 2 ficheiros CSV, um do calibre biometrics e outro de uma atividade desportiva num so ficheiro for csv export, ask the autor mjcpires · GitHub for help doing that.

3

But, if you don’t have privacy concerns about them, please share the original files.
Better for privacy, share your garmin´s Intervals.icu streams.csv without location and your Calibre Biometrics csv files.

4

Thank you for your reply.

5

Updated

Meanwhile a short cut:

Procedure: Creating a Combined Streams File for Intervals.icu

This guide outlines the steps to merge data from your Garmin Fit file (via Intervals.icu) with your Calibre CSV file using Microsoft Excel.

Prerequisites:

  • Ensure your phone/computer and Garmin/Edge device have their times synchronized recently.
  • Have the streams.csv file from Intervals.icu and your Calibre CSV file ready.

Step 1: Ensure Time Synchronization before doing a recording.

Accurate data merging requires perfectly synchronized timestamps.

  1. Reset your phone to ensure a fresh state for syncing and update from time servers.
  2. Re-sync time in your Garmin Edge device with that phone Garmin Connect.
  3. If possible, start recording on both devices at the same time.

Step 2: Prepare the CSV Files in Excel

  1. Check activity streams (power, heart rate, cadence etc.) and custom streams. Only these will be exported,
  2. Export streams.csv file from activity Data TAB
  3. Open the CSV file in Excel
  4. Open the CSV file exported from Calibre.
  5. You should now have both files open in separate Excel windows.

Step 3: Copy Data from Calibre to Intervals.icu File

  1. In the Calibre CSV file, identify and select the columns containing the data you need (e.g., Vo2, VCO2, RER…..).
  2. Copy these selected columns.
  3. Switch to the Intervals.icu streams.csv file.
  4. Click on the cell in the first empty column where you want the data to begin (e.g., column Z).
  5. Paste the Calibre data into this column, ensuring the rows align correctly with the corresponding timestamps(or Heart Rate or Power).

Important: Use the “David VO2 Master Customs Streams” and Missing some data from Tymewear - #11 by david as a reference for correct naming conventions and data mapping.

Step 4: Finalize and Upload

  1. Remove Unnecessary Columns from the combined file:
    Delete any Calibre columns you don’t need, but keep all columns from the Intervals streams.csv file to simplify the data and avoid potential conflicts.
  2. Save the modified Intervals.icu file, ensuring you maintain the CSV format.
  3. Check that column headers in the CSV match Code in custom activity streams Type definitions. Create missing custom activity stream using the headers in the combined streams.csv as Code.
  4. Upload this combined streams.csv file back to the corresponding activity on Intervals.icu.
  5. Ensure persistence: Activity>> Data>>Export Fit File
2 Likes
6

Thank you so much, I’ll try that.

7

Can also, you share your streams.csv from that file?

image
image359×431 18.9 KB

I made same progress.

1 Like
8

Yes thanks

9

Custom fields to create for Calibre Biometrics , what do you think about ?

Calibre HR,(bpm)
Calibre VO2kg,(ml/kg/min)
Calibre VCO2kg,(ml/kg/min)
Calibre VO2,(slpm)
Calibre VCO2,(slpm)
Calibre RER,(%)
Calibre Fat Burn Pct, (%)
Calibre Minute Volume, (l/min)
Calibre Calorie Rate, (cal/min)
Calibre Respiratory Rate,(breaths/min)
Calibre Tidal Volume,(l)
Calibre VeqO2,(ratio)
Calibre VeqCO2,(ratio)

Done and public

1 Like
10

Great, that’s fantastic, thank you very much.

11

Question, have you ever used node.js ?

The parsing scripit i created uses node.js command line

Usage:
node CalibreIntervalsCSV.js <intervals_file.csv> <calibre_file.csv> <output.csv>

1 Like
12

No, I don’t know. I’m just as useless with computers as I am with cycling😂 I’ll take a look later. Thank you for your patience and availability.

13

This is the updated merger

https://storage.googleapis.com/intervals-icu-images/attachments/bcb3e5c4-8777-40ff-8b32-df1335c6969c

1 Like
14

Now working great

15

@GIGANON_BASTIEN Do you have any incremental tests with Calibre to estimate VTs and VO2max?

16

I haven’t had the sensor for long; I’ve only done a 30W/2’ test.

17

Created nice Calibre Fuel Source chart

image
image1307×277 35.5 KB

2 Likes
18

Wow, amazing.

19

For Calibre users, added a Activity Chart for Calibre Test, pls share your findings.

image
image1115×701 146 KB

1 Like
20

Hello,
I follow all the suggested steps, but upon uploading the new streams.csv file, I am getting a popup notification saying “internal server error”. Any idea what is going wrong?
Thanks
Hassan