Advertisements

So it seems when ever I want to learn something new

I find that blogging about the learning process is very helpful for me, and hopefully for anyone who is following behind. So I have started a new, from the very beginning blog on learning QlikView. QlikView is amazing, and is very simple to learn yet so very complex.

Here is the link

Tales from a QlikView Idiot

Advertisements

Qlikview Reload on document opening

Tools, edit module

Create macro

Sub ReloadStuff
ActiveDocument.Reload
End Sub

And then go to settings, document properties, macros tab, OnOpen and then select your ‘ReloadStuff’ Macro

Enabling management interface openVPN

To enable the management interface on either an OpenVPN server or client, add this to the configuration file:

management localhost 7505

This tells OpenVPN to listen on TCP port 7505 for management interface clients (port 7505 is an arbitrary choice — you can use any free port).

From here: http://openvpn.net/index.php/documentation/howto.html

Programming up some glue, PDF Search and Send

So I’m lazy, I admit it. And I had a personal itch for a program that could burst out PDF’s, search through them for a string, and then email it to a matching email address. Mainly this is to automated a process that I imagine probably happens in quite a few places. Lots of payroll systems can export vouchers to PDF but they often do so in to one large PDF (probably for printing or archiving or something) so then you end up with some poor poor payroll person splitting the PDF by hand using Adobe Acrobat, renaming each and every PDF to that person’s name, and then emailing out each and every PDF voucher. Doesn’t this just sound like a process that begs to be automated!! I actually have coded up a solution before in C++ using GhostScript, but it was specialized towards payroll vouchers only. This time around I decided to make a more generalized search PDF’s and then email program.

It turned out to be mainly an integration process. First I hit upon pdftk which can easily burst out PDF’s and it’s GPL as well. So the bursting was taken care of. Next I needed to convert the PDF to text so that I could search inside it. Here is where Xpdf comes in to play, it has a pdftotext.exe utility. (GPL as well!)

So I burst, then I export, and then I regex search, and then I email and wa la. PDF Search and Send is born.

So how do you use it?

First choose a folder that has PDF’s that you want to search and send by clicking thee ‘Select PDF Folder’ button.

Next hit the Edit Users button. The format is ‘what string you want to search on’ comma ‘what email address you want it sent to’

So lets say you had a voucher for Sam the format would be

Sam N nobody, snobody@somewhere.com

Ok, then you fill in your mail server address, from, subject, and body and hit the magic ‘Send Matching PDF’s button’ if all goes well it should burst, and then send out, matching PDF’s to these people.

For downloads and updates this project is going to live here, https://michaelellerbeck.com/z-pdf-search-and-send/

mailto link in vb.net

System.Diagnostics.Process.Start(“mailto:address@domain.com”)

WARNING! August 12 bug in ESX 3.5 update 2

http://vmetc.com/2008/08/11/august-12-bug-in-esx-35-update-2/

http://www.theregister.co.uk/2008/08/12/vmware_12_august_esx_cockup/

This is an extremely bad bug that has not really reached the masses so pass on the word.

Fun with ExMerge, working around 2gb .pst size limitations

Find this post interesting? Do you like interesting things? Maybe you would like my invention, a connectible candle called a WickBrick!

Get one here http://wickbrick.etsy.com/

WickBrick

So having to recover email is always a chore… but it gets even nastier if the size of the exported .pst is larger than 2GB. At first I was going to use the .pst truncating tool from Microsoft but then after reading this post http://articles.techrepublic.com.com/5100-22_11-5109505.html

I decided to just export date ranges, and then I was pleasantly surprised to find out that the missing items where in my users sent box, so I just exported their sent items and all subfolders. Hope it has what is needed!