It looks like we’ve outgrown our web host with the additional data that I’m collecting in the Dev Tracker. So, I’m now considering moving hosts. As a trial, I’m testing out using AWS for the tracker, which you can now see as links under the PK’s Tools page, called “Alternate Dev Tracker 1” and “Alternate Dev Tracker 2”
I have now “upgraded” the Powers Checker application to use Microsoft’s ACE OLEDB library to load the Excel sheet as if it’s a database for querying, rather than using EPPlus to import the ExcelPackage one row at a time. This speeds up the startup of the application SUBSTANTIALLY, from something like five minutes to just a couple of seconds.
If anyone gets any errors running this new version, try installing the required Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255) first, then try again. If you still can’t load it, contact me on the Homecoming forums, and I’ll look into it. I have saved the EPPlus method in the code as a backup in case this fails for most people. I’ve also updated the source code zip file with the latest version of the source code.
I’ve updated the Homecoming Dev Tracker, so it’s back online for the first time since Homecoming moved to the Invision Community. I’ve also sped it up to take about a fourth of the time that it used to take to load, by making use of asynchronous functions. Yay coding upgrade! You can check it out under PK’s Tools page as per usual, as well as download the latest version of my nasty code. New things are coming… Soon™