The free version of MapMyRun has a great route planner built in that I’ve found to be based upon some of the most reliable base mapping and can auto-follow roads very well. The elevation estimates also seem to be fairly reliable. Once you’ve finished your route you can download it in KML or GPX format for your device which is all great.
MapMyRun won’t let you import route files (i.e. tracks without timing info) so if you are given a new route to follow and want to edit it first, there is no easy way to go about doing this. After a little convoluted searching I’ve found a way around this limitation.
MapMyRun expects timestamps in the tracklog, so the trick is to spoof this information to allow you to import it. GOTOES has some really useful Strava Tools, one of which is the “Add or Adjust Timestamps” which does exactly this
Login in to MapMyRun and upload your new Workout
View the Workout and at that point MapMyRun will automatically create the Route. Just go to “My Routes” to see it and edit it!
All in all a very useful way to work with route data
I’ve just started doing some audaxes and whilst GPX routes are often supplied, you can often start at any point. This made me wonder whether you could follow a route on the Bryton Rider 450 from any point along it. The good news is that - yes - you can, however that comes with one major problem. When you get to the end of the route the map screen goes blank and tells you you’ve “Arrived”. What I want it to do is just carry on from the beginning again which the Rider 450 won’t do. This is perhaps unfair behaviour to expect of it and maybe an “edge” case, which means the route would have to be digitised again for your starting point.
The tracklog does carry on recording and this goes to show that the tracklog and map routing are completely separate activities running in parallel on the device. Precedence is giving to tracking as this is highly time dependent. It explains why the maps take time to refresh and the longer the routes get, the longer they take to load. This can at times can give the impression that the unit has frozen, when in fact it’s reading the whole route back in to memory, taking the current GPS coordinate, loading the correct map tile, then plotting the breadcrumb trail over the top. On one ride, I had started following a route, but for the first 20km rode using the data screen as I knew the roads to follow, I then switched to map view and the Rider 450 took more than 5 minutes to refresh the map. This would suggest to the rider that it was frozen, but the distance and cadence fields were live, so it was clearly working. My guess is that it records the last map shown on the route and then iterates through every position along the route until the it matches the coordinates from the GPS, then refreshes the tile. This is hugely inefficient, particularly for long routes but simple and probably computationally easier to accomplish at the expense of significant time.
It also further highlights that the map screen doesn’t refresh until new information is ready to display, again behaviour that might suggest it’s frozen (and indeed it may lockout other actions until this is complete). Crucial to this series of events is being able to get a GPS coordinate: if it can’t do that, the map won’t update. This means that if your system can’t get satellite lock (in a tunnel, under trees etc) then the maps remain frozen until a coordinate is supplied. The tracklog however should carry on recording (doing whatever the recording algorithm dictates for a lack of current coordinate) in these situations.
The key then is patience and just carry on cycling with one BIG caveat. If you genuinely do have a frozen Rider 450 then it will need rebooting! Remember that means pressing and holding the four side buttons for a few seconds, then releasing them. Once rebooted it then needs to go through the whole process of satellite lock and getting a first coordinate - this can take minutes the first time after a reboot. I have also tried waiting on a number of occasions and once it carried on working and on the other the unit remained frozen. The latter problem came when I suspect the unit didn’t have satellite lock and I tried to change from the map to data screen (or vice versa) freezing operation. It is possible that this is a genuine bug that crashes the unit and I can definitely say the tracklog doesn’t carry on recording. The only solution is a reboot, which is certainly necessary if you want to use the maps/data.
I’ve also noticed that refreshjng the map and the lap timer can well conflict. My timer is set to a fairly rapid 2km (4-5 minutes) and the map often tries to refresh when the timer is due to roll over. The latter is given precedence which again freezes the map display. My best guess at the moment is don’t try to switch in/out of the map screen when this is about to happen.
A later post will talk about what to do with the corrupt files!
WiFi (and internet access) is so endemic that we often think of it as an essential utility rather than a useful add-on and it’s got to such a point that just about every restaurant offers some kind of service. Whilst inherently less secure that private WiFi, they can be great to jump on to in order to download some Netflix shows or update some apps. The default action once you’ve connected to a service is to load a default login page in order register and verify your credentials. However problems arise when the default page doesn’t load. This has happened to me for three reasons:
Puffin Browser: it’s a great mobile browser that is fast because it saves data. It does this by pre-loading the page at a server then sending you compressed versions. By default, this means that the Puffin server is trying to access the login page, but obviously can’t because it’s not on the network! The solution is to use a “normal” browser such as Chrome, Brave, or Firefox.
Alternate DNS: if you’ve changed your DNS to try to speed things up and have a little more security then this might be the cause of your problem. The login page will be unique to the WiFi network, so asking OpenDNS or GoogleDNS to do a DNS lookup will fail. The solution is to remove this setting and then use the DNS provided by the WiFi, which will allow your browser to load the login page.
Browser Cache: if you’ve visited a website before then it’s possible the DNS lookup will have been cached. You try to go to the site again, it bypasses the login page and then can’t load the remote site. The solution is to avoid using cached data and then force a new page to load. The simplest solution to the first part is to start a new incognito page which is sand-boxed and can’t access an cache information. Loading a new page ideally requires an http connection (not https as this won’t allow redirection to a login page for security reasons). These are much rarer than you might expect, however
ICAAN’s example.com is a great option.
The third one crops up more often than you might expect, so it’s good to have this fix in the bag!
In my earlier post I noted a couple of “bugs” that would be good to fix and one of these was downloading workout data (locations and sensor readouts) from the device, app, or Bryton Active website. There is no button to press or link to click to do this, but it does exist and is actually much lower level than this!
At it’s simplest, the Rider 450 is simply a data logger with a built-in GPS that can also link to other ANT+ devices and record all of the sensor data. It writes the data to a file using Garmin’s binary FIT file format (Flexible and Interoperable Data Transfer Activity file) which is simple, small, and flexible. When you plug your Rider 450 in to your PC, it mounts the device as a drive and all the FIT files are in the top directory. You can just copy them straight off!
So what can you do with them? DC Rainmaker has a handy list of bike related software including many to manipulate FIT files, however here are a few worth looking at:
FIT Conversion and Repair: from Steve Gordon, this site allows you upload and convert or repair your FIT files. Simple and easy.
FIT File Tools: a very handy select of FIT manipulation tools, including merging tracks, so if you accidentally split your workout then this can splice it back together.
GPSBabel: the Swiss Army knife of tracklog manipulation, GPSBabel supports FIT files and allows you to convert them in to a range of different formats. Originally a command line utility, it also has a GUI which runs the command line in the background. I wanted to convert my FIT file to a text file (CSV) and it didn’t work because (I think) the GUI didn’t produce the right command line. You want to be using something like this:
This will be a “live” list as things come and go, but I thought I’d start putting down some things that would be good to add or fix:
Reverse a route: I’ve planned a route one-way. It would be handy if you could reverse the route once you get to your destination and then follow the navigation back. Maybe too much to ask.
Read full notification: notifications only show you the first ~11 characters. Would be good to see an entire message
Join tracks: I’ve accidentally stopped and then restarted a track when I’ve been recording it which is irritating as your stats are then calculated separately for each one. The ability to join tracks together.
Download Data: would be great to be able to download the raw data from Bryton Active
Navigation Screen: you can tailor the bottom row of the navigation screen to show any of the data fields available. If you are not following a route, then speed is shown in the top-right, if you are following a route then it changes to “distance to go” in the top-left. It would good to make the top row configurable.
Distance to Go: if you are following a route, then the map page shows you distance to go to the finish, however it overestimates this by 15-20%. Quite why I’m not sure as I know the route length from the route planning application and when I get to the end the distance is the same
Turn By Turn Instructions: if you are following a route and switch from a data screen back to the map page, the next turn instruction will be out of date and won’t update until the instruction refreshes at the next turn.
Lap Timer Error: I’ve set the auto-lap to give me a time every 2km, however if the auto-pause kicks in (e.g. at a junction) then this isn’t subtracted from the lap giving a timing error. The correct time is produced after the ride so it’s clearly correct when the stats are produced, but not during the ride itself.
Max Number of Lap Times: I did a 300km ride a few weeks back I when I got to auto-lap 130 (2km each) it stopped recording them. Is this an in-built number of laps it can record?
Fit: out-of-the-box the Rider 450 comes with a standard handlebar mount. It’s cheap and works well enough, but uses up valuable bar space. There are two other options worth considering: a stem mount or out-in-front mount. The former is a bit more efficient on space, but perhaps not quite so good if you are tucked down.
Learn the Buttons: it goes without saying, learn how to use the unit.
1. Two Operating Modes: I found it slightly counter intuitive to have two different modes. A “cycling” mode and a “settings” mode which you can switch between. The RightTop is a “start” or “OK” button depending which mode you are in, whilst the RIghtBottom is a “pause/stop” or “Back” button.
2. Zoom/Scroll: the two buttons on the left are for scrolling up and lists, except when you are using the map when they zoom in and out (useful!)
3. Map Modes: the BottomLeft changes between cycling mode screens. There are up to 5 data screens you can set up/switch off (in the app) which support a range of different layouts, followed by a navigating/map screen.
4. Power/Light: the BottomRight is for power and light.
5. Reset: the 450 has frozen twice on me now. To reset you need to hold all four side buttons and then release. It will take the GPS sometime to get satellite lock so be patient.
Learn the Icons: there are a number of icons at the top and bottom of the screen. There is an efficient use of space so know that they mean as they are useful. For example, the arrows indicate if you are riding above or below the average speed.
Start/Stop a Ride: be careful pausing a ride as my natural inclination is that once you pause a ride, you press the same button to start again. But no! That stops the ride and all the recording that goes along with it. Unless you really have to, just left the auto-pause kick in and then restart. Leave the buttons alone!
Laggy Screens: all the screens are very responsive except for the map and data sync screens. If you load one of these, wait a few seconds for them to complete.
Notifications: these are a step ahead of the competition as you can set up the app to send notifications from any app (not just texts). This is great, however bear in mind it is a 3-line notification that is limited to 11 characters (ish) of text per line. It shows the app, the sender’s name and the message. Anything longer that 11 characters will be truncated. This is frustrating because how hard would it be to allow the notification to fill the screen and then enable you to scroll through it? That’s any comments aside regarding how safe that might be to do.
Sensors: the Rider 450 supports bluetooth and ANT+ sensors. I’ve fitted a cadence sensor which works flawlessly. No problems there.
Bugs: so far I’ve found the following two significant bugs:
Distance to Go: if you are following a route then the map page which show you distance to go to the finish. Except it overestimates this by 15-20%. Quite why I’m not sure as I know the route length from the route planning application and when I get to the end the distance is the same
Auto Lap By Distance: another useful feature so you can see your splits except I can’t get the setting to sync across from the app to the Rider 450, but you can set it on the Rider 450 itself.
This “bug” took me a while to track down… I have a report which embeds a subreport and returns the data to it. Along the way I realised the subreport needed an additional column. I edited the SQL in the Dataset and then reran the subreport. It loaded correctly. I then went back to my main report and ran it to find that the new column was returning “Error” for all values.
I tried recreating the subreport Dataset, the embedded object in the main report, and eventually the whole subreport itself. None of these worked. What was actually causing the problem was the Visual Studio cache that was created when it first ran the main report. Because I had subsequently edited the subreport, it was returning an extra column which it wasn’t expecting and so throwing an error. I’m not sure if there is front-end way of rebuilding the cache, however the simplest solution was to delete the .data file in the report folder, and the “bin” subfolder. These are then rebuilt the next time the project is opened.
The benefit of FlatPress is that it doesn’t use a database… this approach pivots to the axiom of “keep it simple” which should make the rendered site fast, secure, and portable (for example, when I ported from Blosxom to FlatPress). One area where this is particularly evident is backup as all you have to do is copy the content files off the server. You can run this either sever side (putting the files somewhere) or client side (pulling them to a local machine). I’ve opted for the latter approach and my tool of choice is WinSCP (and the portable version), an open source FTP client that includes a n extensive number of reliable and extensible tools. I’ve found WinSCP better than FileZilla, not least because it has reliably handled large file transfers and maintains the create dates of any files you transfer.
Of particular importance for automating FlatPress backup are directory synchronisation and scripting. In fact, the WinSCP GUI can generate the script for you based upon existing profile settings. For completeness this is the very simple script that runs:
synchronize local -mirror
This opens a connection to the server, changes the local and remote directories before mirroring from the remote to the local. On Windows I can then schedule this to run as a daily task.
The arrival of a new Windows PC precipitated an upgrade from Visual Studio 2015 to Visual Studio 2019. All of my development is for SQL-based reports which are then deployed to SSRS. As Visual Studio is Microsoft’s “one-size-fits-all” approach to programming, you need to make sure you pick the right “flavour”. In this instance that means SQL Server Data Tools. For VS2015 and VS2017 that is a standalone installer and you need to make sure you select the “Data storage and processing” option which then installs SQL Server Data Tools. For VS2019 some of the functionality has been moved out in to Extensions: for me that mean installing the MS Reporting Services Projects extension.
With that rigmarole out of the way I pointed VS2019 at my Solution file and… I got an error message saying that it couldn’t be upgraded! WTF?! I mean, seriously? Microsoft can’t upgrade from two versions ago? Whilst the RDL report file format hasn’t changed, setting up new Solution files would be a time vampire for no valid reason.
It then struck me that it was worth a punt installing VS2017 to see if the intermediary version could upgrade the VS2015 files, and then move on to VS2019 after that. A 1Gb download and 30 minute install later (seriously!) and VS2017 successfully upgraded the Solution files. I then copied these over to my new machine and VS2019 successfully upgraded those too. It’s one extra step but is then seamless!
Designing SSRS reports in Visual Studio is liberating in how easy it is to get them up and running, but every so often you come across a gotcha that you think should be straight forward. One of them is copying a “solution” (VS’s name for a set of project files) to a new location. You might want to do this because you want to back it up, duplicate it for another related project, or just to run some tests against a demo version. What’s missing in VS is a “Save As” for the whole solution (you can do it for individual reports). If you copy the folder containing all the files you can create a new version in a new location, however all of the hard coded file locations will be incorrect and it will then fail to load.
So what is the solution?! Well you could create a new solution, then add in copies of all the existing reports, but then you still have to set it all up again which is just a little self-defeating. Surprisingly, the simplest thing is to copy the solution folder, but keep it within the same directory as the original, just changing the name. You can then open the copied solution from within this folder and all the reports load correctly (as new copies). If you are deploying this to SSRS then you will need to change the name of the solution in the solution properties, but then you are good to go.
Whilst designing a report for deployment to SSRS from Visual Studio 2015, I received this error message when entering a SQL query I knew worked in to the New Report wizard:
An error occurred while the query design method was being saved. An item with the same key has already been added.
This is a classic Microsoft error message that is both specific and vague at the same time… and also shouldn’t happen. There are scant details online as to where this comes from but is a result of Microsoft SQL Server Report Designer having a requirement for unique column names (even if the underlying SQL query returns unique columns with the same name). This is a stupid limitation and whilst the error message is accurate, it is sufficiently vague to obfuscate what is going on.
The solution - unsurprisingly - is to make sure that there is no repetition in the names of the columns.
Grouping objects should be one of those things that is - well - easy to do! In Microsoft Word you Ctrl select each object, then right-click and select “Group”. Easy. In Visual Studio 2012, not so. You would have thought that, in Microsoft’s prime programming environment, these simple layout tasks would be easy, but thy’re not and it’s not documented anywhere. In my particular instance I was creating a SQL Server Reporting Services report where images in the template were moving depending on the number of rows in the output. The solution was to group the images together.
The grouping concept is sensible and well implemented, it’s just that working out how to do it is difficult! You actually have to insert a new rectangle object and then drag-and-drop the objects you want to group in to it. Once you’ve done this, the properties of your contained objects should look something similar to this where the “Parent” attribute under “Other” shows “Rectangle”. Now if you move the group, they all move. Job done!
ISO 3166-1 just trips off the tongue, however it’s one of those standards that underpins a fair amount of daily geospatial traffic that is undertaken on a daily basis. Yes, I’m talking about country codes which Wikipedia helpfully defines as:
ISO 3166-1… defines codes for the names of countries, dependent territories, and special areas of geographical interest
This is important because it is used in so much analogue and digital data exchange between countries, although don’t for a moment think the ISO is the only organisation that defines country codes… but that’s a whole other blog post!
What gets in included in the list is interesting… the criteria for inclusion include member states of the United Nations, a UN specialized agency or a party to the Statute of the International Court of Justice. Becoming a member state of the UN is clearly helpful, although what makes a country is interesting in itself, as well as highly politicised. Palestine is an obvious example, but just look at the UK. The UK is a country, but should Wales, Scotland, and Northern Ireland also be included? For example, they are included for FIFA. The UN loosely uses Article 1 from the Montevideo Convention which outlines four qualities a state should have: a permanent population, a defined territory, government, and the capacity to enter relations with other states.
Anyway, once you are on the ISO 3166-1 list you get 2 and 3 letter codes, along with a 3 digit numerical code. These are maintained by the ISO 3166 Maintenance Agency and, given the above, change regularly. You can view the current list here and subscribe to official updates.
At the RGS we are a membership organisation and take online international payments, so having up-to-date country codes is important. Rather than subscribe to the ISO, we use the UK government Country Register, which includes an update service. It has the ISO-2 letter codes, although isn’t necessarily identical (as it’s countries the UK recognises).
This blog has been offline for a little while as the original Blosxom implementation had been hacked. Blosxom was a wonderful CGI script that was elegant in its simplicity yet eminently extensible through the many plugins which existed and made it moderately feature rich. Best of all, it used plain text files to store all its entries which makes backup and conversion much simpler than a database. With my implementation of blosxom decommissioned, I needed to find a replacement. Google flat file blogging engines and there are a lot. However many of the projects have been orphaned, like blosxom, and no longer in active development. What I wanted to find was an engine that was simple, had some good features and an active community. Flatpress seems to fit the bill with a new maintainer - and active Flatpresser - Arvid Zimmerman.
The next step was to convert my archive of over 1000 blosxom blog entries to Flatpress. Big shout out to James O’Connor who wrote the Python script to convert the files. The process is broadly this:
download your Blosxom files, including all the sub-directories for categories, but make sure to maintain the date/time filestamp of individual files - this is used to timestamp the entry for Flatpress. WinSCP does this (Filezilla doesnt)
make sure the categories only ONE DIRECTORY DEEP. Move any sub-sub-directories up to the top level
rename all the directories to numbers. These are used to tag the entries and can then be recreated within FlatPress
copy the script.py and template files to the directory the folders are stored in
edit the template file to have the header/footer you want. The content, date and categories will be changed for the entries
run the script
a new fp-content directory will be created with all your entries
upload this to your flatpress site and rebuild the index
The script does the following
renames the file to entry‹date›-‹time›.txt based upon the date modified date
copies the file to a new subfolder in FlatPress /content folder based upon year and month
deletes the first line from the file (and deletes the first line break)
prefixes the file with:
A (long) time back I wrote about the Acer C112 Pico Projector I was using. I’ve since upgraded to the Pico Genie P200 which gives a great 200 lumens of light and has microSD, USB and HDMI ports to allow all sorts of connectivity along with a built in battery. It’s not perfect - but its very good (and I still follow the same routine for transcoding with DVDDecryptor and TEncoder).
One minor irritant was that the sort order of the files on the memory stick appeared to be shown by date on the projector - I used Nico’s useful BulkFileChanger and… it made no difference. Obviously the embedded Linux system wasn’t using file dates. In fact on my (FAT32) USB stick it’s using the order of the files in the FAT - what was successful was using DriveSort. Problem solved - I suspect this affects a small number of embedded systems (mp3 players, projectors etc) that have had some lazy coding and don’t sort the files on portable drives.
Wake on LAN (WoL) is one of those incredibly useful features that I had forgotten about having used in the dim distant past. As the name suggests, it wakes up a PC by sending it a “magic packet” across a network. To get it all to work you need several things in place:
1. a network card that supports WoL - all should now 2. the network card with WoL enabled. Do this in Device Manager, and in your card properties check all the settings under “Power Management” and then also under “Advanced” make sure “Wake on Magic Packet” is enabled. 3. it’s easier if you PC has a fixed IP on your (home) network - do this in “Control Panel” then Network and Sharing Center->View network status and tasks->Change adapter settings then right-click on “Ethernet” (or what your network card is called) and Properties. Under “Internet Protocol Version 4”, use Properties to set the IP address. 4. the PC can only wake for “Sleep” or “Hibernation” so make sure your PC is in one of these two states. By default Hibernation (which is the lowest power mode) is off in Windows 10. To make this accessible goto “Control Panel” then Power Options->Change what the power buttons do. If Hibernate is unticked, click on “Change settings that are currently unavailable”, tick it then “Save Changes” 5. I wanted my machine to resume to the main screen and bypass login - to enable this goto “Settings” then Accounts->Sign-in Options and change “Require sign-in” to Never. 5. YOU’RE THERE!! Now you only need a way to wake your machine - I installed the aptly named “Wake on Lan” Play store app which just works.
In terms of application, for me it allows me to remotely start my desktop and then remote desktop in. I can’t help but think that this should be one of those things that “just works” rather than having to jump through so many hoops!
One of those great tips that just makes life easier… you have 100,000 records in an Excel spreadsheet that you’ve just pulled from a live database and it’s ended up with some blank rows in it, scattered throughout. How do you delete them easily?? With this tip using (believe it or not) the “Go To” dialog in Excel! And, copied verbatim:
1) Select the cells in one column from the top of your list to the bottom;
2) Make sure that all the blank cells in this selected range are the rows you want to delete;
3) Press the F5 key on your keyboard;
4) On the Go To dialog, click the Special… button;
5) Choose the Blanks option and click OK. This will select all blank cells in the range you had previously selected;
6) Right click on one of the selected cells, select Delete, Entire Row and click OK.
After that I then ran NoteStudio on the StyleTap emulator on my Android device (see blog) but the touch interface doesn’t sit well with Palm (everything’s a bit small). So I moved on to using ToodleDo and Keep - I still use Keep, but whilst ToodleDo is good, the Android client is frustrating to use. So…
I came across TiddlyWiki which is a great Wiki system that can operate in server or single-file mode. The single file is great for using on Android and AdTidWiki provides a simple interface to using it. I like it.
Exporting data from ToodleDo is easy, simple and painless (good for them) allowing me to move data out as a CSV and then import it directly into TiddlyWiki. That made me think, why don’t I revisit the NoteStudio data and see if I can recover it?? These were the steps I took:
1. Reinstall StyleTap onto my Android phone and then restore the last backup of the ROM (I had always used RightBackUp on Palm, so had a complete copy I could restore). 2. NoteStudio supports export to MemoPad format (although this was VERY slow) 3. MemoPad isn’t included as a standard app in the StyleTap ROM which led me on a search for a freeware replacement. This led me to Redwood’s MemoLeaf. Install this into the ROM, import the Memopad file and then export as DOC format (which generates a single PRC file with all the selected entries in). 4. Copy the PRC file to your PC and then use Zamzar to convert it to a TXT file (Zamzar is actually using the libraries in Calibre in the background to do the conversion). 5. That finally left me with a text file for some text wrangling to convert the data entries into JSON which TiddlyWiki would happily read. My programming skills are a little rusty so I asked James to throw together some code to do this. The code does this, taking the input TXT and doing some extra wrangling:
-put the title in the title tag -insert \n for a line break -replace double quotation (“) with single (‘) -replace anything in square brackets (e.g. [linkname]) with [[linkname
Straight from one of the best books I’ve read on communication (Trees, maps and theorems by Jean-Luc Doumont), is this paragraph on helping stem the flood of emails. Sage advice indeed:
If you are buried under too much incoming email, you may feel helpless about it. Yet, without hoping for a revolution, you can still take concrete steps toward easing the overload. To receive less email, simply send less email - and send better email, too.
So, starting today, think before you send and if it’s not required, don’t send it.
This is one of those actions that is incredibly useful every so often… you have a tab open and you actually want to duplicate (so you have an active copy) and then carry on working with the current tab. Except there is no “duplicate tab” (or clone) option when you right click in the window or on the tab. This is actually one of those Unix-esque type daisy-chaining of functions to achieve the same in result. So… middle clicking on a link will load that link in a new tab (very useful itself). Solution:
middle click on the reload page icon (next to the address bar)