Here is a video collage of my ice-cream, Coca Cola and cake tour of western Mallorca, earning and re-earning the jersey (!) I had some company – human, animal and insect – here and there too! Climbs such as Port Valdemossa, Port Canonge, Galilea, Es Grau, Coll n’Esteve, Gramola, Bastide, Coll de Pi feature amongst others
Advice and suggestions re Mallorca cycling for friends
Many others have been there, but I tend to keep useful links available, so here is a slightly incoherent (nothing new there, I hear the wags at the back say, not entirely unjustifiably!) collection of links and information I have collected or found useful or which others might like to look at. It suggests looking at some of my many weeks in Mallorca on Strava for ride and route suggestions, but of course there are many others!
Mallorca sportives and events
I totally recommend the Mallorca 6Points weekend (a charity event benefitting the Asdica charity in Mallorca), having done it in May 2019. The Challenge this year was 425kms around Mallorca, visiting lighthouses at the North (Cap Formentor), West (Sant Elm), South (Cap de Salines), and East (Cala Ratjada) compass points, and the highest point (Puig Major) and the lowest point (any sandy beach, Caló d’en Pellicer at Santa Ponsa in our case, where we start and finish!) We met some of the Asdica Charity beneficiaries at the finish at the Caló d’en Pellicer beach in Santa Ponsa.
For more on 6Points Challenges, and booking opportunities, see https://6pointschallenges.com/
which describes both the upcoming October 2019 Ibiza event and the May 2020 Mallorca event.
Should you wish to support me and the other riders on the Ibiza ride next weekend, please see:
Weʼre raising £1,500 to help children’s charities on Mallorca. 6Points Cycling Challenges has raised over £61,000 in 3 years. Our work continues. Please support us.
The Mallorca 312
The 312 is ever present annually; see Leslie and me there in 2018
The 312 used to be a closed road event right round the perimeter of Mallorca, but the southern part (near Palma) has now been removed (being too difficult to achieve closed roads in that busy part of Mallorca), and now the route, having started in Alcudia and followed the Ma10 over to Andratx, returns through central Mallorca to Sa Pobla, and then takes a loop down to Artá before returning back to Alcudia; it’s still 312 kms distance over closed roads. See more about the Mallorca 312 at
for the 2020 event in late April. I have done the 225kms version (in my view the more interesting, hilly part!) and there is also a 1/2 version, the 167kms.
Bike rental and services
Mallorca Cycle Shuttle
https://mallorcacycleshuttle.co.uk do airport transfers, bike transfers (eg coach out , bike back, Port Pollensa – Andratx or San Telm), bike breakdown insurance and photography, all on their website. Gary Abel is the main person there; he has developed a great set of services.
As you will see, Mallorca Cycle Shuttle also run Mallorca Photos https://www.mallorcacyclingphotos.com, and importantly, Mallorca Bike Rescue https://mallorcacycleshuttle.co.uk/mallorca-bicycle-rescue-home.html which is a get-you-home service should bike or body fail you. I ALWAYS register with it.
Pro Cycle Hire https://www.procyclehire.com is probably the gold standard in bike hire, and they not only rent bikes, but are also a bike café, and lead social rides three mornings a week plus a schedule of longer rides, including “The Lap”, a round Mallorca tour like the 312 used to be but without closed roads. There are some great historic bikes on display there too, plus a good café. Owner is Bruce Griffiths. For all about Pro Cycle Hire rides see https://www.procyclehire.com/guided-tours/the-lap/
Pro Cycle Hire rent Colnagos as well as other brands, but if you want a Pinarello (e.g. a Dogma), try the Pinarello Store tps://www.pinarelloexperience.com in Port Pollensa. The Pinarello store has a a nearby clothing outlet, usually with a sale, so there are good deals on jerseys, bibs etc.
See the link https://oqservicecourse.com/ for Ottilie Quince’s service shop next to the Pinarello Store, which is worth a visit; Ottilie does massage (you might well need it!) as well as bikes and advice. She is, by the way, an 11 times world cycling champion.
Around the corner, on the sea front, is Tolo’s restaurant, https://tolosrestaurant.com complete with Wiggins bike, another must visit. A restaurant I also happen to like that does wonderful pizzas is Casa Vila in the central square in Port Pollensa, https://casavilarestaurant.com/?lang=en
Loop rides from Port Pollensa, and in the west
The obvious first ride is up to Cap Formentor and the lighthouse. It’s a double climb ride with a handy cafe at the top of the first part, Mirador de la Creueta (Viewpoint).
From that intermediate café, there is a little climb up to a “pepper pot” structure (a bit like a Martello tower) called the Telaia Albercutx, http://www.pollensa.com/en/places/to-visit/albercutx-fortress/. It’s quite a gravelly road up there so take care, but very much worth the views. No café for once, but it’s only 3kms or so!
Then you can take on the descent on the other side, towards Formentor beach and then the second part of the climb to the lighthouse (where there is also a large cafe and great views). It’s one of the climbs where Mallorca Photos https://www.mallorcacyclingphotos.com have photographers until early afternoon (best to ride early up there to avoid traffic). They have them on Sa Calobra too, and the same applies there – go early, or go in traffic. See Fränk Schleck on Sa Calobra here.
Sa Ruta Verda
You MUST visit Sa Ruta Verda Bike Café in Caimari and say hello to owner Lennart for me. You can make a good round trip – quite hilly – via Campanet/Selva/Caimari/Sa Bataia/Lluc/Sa Calobra/col de Femenia and back to Port Pollensa. Places not to miss on that loop are Col de Sa Bataia (the Repsol service station at the top which is a bike cafe too, and does great ensaïmadas), and the Sa Ruta Verda café of course https://www.facebook.com/Sa-Ruta-Verda-907542862673060/ in the north end of Caimari which definitely DID open for the autumn again this weekend (wear your GGCC top if you have one, which Lennart recognises!). The three Monasteries further to the south are good little climbs, and again you can make a day tour of them (see https://www.cyclinglocations.com/mallorca-climbs/ for all the main climbs) of which Santuari de Cura in Randa and San Salvador near Felanitx are the better ones, the other being Petra which is nearer to Pollensa.
I’d also thoroughly recommend climbs at “my” end of the island (we have an apartment in Costa de la Calma) nearer to Andratx – eg the Es Capdella – Galilea – Es Grau loop. A fuller loop description might be Andratx/San Telm/Estellencs/Banyalbufar/Esporles/Es Grau/PuigPonent/Galilea/Es Capdella/Calvia/Santa Ponsa/Peguera/Camp de Mar/Andratx, or Andratx/San Telm/Estellencs/Banyalbufar/Esporles/Es Grau/PuigPonent/Galilea/Es Capdella/Coll de n’Esteve/Andratx, either of which take you over the main climbs in the west of the island that are on the Mallorca 312 route, and provide much of he climbing on that sportive (apart from Puig Major, mentioned below).
The Orient Valley
From Port Pollensa, Col de Soller, Bunyola, Col d’Honor and Orient itself in the Orient valley make a great (long and hilly) ride – Port Pollensa/Col de Feminia/Col de sa Bataia/Puig Major/Soller/Col de Soller/Col d’Honor/Coll d’Orient/Alaro/Lloseta/Selva/Campanet/Alcudia/Port Pollensa or some variation of that.
The Orient valley, between the south end of the Col de Soller climb/descent and Selva, is a very pretty ride, with a great ice cream and crêpe shop at Alaro called La Isla del Gelato (in Google maps) https://www.facebook.com/laisladelgelato/. If you happen to ride via Campanet either way to or from Caimari and Selva, take care, one or two of the only potholes in Mallorca are there although they are resurfacing this year, and I believe they might all be cleared up now.
In Selva (only 2kms from Caimari) there is a bike shop called the Bike Station that also rents bikes http://www.dandanellbikerental.com in the main cathedral square (also with cafés) that sells the jersey with many of the main Mallorca climbs on it!
The Ma10 across the Tramuntana – Big Daddy
As well as the recently added airport transfers, Mallorca Cycle Shuttle runs their great bike transport service, so that you can take their coach out from Port Pollensa, right across the island to the west (or to the south, or just to Sa Calobra) and ride back on the Ma10 “Big Daddy” route.
The Shuttle does have a hot summer fallow period in August but it has now opened again for the Autumn. They take you, for example, from a number of hotels the Port Pollensa area to Andratx, and also San Telm if you want to ride back coast to coast. It’s a “must do” ride, with options to descend and ascend at Port Canonge https://mallorcacycleshuttle.co.uk/port-des-canonge-climb.html, Port Valdemossa and Sa Calobra, which makes it a very long ride, so don’t book dinner in Pollensa too early!
Be sure to book the Shuttle for the day you want, it does get full nearer the time. They have some other destination drop-offs now, at least on on the south of the island (see Monasteries below).
Along that route are Estellencs, Banyalbufar, Valdemossa, Deia and Soller and Port de Soller, on the coast. It also includes the highest climb on Mallorca, Puig Major, 13kms at an average 6%, with a (dark) tunnel at the top. That is the main climb on the Mallorca 312 which ISN’T in the west of the island.
Check out my Strava rides
I wouldn’t recommend rides I haven’t done(!) so amongst the following weeks of Strava rides you will see all the ones I have mentioned and many more! See my Strava rides for 8-13th May 2016 and 16th-21st April 2017 for lots of good routes in the east, or 15-24th July 2016, 15th-23rd August and 9-12th October 2015 for the western end of the island.
Also my weeks 25th April – 1st May 2018 for the Mallorca 312 (one end of the island, Alcudia to to the other, Andratx via the Ma10, and back through the central part) and other rides during 8-16th October 2018 for general western Mallorca riding, and 14th-21st May 2019 for the 6Points right around Mallorca, visiting the 4 compass points lighthouses, the highest (Puig Major) and the lowest (any beach, Santa Ponsa in our case). See https://www.facebook.com/6PointsChallenges and https://6pointschallenges.com for more about that 440kms ride with 7000m climbing, or the Ibiza version below.
I’ll be riding on 1st-8th October 2019 in Mallorca and in particular 5/6th October in Ibiza/ Formentera https://6pointschallenges.com/6points-ibiza-2019/. Here’s the official taster video from the May 2019 edition of the 6Points Mallorca:
More useful bike ride links
Here’s a video taster of many of the climbs (& descents) in Mallorca. It’s about 30 minutes, and includes several I have mentioned. here they are with the timings in the video:
Sa Calobra descent 00:50 Sa Calobra ascent 02:58 Coll de sa Batalla descent 05:07 Coll de sa Batalla ascent 07:09 Road to Cap de Formentor 09:21 Puig Major ascent 14:20 Coll de Femenia ascent 17:54 Coll de Femenia descent 18:56 Coll de Soller south ascent 20:03 Coll de Soller south descent 21:00 Coll de Soller north descent 22:55 Coll de Soller north ascent 25:11 Coll d’Honor ascent 26:39 Puig de Santa Magdalena ascent 29:51 Puig de Santa Magdalena descent 30:45
Plus the toughest of them all, Sobremunt, Es Verger I hope to be trying in October 2019 https://mallorcacycleshuttle.co.uk/the-hardest-cycle-climb-in-mallorca.html
Plus the toughest of them all, Sobremunt (Es Verger), I hope to be trying in October 2019 https://mallorcacycleshuttle.co.uk/the-hardest-cycle-climb-in-mallorca.html
October 5/6th is only 6 weeks away!
What a way to celebrate the onset of autumn and enjoy 2 days of fantastic riding in the sun and see the two beautiful islands of Ibiza and Formentera.
We will go to some great restaurants and you will also enjoy the signature camaraderie of all 6Points events.
Get your Registration in now at https://6pointschallenges.com/6points-ibiza-2019/
Weʼre raising £1,500 to help children’s charities on Mallorca. 6Points Cycling Challenges has raised over £61,000 in 3 years. Our work continues. Please support us at https://www.justgiving.com/crowdfunding/bryan-visser-4
You can enjoy this taster weekend on Ibiza on 5/6th October (as I am) prior to the Mallorca event on 15/16/17th May 2020!
For the most focused long weekend way of doing it, you can fly out to Ibiza on Friday 4th October, and return on Sunday evening or Monday morning, having ridden on Formentera (65kms) on Saturday 5th and Ibiza (135kms) on Sunday 6th, with hotel nights at Ibiza Playa Hotel.
Anyone who wants to take my approach of going via Mallorca and ferry to/from Ibiza is welcome to let me know and keep me company Tuesday 1st -Tuesday 8th October, either side of the weekend in Ibiza.
You can’t have missed that I did the Mallorca 6Points in May this year and it was a brilliantly organised event, which I will be doing again in May 2020.
This shorter Ibiza event in October offers a perfect taster with wonderful autumn cycling weather in the Balearics, with the possibility of either direct travel to Ibiza, or spending a week travelling and cycling via Mallorca.
Just a little more after I lost the last part of a ride yesterday on my Garmin 520, which seems to be misbehaving lately. For the second time, most of my ride was recorded, but possibly as the battery life began to drop, or through some other cause, the last section of my ride after the last rest point wasn’t recorded.
Now that Strava has a new facility called “add someone who didn’t record”, if you WERE riding with someone else, they can send you their ride fit file through Strava, and you can upload that instead.
The issue with that (although it does give a good fall-back option) is that aspects of the ride personal to the other rider, such as heart rate will be missing, so you get no “suffer score” and power data.
If only part of the ride is missing, there’s another approach.
Ask a friend you were riding with to download their own ride file from their Garmin Connect as a .tcx file (it contains ALL the ride data). Their original Garmin file in their device will probably be a .fit file (for modern Garmins), not easily editable, but downloaded .tcx and .gpx ride files are alphanumeric tagged XML files, and they can be edited with a text editor. I use the free TextWrangler editor (there’s a more advanced chargeable version called BBEdit, but that isn’t necessary). I posted about TexWrangler at http://www.briansutton.uk/?p=330
Once you have your own incomplete .tcx file, and also your co-rider’s complete .tcx file, just look at the last timestamp tag in your own file between the <Trackpoint> and </Trackpoint> tags, in my case;
and then find the next recorded trackpoint in your friend’s file;
and copy that and all the subsequent trackpoints, and included tagged variables, from their file, and paste into a new file.
Then copy their preamble (everything before their first trackpoint);
<?xml version=”1.0″ encoding=”UTF-8″?>
and postamble (everything ATER their last trackpoint);
<Name>Garmin Connect API</Name>
which contain generic and summary information about the xml version and other data, and add those into the front and back respectively of the partial trackpoint file for you friend’s ride you just created and saved from.
Now you have two ride files available, with complete preambles and postambles – your own original one finishing (say) with the last trackpoint at:
and your friend’s data, from the part of the ride after that, starting with the trackpoint, say:
You will see that the Lat/Long match pretty well at the changeover point, as does the altitude, allowing for slight differences as they were recorded on different devices.
Adding the preamble and postamble data to your friend’s latter part of the ride makes it a properly constituted XML file.
Save, in your text editor, the newly created file with a .tcx extension (instead of the default .xml, to make it a recognisable ride file for Garmin and Strava.
Now go to www.gotoes.org (as I have posted about before at http://www.briansutton.uk/?p=472) and upload, and combine your own ride file, and the partial one created from your friend’s file, using the very simple dialog on that site. Just to be safe, accept the option to randomise the file ID (as if you already uploaded your original incomplete file, Strava will probably refuse another file with the same start time and owner.
That site can automatically upload the file to Strava, and this is what I used yesterday to post my Callander Sportive ride. I had already (quickly!!) made the incomplete one private, so as not to gather “kudos” onto the wrong ride posting. I have also now deleted it so as not to gather double distance on my own Strava activity reporting.
True, the last part has my friend’s heart rate etc, but we rode together, and all the location and speed data is correct; and since my own Garmin recorded everything about my ride up to 105kms or so, out of a total of 140kms, most of the data in the ride is good for me.
Finally – all ride pictures found their way into the right places on the new Strava posting. Unfortunately, Relive’s record of the ride was based on the incomplete 1o5kms ride – but hey….first world problems!
As friends will know, our family spent the greater part of 2017 in London last year caring for my mother-in-law, Laura, in her final illness. Marie Curie provided much respite caring help on several night a week, and I’ll be trying to show gratitude by riding for them in the Prudential RideLondon this year, and fundraising on their behalf.
If you have a UK mobile number, you can also just text OUEM50 and the amount to 70070. For example, if you wanted to donate £10 to Marie Curie via my JustGiving code OUEM50, you’d text:
‘OUEM50 £10’ and send to the number 70070
50 years since I graduated with my first degree from King’s College gave me the opportunity to join the Alumni weekend in London, and the sunny weather made it a real treat as I walked about early in the day in peace and quiet – much needed after recent events in London. Here are some of the pictures from the day…
I have recently seen three examples of duplicate rides on Strava, owing to the rider recording the ride both on s conventional Garmin, and also on a wristwatch device.
Usually, Strava normally doesn’t allow duplicate rides. I thin, however, there is a logical gap in their thinking – each ride has a unique serial number, and if Strava sees the same serial number it won’t accept it again.
But the same ride on two DIFFERENT devices will have, I’m sure, two different serial numbers so Strava accepts it. It doesn’t make its judgement, it seems, on the CONTENT of the ride (time and location coordinates) which would be harder to program – so i guess they haven’t bothered.
Strava used to have a restriction on when pictures could be uploaded to a ride, on the basis of some misplaced strategy to make sure people didn’t forge ride pictures!!
But it seems they haven’t even got the basics right!! They obviously need some consultancy on this…see my previous article at www.briansutton.uk on merging rides for a bit (lot) more in this kind of area.
Suffice to say that when merging two rides (recorded in two successive parts on two different devices owing to battery life issues) you have to randomise the serial number of the merged ride. Otherwise it inherits the serial number of one of the component part rides, and won’t upload because Strava spots the duplicate serial number.
A while ago, I posted an example of how to edit .gpx and .tcx files when there might have been a small corruption of the ride file preventing it from being uploaded to Strava. See it at http://www.briansutton.uk/?p=330.
This post concerns the situation when you have been on a long ride, and the battery on your first Garmin Edge (or similar) GPS has run out and you have continued the ride with a mobile phone app (such as the GarminConnect or the Strava app) or another Garmin, and therefore have two, consecutive files that need to be merged to create a single ride file.
In the past I have used the Strava recommended website and tool at http://gotoes.org/strava/Combine_GPX_TCX_FIT_Files.php which is very easy to use and usually DOES create the single file required. It IS necessary to follow the advice in the app to randomise the ID number of the ride (in case either part of the ride has been uploaded to Strava previously – duplicate IDs are not allowed and will prevent the new file from uploading). Once it IS successfully uploaded, make the old files private (on Strava) to avoid doubling up on the relevant distances and elevations! GarminConnect refuses to upload “duplicates”.
By the way, this tool does handle any mix of .gpx, .tcx and .fit files as well; .fit files are digital, not text based (saving a lot of space on the more modern Edge devices that use it as their native file format) but Gotoes (and Strava and GarminConnect) convert them to .gpx or .tcx format for display (your choice when merging) and these formats ARE viewable and editable sensibly in good text editors such as the free one I use, TextWrangler (or its upmarket and chargeable version, BBEdit).
What I have found, however, is that although this Gotoes technique DOES create a file that is readable by Strava as a complete activity, and shows the whole map of the route both for the activity (AND for a course created from it) appropriately on the GarminConnect website, it doesn’t do the whole job when you need to download the course derived from the ride activity to your Garmin for later use.
What happens is that when the second ride recording device is started, although it records latitude and longitude correctly (of course), the cumulative distance parameter starts again from zero (naturally). The effect of this is that when you try to turn the whole, Gotoes merged ride into a Garmin course, although the online GarminConnect shows the course correctly, when downloaded by Garmin Express to an Edge device as a course, the course is truncated at the changeover point where the second Garmin started recording. So the downloaded course on the Garmin device is incomplete, only showing the course from the first part of the ride.
It turned out to be quite a task to put this right, and this post describes the process. It’s a long post, but working all this out and doing the conversions took me most of a day! The author of the Gotoes app, Brian Lucido, has since very kindly and very quickly taken a look at this for me, and his comments and emerging solution are at the end of this article.
Extract from the start of the combined ride .xml file
What follows here is the .tcx file preamble (ride summary), and also the first trackpoint from the combined .tcx file created by Gotoes, but it includes in its preamble section the distance recorded by second (!) device used on a ride when the first ran out of battery life, not the complete distance. I am surprised it used the second Garmin (shorter) distance for this ride (Andratx to Port Pollensa), because in my first attempt at doing this for another ride on another day (Port Pollensa – Sa Calobra loop), it took the FIRST Garmin (longer) distance (!):
<?xml version=”1.0″ encoding=”UTF-8″?>
The first highlighted line is in the file preamble, showing the supposed total length of the ride, 20586.637522382 kms, and the second highlighted line is the correct initial starting distance for the combined ride (zero) i the first trackpoint of the combined ride.
We can see highlighted below that the preamble ride distance in the instance is probably picked up from the second Garmin, because the last trackpoint in the combined file has used that distance (the time, latitude and longitude are correct of course, for the ride termination point!):
Last trackpoint in the Gotoes combined ride file
The problem is that the whole ride distance was 116536.455 kms, as we see below from the last trackpoint in my own, final modified ride file, created using the techniques I explain below. That combined distance, of course, does not appear itself in either Garmin, it has to be calculated, as it does for every other trackpoint in that second part of the ride (by adding on the last trackpoint distance from the first Garmin):
Final, corrected combined ride trackpoint in my reconstructed ride file
The problem is caused by Gotoes somehow picking up the trackpoint distances recorded by the second Garmin and treating them as valid for the whole ride, whereas they are only valid for the second part of the ride; ideally the distance would have started at the end distance recorded by the first Garmin device, but of course the second Garmin doesn’t know about the first one, and in effect the <DistanceMeters> has been reset to zero at that point.
The real problem is that when merging the two files, Gotoes should adjust every one of those trackpoint distances for the second Garmin ride file entries, by adding on the final recorded distance of the first one, to each one, but it doesn’t. This is what I have had to do manually using the following techniques (to do it globally rather then editing hundreds of them one by one!).
Maybe the problem would be resolved if all distances were calculated from latitude and longitude data at the time of Gotoes merge, because these ARE correct, but because Garmin adds (the possibly redundant (see my comments at the end of the article)) <DistanceMeters> parameter to every trackpoint, Gotoes seems to use this instead of recalculating distances from latitude and longitude data. Maybe this is why Gotoes merge works for activities up on the Strava and Garmin websites – possibly those websites DO use the latitude and longitude to (re-)calculate and display ride statistics and maps, and for online course display; but not, apparently, when downloaded to a Garmin Edge device. Maybe the Garmin Edge device doesn’t have that function built in for recalculating downloaded courses, and just uses the <DistanceMeters> parameter when doing that.
In summary, this doesn’t seem to be a problem for the activity itself on GarminConnect and Strava, but it does cause an issue for the Course created from the activity once downloaded to a Garmin Edge; hence the need to edit the Gotoes file.
XML file editing process
This took me half a day to work out, but then only 1/2 hour to implement for each of two such rides! I’ll just describe the essentials, and can expand further for anyone who needs help!
The issue is that any text editor, whether a really good one like TextWrangler or BBEdit, or a basic one, doesn’t do arithmetic! In the file from which extracts were taken above, there were hundreds of trackpoints in error (the second part of the ride, on the second Garmin) as far as distance is concerned. This was far too many to adjust manually (by adding the closing distance parameter from the first Garmin (which was 95950 kms) to every trackpoint distance from the second Garmin).
I should say here (for the “techies”) that I first thought of using the “regular expression” editing option (called “grep” in the web editing trade) in TextWrangler to isolate the <DistanceMeters>123.456</DistanceMeters> distance parameters, which is very easy (123.456 is obviously going to be different for every trackpoint for the ride). But then there is no way to edit or paste in (globally in one operation) each different trackpoint distance within TextWrangler (varying distances here represented by 123.456) by adding the constant 95950 to each original one.
One can find and select the trackpoints with their different distance data globally using grep wildcard characters (I used the search term:
<DistanceMeters>.*\..*</DistanceMeters> and it works for any amount of different numbers either side of the decimal point in the distance numbers)
but there isn’t a way to do a selective, global replacement with the (different) correct distances for each trackpoint.
What I found was necessary is to import the relevant thousands of lines (“only” hundreds of distance lines but each trackpoint has a dozen or so other lines of data) of the .tcx file into Excel (where you CAN do arithmetic!) as a (html) file delimited by certain characters; isolating the distance figure in each <DistanceMeters> line into a separate Excel column; add on the constant starting distance 95950 kms to each distance number entry in that Excel column; and then save the file with the modified distances as an Excel text .txt file. This file is then opened by TextWrangler, where, if it is done the right way (as explained below), the original file format can easily be recreated and the data (the whole new file, in essence) substituted into the second part of the original, merged ride file (i.e. the part from the second Garmin whose <DistanceMeters> data had started at zero instead of 95950 in this case) to create a ride file properly representing the whole ride and its complete distance.
More TextWranger XML editing, Excel import, Excel editing and final TextWrangler XML editing details
What took so long to work out?! Here’s the a) to r) of the process:
a) the import of the second Garmin file into Excel (by default an Excel .txt file) requires 1) only importing the trackpoint items (hundreds of them) and 2) not the preamble (easy);
b) work out a way of specifying the delimiting characters such that the distance data is isolated into its own column in Excel when imported (more difficult). This is the most important and crucial step, it turns out. What I had to do (there might be a better way) was replace the surrounding <DistanceMeters> and </DistanceMeters> tags with xx and xx/ respectively (the / is possibly redundant, but I wanted to be able to edit back in the original tags which are different for opening and closing tags). “xx” is unique in the file, there being no other instances;
c) add on the starting distance (95950 for starting the the second part of the ride, not zero! i.e. the closing distance for the first part) to each line where the distance parameter occurs (in Excel’s column C, say); this is best done by doing a conditional add into another (intermediate temporary) empty column (e.g. using the Excel formula if(C1<>””,C1 + $G$1,””) defined for row 1 in the temporary column, and then pasted into every row cell in that temporary column in the spreadsheet, where the constant add-on distance 95950 has been stored in cell G1, say) where we only add on the distance 95950 where the existing distance column has a number in it (i.e. isn’t blank). Then this new column is “pasted special” into the original distance column, choosing the option values only (since we want nothing but text or number data in the new file, NOT formulae). The intermediate, temporary column is then deleted;
d) add a new column either side of the new, replaced distance data column, ready to receive some new tags (i.e. <DistanceMeters> tags instead of the unique xx used purely to isolate the distances for the Excel import);
e) similarly, as for the distance data, conditionally (e.g. using if(C1<>””,<DistanceMeters>,””) to add this opening tag text to another column to recreate the original style opening tags, only in rows where the cell in the distance data column isn’t blank;
f) similarly, conditionally (e.g. using if(C1<>””,</DistanceMeters>,””) to add this closing tag text to yet another column to recreate the original style closing tags, only in rows where the cell in the distance data column isn’t blank;
g) again using paste special, paste the values only from these two intermediate columns into the new columns created either side of the actual distance data column;
h) delete the two intermediate columns;
i) save the new Excel .txt file and open it in TextWrangler (which allows opening any text based file, including Excel delimited ones (just like .csv files, although this is a .txt file in Excel), with those new <DistanceMeters> and </DistanceMeters> columns we created in Excel, effectively undoing the “xx” tag changes we made as part of step b);
j) globally edit out any spaces left between the distance data items and the new <DistanceMeters> and </DistanceMeters> tags introduced in Excel; there are some left in the the Excel .txt file when it opens in TextWrangler. This is two very simple standard global edits, e.g replacing:
“<DistanceMeters> ” with “<DistanceMeters>” (using “Replace all”) and similarly for;
” </DistanceMeters>” with “</DistanceMeters>”;
k) copy and paste the whole file of new trackpoint items (no preamble or “postamble”, remember, trackpoints only) into the second part of the original Gotoes merged file to replace the old, second Garmin data from the changeover point;
l) The summary ride length parameter in the Gotoes merged .tcx file preamble was actually, in another file I had to alter, the longer of the two ride parts, and in this one it was the shorter one! Naturally I changed that to the total length in each one, a simple single edit each time.
m) run the add-on XML formatting option in TexWrangler (the Text Filter “XML Tidy” plugin which I had added to my TextWrangler before) over the whole file to achieve the right indentation (for appearance and accessibility only, with no change of content); I use this because sometimes when using TextWrangler to import xml data (as with Gotoes) the xml data is inserted as an extremely long string of data. Soft wrap doesn’t sort this, but there are reformatting tools like XMLTidy, JSONTidy and PHPTidy (and others) that don’t change content but re-present it in the accepted format for such file structures.
n) delete all versions of the original two parts of the ride activity in GarminConnect, and any website incorrect courses derived from them (Garmin won’t upload files it thinks are duplicates);
o) upload the new file to GarminConnect as an activity;
p) turn the activity into a course using the standard GarminConnect website dialog;
q) download the new course into the Garmin Edge of your choice (both of them in my case!)
r) check that the whole course is in the map option in the Garmin Edge – at last it is!
Appendix: Even a little more on Step b)!
In order to get the Excel import of a tab or character delimited file to isolate a numeric item in any line, we have to find a unique character that opens and closes that data item in TextWrangler, in any line in which it appears, before importing into Excel. Each trackpoint entry in the .tcx file has a dozen or so lines as we see above from the extracts, and only one of them for each trackpoint has the distance data for each (of the hundreds) of the trackpoints.
An issue is that the more obvious and usual delimiters from the xml tagging, “<” and “>”, appear for all other data items too, so using them, or any other alphabetic single letter (Excel import only allows one delimiter character!) one might choose in <DistanceMeters> or </DistanceMeters> is no good for isolating distance data, as all of the letters in them happen to be used in other lines of each trackpoint. The delimiter character needs to be unique to the distance data item line in order to isolate the imported distance data into its own Excel column.
I first thought of changing <DistanceMeters> to “x” all through the .tcx file, but in the end decided to use “xx” for the opening and “xx/” for the closing tag each time – maybe unnecessary but I wanted to be super-safe there were no other single “x”s, or that the single character delimiter “x” in the Excel import dialog didn’t cause confusion when it was used for both opening and closing, and I added the “/” (to distinguish opening and closing delimiters) which in the end I just deleted in the excel file as it turned out not to be necessary. I used double x “xx” in case that would create a column either side of the distance data, but it didn’t! But it DID isolate the distance numbers themselves into their own column which was the object of the exercise.
The three successive Excel import process dialogs thus looked like:
PS I should say that I reported this to Brian Lucido (the Gotoes developer) at Gotoes.org on their website at 00.27 Mar 25th UK time, and he responded at 00.35! Mightily impressive in the early hours of Sunday UK time (I think they are 7 hours behind, but it still Saturday evening for them, when they should be at the pub!) He is looking at it now, defining the issue as the distance resetting as each new part of the ride is added to the combined ride file. I’m off to bed now while they work on that! I’m losing an hour, as we all are tonight! Need my beauty sleep at my age!
Brian came up with a solution after I suggested the point about data redundancy – and just removed the <DistanceMeters> tag! It’s the easiest thing to do, and he agreed it was redundant. H looked into what it would take to fix the issue (problem was a private variable – so it gets reset to zero each time the subroutine is executed)… and decided that it would be easier just to comment out the <DistanceMeters> part. He realized that his app prohibits files lacking lat/long in any case… <distancemeters> is only there for swimmers and people on trainers and treadmills who don’t have any lat/long data. Those types of activities don’t really need a merge tool!
I own up to having a hobby horse. My cycling friends will be surprised to know I don’t wear a helmet when riding it (!).
The hobby horse, of course, is my insistence on the advisability of wearing a helmet when cycling – always.
But I have today been assailed by several articles that I can’t let go without comment. I’ll be as brief as I can, and not repeat my previous comments on this safety topic. I’ll restrict myself to brief commentary on subject matter of the articles themselves.
My notice was drawn to the issue today by this potentially self-serving Facebook post by Velosure Legal and Cycle Insurance. Why “self-serving”? Well, I can only imagine that if riders take the advice that helmet use is of no help, it makes medical claims bigger and ambulance chasing fees higher!
As for the Guardian article to which they refer:
both they and Velosure should realise that a helmet’s primary purpose is for head protection (not for persuading motorists to take care, although it would be good if they did) – the head that contains a human being’s most important asset, the brain; the organ that seems to be missing in those that argue that it’s OK to ride without a helmet.
I’m certainly not going to be brainless enough to leave my helmet at home on the off-chance that somehow public road safety policy will change as a result. I’m not convinced by those that argue that personal safety measures and road infrastructure improvements are an either-or, or equivalently that somehow that tails will start wagging dogs; those that believe that will no doubt also expect that pigs might one day fly. F1 racing drivers (I think David Coulthard once said this) used to talk of leaving their brain in a box in the pits before going out to race, a metaphor for refusing to focus on the high risks of the sport (even higher back in the day) to reduce inhibition and enhance performance. For most of us this isn’t an option – or shouldn’t be.
Talking of brainlessness, in the cycling policy area I am in particular appalled that British Cycling (BC, the “organisation” that doesn’t have a system to record medication given to the professional cyclists they support; BC, that employs a doctor who apparently can’t keep his laptop safe; BC – and/or their favoured Sky team that hand carries an undocumented jiffy bag to their world-leading racer at a major event; BC, that can’t make a doctor available to present clear, honest and informed evidence to a Select Committee; and BC, that is alleged to be institutionally misogynous) continue to keep Chris Boardman as Technical Adviser despite his misplaced views on helmet wear, well documented and demonstrated in cycling advisory videos where he appears consistently riding a bike without one. With all their other failings, it isn’t surprising that BC’s HR policy in this area is also a mess.
Get thee to a doctor?
The neurosurgeon quoted in the article above might, as a by-product, also increase his caseload by persuading people to make themselves more likely to suffer a brain injury. He’s also generously spirited enough to try to get a Darwin award himself by being quoted as riding through red traffic lights, apparently OK in his opinion because it’s only his life he’s putting at risk. Really?! Ignoring the risk of secondary accidents caused by any necessary avoiding action by other road users? It beggars belief! What credibility does he have to pronounce on the choice of wearing a helmet or not? And do we really think that a research project on road-user attitudes and driving style* can distinguish a three-inch difference in road positioning when the driver sees a rider wearing a helmet. I don’t believe it. Especially as it’s quoted by our potential Darwin award winner.
* http://www.bath.ac.uk/research/news/2016/01/25/helmet-wearing-risk-taking/ – Dr Tim Gamble and Dr Ian Walker, from the University of Bath’s department of psychology
More Grauniad excellence
Here go the Guardian again, with what seems to be a concerted campaign to allow bike riders to kill themselves (by giving people excuses to ignore the benefits of a helmet), which, I suppose, might be seen as a good outcome by some of their other road-using readers. Despite their insistence here that they aren’t advising people to stop wearing helmets, they miss the simple point that reducing blunt trauma and severe abrasions are the primary purposes of a helmet – anything else is theoretical puff. No-one who has suffered or seen a head-impact fall from a bike would say otherwise, surely!
The Guardian must have spiked this article on Risk Compensation!
A very good point is made in the article – the logic of NOT wearing a helmet, so as to make yourself and others be more careful, might lead you to do exactly what is suggested in the title of the web page article!
In case this helps anyone who gets bored after a day or two with any of the Zwift courses, you can change your preferences to force Zwift to give you London, Watopia or Richmond on any day of the week, not just the allotted ones on the monthly schedule. Take care, and be aware of the advice that there are no hidden courses (allegedly). So don’t, as a computer scientist might, try other changes to see what happens and where you might be taken! Your rides might be a little more lonely than usual when making an alternate choice, of course…and I presume there might not be any races or group rides organised “off-piste” so to speak…
Important: Do not insert bogus values into your preferences file!
There are no “hidden” courses, secret maps or back doors which can be found by inserting the wrong values into your prefs.xml file. If it’s invalid, Zwift will just behave unpredictably or even crash. Follow these instructions carefully and you’ll be safe!
PS I would recommend iMazing as a Mac based IOS file manager rather then the one suggested in the zwiftblog link. See the reasons here https://www.entertainmentbox.com/itunes-update-breaks-ifunbox-vshare-alternative-fix-imazing/