Don't forget the output file statement from Thad's previous email at the beginning of the export as well.
Output to c:\vntgwork\myexport.csv.
Troy Funte
Liberty Electronics
Output to c:\vntgwork\myexport.csv.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Wednesday, June 19, 2002 7:01 PM
Subject: RE: [Vantage] Re: Progress Exports, next step (are we to adolesce nt s teps yet?)
/*Oops, I forgot a few periods use this version instead.*/
export delimiter "," "PartNum" "Description" "Rev".
FOR EACH Part NO-LOCK WHERE
Part.Company = "001",
EACH PartRev WHERE
PartRev.Company = "001" AND
Part.PartNum = PartRev.PartNum:
export delimiter "," Part.PartNum Part.PartDescription PartRev.RevisionNum.
END.
output close.
/*All done..*/
-----Original Message-----
From: Clint Muhlestein [mailto:cmuhlestein@...]
Sent: Wednesday, June 19, 2002 3:53 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Progress Exports, next step (are we to
adolesce nt s teps yet?)
Thanks I will give it a try.
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Wednesday, June 19, 2002 3:11 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Progress Exports, next step (are we to adolesce
nt s teps yet?)
The utility composes a For Each progress statement to select the records.
all the FOR EACH statement does is select the records. The FOR EACH
statement in and of itself It does not export them. When you run the
export, Vantage creates some more progress code in the background that
exports the selected records to the format you desire.
So what you do, for instance is go into the export utility and create an
export. For instance, join the part table to the partrev table, using
company, and part number. Select only the fields you need. For our
example, we'll just use Part.PartNum, Part.PartDescription, and
PartRev.RevisionNum.
Then you open up the procedure editor (..\dlcsrv\bin\prowin32.exe)
I use this shortcut on my desktop for our Version 3 database.
P:\DLCSRV\bin\prowin32.exe -db p:\vantage\db\dcdv7.db -N TCP -S vntgserv -H
fs2 -p _edit.p
For a 5.0 database, using the service and db names prescribed in the install
documents, it would read:
V:\DLCSRV\bin\prowin32.exe -db V:\vantage\db\VANTAGE.db -N TCP -S EPIC50 -H
VantageServerName -p _edit.p
So you open the shortcut, and it places you in the procedure editor window.
Cut and paste the FOR EACH statement from the vantage export utility into
the procedure editor. Add the output and export statments.
/*Start Code*/
Output to c:\vntgwork\myexport.csv.
export delimiter "," "PartNum" "Description" "Rev"
FOR EACH Part NO-LOCK WHERE
Part.Company = "001",
EACH PartRev WHERE
PartRev.Company = "001"
Part.PartNum = PartRev.PartNum:
export delimiter "," Part.PartNum Part.PartDescription PartRev.RevisionNum.
END.
output close.
/*All done..*/
Rather than use the export utility to create my code, I usually just write
the queries manually. The query language is pretty easy to grasp.
Let me know if you have further questions,
Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...
-----Original Message-----
From: cmuhlestein2002 [mailto:cmuhlestein@...]
Sent: Wednesday, June 19, 2002 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Progress Exports, next step (are we to adolescent
s teps yet?)
I noticed that you had posted this E-mail several months ago and was
wondering if you could expound a little more on the
"straight - record for record queries by copying and pasting from the
Export Utility in Vantage"
How are you doing this and are you getting good results?
I am looking for an automated way to export Table Data out of Vantage.
--- In vantage@y..., Todd Caughey <caugheyt@h...> wrote:
> Have you looked into the new VBI module (CorVu BI)? If I recall
correctly
> from Perspectives this does some pretty amazing exporting to Excel
(and
> presumably .csv). There is a webinar today. If you need the
connect info I
> could forward it.
> -Todd C.
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@e...]
> Sent: Thursday, March 14, 2002 9:50 AM
> To: Vantage
> Subject: [Vantage] Progress Exports, next step (are we to
adolescent steps
> yet?)
>
>
> Many of you have been able to export .csv files directly using small
> Progress programs. I have done this with straight - record for
record
> queries by copying and pasting from the Export Utility in Vantage.
Next
> crossroads I have come to is this:
>
> Is there a way to Group, Summarize and Total fields in an export?
Does
> anyone have sample code to do that?
>
> Specifically, I want to take the OrderHed, OrderDtl, and OrderRel
tables,
> Group by PartNum, Find the formula OrderRel.OurRelQty -
> (OrderRel.OurJobShippedQty + OrderRel.OurStockShippedQty). This
would be
> the BalanceDue.
> Then I want to Summarize the BalanceDue for each PartNumber.
>
> Output to the .csv file would only include: PartNum, Description,
> BalanceDue.
>
> Any ideas?
>
> Troy
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
< http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17>
050071
> 83:HM/A=847665/R=0/* http://ads.x10.com/? <http://ads.x10.com/?>
bHlhaG9vbW9uc3RlcjcuZGF0=1016121683%
>
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=84766
5/R=1>
>
>
> < http://us.adserver.yahoo.com/l? <http://us.adserver.yahoo.com/l?>
M=215002.1818248.3328688.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=387903740>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> < http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> < http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> < http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.
>
>
>
>
> [Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]