I posted a new zip file for KgdGenHtml. It has source code on all but 2 routines.
JobReport was not written by me. Tony Curcio wrote it and I do not have source. Maybe he will post it. Nice job Tony by the way.
The other routine without code is KgdGenHtmlFromSqlRtn. I am not teaching you guys how to use ODBC in BASIC. You do that way too much now. It is not a good practice to go around the GUI but I like this routine. It lets me feed any SQL into any ODBC connection and generate html document which I can email. It is a very important piece to EtlStats as well. I use it in the QA part of EtlStats as well. I think the ETL should notify you when it succeeds and when it fails with the best looking reports possible. That is why I wrote this routine. I cannot always count on BO or MicroStrategy to write my reports. This is quick and dirty and I think it looks professional.
This all started from this private message. Please post questions in the forum and no emails or private messages but thanks for this one. This zip file has not been updated since 2004 so it needed a fresh look.
From: thurmy34
To: kduke
Posted: Wed Sep 13, 2006 7:41 am
Subject: KgdGenHtml Quote message
Hi
I found the documentation facilities (KgdGenHtml) and it's very useful.
The thing is that i can't see the code of your routine.
Do you mind send me it ?
I just want to improve my understanding and my knowledge.
I've tried to use the KgdGenHtml and it works OK but seems like it is not generating the bmp images for each job, or at least they are not under ..\KimD\Jobs\ directory or anywhere else in the server.
I've copied the DSaveAsBmp.bat and DSaveAsBmpDriver.bat to my local client directory C:\Program Files\Ascential\DataStage7.5 but still isn't generating bmp files.
Do I have to copy the *.bat to a specific directory? Do they have to be at server side?
You need to edit the bat files to see what directories are hardcoded. Normally they are installed in C:\DataStage\KimD\Scripts. There also needs to be a C:\DataStage\KimD\Backups directory unless you edit the files.
Your automated report generator will be a godsend for the backlog of job documentation I have to do. I generated reports using KgdGenHtml. The reports give less detail than the ones I get when I use Designer's report generator. What do I need to change to get that level of detail.
The only problem I've found is the size of the final solution because of the BMP's from designer. I got around that by converting them to jpg and sed'ing the html to change bmp to jpg. I have also added an annotations area as a scroll port in the html, linking to a file in an annotations directory created via touch. Users, designers etc can edit this file and have it show in the doco.
I have to agree, this is the best tool for documentation. With discipline on the developers part to fully document the jobs and stages (standards, standards, standards) the html has become our only documentation method as it's easy to keep up to date, where other forms tend to be either not complete and are rarely updated.