Import <---> Export

comments : 0

How to use the import and export feature of the training logs for training plan uploading, plan-building and other analysis.

With the import/export functionality, you will be able to:

  • Import a basic training log via a csv file to add to your actual training log. 

  • Export your actual training for other analysis on other spreadsheets.

  • Import a training plan that you created via csv to use/reuse in your planned training log and all associated features and graphs.

  • Export a BT training plan from your planned training to modify in Excel or other spreadsheet then import the modified plan to use/reuse.

Features talked about per membership level:

IMPORT YOUR TRAINING LOG OR PLAN FROM CSV

 

Creating a .csv spreadsheet for importing

To import a training plan or a training log, you will have to create and put the spreadsheet into a csv filetype (comma separated value) first while using the same cell headers as we do. 

  • Download the Import Template

  • Alternatively you can export a date range and use the headers from that as a template to import by.  Use only what is necessary.

  • Use the following headers and formatting guidelines immediately below.


If you want to import 'empty' days between workouts, you must have it in the spreadsheet.

 

*Excel Users - You can save an Excel worksheet to a .csv file by doing a 'Save As' and choosing 'Other Formats' and then 'CSV - Comma Separated Value'.

 

You only need the cell headers of things you want to import.

All times are in 'decimal minutes'.

 

Date header and format

- Log date (v1.2):  Dates can be in dd/mm/yyyy format, or sequential numbers (1, 2, 3, etc)

 

Swim headers and format

Swim time (minutes), Swim distance, Swim units, Swim pace, Swim pace units, Swim comments

* Swim units are 100.  Use them as follows: min/100yards, min/100meters 

** For 'Swim pace', you can leave empty if you have time and distance.  Pace is in decimal minutes.

 

Bike headers and format

Bike time (minutes), Bike distance, Bike units, Bike pace, Bike pace units, Bike comments

*Bike pace units is either mile or km.  You can leave empty if you have time and distance.  Pace is in decimal minutes.

 

Run headers and format

Run time (minutes), Run distance, Run units, Run pace, Run pace units, Run comments

*Run pace units is either mile or km. You can leave empty if you have time and distance.  Pace is in decimal minutes.

 

Strength headers and format

Strength total time (Minutes), Strength comments

Sports headers and format
Sports comments 

Overall comments

 

Importing your training plan or training log

 

You can access the import area by going to SETTINGS --> TRAINING LOG SETTINGS --> MY TRAINING PLANS 

 

At the bottom you will see a 'Import a plan' box:

 

  

 

Then choose the .csv file you would like to upload:

 

After uploading, your import will be available in the area above the 'Import a Plan' box.

 

 

 

Imports don't go directly to your training log or your planned training.  You will then be able to edit the title, browse and edit the training days if needed.  You can also copy the plan or data into a new plan and further modify.

 

Once you are happy with the training log or training plan, you can then use the 'Upload to your training' link to get the following:

 

  

  

You can choose to import it into your actual or planned training log with several customization options.

EXPORTING

 

Go to SETTINGS --> TRAINING LOG SETTINGS --> EXPORT LOG DATA

 

Choose the actual or planned training log to export and the date range.  If you will be making modifications to a training plan and importing it, include the empty days in the export.

You will then get prompted to save the file as a .csv and you will then be able to open and modify it in Excel or other compatible spreadsheet. 

 

NOTE, there will be many more feilds of data included in an export (health, HR zones, sports, etc) .  For simplicity, we only use the basic date, swim, bike and run time/distance/pace/comments for import.

 

Download the Import Template

Rating

Click on star to vote
30504 Total Views  |  72 Views last 30 days  |  9 Views last 7 days
date: May 16, 2007