Source code to run RB engine from icon (complete program)

It was EXACTLY what I wanted also, no provision required. I used Procedure
Editor to make changes as that way you can debug prior to adding to the
menu. If you haven't done so already, download the language reference and
programmers handbook from the progress site, they are sure to come in handy.

Add the udxxxxx.w to the menu exactly the same as you do for PRLs (except
for it not being a customer report link) and hey presto, no more user
un-friendly edit-filters required. Use RUNTIME-PARAMETER("xxxxx") in your
PRL to get any values passed by the .W. I can think of a few enhancements
that would be nice, like defining all the things that you would change (ie
like the PRL, the report name, etc) up the top, and possibly having ONE file
that you include in each procedure

The next thing that I would like an example of is how to populate a
combo-list from a query so you could select things like customers from a
dropdown list and the custnum get's passed to the report.

Thanks heaps Steve, we owe you and I'm sure Lonnie's will come in handy too.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, 21 August 2001 12:22
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Source code to run RB engine from icon (complete
pr ogram)


Steve,
Do I need the Provision code to work with your file? If not, how
would I implement this code with some of my reports. I really like
the idea.

Troy Funte
Liberty Electronics

--- In vantage@y..., "Steve Sanders" <ssanders@d...> wrote:
> Okay, in the spirit of sharing, I uploaded a file called UDRBEMPL.w
that I
> use as a template for reports that require a date range. This
program will
> calculate the date range for the prior week (we pay on a weekly
basis) but
> allow the user to change those dates. It also shows how to pass
parameters
> in to a Report Builder report that is called from a Progress
program. With
> the UD prefix, it can be added to the Vantage menu and is much more
> user-friendly than the one that comes by default from Progress.
>
> I also created a new folder ("Progress Code") in the web site Files
section
> and took the liberty of moving Lonnie's code to that directory as
well.
> Hopefully, these two files won't remain 'lonely' for long!
>
> Lonnie, I applaud your willingness to share your code and would
encourage
> others to do the same! Just remember that if you write to the
database with
> your own code and anything goes wrong, don't go looking to Epicor
for help
> unless you are ready to pay for it! Having said that, there are a
great
> number of things you can do to enhance the usability of your system
and
> sharing code like this helps to make Vantage a more useful tool!
> ======================
> Steve Sanders
> Delta Centrifugal Corp
Lonnie,

I just downloaded this and took a quick look at it.

Nice start ... Your ideas section all look like valid ideas.

The "Open Source Code" effort is to be applauded.

Any other gems you would like to share ?

Does any one else on the list want to share some stand alone utilities with
source code ?

Todd Anderson

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Thursday, August 16, 2001 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Source code to run RB engine from icon (complete program)


Someone mentioned to me in an email last week that we should start
some sort of open source code effort. Here's MY free contribution.

I was asked by quite a few people (a few weeks ago following a post)
about running an RB report outside of Vantage and what it takes. I
took some time and wrote something that most could deploy as-is, or
as a template/example from which to build your own.

This could cut down the number of users logged in just to run reports.

I'm uploading the file which you can save to 'ud' directory and RUN
FROM AN ICON, a quit statement exists which would close vantage.
Sample command line (Windows NT tested): v:\Epic50
\Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
ServerName -S ServiceName -p v:\vantage\ud\Reports.w.

Check out the 'ideas' button. I'll gladly share what I've learned
with anyone who would like to enhance the code.

Enjoy,

Lonnie Drew
lonniedrew@...



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
997995778>

<http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=317287691>

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]
> Any other gems you would like to share ?

geez - gimme a break, I haven't totally gotten use to the idea yet,
it's hard letting go of code for 'nuthin.. I'll wait for the person
who suggested this to upload one first..

Lonnie

--- In vantage@y..., Todd Anderson <tanderson@j...> wrote:
> Lonnie,
>
> I just downloaded this and took a quick look at it.
>
> Nice start ... Your ideas section all look like valid ideas.
>
> The "Open Source Code" effort is to be applauded.
>
> Any other gems you would like to share ?
>
> Does any one else on the list want to share some stand alone
utilities with
> source code ?
>
> Todd Anderson
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, August 16, 2001 4:03 PM
> To: vantage@y...
> Subject: [Vantage] Source code to run RB engine from icon (complete
program)
>
>
> Someone mentioned to me in an email last week that we should start
> some sort of open source code effort. Here's MY free
contribution.
>
> I was asked by quite a few people (a few weeks ago following a
post)
> about running an RB report outside of Vantage and what it takes. I
> took some time and wrote something that most could deploy as-is, or
> as a template/example from which to build your own.
>
> This could cut down the number of users logged in just to run
reports.
>
> I'm uploading the file which you can save to 'ud' directory and RUN
> FROM AN ICON, a quit statement exists which would close vantage.
> Sample command line (Windows NT tested): v:\Epic50
> \Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
> ServerName -S ServiceName -p v:\vantage\ud\Reports.w.
>
> Check out the 'ideas' button. I'll gladly share what I've learned
> with anyone who would like to enhance the code.
>
> Enjoy,
>
> Lonnie Drew
> lonniedrew@c...
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17
050071
> 83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-
1039-1?mpt=
> 997995778>
>
> <http://us.adserver.yahoo.com/l?
M=210949.1523302.3121208.1269402/D=egroupmai
> l/S=1705007183:HM/A=763786/rand=317287691>
>
> 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]
Looking for additional ideas, check out the AutoRpts utility. It runs
outside of Vantage unattended not using a Vantage license. Reports are
scheduled Daily, Weekly, Monthly, Quarterly, Yearly and several others. The
reports are generated to different/specific printers. It also can have the
reports go out in PDF, HTML and raw TXT format. There is also the ability
to have the report output information e-mailed instead of printed. Stuff
and ideas for its future are Graphing, a utility to convert/point all
reports in a PRL file to a new Host and server so that you don't have to do
this manually each time you upgrade or change Vantage with everyone of your
reports, Multiple copies of reports, Automatic Faxing, better logging and
alerts plus a few other enhancements.

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Thursday, August 16, 2001 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Source code to run RB engine from icon (complete
program)


Someone mentioned to me in an email last week that we should start
some sort of open source code effort. Here's MY free contribution.

I was asked by quite a few people (a few weeks ago following a post)
about running an RB report outside of Vantage and what it takes. I
took some time and wrote something that most could deploy as-is, or
as a template/example from which to build your own.

This could cut down the number of users logged in just to run reports.

I'm uploading the file which you can save to 'ud' directory and RUN
FROM AN ICON, a quit statement exists which would close vantage.
Sample command line (Windows NT tested): v:\Epic50
\Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
ServerName -S ServiceName -p v:\vantage\ud\Reports.w.

Check out the 'ideas' button. I'll gladly share what I've learned
with anyone who would like to enhance the code.

Enjoy,

Lonnie Drew
lonniedrew@...



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/
Okay, in the spirit of sharing, I uploaded a file called UDRBEMPL.w that I
use as a template for reports that require a date range. This program will
calculate the date range for the prior week (we pay on a weekly basis) but
allow the user to change those dates. It also shows how to pass parameters
in to a Report Builder report that is called from a Progress program. With
the UD prefix, it can be added to the Vantage menu and is much more
user-friendly than the one that comes by default from Progress.

I also created a new folder ("Progress Code") in the web site Files section
and took the liberty of moving Lonnie's code to that directory as well.
Hopefully, these two files won't remain 'lonely' for long!

Lonnie, I applaud your willingness to share your code and would encourage
others to do the same! Just remember that if you write to the database with
your own code and anything goes wrong, don't go looking to Epicor for help
unless you are ready to pay for it! Having said that, there are a great
number of things you can do to enhance the usability of your system and
sharing code like this helps to make Vantage a more useful tool!
======================
Steve Sanders
Delta Centrifugal Corp

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Thursday, August 16, 2001 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Source code to run RB engine from icon (complete pr
ogram)


> Any other gems you would like to share ?

geez - gimme a break, I haven't totally gotten use to the idea yet,
it's hard letting go of code for 'nuthin.. I'll wait for the person
who suggested this to upload one first..

Lonnie

--- In vantage@y..., Todd Anderson <tanderson@j...> wrote:
> Lonnie,
>
> I just downloaded this and took a quick look at it.
>
> Nice start ... Your ideas section all look like valid ideas.
>
> The "Open Source Code" effort is to be applauded.
>
> Any other gems you would like to share ?
>
> Does any one else on the list want to share some stand alone
utilities with
> source code ?
>
> Todd Anderson
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, August 16, 2001 4:03 PM
> To: vantage@y...
> Subject: [Vantage] Source code to run RB engine from icon (complete
program)
>
>
> Someone mentioned to me in an email last week that we should start
> some sort of open source code effort. Here's MY free
contribution.
>
> I was asked by quite a few people (a few weeks ago following a
post)
> about running an RB report outside of Vantage and what it takes. I
> took some time and wrote something that most could deploy as-is, or
> as a template/example from which to build your own.
>
> This could cut down the number of users logged in just to run
reports.
>
> I'm uploading the file which you can save to 'ud' directory and RUN
> FROM AN ICON, a quit statement exists which would close vantage.
> Sample command line (Windows NT tested): v:\Epic50
> \Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
> ServerName -S ServiceName -p v:\vantage\ud\Reports.w.
>
> Check out the 'ideas' button. I'll gladly share what I've learned
> with anyone who would like to enhance the code.
>
> Enjoy,
>
> Lonnie Drew
> lonniedrew@c...
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17
050071
> 83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-
1039-1?mpt=
> 997995778>
>
> <http://us.adserver.yahoo.com/l?
M=210949.1523302.3121208.1269402/D=egroupmai
> l/S=1705007183:HM/A=763786/rand=317287691>
>
> 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]


Yahoo! Groups Sponsor



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]
Great ideas for scheduling! (I've actually incorporated many of them
in other Progress programs). Here's what I've found out..

>"It runs outside of Vantage unattended not using a Vantage license"
- Progress can't do that, but when a report is run from your program
a license is used also. The trade-off here would be the ability to
run reports immediately from an icon outside of Vantage, with the
basic program I uploaded, I'm sure licenses will be saved.

>"The reports are generated to different/specific printers. It also
can have the reports go out in PDF, HTML and raw TXT format."
- Can't this be controlled with RB engine parameters RB-PRINT-
DESTINATION and RB-PRINTER-NAME?

>"Multiple copies of reports"
- Controlled with RB-NUMBER-COPIES RB parameter.

>"Reports are scheduled Daily, Weekly, Monthly, Quarterly, Yearly and
several others"
- Scheduling enhancement using WAIT-FOR could handle that.

>"A utility to convert/point all reports in a PRL file to a new Host
and server so that you don't have to do this manually each time you
upgrade or change Vantage with everyone of your reports"
- Controlled with RB-DB-CONNECTION parameter. This is a good one,
haven't thought about it. Running from Vantage automatically
overrides connection parameters, and the same can be done with a
Progress program. But how would you ACTUALLY "convert/point" an RB
report to new location? I asked Epicor in the past if there was a
way to directly modify the connection parameters embedded in a PRL
and they said Progress said it couldn't be done.

>"Automatic Faxing","report output information e-mailed "
- Progress OS-COMMAND statement should be able to do it, but need the
fax/email command as if run from command line.

>"better logging and alerts"
- Scheduling and logging could be handled with a table. Regarding
alerts, there are some limitations as to what Progress itself can do,
but I'm sure there are API calls that could get the job done.

We're also working on our own version of a client timeout utility and
a way to remotely reboot workstations, remotely restart Vantage
(after maintenance shutdown for example), monitor user activity,
etc. I'm not a VB programmer, but our NT support/computer tech is.
I think he's done a great job, it's very robust.. too good, I don't
think we can just give it away.

Anyway, if you would like to share some of the Progress code that
runs from your VB program, I'd sure like to see it.

If anyone would like to discuss enhancements, I do have other code
you can use as a base. I've got one program I'm dying to show off....

Lonnie



--- In vantage@y..., "Podlin, Michael" <michael.podlin@v...> wrote:
> Looking for additional ideas, check out the AutoRpts utility. It
runs
> outside of Vantage unattended not using a Vantage license. Reports
are
> scheduled Daily, Weekly, Monthly, Quarterly, Yearly and several
others. The
> reports are generated to different/specific printers. It also can
have the
> reports go out in PDF, HTML and raw TXT format. There is also the
ability
> to have the report output information e-mailed instead of printed.
Stuff
> and ideas for its future are Graphing, a utility to convert/point
all
> reports in a PRL file to a new Host and server so that you don't
have to do
> this manually each time you upgrade or change Vantage with everyone
of your
> reports, Multiple copies of reports, Automatic Faxing, better
logging and
> alerts plus a few other enhancements.
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, August 16, 2001 4:03 PM
> To: vantage@y...
> Subject: [Vantage] Source code to run RB engine from icon (complete
> program)
>
>
> Someone mentioned to me in an email last week that we should start
> some sort of open source code effort. Here's MY free
contribution.
>
> I was asked by quite a few people (a few weeks ago following a
post)
> about running an RB report outside of Vantage and what it takes. I
> took some time and wrote something that most could deploy as-is, or
> as a template/example from which to build your own.
>
> This could cut down the number of users logged in just to run
reports.
>
> I'm uploading the file which you can save to 'ud' directory and RUN
> FROM AN ICON, a quit statement exists which would close vantage.
> Sample command line (Windows NT tested): v:\Epic50
> \Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
> ServerName -S ServiceName -p v:\vantage\ud\Reports.w.
>
> Check out the 'ideas' button. I'll gladly share what I've learned
> with anyone who would like to enhance the code.
>
> Enjoy,
>
> Lonnie Drew
> lonniedrew@c...
>
>
>
> 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/
>Lonnie Wrote: We're also working on ...
...a way to remotely reboot workstations,

You could do this with VNC, a freeware, cross- platform software that allows you to control other workstations remotely. I've used it to reboot the server from home, as well as reboot workstations. see http://www.uk.research.att.com/vnc/ and www.tridiavnc.com


>... remotely restart Vantage (after maintenance shutdown for example),

You can do this from a batch file.


>... monitor user activity, etc.
If you're talking about LIVE monitoring, VNC can be used for this as well, but a small icon on the taskbar would let the user know they are being watched, and there are some ethical concerns about 'big brother' type stuff like this.


Troy Funte
Liberty Electronics


----- Original Message -----
From: Lonnie Drew
To: vantage@yahoogroups.com
Sent: Thursday, August 16, 2001 6:49 PM
Subject: [Vantage] Re: Source code to run RB engine from icon (complete pr ogram)


Great ideas for scheduling! (I've actually incorporated many of them
in other Progress programs). Here's what I've found out..

>"It runs outside of Vantage unattended not using a Vantage license"
- Progress can't do that, but when a report is run from your program
a license is used also. The trade-off here would be the ability to
run reports immediately from an icon outside of Vantage, with the
basic program I uploaded, I'm sure licenses will be saved.

>"The reports are generated to different/specific printers. It also
can have the reports go out in PDF, HTML and raw TXT format."
- Can't this be controlled with RB engine parameters RB-PRINT-
DESTINATION and RB-PRINTER-NAME?

>"Multiple copies of reports"
- Controlled with RB-NUMBER-COPIES RB parameter.

>"Reports are scheduled Daily, Weekly, Monthly, Quarterly, Yearly and
several others"
- Scheduling enhancement using WAIT-FOR could handle that.

>"A utility to convert/point all reports in a PRL file to a new Host
and server so that you don't have to do this manually each time you
upgrade or change Vantage with everyone of your reports"
- Controlled with RB-DB-CONNECTION parameter. This is a good one,
haven't thought about it. Running from Vantage automatically
overrides connection parameters, and the same can be done with a
Progress program. But how would you ACTUALLY "convert/point" an RB
report to new location? I asked Epicor in the past if there was a
way to directly modify the connection parameters embedded in a PRL
and they said Progress said it couldn't be done.

>"Automatic Faxing","report output information e-mailed "
- Progress OS-COMMAND statement should be able to do it, but need the
fax/email command as if run from command line.

>"better logging and alerts"
- Scheduling and logging could be handled with a table. Regarding
alerts, there are some limitations as to what Progress itself can do,
but I'm sure there are API calls that could get the job done.

We're also working on our own version of a client timeout utility and
a way to remotely reboot workstations, remotely restart Vantage
(after maintenance shutdown for example), monitor user activity,
etc. I'm not a VB programmer, but our NT support/computer tech is.
I think he's done a great job, it's very robust.. too good, I don't
think we can just give it away.

Anyway, if you would like to share some of the Progress code that
runs from your VB program, I'd sure like to see it.

If anyone would like to discuss enhancements, I do have other code
you can use as a base. I've got one program I'm dying to show off....

Lonnie



--- In vantage@y..., "Podlin, Michael" <michael.podlin@v...> wrote:
> Looking for additional ideas, check out the AutoRpts utility. It
runs
> outside of Vantage unattended not using a Vantage license. Reports
are
> scheduled Daily, Weekly, Monthly, Quarterly, Yearly and several
others. The
> reports are generated to different/specific printers. It also can
have the
> reports go out in PDF, HTML and raw TXT format. There is also the
ability
> to have the report output information e-mailed instead of printed.
Stuff
> and ideas for its future are Graphing, a utility to convert/point
all
> reports in a PRL file to a new Host and server so that you don't
have to do
> this manually each time you upgrade or change Vantage with everyone
of your
> reports, Multiple copies of reports, Automatic Faxing, better
logging and
> alerts plus a few other enhancements.
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, August 16, 2001 4:03 PM
> To: vantage@y...
> Subject: [Vantage] Source code to run RB engine from icon (complete
> program)
>
>
> Someone mentioned to me in an email last week that we should start
> some sort of open source code effort. Here's MY free
contribution.
>
> I was asked by quite a few people (a few weeks ago following a
post)
> about running an RB report outside of Vantage and what it takes. I
> took some time and wrote something that most could deploy as-is, or
> as a template/example from which to build your own.
>
> This could cut down the number of users logged in just to run
reports.
>
> I'm uploading the file which you can save to 'ud' directory and RUN
> FROM AN ICON, a quit statement exists which would close vantage.
> Sample command line (Windows NT tested): v:\Epic50
> \Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -H
> ServerName -S ServiceName -p v:\vantage\ud\Reports.w.
>
> Check out the 'ideas' button. I'll gladly share what I've learned
> with anyone who would like to enhance the code.
>
> Enjoy,
>
> Lonnie Drew
> lonniedrew@c...
>
>
>
> 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



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]
The ability to remotely reboot and automatically log back in to
Vantage is the primary reason he's writing this - so tired of
the 'walk through' every time we have to shut down server.

In essense, what he's developing/deploying is a master program that
sends commands to client programs on user workstations. One such
client command closes Vantage, restarts workstation, logs into
network then logs the shop workstation into Vantage - this can be
done in real time/batch mode- all chosen workstations in sequence.
Also the ability to warn and kick off user if no activity after
certain time, disable workstation features remotely,
prohibit 'games', send message box to client PC - I don't know all
he's put in it. He did mention that some features are redundant with
Netmeeting (except monitoring desktop, hasn't figured that out).

If anybody knows how to view client desktop in real-time, it would be
an interesting addition to the program. Of course it would be
disabled on certain office personnel's machines.

Lonnie


--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> >Lonnie Wrote: We're also working on ...
> ...a way to remotely reboot workstations,
>
> You could do this with VNC, a freeware, cross- platform software
that allows you to control other workstations remotely. I've used it
to reboot the server from home, as well as reboot workstations. see
http://www.uk.research.att.com/vnc/ and www.tridiavnc.com
>
>
> >... remotely restart Vantage (after maintenance shutdown for
example),
>
> You can do this from a batch file.
>
>
> >... monitor user activity, etc.
> If you're talking about LIVE monitoring, VNC can be used for this
as well, but a small icon on the taskbar would let the user know they
are being watched, and there are some ethical concerns about 'big
brother' type stuff like this.
>
>
> Troy Funte
> Liberty Electronics
> If anybody knows how to view client desktop in real-time, it would be an interesting addition to the program. Of course it would be disabled on certain office personnel's machines.


Lonnie, VNC is all open source code, so you could download their stuff and see how they do it.

Troy Funte
Liberty Electronics


--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> >Lonnie Wrote: We're also working on ...
> ...a way to remotely reboot workstations,
>
> You could do this with VNC, a freeware, cross- platform software
that allows you to control other workstations remotely. I've used it
to reboot the server from home, as well as reboot workstations. see
http://www.uk.research.att.com/vnc/ and www.tridiavnc.com
>
>
> >... remotely restart Vantage (after maintenance shutdown for
example),
>
> You can do this from a batch file.
>
>
> >... monitor user activity, etc.
> If you're talking about LIVE monitoring, VNC can be used for this
as well, but a small icon on the taskbar would let the user know they
are being watched, and there are some ethical concerns about 'big
brother' type stuff like this.
>
>
> Troy Funte
> Liberty Electronics



Yahoo! Groups Sponsor




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]
Guys - viewing remote desktop was JUST an idea, that's ALL. Anyway,
Readme.txt for VNC source says it's in C++ (amongst 167 files
zipped). Outta my speciality.. I'll mention it though. If a
decision is made to view remote desktop, taking a snapshot should do
(I was told a week ago that capability was there).

Mark, thanks for the .exe. Over that hurdle but it would be great to
see how you coded it. Can you upload for comparison?

Still waiting for person who suggested this entire thread to upload
something.... you know who you are!

If I see more source uploaded, I have quite a few I would think about
sharing also (I found 600+ .w/.p sitting around, and 500+ RB reports
just in ud directory - time for house cleaning). Maybe I need to
throw together a web page and market this stuff..... let's see more
source!

Thanks all for the ideas.
I've just started with VNC and find it a great piece of software and if you
find a way of running it and hiding the viewer icon in the systray I'd be
pleased to hear it.

Regards Chris Reed
PWSL

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: 17 August 2001 00:38
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Source code to run RB engine from icon (complete
pr ogram)

>Lonnie Wrote: We're also working on ...
...a way to remotely reboot workstations,

You could do this with VNC, a freeware, cross- platform software that allows
you to control other workstations remotely. I've used it to reboot the
server from home, as well as reboot workstations. see
http://www.uk.research.att.com/vnc/ and www.tridiavnc.com
After following the VNC newsgroup for some time, there were MANY people who asked the same question. The issue always came back to the 'spy' mentality, and the official version of VNC was left with the icon in the tray. Being public, and open source code, a person would have to dig into the C code to find a way to remove the icon.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Chris Reed
To: vantage@yahoogroups.com
Sent: Friday, August 17, 2001 2:00 AM
Subject: RE: [Vantage] Re: Source code to run RB engine from icon (complete pr ogram)


I've just started with VNC and find it a great piece of software and if you
find a way of running it and hiding the viewer icon in the systray I'd be
pleased to hear it.

Regards Chris Reed
PWSL

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: 17 August 2001 00:38
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Source code to run RB engine from icon (complete
pr ogram)

>Lonnie Wrote: We're also working on ...
...a way to remotely reboot workstations,

You could do this with VNC, a freeware, cross- platform software that allows
you to control other workstations remotely. I've used it to reboot the
server from home, as well as reboot workstations. see
http://www.uk.research.att.com/vnc/ and www.tridiavnc.com




Yahoo! Groups Sponsor



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]
Steve,
Do I need the Provision code to work with your file? If not, how
would I implement this code with some of my reports. I really like
the idea.

Troy Funte
Liberty Electronics


--- In vantage@y..., "Steve Sanders" <ssanders@d...> wrote:
> Okay, in the spirit of sharing, I uploaded a file called UDRBEMPL.w
that I
> use as a template for reports that require a date range. This
program will
> calculate the date range for the prior week (we pay on a weekly
basis) but
> allow the user to change those dates. It also shows how to pass
parameters
> in to a Report Builder report that is called from a Progress
program. With
> the UD prefix, it can be added to the Vantage menu and is much more
> user-friendly than the one that comes by default from Progress.
>
> I also created a new folder ("Progress Code") in the web site Files
section
> and took the liberty of moving Lonnie's code to that directory as
well.
> Hopefully, these two files won't remain 'lonely' for long!
>
> Lonnie, I applaud your willingness to share your code and would
encourage
> others to do the same! Just remember that if you write to the
database with
> your own code and anything goes wrong, don't go looking to Epicor
for help
> unless you are ready to pay for it! Having said that, there are a
great
> number of things you can do to enhance the usability of your system
and
> sharing code like this helps to make Vantage a more useful tool!
> ======================
> Steve Sanders
> Delta Centrifugal Corp
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, August 16, 2001 4:34 PM
> To: vantage@y...
> Subject: [Vantage] Re: Source code to run RB engine from icon
(complete pr
> ogram)
>
>
> > Any other gems you would like to share ?
>
> geez - gimme a break, I haven't totally gotten use to the idea
yet,
> it's hard letting go of code for 'nuthin.. I'll wait for the
person
> who suggested this to upload one first..
>
> Lonnie
>
> --- In vantage@y..., Todd Anderson <tanderson@j...> wrote:
> > Lonnie,
> >
> > I just downloaded this and took a quick look at it.
> >
> > Nice start ... Your ideas section all look like valid ideas.
> >
> > The "Open Source Code" effort is to be applauded.
> >
> > Any other gems you would like to share ?
> >
> > Does any one else on the list want to share some stand alone
> utilities with
> > source code ?
> >
> > Todd Anderson
> >
> > -----Original Message-----
> > From: Lonnie Drew [mailto:lonniedrew@c...]
> > Sent: Thursday, August 16, 2001 4:03 PM
> > To: vantage@y...
> > Subject: [Vantage] Source code to run RB engine from icon
(complete
> program)
> >
> >
> > Someone mentioned to me in an email last week that we should
start
> > some sort of open source code effort. Here's MY free
> contribution.
> >
> > I was asked by quite a few people (a few weeks ago following a
> post)
> > about running an RB report outside of Vantage and what it
takes. I
> > took some time and wrote something that most could deploy as-
is, or
> > as a template/example from which to build your own.
> >
> > This could cut down the number of users logged in just to run
> reports.
> >
> > I'm uploading the file which you can save to 'ud' directory and
RUN
> > FROM AN ICON, a quit statement exists which would close vantage.
> > Sample command line (Windows NT tested): v:\Epic50
> > \Progress\bin\prowin32.exe -db v:\vantage\db\vantage.db -N TCP -
H
> > ServerName -S ServiceName -p v:\vantage\ud\Reports.w.
> >
> > Check out the 'ideas' button. I'll gladly share what I've
learned
> > with anyone who would like to enhance the code.
> >
> > Enjoy,
> >
> > Lonnie Drew
> > lonniedrew@c...
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> >
>
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17
> 050071
> > 83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-
4458-
> 1039-1?mpt=
> > 997995778>
> >
> > <http://us.adserver.yahoo.com/l?
> M=210949.1523302.3121208.1269402/D=egroupmai
> > l/S=1705007183:HM/A=763786/rand=317287691>
> >
> > 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]
>
>
> Yahoo! Groups Sponsor
>
>
>
> 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]