The Three Areas involved
There are three areas involved with producing the Café Routes page:
1 – the Media Library – contains all the GPX files AND the routes spreadsheet which is called ‘Wheelers-Routes.xlsx’
2 – the Downloads area – this allows the GPX files to be referred to and downloaded from the website
3 – a wpDataTables table called ‘Café Routes’ – this is the table that displays the data on the routes page. It takes it’s data from the xlsx file that is stored in the Media Library
Process to add a new route
Read the new GPX file into your editor e.g. Komoot (New > Import GPS file > Upload File)
Edit the GPX e.g. move the start to FBP, set it to round trip etc
Save the GPX file to local disk
Tidy GPX filename up, remove date etc ready to upload to website
If you don’t already have the latest file locally, download the “Wheelers-Routes.xlsx” file from the Media Library – to do this go to the Media Library, select the file then select ‘Download file’ – Tip – use the ‘Spreadsheets’ selector
Once downloaded, it recommended that you re-upload immediately (it will get auto-called ‘Wheelers-Routes-1.xlsx’) to form a backup.
Open the xlsx file with your favourite spreadsheet app and start to fill in a new line e.g. start location, distance, climb etc using information from Komoot
Login to Wheelers website to add the GPX file via Downloads > Add New Download (NB do NOT simply add it via Media Library area)
Fill in title of download e.g. ‘FBP to Porthtowan’
Click ‘Upload File’
Click ‘Upload Files’ tab > ‘Select Files’ button
Select the GPX file, wait for upload to complete then click ‘Select’ (bottom right)
Check ‘GPX Files’ under Download Categories
Then click ‘Publish’
Copy ALL of the text in the shortcode field then go to database sheet and paste it into the GPX Download cell
– Up to here can be repeated for several routes –
Once ready to put database spreadsheet online, the original needs to be deleted first:
Media > Library
Find and select ‘Wheelers-Routes.xlsx’ > Delete Permanently > OK
Add Media File > Select Files
Select the ‘Wheelers-Routes.xlsx’ saved earlier and allow to upload
– At this point, routes page should have been updated, however if the FORMAT of the spreadsheet has changed then this will need to be reread into the wpDataTables table, to do this:
Once the updated spreadsheet has been uploaded as above, go to wpDataTables > wpDataTables > Wheelers Café Routes
Click on Save Changes and the spreadsheet will be reread into the table
Well Done