Pretty darn clever way around that miserable ODBC program. Can I get you and
Wayne to do my Federal Tax Return this year? : ) Les
Wayne to do my Federal Tax Return this year? : ) Les
> -----Original Message-----
> From: Troy Funte [SMTP:tfunte@...]
> Sent: Monday, December 10, 2001 10:33 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Automating Exports
>
> When I do multiple exports, I call them one by one from a main export.p
> program using the "run subexport.p" program. I also added a button to
> STOP the process, just in case. It helps to add a Target line to your
> shortcut: n:\vantage, so that you don't have to add the path to each of
> your run statements.
>
> I use the .csv files by linking them in Access, and then creating a query
> from them. That way I can use them in Crystal reports or Access reports.
> Each time the files are exported again, the links are automatically
> updated with the new data. I've found that adding fields to Vantage
> Reports this way, rather than through ODBC, eliminates having to have ODBC
> on those workstations.
>
> I'd love to hear ideas from others on what can be done using these
> exports.
> (And thanks to Wayne Cox for originally communicating the idea to me.)
>
> Troy Funte
> Liberty Electronics
> ----- Original Message -----
> From: Les Tingley
> To: vantage@yahoogroups.com
> Sent: Monday, December 10, 2001 10:30 AM
> Subject: RE: [Vantage] Automating Exports
>
>
> Thanks Troy,
> I modified your code, and it worked great in my 5.1 test environment.
> I'll now attempt to apply this to suit my needs.
>
> Les
>
> > -----Original Message-----
> > From: Troy Funte [SMTP:tfunte@...]
> > Sent: Monday, December 10, 2001 9:43 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Automating Exports
> >
> > Les,
> > Below is the text of the Program. Change the company name to your
> > company.(If you cut and paste from Vantage Export Utility, you will
> need
> > to put your company name here as well. The export uses a variable
> > "cur-comp".) Save the text in a file with a .p extension. Put the file
> in
> > your Vantage folder (or Vantage/ud). Then create a shortcut on your
> > desktop with the following command line:
> >
> > N:\progress\bin\prowin32.exe -db n:\vantage\db\vantage.db -N TCP -S
> > servicename -H servername -p n:\vantage\export.p
> >
> > N is the mapped drive to Vantage.
> > servicename is usually epic50 for Vantage 5.0.
> > servername is the name of your server with Vantage.
> >
> >
> > If you want to use the Procedure Editor to edit and work with your
> > program, you will need to find a way to connect to the database so
> that
> > you can run it. I usually click Edit/Insert Field, which then prompts
> me
> > to connect to the database. After connecting, I click cancel and then
> > click F2 t run the program to test it. The Help in Procedure Editor
> can
> > give you all the fancy stuff like variables, messages, calling other
> > programs, etc.
> >
> > Feel free to ask more questions.
> >
> > Troy Funte
> > Liberty Electronics
> >
> > /* begin export program */
> >
> > output to c:vntgwork\job.csv.
> > export delimiter "," "JobNum" "MtlSeq" "Partum" "Description"
> > "RequiredQty" "IssuedQty" "PartNum" "PartDescription".
> >
> > for each JobMtl Where JobMtl.Company = '100'
> > and JobMtl.IssuedComplete = no
> > and JobMtl.JobComplete = no no-lock,
> >
> > each JobHead Where JobHead.Company = JobMtl.Company
> >
> > and JobHead.JobNum = JobMtl.JobNum
> > and JobHead.JobReleased = yes and JobHead.JobClosed = no
> > and JobMtl.RequiredQty > JobMtl.IssuedQty
> >
> > By JobMtl.JobNum:
> >
> > export delimiter ","
> > JobMtl.JobNum
> > JobMtl.MtlSeq
> > JobMtl.PartNum
> > JobMtl.Description
> > JobMtl.RequiredQty
> > JobMtl.IssuedQty
> > JobHead.PartNum
> > JobHead.PartDescription.
> >
> > end.
> > output close.
> > message " Records exported for Job.csv Table.".
> > /* end of export */
> >
> >
> >
> >
> > ----- Original Message -----
> > From: Les Tingley
> > To: vantage@yahoogroups.com
> > Sent: Monday, December 10, 2001 8:58 AM
> > Subject: RE: [Vantage] Automating Exports
> >
> >
> > Hi Troy,
> > Yes, Please send me the samples.
> >
> > Thanks,
> >
> > Les Tingley
> > MIS Director
> > Decorated Products
> >
> > > -----Original Message-----
> > > From: Troy Funte [SMTP:tfunte@...]
> > > Sent: Monday, December 10, 2001 8:51 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] Automating Exports
> > >
> > > Les,
> > > We had been exporting data nightly in Vantage for months using
> > Ground
> > > Control macro software
> > > (http://groups.yahoo.com/group/vantage/files/_Misc/gc.zip), which
> > > basically replays keystrokes in Windows to do the task. It worked
> > fine,
> > > but was unreliable 10% of the time because of flukes in our system
> > (ie.
> > > Vantage taking extra time to logon, or whatever).
> > >
> > > Just recently, with the help of a number of folks on the list
> > here, we
> > > came up with something faster and much more reliable using the
> > Progress
> > > programming language. You can use this method even if you don't
> have
> > the
> > > 4GL compiler or the Vantage source code. I can run the very short
> > program
> > > through my Task Scheduler on my PC or it runs from an icon
> (outside of
> > > Vantage) and thus doesn't use a Vantage license. The program is
> easy
> > to
> > > create using the Export utility in Vantage to build the joins I
> want,
> > then
> > > I cut and paste into the program.
> > >
> > > If you're interested, I can send you some samples to look at.
> > >
> > > Troy Funte
> > > Liberty Electronics
> > >
> > > ----- Original Message -----
> > > From: lptingley
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, December 10, 2001 8:30 AM
> > > Subject: [Vantage] Automating Exports
> > >
> > >
> > > Is it possible to automate the exporting of data out of Vantage?
> > >
> > > Thanks - Les
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> > > 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]
> > >
> > >
> > >
> > > 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]
> >
> >
> >
> > 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/
> >
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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]
>
>
>
> 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/
>