Exporting climbed passes to an OpenRunner account
Tutorial prepared by Gérard Birelli (CC 5553)
Introduction
On the OpenRunner website, pass collectors can list the passes they have "climbed" and those they have "to do" as they map out their route.
A number of OpenRunner users from the Club des Cent Cols have expressed the need to import a batch of passes, or even all the passes they have climbed, into their personal space.
The following procedure shows how to import a list of collars in batch mode.
How do I create a batch of passes that have already been climbed but are not listed in OpenRunner?
There are three possibilities:
- Or manually :
In OpenRunner, all you have to do is tick the corresponding box in the pass pop-up along the route.
All the passes are therefore listed in your personal space. Once a pass has been climbed during a holiday, it is ticked off in the "Passes to be climbed" section, along with the date on which it was climbed, and then appears in the "Passes climbed" column, along with the date on which it was climbed.
- Or from a spreadsheet file such as Excel© or OpenOffice© or other with the following format:
- A column with a "Code" header
- A series of Hundred Passes codes.
The file is saved in CSV (Comma Separated Valueswhich translates into Values separated by commas).
- Or from the file of passes achieved extracted from your membership form on the Club des Cent Cols website.
There are currently two ways of accessing this file, pending a dedicated menu.
When you log on to the Club des Cent Cols website after validating your member access, you will be taken to your Member File:
- In the member file, in the menu Tools for members
Click on Save your collars. The result is shown on the following page:
- Go to the menu Made collars
This takes you to the
Before extracting this file, you need to select the valid status
PLEASE NOTE: the extracted file only includes collars in the latest version of the catalogues. Deleted collars are therefore not included. This is necessary because the collar database in OpenRunner is consistent with the latest version of the Club des cent Cols collar database.
To extract the file of all or some of the collars recorded with a specified sort, click on the Excel button.
The downloaded file is in CSV format. It contains the following information:
There's no need to process the file to get it in this form, you can import it directly into OpenRunner as it was downloaded.
Personal space in Openrunner
When you open an OpenRunner session
1 Open OpenRunner ;
2 Go to "My space" ;
3 Go to the "Club des Cent Cols" tab,
4 There is one new feature.
On the One hundred passes page you will find
There is a counter of passes crossed (total and over 2000m) and on the right a button to export the passes crossed. The exported file is in CSV format.
At the end of the year or at any other time, users can retrieve the list of passes they have climbed and submit it to their Territorial Delegate.
How do I import a batch of passes that I've already climbed but which are not listed in OpenRunner?
A batch of collars can be imported either from a spreadsheet file or from the member record, as above.
In the Cols Gravis section
Click on the "Import climbed passes" button to select the file you want to import to your computer.
