Work Items and Priorities

TOPO Priority Tasks

to test the new entry system
click  My_entries  to ensure you are logged in as the person you want to enter
then use the back button to go back to this page and click the event you want to enter them for

WDT 2020
  sil 2021
Pom 2021
Exmoor Trial 2021
Blyton 2021


Work need on Cloud Based Finder delivered 26th June

+ Involve Lede in support and maintenance and agree terms of support contract. 
+ TOPO to decide on priorites and dates for next phase, with sugestion for later phases.
+ TOPO to start Functional acceptance testing, eg a staff member executes every step of a typical office process.
           Eg Credit card billing for a Race meeting.,  create entries & results program for a new event.
+ TOPO to define rules for n and b options in newsletter wizard. 
+ TOPO and Lede to test inserting new members and Credit cards from cloud.vscc to vscc_membData
        using Finder's action  Membership_Maintenance.Import_New_members_from_website ,
                  For testing use devSite  and program FinderTest (2)
+ TOPO and Lede, To allow new entries for Mallory edit web site and Finder data ;
              Remove race selections for existing Mallory 2020, Not sufficient to just delete in Finder
+ TOPO to test results EXCEL program with Office 365, Potentail problems PCs may need to have installed ADODB.Recordset Provider=Microsoft.Jet.OLEDB.4.0;  


Urgent Issues for Lede

+ split my_detaisl and membership list profile, or make 2 columns
+ include memb type in new member email
+  set web fee for ex members to allow online rejoin, (needed pre march 2021)
+ ALTER TABLE `vscc`.`User` ADD INDEX `User_NameId_IDX` (`nameID` ASC) ;
+ adminPageID=28  Adress4  should read County or contry and offer a lookup into counties table
+  newFeatureAccess  shoudl default to NO, there are 5000 who have access WHY?  please remove priv.
+ allow single sign on or parrallel sign on to admin , members an dweb finder. 
+ for tables like membName, default created date column to create date, NOT update timestamp()
+ add contsratints to vscc_MembData , vscc_compsData, other to be done in slow time
+ DR done from finder,  TOPO can now bulk edit contacts detaisl that are invalid.
+ for members website move all Finder tabe to clustered schemas
+ new functionality - members to add credit cards via vscc.co.uk
+ install the konica printer so printed reports can be generated from cron jobs 
+  membership data is to be verified on entry, eg is county in county table
    could be done at the finder end if upload sync is available.
+ Recreate all sync functionality to web site  that was running on old server
+ bulk upload of full scheams, eg vscc_AwardsData to clound when triggered by  insert into vscc_ho.upload_control,     by insert into table from Finder or with  scripts C:\VSCC_dbs\progs\Prod10\scriptsMySQL\schemas  uploadControl.bat which is called from housekeeping trigger files
+ scheduled tasks hang , because access scripts do not close MySQL connections.
+ date-updated column  needs to be added to all defs table in MembData and CompetionData.mdb
   the reimported into P:\VSCC_dbs\data\Prod09c\PublicData DefsData_ClientCopy.mdb
+ new enrties to have correct defaul class,  Races default  NA - no class for races
  other default to na or dash as agreed., or at least defaule ot id=600   dash for all event types
+ adding new VSCC cars must check for existing RegNo and Link cars. (was working)
+  FS_VSCCcarsEdit form does not allow link or merging cars with pull down boxes
+ eventEntriesForNames.bestTime default to 5.55

Lower Priority System & Database issues


+ FinderAction views create  from C:\VSCC_dbs\progs\Prod10\Finder_sql\\FinderDataViews\ 
+ Move vba to MySQL  create trigers from vba code in C:\VSCC_dbs\progs\Prod10\Finder_sql\triggers
+ web finder increase title length on https://www.vscc.co.uk/finder?action=335
+ web finder add selector for  race range, race type, and trophies name
+  Add help button to  webFinder Page to display Help text  from ActioData.memo
+  db_import_TOPO_XX.bat  needs to import FinderDataViews as views are NOT exported to dmp file
+  or change connection method in  vscc_results.xls  importEntry.connectDb()
+ online data changes to data on .251  ( eg office_finder.php) 
+ backup  Finder source and data (a full copy all Finder source is currently made weekly to NAS)
+ create ssh users so staff can access db.lede.co.uk from home , currently they all use drolfe
+ change tables shown below used for Trophy Points pages  (maybe create view)
     EventResultsTrophies_DriverCarDataDisplay_YY to EventResultsTrophies_DriverCarData_YY
     EventResultsTrophies_DriverDataDisplay_YY to  EventResultsTrophies_DriverData_YY
     Then delete  tables like vscc.AwardsData.EventResultsTrophies_DriverData*Display_YY 
+ Now membership is live add important constraints to vscc_membData m eg for NameId
+  memb report SubsPaid_TotlaCash_CrosstabSummary_Crosstab when built from cron has invalid cash formats


When MySQL is MASTER
move finder program code  mdbs  which useto links mdb data to MySQL db

****    Saving historical data for Race Meetings  ******** (This is a fundemental to handicapping )
currenlty the history race data is not being insert into race reulst amd history tables.

see code in vscc_eventResults.mdb   FileFunctions_raceResults.updateVsccRaceResults()
str = "INSERT INTO RaceResults  does not insert a value for the column BestLap
eg for Mal2020   select *  from RaceResults where BestLap = null and EventId = 1619


consider  importing of TK file in web finder v  importing in finder.mdb

importing timekeeper files on web does not insert data into .251 schemas
actions FinderActionProcessing have event Ids hard coded
Updating race results and practice resuts in Finder looses time BestLap
building tables with variable columns from crosstabs queries needs to be moved from dmb sql to MySQL
Move race step 5 to MySQL see comp/VSCC_RaceHistory_CreTables_MySQL.mdb
Speed history table Speed_History_Times is a variable table  create dafter each speed evnent

 

Web Finder 2.1 Issues

  1. All these pages on members site  use _dev not live data    FIXED
  1. Can you give me the SQL so we change these queries to views in FinderDataViews ( in line with how we use views in )
 In web finder ; To prepare for different level of users. Replace vsvv_privateData table with view Vscc_FinderDataViews. ActionsIdsAlowed where User Code = "finder"
 
  1. In web finder ; Display short code, Mal20, for event selected  top of page and increase length of texr showing action
  1. In web finder ; Increase time out and don't loose event selected
  1.  In web finder; Display short code for the event selected , eg Mal20, at the top of page and increase length of text box showing action selected
  1. If easy In web finder; Add run button to so we can run process without uploading, later upload box will be optional.
  1. This needs long term thought.
Vscc_FinderDataViews do not recognise when new columns have been added like Mal20
Even though the view created with select *  , the view is built with all the column names
eg
create view  vscc_FinderDataViews .HistorySummaryEvents as
select *      FROM        `vscc_HistoryData`.`HistorySummaryEvents`;
eg SELECT * FROM vscc_HistoryData.HistorySummaryEvents  where DriverNameId=8452 and CarId = 21408;
 
and table  HistorySummaryDeltas
 
 The same will be true for Trophy tables which has the events across the top
 
 

 
****        Later changes   To  Web Finder ********
 
Add print button and fit table to page width.
Add a help button to display action memo field
For non speed events is it possible to hide actions that are for EventTypeId=12
 
 
Longer Term possibilities,
After TOPO has fully moved to mysql version
As an alternative to upload file, add a button to run processing
Allow different privileged users from UserDefs and linked to roles, eg Comitteee, eligibility
Allow some columns to edit 251 data with or without using Office php forms. Should also repeat in cloud to allow instant refresh.

Tasks moved from above when Completed

+ web FINDER 2.1 to use lookup table for queries
+ Rename vscc to vscc_ho
+ WebFinder 2.1 cannot see Prescott Track Day 1st Aug 2020
+ set as trusted location ,   \\10.149.0.2\vscc_compswrk_and_database\VSCC_dbs\data\Prod09s\membData 
+  db now called _ho or hq , may have no access for user vscc,
       check out housekeeping scripts uploadControl.bat, syncDisable.bat
       drop OLD schems from .251  vscc and vscc_dev
+ scheduled tasks hang , because access scripts do not close MySQL connections.
   scripts in scriptsMySQL can not see teh P; when run from schedular
   so script must map teh network drive or use the  login profile   
(effects the ability to run the old and new finders in parallel as no new entries will NOT be seen in the old finder) 
+ TOPO to sign off unit testing (ie Colette's testing to ensures each action attempts an activity).
+ TOPO to agree a date for the move of Membership Maintenance  to New System.

Lede COMPLETED tasks
+ vscc_MembData.UserDefs table is wrong when seen as a link from program vscc_Finder_MySQL_*.mdb
+  web finder points to table _dev, 

Membership Issues

 
+ MembMaint crashes when calculating members subs.


TOPO to test 
 Membership subs updates and annual renewal process

Comps Issues

Renumbering hangs with shared cars

Lower Priority 
+ Import table constraints from access before comps migrated
Aggregate Trophy calcs update with new Lycett rules

Web Site Features

+ can the memebrship login go to site map https://www.vscc.co.uk/page/my-vscc not old MyDetails. Also can we have a pop up on the Sign In button as previously? Currently it goes to the link above but it is not immediately obvious to members they then need to second click a link to sign in.
+ as TOPO library db is  not synced to cloud Lede to create new web pages to edit library database, then turn off  library access database
+ allow admin user to view front end pages as any member, important as PINs not available
+ Update Style of Admin site
+ Update My Account to new style
+ Release Eligibility pages - requires populating with exiting cars and makes
+ Allow Eligibility users to upload a photo for exiting cars
+ New Page History by Make - Allow dynamic selection of make for click to SQL for Marque Pages
+ query speed in Access using MyISAM v InnoDB see tests in .\main\storage.accdb

members web site

To Finsih Eligibility 99% complete
  1. Remove eligibiliy test data
  2. insert list of car makes, already in vscc_MembData.
  3. populat eligibility data with cars from  vscc_competitionData.CarsVSCC, This will ensure all existing eligible cars are in teh eligibility susyem with their buff form number
  4. Initally restrict members use to updating existing cars with adding photos.
  5. Ensure photos have been uploaded before request submitted

 Post  2020
  1. electronic ticket sales  started  01/02/2020
  2. MSUK licences and trsnponders  started  01/02/2020

___ Milestones __


Work Items for Finder Project. With entries suspended and no member changes the migration goals are;
June membership jobs working in test
July Find conversion tool that retains commemts and constraints
June/July TOPO signs off membership jobs working in  MYSQL Finder 
eg calcualted entry fee
July move  membership maintenance to  MySQL -Finder 
Access Finder to continues using data published from MySQL memb data

August/Sept have important comps working in test
Oct  have important membership renewal working   (moved to JUNE)

2021  -  April have race meeting functions available,   Oct -  trophy Engraving 
No parrallel double entry with old system is planned