Maintaining the GP data

John Hutchinson looks after the GP data. He trawls the results for GP events and maintains the spreadsheet. When he has an updated spreadsheet he emails it to the Web Officer. There are two tasks to be done:

Task 1: Upload raw spreadsheet to website

This is the easy bit.

Normally you will be replacing the ongoing ‘live’ spreadsheet.  From the Dashboard go into Media then Library and locate the current spreadsheet. The file you are interested in is:

gpresults-current.xls

The easiest way to find this file is to enter gpresults into the Search Media Items box. i.e.

Click on the thumbnail to highlight it, and you will see the upload dialogue. There is a WordPress plugin installed (‘Enable Media Replace’) that allows us to easily replace commonly updated files rather than go through the hassle of uploading a new file, deleting the existing one, and renaming the new one. So in the upload dialogue look for the Replace  media option and click on Upload a new file (see below):

 

On your computer locate the most recent GP data file that you’ve got from John Hutchinson and upload it. At the moment this file will most likely be named gp2017-2018.xls.

Upload the most recent version of the spreadsheet and you’re done. You will be warned that you are about to replace the file (but you already knew that so you’re not scared). Click on Upload. i.e.

Most of the time that’s all you’ll need to do, unless it’s a new GP year in which case there’s really quite a lot to do.

The GP Results Spreadsheet (xls) link on the GP page links to the spreadsheet you’ve just uploaded.

Task 2: Update the spreadsheet in Google Drive

The results tables that are displayed on the GP page are fed from documents stored on Google Drive. You will need to use the elvet.striders google account to access them.

The link to the files is:

Google Drive GP Folder.

You should see something like this:

You’re interested in the Raw-Data file. Open the file (Double-Clicking on it will probably do it – will depend on your browser configuration), then, with the spreadsheet open,  select File / Open:

This is the important bit. You will be selecting Import. Click on import then select the Upload tab. Locate the spreadsheet on your computer and upload it. Once uploaded you’ll get another dialogue window prompting you for Import action. Select the Replace spreadsheet option. You should now be looking at something like this:

Click on Import and the spreadsheet in Google Drive will automatically be updated.

This should now feed automatically to the GP page.

Note that the code that does this behind the scenes is lifted entirely from the old website. Here it is for reference:

<iframe src="https://spreadsheets.google.com/spreadsheet/pub?hl=en_GB&amp;hl=en_GB&amp;key=0AsgMvd8yPd5IdGk0ZTN6U29VTy1JTllJLWloTXJrU2c&amp;output=html&amp;widget=true" width="800" height="420" frameborder="0" data-mce-fragment="1"></iframe>

<iframe src="https://spreadsheets.google.com/spreadsheet/pub?hl=en_GB&amp;hl=en_GB&amp;key=0AsgMvd8yPd5IdG1rdjJUbEF6b1Ytdkh6bW1wa0RUMEE&amp;output=html&amp;widget=true" width="800" height="420" frameborder="0" data-mce-fragment="1"></iframe>

You don’t need to do anything here. Just be aware that you’ll see this code if you Edit the GP Results page and look at it in Text mode.

One day this may stop working. If that happens it may be better to look at a different solution, such as using the Tablepress plug-in. WordPress may offer ways of displaying the data better.

(Visited 1 times, 1 visits today)