James McDonald

Access

Blog History

Scripting PSFTP and PLINK using VBS

Sample script of using PuTTYs psftp and plink to: login to a remote linux host using plink via ssh, run a find command to return a list of files in a directory tree, build a psftp batch script to grab and move the remote files login again using psftp and run the batch...

read more

RegRead / RegWrite VBS

Thinking of storing settings in registry. Some sample code: set oshell = createobject("wscript.shell") apf = "HKEY_LOCAL_MACHINE\SOFTWARE\Settings" settings = Array("user", "domain", "password", "host") slug = apf & "\edi_transfer_" ' create APFoods key...

read more

VBS Dictionary Object: The poor mans JSON

After spending a lot of time coding in jQuery and CakePHP. Which rely heavily on JSON and PHP Arrays respectively I have come to appreciate storing stuff in objects. Most of my at work Windows scripting stuff is done using VBS so I was searching for a way to store...

read more

Learning Git

Generally if you Google you will be heading over to stackoverflow and will probably find the answer to specific problems quite quickly. However it pays to have a structural overview of git. I found the following two resources immensely  helpful. The most amazing...

read more