1134. Made the first of three technical support visits to NRC this month. December payroll was imported into EPPMS from IPPIS. Compressed EPPMS backups were copied using Double Commander to a 64 GB flash drive that had the exFAT filesystem, while using Windows Explorer for a big 2.4 GB database file to avoid corrupting the flash. When we wanted to use the flash back in the office it was again unreadable. We had to consider other file managers that would not get the flash corrupted while copying to it, eventually settling for 7zip after trying Total Commander and still experiencing the corruption.
1160. Made the first 2022 revision of Gerian, correcting the non-initialization of the newly introduced sign-ups and hits columns for new rows on the Key Code List. We tweaked the automatic calculation of HIDDEN streak for a new game, by first converting the date to SFI date based on the time. This was so it would no longer be necessary to correct the wrong streak that was calculated when the local date was ahead of (or behind) the SFI date.
1230. We did the first 2022 revision of MBTM as version 1.94, addressing update issues on the activity forms (as on the image shown here) and also allowing the Details value and those directly below it to be re-sizable or movable, then revising the to-do list form. We also looked into and saw why the invoice approval setting didn’t seem to be working during project time invoice generation.
1252. We began preparatory design and coding work on the Printwiser Estimating upgrade that was discussed with the client last month, working on database tables and SQL functions and procedures to do the actual flattening of estimate values to a single table format. This continued for the rest of the month.
1274. At NRC we transferred compressed backups to the 64 GB flash once more using 7zip File Manager. Back at the office, the flash again was unusable on our computer, Windows saying it needed to be formatted first. So now we had to begin suspecting that something else on the NRC computer was also responsible for corrupting the exFAT filesystem in the flash each time we copied to it there. To be on the safe side we would need to stop using that particular flash (with the unsupported exFAT filesystem) there.