Running a Progress Procedure

Yahoo Archive
1
Someone posted a way to run a report off of a desktop -- I don't remember
who it was. This code works for me in the shortcut on the desktop -- we are
on 4.0.

Z: is the mapped drive
servername is the name of your server
Z:\vantage\ud\labor.p is the path and name of your procedure

Z:\progress\bin\prowin32.exe -db z:\vantage\db\vantage.db -N TCP -S
vantage -H servername -p z:\vantage\ud\labor.p

Hope this helps!
Sandy Morse
BVR Aero Precision Corporation
2
Is it possible to set up an icon to run a procedure without having to
be in Vantage. For example I have a procedure that exports the
PREmpMas table to a csv file. I have this set up as a menu item in
vantage but I would like to run it without having to be in Vantage at
all or the procedure editor. I realize that you need to be connected
to the database in some way and I was hoping that someone had a
solution on how to do this.

Thanks
Rhonda
3
Do you have Provsion? If so, you can create your connection there and run
your procedure.

Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: rhondareilly [mailto:rreilly@...]
Sent: Tuesday, November 19, 2002 5:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Running a Progress Procedure


Is it possible to set up an icon to run a procedure without having to
be in Vantage. For example I have a procedure that exports the
PREmpMas table to a csv file. I have this set up as a menu item in
vantage but I would like to run it without having to be in Vantage at
all or the procedure editor. I realize that you need to be connected
to the database in some way and I was hoping that someone had a
solution on how to do this.

Thanks
Rhonda


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/
4
Hi Rhonda,
Have you tried setting up a desktop shortcut, using the following logic?

Y:\progress\bin\prowin32.exe -db Y:\vantage\db\vantage.db -N TCP -S epic51
-H Oracle -p Y:\vantage\UD\Exports\PREmpMas.p
[your Progress location] [Your Vantage location]
[Service name] [Host name] [Location of your Progress program]

The above shortcut would call a Progress .p file, but I believe that I have
used it for other file formats.

Good Luck,

Les Tingley
IT Manager
Decorated Products


> -----Original Message-----
> From: Leonard, Jeremy [SMTP:jleonard@...]
> Sent: Wednesday, November 20, 2002 8:05 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Running a Progress Procedure
>
> Do you have Provsion? If so, you can create your connection there and run
> your procedure.
>
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: rhondareilly [mailto:rreilly@...]
> Sent: Tuesday, November 19, 2002 5:13 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Running a Progress Procedure
>
>
> Is it possible to set up an icon to run a procedure without having to
> be in Vantage. For example I have a procedure that exports the
> PREmpMas table to a csv file. I have this set up as a menu item in
> vantage but I would like to run it without having to be in Vantage at
> all or the procedure editor. I realize that you need to be connected
> to the database in some way and I was hoping that someone had a
> solution on how to do this.
>
> Thanks
> Rhonda
>
>
> 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 http://docs.yahoo.com/info/terms/
>
5
Rhonda, (I was just going to hit SEND on this, but Les beat me to it. I'll send anyway so that I get brownie points, and just in case it helps you figure out something else).

You can make an icon on your desktop. Enter the following line (adapted to your database of course) in the TARGET section. In the START IN section you can put your mapped Vantage directory.

E:\epic51\progress\bin\prowin32.exe -db d:\epic51\vantage.db -N TCP -H localhost -S epic51 -p "e:\documents and settings\tfunte\desktop\Vantage Exports\D-ExportMain.p"

The format of the above line is:
prowin32.exe_path -db database_path_and_name -N TCP -H hostname -S servicename -p program_path_and_name

If any of the above paths have spaces in them, you will need to use the quotes as I did in the program_path_and_name above. I think you can use a mapped path from a client workstation instead of the physical path to the database. The above link is on my test machine and I don't use a mapped drive for it.

If you have any further questions, just ask.

Troy Funte
Liberty Electronics

----- Original Message -----
From: rhondareilly
To: vantage@yahoogroups.com
Sent: Tuesday, November 19, 2002 5:13 PM
Subject: [Vantage] Running a Progress Procedure


Is it possible to set up an icon to run a procedure without having to
be in Vantage. For example I have a procedure that exports the
PREmpMas table to a csv file. I have this set up as a menu item in
vantage but I would like to run it without having to be in Vantage at
all or the procedure editor. I realize that you need to be connected
to the database in some way and I was hoping that someone had a
solution on how to do this.

Thanks
Rhonda


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]
6
make a copy of your Vantage.VTG file. Edit that copy so that the mainmenu.w
is your procedure.p. Then just create a shortcut to your new VTG file.
That should work.

-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Wednesday, November 20, 2002 7:05 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Running a Progress Procedure


Do you have Provsion? If so, you can create your connection there and run
your procedure.

Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: rhondareilly [mailto:rreilly@...]
Sent: Tuesday, November 19, 2002 5:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Running a Progress Procedure


Is it possible to set up an icon to run a procedure without having to
be in Vantage. For example I have a procedure that exports the
PREmpMas table to a csv file. I have this set up as a menu item in
vantage but I would like to run it without having to be in Vantage at
all or the procedure editor. I realize that you need to be connected
to the database in some way and I was hoping that someone had a
solution on how to do this.

Thanks
Rhonda


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 http://docs.yahoo.com/info/terms/
7
Hey Troy, I'll give you the "Brownie points". After all, you're the one that
taught me how to do it. Besides that, my head is still swollen from the
wonderful comments from Sarah V. Last Week. LOL. : ) I can't say enough
about the practical uses for Progress Code. P files in particular. I'd love
to see a site with more code samples, that are relevant to Vantage. Some
basic "Progress 101" might be nice, as well.

Les Tingley

IT Manager
Decorated Products

> -----Original Message-----
> From: Troy Funte [SMTP:tfunte@...]
> Sent: Wednesday, November 20, 2002 8:27 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Running a Progress Procedure
>
> Rhonda, (I was just going to hit SEND on this, but Les beat me to it.
> I'll send anyway so that I get brownie points, and just in case it helps
> you figure out something else).
>
> You can make an icon on your desktop. Enter the following line
> (adapted to your database of course) in the TARGET section. In the START
> IN section you can put your mapped Vantage directory.
>
> E:\epic51\progress\bin\prowin32.exe -db d:\epic51\vantage.db -N TCP -H
> localhost -S epic51 -p "e:\documents and settings\tfunte\desktop\Vantage
> Exports\D-ExportMain.p"
>
> The format of the above line is:
> prowin32.exe_path -db database_path_and_name -N TCP -H hostname -S
> servicename -p program_path_and_name
>
> If any of the above paths have spaces in them, you will need to use the
> quotes as I did in the program_path_and_name above. I think you can use a
> mapped path from a client workstation instead of the physical path to the
> database. The above link is on my test machine and I don't use a mapped
> drive for it.
>
> If you have any further questions, just ask.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: rhondareilly
> To: vantage@yahoogroups.com
> Sent: Tuesday, November 19, 2002 5:13 PM
> Subject: [Vantage] Running a Progress Procedure
>
>
> Is it possible to set up an icon to run a procedure without having to
> be in Vantage. For example I have a procedure that exports the
> PREmpMas table to a csv file. I have this set up as a menu item in
> vantage but I would like to run it without having to be in Vantage at
> all or the procedure editor. I realize that you need to be connected
> to the database in some way and I was hoping that someone had a
> solution on how to do this.
>
> Thanks
> Rhonda
>
>
> 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/
>