11015. Continued trouble-shooting the MoneyBooks Inventory’s crashing issue on entering the date on the parameter window for stock history report, later resolving it, also including more totaling on the Stock List and the detail version of the Stock Transaction History List. A second revision v1.633 was made later in the month, putting in code to round stock amount calculations before summing them on the transaction forms, in a bid to prevent having the transaction detail total varying slightly from the master figure as was observed recently.

We received the next Printwiser upgrade request from a client, that included an issue with the work-back report for Capital/Energy estimates. The issue, not showing markup, was resolved (in-house) the next day after finding it only occurred when the estimator indicated that VAT should be excluded. A follow-up revised upgrade request was later received in the month.

11085. We created as requested a stand-alone installer for the client whose Printwiser Estimating was recently upgraded to v10.06. Next day after testing the installer on a separate system we uploaded it to server and sent the client the download link.

11100. A website client recently reported inability to log in at their website. Today we looked into this, seeing that the issue didn’t seem to be that someone changed the password without informing the client. Our next suspicion was it might have to do with the PHP version of the new server. However, it turned out to be due to the PHP function md5() now generating a different hash code for the password from what was stored for it. We searched the web to find out why md5() should now be generating a different value, and saw that its output depended on the character set in use, and html5 on modern browsers now only used the utf-8 character set, different from when the website was created. Probably if the client’s password didn’t contain certain characters, the coded value would have been the same, which was why another person could log in at the site without difficulty.

11144. A minor revision was made to MoneyBooks General Ledger, on the CSV transaction import window and the transaction detail data grid.

11170. Printwiser 10.5 upgrade: Following recent discussions with the client, work on this upgrade began today, beginning with implementing the new multi-database feature that allows switching to any defined database from within the program and also assigning what databases users had access to. The upgrading work went on during the rest of the month:

• Optionally including entry of hard cover and limp cover ratios for estimate extra charges items, for the hard/limp cover estimate working sheet report generation.
• Planning and implementing the biggest of the upgrade features, a new material/labor grouping option for the flexible estimate spreadsheet. During testing of this we discovered and corrected a rarely-activated bug in the cost sheet report.
• Creating the documentation, both in PDF and compiled HTML formats.
• Upgrading local copies of client’s databases and testing against them. While testing on a client database an issue was discovered and it turned out to be due to the database engine software, not the SQL code, as when the engine was changed, the issue went away.