Alex Kovacic

Rebuilding old software

The Access database, the spreadsheet with 18 tabs, the PHP 5 site nobody wants to touch. I rebuild them and bring the data across.

When it's time

The software still works, but only on one computer running Windows 7. Whoever wrote it no longer answers. The spreadsheet has macros nobody dares touch, or the site runs on a PHP version the hosting company is about to drop.

How I rebuild it

I start from the old software: I open it, read the tables, formulas and macros, and write down what it really does, including the rules nobody remembers any more. I can also read Access databases (.mdb and .accdb) without needing Access. Then I rebuild it as a web app, with the old one still running until the new one is ready.

The data comes along

For my CRM I wrote a script that imports the old data and can be run again without creating duplicates, so the last import happens on switchover day, with that morning's data. The original spreadsheet had 18 tabs, and it stays available in an archive with its original formulas.

Problems I often solve