I created a program that creates a program and exports the result in a tab-delimited file by using the data descriptors. I entered some standard stuff like file, name, heading, data descriptors, break-on and id-supp. I expanded this to launch excel and import it on the fly so that a user could run a report in multi-value and the result would appear on his work station in Excel a few seconds later. No repetitive headers or the rest of the spooler junk. I than incorporated it to process the end-of-day reports and store them in tab delimited format in the end_of_day folder on the server. Then I emailed the excel reports the end users.
D Raven P.O. Box 17811, Irvine CA 92623-7811 -- "Mark Johnson" <[EMAIL PROTECTED]> wrote: Wow, you pegged me properly. I once bought an SP-JOBS utility for D3 (allegedly) and it was somewhat incomplete and had a few bugs that it basically taught me what to write and I wrote my own. P.S. If not for anything else, Microdata had one of the best spooler manager. Thanks. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, April 16, 2005 8:21 PM Subject: Re: [U2] Hold-file to CSV > In a message dated 4/16/2005 7:34:46 AM Pacific Daylight Time, > [EMAIL PROTECTED] writes: > > > > Like many systems, this one is full of finished reports (both english and > > databasic) and the object is to send them to the hold-file and convert from > > there. I don't want to re-invent the report generation logic, just use the > > hold files. > > Yes you have to parse the headers to determine the column start and stop > positions and then scan the data to extract the column/row cell entries. > I know you're the type that likes to program it yourself instead of buying > it off-the-shelf :) > Will > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
