12021. Preliminary work on the Printwiser 10.5 upgrade was completed in the next two days with the setting up and testing of the client installer. The installer serves to update an existing Printwiser as well as installing a new one, optionally installing the two different client databases for standalone access.

12113. We revised the csv import in Lemeechi StockReader to handle duplicated rows appearing next to each other. We made a database-side adjustment to MoneyBooks GL, ensuring amounts for a posted transaction cannot be changed, both master and detail, using two before-update triggers. Then we did the v1.65 revision of Gerian, on the Bookmark List (enlarging the size of URL column and introducing year, month and day columns for querying) and HIDDEN Form (ending any pause mode on game resumption; automatically resuming when the Continue keyboard shortcut was pressed instead of beeping when Resume keyboard shortcut was not first pressed).

12172. Over a week ago, we encountered a “Bandwidth Limit exceeded” error situation with our primary website, that effectively made it inaccessible. It took several days before things got back to normal.

We had once considered making the statistics generated by cPanel’s Webalizer tool more easily accessible by importing them into MoneyBooks, and that incident prompted us to action. We worked on the database side, designing the tables to store the data, then on the client side, starting a new Website Statistics submodule of MoneyBooks Data Manager v3.5, with implementing the importing of the first section of Webalizer’s monthly statistics html file. The work on the submodule continued until completion about a week later:

• Importing of the next 2 sections of the Webalizer html file, hour/day hits and hits by response code. We had to introduce a new table for the response codes as we saw there could be different sets of codes each month, so were not suitable for fixed column names in the main monthly table.
• Importing of the remaining sections—daily statistics, hourly statistics, top URLs, top entry/exit pages, top sites.
• Display of imported detail data stored in the child tables—response codes, daily/hourly stats, top URLs, top entry/exit pages.
• Updating our 3 in-house MoneyBooks databases for the new MBDM version, then importing Webalizer data for January to November into the company database without any issue, reviewing it and noting enhancements that could be done to the submodule.
• Implement searchable lists (all months at a go) for the website statistics detailed data—Top URLs, Top Search Strings/Site/Country/Referrer/User Agent. The Top Search Strings for instance shows what people are using to search for the website and when.
• Implement the View in Browser button that shows the original usage statistics html file of Webalizer in a browser. The html file and associated images are recreated from the imported data if they no longer exist locally.
• Implement the View/Update Monthly Chart buttons for the Monthly Statistics List. The monthly chart is a bar chart of traffic for each month of the year up to the current month, so would need to be updated on monthly basis, or at least at the end of the year.
• Implementing a toolbar icon for the Monthly Statistics List for faster access. Finally, implementing a before-delete trigger for the monthly statistics table, first deleting the attached documents (html and png files) from the database, ensuring they did not remain as orphans in after deleting a particular month.

12194. Having identified the publicly-advertized URL for our Online Shop as being the target of robots and web crawlers since last month, resulting in abnormal traffic of up to 18 GB monthly that led to that bandwidth limit issue, we decided to make that URL to display an under-maintenance message, as a temporary solution. Please email us for an alternative URL for the Shop, in the meantime, if you wish to visit the Shop.

12264. Because VideoProc stopped working on a Windows 7 system after we installed the latest upgrade, insisting on Windows 8 minimum, and because the video downloader extension in the Firefox browser in the same system was attaching a watermark to long videos, we went looking for something to replace VideoProc. We downloaded the 64-bit version of the open-source Libre AV Converter and checked it out, downloading videos from YouTube and X (Twitter) though with some issues.

12275. We began coding changes to this Blog, rejecting public attempts to use i/frame tags in comments. (Earlier in the month, public attempts to use image tags were rejected, to check against spamming.) Began customized pagination for comments, so that only 10 comments would be displayed at a time. The review of the Blog was completed two days later, with the implementation of pagination and search for the Users list.