Some of my 20-something Computer Science students at the community college where I teach see me as a living fossil because of the several decades age difference between us. Their perception is reinforced when I tell them I use decades-old tools like batch files. However, sometimes an oldie can still be a goodie. If you’re interested, read on.
I am an ENA (Evil Network Administrator) at a law firm. The firm’s accounting software stores client and matter information. The firm’s document management software needs the same information. Entering the same information twice would be double work, plus doubling the risk of data entry error. However, the accounting software did not provide for an export of its client and matter information into a format recognized by the document management software. Complicating the task is that the two applications use very different database formats.
Text files usually are a common denominator. Accordingly, my plan was to export the client and matter information from the database of the accounting software into a CSV (comma separated values) file, and then import that information from the CSV file into the database of the document management software.
start %WINDIR%\SysWOW64\wscript.exe godzilla.js //NoLogo