Thanks. ----- Original Message ----- From: "Paul Trebbien" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, April 18, 2005 11:22 AM Subject: RE: [U2] Hold-file to CSV
> Hi Mark, > I note you're from Comcast - they used to run use the DataFlo ERP > system. I met Comcast employees in 2002 at the Epicor Users Group > conference in Minnesota. I believe Comcast has switched to E by Epicor. > > Anyway, possibly if you still have wIntegrate you can use the Query > Builder for generating a report in CSV format. Essentially, you need the > 'output' in a file so Query Builder can use an Info/Access statement to > import that data to your PC. > > For the last 20 years I've been supporting DataFlo (at DataWorks, > then Epicor, and now here at Kore Technologies). What I do for my customers > who request that I add the ability to 'Export' the basic program report to > an Excel Spreadsheet is to use the DataFlo Report Manager's Export option. > The processing goes something like this: > * Select the records. > * Call Conversion subroutine to build records in a temporary file, > before returning be sure to select/save the list of records from the > temporary file. > * Report manager sends a 'get-list' statement and the list of dict > items to wIntegrate's Import Utility which transfers the output to the xls > file on the user's PC. > > In that Conversion subroutine (copy of the basic program that used to > generate the output), I create a single record for each line of output with > the data in each attribute representing what would be in the columns. Note, > if there is another file which has the same data configuration I can format > mine the same so can use that dictionary for the Report Manager's 'Export' > dict items list. DataFlo is nice that it has a temporary work file for each > user that logs on (TWFnnn) which I use as it enables multiple users to run > the same report at the same time. > > Hopefully, this will help. I discussed this concept in our Kore > Newsletters using the Sales Order Backlog Report as an example. See the > July, August, and September of 2002 issues which everyone is welcome to look > at on our website at koretech.com - under the <News> tab choose "News and > Events" and go to the bottom of the page for a links to all past > newsletters. Look for Paul's Corner and my Q&A's. > > Have a Great Day! > > > Paul Trebbien > > Kore Technologies, Senior Support Tech. > > "Solutions that work. People who care." > > V 858.678.0030 F 858.300.2600 W www.koretech.com > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Monday, April 18, 2005 6:34 AM > To: [email protected] > Subject: Re: [U2] Hold-file to CSV > > > How can Basic be limiting. It has everything English (sic) has and so much > more. In fact, there are many reports that 'turn the corner' and cannot be > done in English and must be done in Basic. > > > ----- Original Message ----- > From: "Dave S" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Sunday, April 17, 2005 10:35 PM > Subject: Re: [U2] Hold-file to CSV > > > > That's the danger of creating reports in Basic. As you can see it's very > limiting. > > > > > > Mark Johnson <[EMAIL PROTECTED]> wrote: > > I have my own method of taking English (access etc) statements and > creating > > CSV's. I'm talking about not re-engineering existing report. > > > > Thanks. > > > > ----- Original Message ----- > > From: "Dave S" > > To: > > Sent: Sunday, April 17, 2005 7:57 PM > > Subject: Re: [U2] Hold-file to CSV > > > > > > > If the reports where written in Uniquery it would be simpler to extract > > data from them. > > > > > > Have you looked at MVQUERY ? > > > > > > Key Ally wrote: > > > [AD] You can do this with Zeus as well, and Zeus has other advantages > > > which Monarch does not share. (www.MtOlympus.us) [/AD] > > > > > > Roger Glenfield wrote: > > > > > > > Monarch from Datawatch. Converts report files into data. > > > > Mark Johnson wrote: > > > > > > > >> The whole premise was to use the existing reports that are presently > > > >> designed and not re-engineer them. > > > >> 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. > > > ------- > > > u2-users mailing list > > > [email protected] > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > --------------------------------- > > > Do you Yahoo!? > > > Plan great trips with Yahoo! Travel: Now over 17,000 guides! > > > ------- > > > 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/ > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > ------- > > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
