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: u2-users@listserver.u2ug.org
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: <u2-users@listserver.u2ug.org>
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
> > u2-users@listserver.u2ug.org
> > 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
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> -------
> u2-users mailing list
> u2-users@listserver.u2ug.org
> 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
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
