Toggen Blog

Tech tips

Articles

Latest

Access

Blog History

Command Line xTuple DB restore on mac

Command Line xTuple DB restore on mac

This is for a restore to a remote host running postgresql on a custom port and using the pg_restore provided by pgAdmin on a mac. gzcat xtuple-2016-11-07_1412.dump.gz | \ /Applications/pgAdmin3.app/Contents/SharedSupport/pg_restore \ -v -p 5434 -h 10.20.20.20 -U...

xTuple Postbooks Edition 4.10.0 RC FTW

xTuple Postbooks Edition 4.10.0 RC FTW

So for a while I was using Simple Invoices to raise invoices for my Small IT Consultancy Business. However in a short space of time I found that it just didn't have the bells and whistles that I needed. Being an avid fan of Open Source software I looked around and...

Perl Script to Parse PDF Invoice and Send Email

This script uses perl to run pdftotext to grab the text from a PDF Invoice. It parses and extracts document meta data and then uses that to construct a meaningful filename and attach and send the PDF to the correct recipient. You could automate this by placing a watch...