Administration

This section is not normally visible or accessible using the usual site navigation.

Its purpose is to automate the production of data used on LPMCC.net and to run checks. Wherever possible these tasks are automated to make them simple and foolproof so that they are run regularly, at the appropriate time, and without human error.

If a browser does not support the page scripts, its link is disabled.

Contents of this section may not be available on-line.

The index will appear here soon ... ... ... ...

When pages are updated

What pages are new today?

Standard Files: sitemap.xls and mobile/index.htm are complete files. rss.xls, home_map.htm and news_index.htm are partial data files for insertion.

Validate Data Comprehensive checks of menu_db, reunions_db, badge_db & extra_db, members_db and rallies_16. Run dev_datacheck.htm as an independent diagnostic if standard pages fail to display.

COVID-19 lockdown

Changes have been made necessary during the Covid-19 pandemic. Mostly to scheduled events. These need to be rescheduled when lockdown is removed.

  • Common.js - Mobile menu has a covid-19 button specified in more_navs[ ].
  • Data.js - menu_db[ ] to have home/home_covid19 removed.
    Leave the file in place in case there are links to it.
    Consider transferring some content to other pages such as FAQ.
  • Data.js - menu_db[ ] can have 2020/photos_364 to 366 un-REMing as appropriate.
  • Data.js - reunions_db[ ] needs events un-REMing from March to July.
  • Home/home_calendar.htm line 361 returns to monthly skype nights
    line 402 needs the covid19 boolian adjusting for lockdown.
  • Rallies/rally_rallylisting.htm line 905 reduced the font-size to fit all the cancellations into the Contact Centre message box
    Line 1032 will need default changing to ALL rallies
    Look for "6 Apr 2020" changes when the covid19.gif was added along with home/covid.js script file
  • Activity/event_skype.htm line 82 about keeping Skype link open. Also change SkypeNightURL at the top of data.js.
  • 2020/photos_366.htm has Covid-19 cycling rules and a group centre plan.

Special page data

Clean Text removes and replaces characters that do not encode properly.

Paste text into here to create web friendly version.


Removes unwanted spaces.
Replaces all quote marks by codes.
Spaces punctuation.
Capitalises I.
Converts well known initials to capitals.
Replaces foreign letters by Latin alphabet.

Add Star Ratings after copying and renaming star.eml files into admin/stars and running 1st_run.bat to rename as .txt files and create a list.
Add Comments is a similar system (for discontinued MotoGP section) that codes comment emails.
Add records to stars.xls as well as data.js>menu_db[] and MotoGP commentXXX.js files.
These pages read data imported as text files in an iframe and therefore need to be from a server.

Rally Locations Geocodes Hans Veenendaal's Excel data for the european rallies to be plotted.

  1. Download PDF and spreadsheet from Dropbox - Rallies to the Downloads folder.
  2. Transfer files from Downloads to Ben\Rally Import folder.
  3. Rename the PDF file 2019.pdf and transfer to LPMCC.net/documents replacing the existing file.
  4. Update standard.js with file size and date.
  5. Delete any old XLS files in Rally Imports.
  6. Open the new imported spreadsheet file.
    1. Scroll to the bottom for changes and cancellations and alter rally.xls accordingly.
      • Change whatever is changed and add a note to the change column. Add date with ctrl: enter f2 , [change code]
      • Move entries that need a new GeoCode to the bottom of the list and delete the empty row.
      • Remove latest duplicate row and add the reference number of this and the extant entry to the duplicate list in rallies2016.js
    2. Sort on Postcode to remove blank lines.
    3. Show hidden columns and delete them. Look for one between rally details and URL.
    4. Start quicky.ahk (AutoHotKey on f1)
      • Find a space between location and rally in column D and press f1 to put a ~ (tilde) between them and move to the next row.
      • Continue down the whole list. Also look for apostophe s in plurals and ... for missing location details.
    5. Start dev_reformat.htm.
      • Paste whole XLS datainto the text area and press CHECK button to reformat for GeoCoding.
      • Check there are no extra lines, errors or queries ( ??? ).
      • Paste the sorted file into GeoCode page.
      • Paste the Country tally data into rallies.js.
  7. Start rally geocode page by clicking Geocode link.
    • Copy the new data and paste into Rally Geocode text area.
    • Include any lines of events that need re coding.
    • Press GEOCODE button.
  8. Copy results back into the rallies.xls Current tab page.
    1. Sort new data on column J so that any uncoded or wrongly coded lines are together and in the correct order.
    2. Reprocess uncoded rallies through the Geocode page several iterations until no more can be coded.
    3. Click the country links beneath the buttons. These open geocode data in the next browser tab.
      • Look for geometry location data and copy both latitude and longitude lines to a text editor.
      • Edit the URL (eg remove postcode) if the geocode fails.
      • Edit the resulting lat long pairs with tabs between lat and long.
      • Paste the resulting list into the area of columns H and I
      • Check the resulting data by pasting back into Rally Geocode and pressing the INTEGRITY button to see they are within the expected country.
      • Delete the error numbers from column J
    4. Copy the next reference number from cell J1 to column J on the first new line using ctrl/shift/v
    5. Put todays date in column K [ctrl+; - check this is correct"].
    6. Add formula =1+↑ in column J of all the other lines of new data and =↑ in column K.
    7. Copy all the numbers in column J and K and paste them back as numbers using ctrl/shift/v
    8. Remove any remaining blank lines and sort the whole page on Start, End, Postcode.
  9. Copy the data into Editpad text editor.
    1. Find all new lines and replace with ", newline "
    2. Top and Tail so the file starts and ends with "quotes.
    3. Copy this file and replace rallie_16 data in rallies.js
    4. Update the date in the up_date variable.
  10. Validate Data
    • Correct any errors in rallies.xls AND rallies.js
  11. Save rallies.xls.
  12. Open data.js, change the date and add the new total of rallies.
  13. Open Rally List and check it is OK.
  14. Create a new sitemap, mobile index and RSS file. Only the top of the RSS changes and delete earlier entries at the bottom of the file.
  15. Run Backup LPMCC.net (bat file) and then open transfer.txt.
  16. Open WS FTP lite and upload all the changed files to the server.

Rally List Hard codes rally list data from current rallies.js file into format for pasting into rally_links.htm.

Author's latest page. Click this to trace the most recent report from any author.

Rear Observation Creates rear_obs array for use in rearobs.js either from email forms or by manual input (from paper forms!)

Route Plotting Geocodes polylines on a map and measures approx mileage. Used in cycling.js > fpc[].

Cycling Miles Creates data lines for miles above minimum. Used in cycling.js > cycle_db[].

New people and authors Produce data for people.js > author_data[] & people_data[]. Also checks when people become authors.

News process checklist. Keep open while doing News Update.

Pallet of preferred website colours.

Photo Processing

Copy incoming photos to the admin/photos folder, run dirn.bat then ...

Inspect and Deselect: Choose the photos that can be deleted.

Rename: Three renaming batch files. By date of photo, by example text and thumbnails for a selected recent page.

Check Thumbnails: For existance and correct 125x94 dimensions based on menu_db listing.

Choose Photos: Select photos in required order and groups. Indicates aspect ratios.

Incoming Documents photos and badges as they arrive and are prepared for later addition to the website. The documentation files are gallery/incoming.js and rallies/incoming.js.

Check of next BUT ONE event promo photo.

Badge Work

Resize badges based on the pixel size of included scales or coins. Examples of existing badges can be shown.

Badges Checks which badges are anonymous and which badges are not included in badges.js. Before running this page use the badge.bat file to create a badge.txt list of the badges in the rallies/gif folder.

Badge data Use selected unused badges list from the above program to create data lines for badge_db[ ] and extra_db[ ].

Missing Rally Reports List rally reports that are NOT in BOTH menu_db AND badge_db.

Move Badges Paste in a selection of badge data from badge.js > badge_db[ ] to move them up or down the page wholesale.

Promo Badges Create a 500x200 Promo banner after adding new badges.

All Badges Hard HTML code with ALL badges with title and sender in the ALT attribute. Code is transferred to motorcycle_rally_badges.htm. Also update menu_db and admin_sitemap.htm.

Regular administration

People Links Creates hard HTML coded links for everyone mentioned on LPMCC.net for home_everyone.htm and all past members mentioned for members_everyone.htm.
[Update January.]

All Badges Hard HTML code with ALL badges with title and sender in the ALT attribute. Code is transferred to motorcycle_rally_badges.htm. Also update menu_db and admin_sitemap.htm.
[Update February.]

Links listed with page address. Keep data in rally_links.xls and paste into external.js. Then use dev_links.htm in IE to find which links no longer work.
[Check March.]

Photographs listed with page and dimensions for gallery data JS files.
[Check April.]

Messages Shows the current messages contained in back_message in data.js shown in the Message Centre and the date of the cookie ID.

Page information Displays information for a page based on the page content and menu_db. Use to cross check consistency.

External services & checks

Closure Compiler Javascript compressor by Google to reduce the download time of common.js etc

RSS Validator to check the RSS conforms to standards.

Check website security. Look for malware, blacklisting and vulnerabilities.

Convert map coordinates Convert between Latitude/Longitude & OS National Grid Reference points.

Changes to common.js

Show/hide all changes.

DateLocationChange

These figures are graphed on the Statistics page.

Cookies

NameValue 

Local Storage

NameValue

localStorage

This browser in this environment CANNOT access localStorage. Some site features are therefore disabled.

Test Area

all rally badges  

THIS IS A TEST OF THE FLASHY TEXT SYSTEM

Why are police officers so strong?

Because they hold up traffic.

What did the grape do when it got stepped on? It gave out a little wine.

Example of Scalable Vector Graphics - no pixelation at any size!

THIS IS ANOTHER TEST OF THE FLASHY TEXT SYSTEM

Two test links...
a good one
and a a bad one.