Original Blog Entry: Updater file test worked wonderfully!

hypersoniq — Tue, 25 Nov 2025 18:52:19 GMT

I let it go a few days to see if it would capture just what was added... and it worked! Updated all 14 games of interest to their respective csv files, including bonus balls for the jackpot games that have them... no extra or missing data!

It seems surreal having to run one script and have it replace what would have been at least an hour of work...

The updates complete in seconds for each game, less than 2 minutes total run time!

The rest of the work I am doing seems to pale in comparison... THIS was my 2025 coding goal and it has been met !!!!!!

Both the builder AND the updater have been built and tested!

There are some considerations in the pick N games, such as now the double draw promotional results are in the data, as well as the infamous 666 fix draw... but since I am not currently using full history, that seems it will not be an issue.

The builder allowed me to capture data from matrix changes by entering the start date, or by just entering a start year for the pick N's

The updater only returned new draws by reading the last date in each csv file and starting from there... it does not matter if it was a daily or run 2 or 3 times in a week.

I also no longer need to maintain a separate spreadsheet file for each game, as the data from a csv is easily imported into a sheet if needed.

Today I am busy identifying and converting variables in the classifier script to be passed into the function call... almost there with one function for any game!

These are the key challenges in the GUI transformation, and the updater part is now fully functional! The universal function for classification is not far behind... with testing maybe a few hours to a few days tops...

Whether or not the classification idea goes anywhere, I have the building blocks for my own software development framework, which can be tweaked for ANY idea!

Like Ice Cube said, it was a good day!... [ More ]