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 unless there is a fault in a startup function, or a duff date in the New and Updated localStorage
Scheduled
Release
Title
Stat
Item marked red are overdue. They are deleted after six days or when double-clicked.
On release date ensure that all support files are in place. eg.
Data.js > menu_db complete
RSS, Sitemap and mobile/index
Badge.js contains link
Home_map for NEW pages
Mon
Tue
Wed
Thu
Fri
Sat
Sun
New people soon to be named.
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.
Charts are now included in Statistics, imported into an iframe.
Monthly - for statistics
On the last day of the month copy the created/updated/star rated figures for the month into stats.js > history_db REMmed out until tomorrow.
Download data from Google Analytics using Chrome browser!
CSV file for the previous month for totals and sections,
Save it into LPMCC Data > WebLogs folder as YYMMmonth.csv, copy it to admin/weblog/sections.txt.
CSV file for the last 12 months for foreign languages,
Save it into LPMCC Data > WebLogs folder as YYMMyear.csv, copy it to admin/weblog/languages.txt
Server Log Analysys: After the above files are in place, produces data for...
pages_db[] as a single total
visit_db[] as a single total
section_views[] as an array
Languages: After the language data is in place. Produces a data line for
lang_db[] for a 12 slice pie chart.
Rally List: Additions, changes, cancellations and active rallies for the previous month are counted and added to
ral_changes[ ] MUST be run before removing last month's rallies.
Jobs completed: Monthly totals of time worked and backed up files counted in job.txt. (Create a new job.txt file each year.)
Single values added to the end of mns_mth[ ] and fls_mth[ ].
Old Star Counts: Creates a snapshot of the number of ratings for pages in the menu so that pages can be counted if they are given stars in the next month.
Author Table: Uses the server log file to produce an individual's (HTML) table of hits.
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.
Reads 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.
Download PDF and spreadsheet from Dropbox - Rallies to the Downloads folder.
Transfer files from Downloads to Ben\Rally Import folder.
Rename the PDF file 2019.pdf and transfer to LPMCC.net/documents replacing the existing file.
Update standard.js with file size and date.
Delete any old XLS files in Rally Imports.
Open the new imported spreadsheet file.
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
Sort on Postcode to remove blank lines.
Show hidden columns and delete them. Look for one between rally details and URL.
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.
Album Numbers: If creating a new album page, choose an available number from this list.
Rename: Three renaming batch files. By date of photo, by example text and thumbnails for a selected recent page.
Choose Photos: Select photos in required order and groups. Indicates aspect ratios.
Update the photo section sitemap by unremming photoSiteMap() function call in eggstra() function of data.js and then open the page for the XML to appear in the Contact Centre. Add the NEW data to the TOP of the appropriate sitemap file. Then open Image Sitemap page to remove any duplicates. Check XML syntax.
Check Thumbnails: For existance and correct 125x94 dimensions based on menu_db listing.
OpenGraph Image: Create 600x315 if there are enough thumbnails.
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.
Rename batch file Detects foreign characters first ! Create a list.txt of badges using dirn.bat, then run this. Paste result into renr.bat and original_names.js. Final badge names need checking.
Perspective Correction For photos taken from an angle. Reduce distortion. Images need further work in PaintShopPro. Capture image with WinKey+Shift+S.
Find existing sizes and locations of the website .GIF files.
Show and measure similar badges by comparing badge_db[ ] badge names with original_name.js > btitle[ ] data.
Badge data Use selected unused badges list from the above program to create data lines for badge_db[ ], extra_db[ ], patch_db[ ] and card_db[ ].
Code Subtypes Code cloth badges (patches), machine badges and stickers with subtypes and replace entries in patch_db[ ].
Count Subtypes Count cloth badge (patch), machine badge and sticker subtypes and find the maximum count.
Badge counts Find the latest totals from badge_db[ ], extra_db[ ], patch_db[ ] and card_db[ ].
Update Badge Sitemap Paste the result into root/sitemap_badges.xml. Then open Photos Sitemap page to remove any duplicates.
Rally Reports with no badges Writes a badge_db entry when there is a report without a badge. These must be added at the top of the badge_db letter group and NOT sorted and indexed.
Missing Rally Reports List rally reports that are NOT in BOTH menu_db AND badge_db.
Patch class promo pictures Double size promo pictures of latest and embargoed patches, machine badges etc.
Promo Badges Create a 500x200 Promo banner after adding new badges.
Thumbnails Create thumbnails from badges for rallies that do not have photos.
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.
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.
Cycling Tasks
Route Plotting Geocodes polylines on a map and measures approx mileage. Used in cycling.js > fpc[ ].
Cycling Miles Creates data lines for miles from Google Keep list. Used in cycling.js > cycle_db[ ]. Adjust existing data lines for miles above minimum.
Rupert Rhymes Add rhyme to box to create Rupert banner.
WhatsApp reformat Paste in copy of WhatsApp messages to reformat into data suitable for smsnn.js file.
Review Lunches Paste ALL review emails into the reviews folder, click 1st_run.bat to rename and create list, then run this program. Output average values into pubs.js.
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.
New Year Changes
Prepare for the New Year with changes to ...
Concatenate two years of rally data in the Rally Lists (desktop and mobile). Change the Mobile Menu link in common.js to next year's Rally List.
Create the next year's gallery taking note of page file names from album_numbers.xls .
Draft a list of cycle rides for the new year and create template pages.
Rewrite gallery data lists of photos for Rallies and the current year gallery using admin_photoz.htm.
Write a review of the past year. Refer to admin/2021annual.txt for notes.
Post the Foz Annual with embargo. Useadmin file to pull Foz Spots out of the year's News updates.
Update redirects on short URLs www.LPMCC.net/cycle/index.htm and www.LPMCC.net/rallies/index.htm.
Create a holding page for activity/printNN.htm until the National Rally data is available in June.
As soon as the New Year begins ...
The usual Statistics update.
Update home_calendar.htm to show the new year rallies saved in localStorage.
Post www.LPMCC.net/cycle/index.htm with new redirect.
Change the target page for Alt+1 in common.js > keyNav(event).
Run Author Feedback and send feedback to main contributors. Update admin_stats.htm>author_count[ ].
Create a rallyYYYY.js file with last year's complete list from rallies_past.xls. Modify and run dev_eurocode.htm to create replacement HTML for insertion into rally_links.htm.
Telephone Donington Moto Services 01509 672220 #1 and speak to Donna Page or Ian King for permission to operate National Rally Control again. Contact Marshals and ask them to put 6/7 July in their new diaries/calendars.
Skype Night Process
Before 8:30pm ...
Start Skype and update.
Restart and log in. Note. It may be necessary to Quit Skype and restart.
Press the + New button.
Add "Skype Night" as session name.
Copy the link.
Paste the link into SkypeNightURL in data.js.
Update menu_db entry in data.js
Field 7: Today's date.
Field 12: Skype Night is OPEN.
FTP data.js onto the server.
Keep the session open.
Prepare data.js by removing the SkypeNightURL value and menu_db change Field12 to Next Skype Night is ....
After Skype Night ends ...
FTP data.js to server.
National Road Rally
Telephone Moto Services manager Donna Page or Assistant Ian King on 01509 672220 (option 1) and check it is OK to operate control with the usual registration of marshals' vehicles.
On receipt of Controls List and Matrix (Late June) ...
FILE
ACTION
In national_rally.xls Create new controls_db in new controls2014.js file.
Check and update Controls. Numbers, locations, details. Renumber all links.
Unset adjustment data in controls2014.js
Draw Matrix using admin_coordinates.htm after updating the included .js file reference. (This page also checks for link inequalities.)
Make adjustments so that the links are clearly visible.
Create/update event_nat_matrixNN.htm. Point it to a new printNN.htm printable route list.
Redirect all previous year's matrix pages to this year's page.
Update mobile/nr.htm. Note that matrix/index.htm should update automatically.
Create a 500x200 home/promo/event_nat_matrixNN.jpg picture and add it at the front of promo_db[] in home/standard.js.
Collect and create entry list in Excel ready for transferring to entries2014.js in the 2014 photos directory.
Immediately before the event ...
Add the latest amendments to leaflet admin/nrr_leaflet.htm and print 20 to take to the Control.
For 2014 prepare 2014/photos_nnn.htm
Put a message in nrr/index.htm saying the new album will appear soon after the rally.
Straight after the event ...
Scan the rider sign-in forms and send them off with marshal sign-in form in the SAE. Include a letter of thanks from template in D:\Documents\Ben\New Sites\_notes.
Create a spreadsheet form with entry number and check in time. (Use Google Docs on tablet to add these during rally duty) Expand the list using NationalRally\entry_times_expansion.htm and paste result into the entry list pasted from the NRR website. Note that there could be duplicate entry numbers. Times should be a four digit string "0000" format.
The photo file requires entry_db[] in entries2014.js for names and time of registering at Kegworth. This file also contains the photo stub list in msnpics[] and known names in a parallel known_names[] array (as they are found from photo requests. Also in this file is comments_db[], The last field is a photo of the person sending the comment.
The photo date naming convention applies BUT early photos must be named for times after 11.51am.
Change the target of the redirect in nrr/index.htm to the new photo album.
Document this year's experience in event_nat_review.htm.
Thank the marshals and the Kegworth site manager.
Prepare for next year!
Annual Survey
LPMCC.net seeks feedback from users in October using a questionnaire and a localStorage data record.
No survey flag data. Press f5 to reload the page and show the survey if you have localStorage.
The survey does not appear until the second LPMCC.net page is opened. It does not appear on subsequent pages until LPMCC.net is revisited at least one day later. Once the survey is completed and sent in it will not appear again for at least one year. This is achieved using localStorage to flag page number, when it is visited and when the form is sent in.
the questionnaire flag.
The survey respects pop-up blocking.
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.
Date
Location
Change
New and updated
Insert this table into stats.js > history_db
Star ratings are added to history_db by hand from email count.
This table is location dependant and is only correct when regularly viewed!
