I have a Progress DB field that stores a time stamp in seconds from midnight format (1-86400 seconds). I Googled and only seemed to dig up examples from other languages. This is my attempt in VBA/VBS Language. It seems to return the correct values. Function ct(stamp)...
James McDonald
Fedora 10 – Network Interface not coming up
I have a Fedora 10 VM that wasn't bringing it's network interface eth0 up on boot. Even though the settings in /etc/sysconfig/network-scripts/ifcfg-eth0 were correct. The problem: the network service wasn't enabled The fix: run ntsysv or setup ==> services from the...
XSLT
At work we have an ERP system that can receive information in a proprietary XML format via directory drop or Web service call. Our customers place orders with us using disparate systems and methods. Fortunately most of them output some sort of XML. How to convert one...
Power outage for a day
Today 7 Jan 2009 we have an all day power outage starting at 8:30AM. Seeing as this webserver sits under my desk at home and the UPS is a tiny one that means that we are going offline for the duration of the outage. Be back at about 4:00PM
Clear Squid Cache CentOS 5.x
How: service squid stop rm -rf /var/spool/squid/* (removes cached files and directory structure) rm -rf /var/log/squid/* (removes the logs) squid -z (recreates the cache_dir structure) service squid start Why: Doing the above can be helpful if you want to claw back...
Running Cron Every X Minutes
I keep forgetting the correct format of cron entries to have a command run every three minutes To do it every three minutes you need to make the syntax */3 not simply 3 (which means on the 3rd minute of every hour) # m h dom mon dow command */3 * * * *...
LedgerSMB – Changing Invoice to “Tax Invoice”
This is done on Fedora 10. File paths may change depending on what install package or location you install to. On Fedora 10 the path is LSMB_ROOT=/usr/share/ledgersmb To maintain an orginal untouched set of templates you should always copy the demo templates away to a...
Putting the I in Idiot – or I just deleted my External USB Drive Partition
The Problem: Doing a Windows XP Pro install at work... Boot Install CD Delete partitions Delete C: Hmm didn't know there was a D: but hey it's got to go.... Delete D: ... Oh No! That was my 250GB External USB drive holding a heap of backups.... Argggh The Fix: I have...
Changing the LedgerSMB Letter Head Graphic
Make a backup of the original demo templates cp -rv /var/lib/ledgersmb/templates/demo /var/lib/ledgersmb/templates/template1 # on Ubuntu this was sudo cp -rv /etc/ledgersmb/templates/demo /etc/ledgersmb/templates/template1 Go into the LedgerSMB admin control panel and...
Make a y/n prompt for cscript.exe using VBS
msg = "Do you wish to add " & First & " " & Last & "?" wscript.echo msg Wscript.StdOut.Write "Add Employee to DB? (y/n) " choice = Wscript.StdIn.ReadLine ' read the input if choice = "y" or choice = "Y" then ' do what you have to do .... end...
