Hi, I exported hrv4training data as a csv. The dates were in YYYY-DD-MM format and the HR, rmssd and sdnn were in floating point, After reformatting the dates into YYYY-MM-DD, and rounding the others, the import into intervals wellness was fine. tx.
So my sleep data and resting HR now gets automatically uploaded on the calendar however all other data such as so02, body battery, health snapshot etc from Venu2 does not even though I’ve checked off all the wellness fields.
It took me quite a bit of fiddling to sort out my hrv4training csv file such that it could be imported into intervals. The main problem was the date field, which presented entries in blocks of two formats, one of which didn’t seem to represent a date when imported into a spreadsheet. A bit of manual tinkering sorted that out. It has made me worry about how Golden Cheetah parses those data (I haven’t noticed a problem).
What would be the simplest route for importing these data automatically?
I sorted the import out in the end. I think Numbers opens the csv file in a more sensible way than Excel. I’ll email over the csv file. Maybe you can advise on auto import…
Intervals is great work BTW. I’m still learning my way around it, and I’m hoping to consolidate data from a range of platforms.
I gave this a shot today for importing my weight and it seemed to work, except the weight it shows on the Calendar is more than double the value I had in the file. I imported “209lbs” and it shows up at “461lbs”. I downloaded the Intervals CSV and it comes back as 209lbs. Can’t quite figure out what is being done to make my weight so high! Any ideas?
Please, I wanted to ask you:
If from a Tanita segmental body composition scale, which analyzes twelve body data, I were to then upload the CSV file extracted into the Wellness section of Intervals.icu, will the system automatically recognize and report the twelve data in the appropriate section? I could create a specific graph to monitor its progress over time thanks to the graphical representation, as already happens for fitness etc.
You need to add custom wellness fields for the data points you want to track. Then you will be able to upload a CSV with those fields (use the field code’s in the CSV header row) and plot them over time etc…
This CVS populates the custom field respiration rate (code “RespirationRate”):
Thanks very much for your help.
I have already created the personalized fields in the wellness area.
Now I need to better understand the structure of the CSV file with the data inside it, so that once loaded the fields are filled automatically.
if you don’t mind could you send me a CSV file with more different data?
Maybe this way I can understand whether or not I need to modify the structure of the file extracted from the scale app.
Forgive the hassle, but for me it would be important to also have a tracking of my body data, like what happens with the Forma graph.
as you can see from the screenshots, I created the various fields and tabs. I think I have to understand well whether the original structure created by the Tanita scale app of the CSV file is fine, or I have to modify it as you tell me, each time, to develop the graph over time with the repetition of the weighings.
If you download the CSV and open it in Excel or Google Sheets you can see all the columns you need to fill in. You can delete the ones you don’t want to upload:
I now have a clearer understanding of how the CSV file must be structured to be imported into the appropriate fields.
Now I just need to correct and create the fields in the wellness section of Intervals.icu to allow the right synchronization.