.p program Blank Title 85322

Yahoo Archive
1
Reminds me of one of my favorite e-mail signatures:

"To err is human. To arr is pirate."

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Monday, November 23, 2009 7:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] .p program

Steven wrote:
> You could purchase a full Progress license and then you could
> write your code in 4GL (.p) and compile it. Since we don't
> have a full Progress license, I can't expand on this any more than
> this.

And since Warren's email is PirateOfTheMagothy, you could compile your .p
programs into .Arrrrr programs.

(Sorry, I tried to stop myself...)

Marrrrrrk W.




------------------------------------

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/linksYahoo! Groups Links
2
Can anyone offer a suggestion on how to write a progress .p program that connects to the Vantage database without having Vantage opened? I am on Vantage 6.1 with Progress database. I currently have to open Vantage and manually run an extraction program that I then feed data into a third party applicaion used to present sales data in many different views. I am trying to automate the extraction process without having Vantage opened.
Â
Thanks,
Warren Klug
Lion Brothers




[Non-text portions of this message have been removed]
3
I assume you are looking to automate this data extraction on some scheduled
basis. Are you just dumping the data out to flat file that your sales
program then picks up?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
warren klug
Sent: Thursday, November 19, 2009 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] .p program





Can anyone offer a suggestion on how to write a progress .p program that
connects to the Vantage database without having Vantage opened? I am on
Vantage 6.1 with Progress database. I currently have to open Vantage and
manually run an extraction program that I then feed data into a third party
applicaion used to present sales data in many different views. I am trying
to automate the extraction process without having Vantage opened.

Thanks,
Warren Klug
Lion Brothers

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Warren -



Use the DB-CONNECT statement and pass your db parameters.



Thank you in advance,

Calvin Dekker

Email: calvin@... <mailto:calvin@...>

http://www.codabears.com <http://www.codabears.com>

<http://www.codabears.com/>

*New software/hardware Support & Maintenance Programs







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of warren klug
Sent: Thursday, November 19, 2009 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] .p program





Can anyone offer a suggestion on how to write a progress .p program that
connects to the Vantage database without having Vantage opened? I am on
Vantage 6.1 with Progress database. I currently have to open Vantage
and manually run an extraction program that I then feed data into a
third party applicaion used to present sales data in many different
views. I am trying to automate the extraction process without having
Vantage opened.

Thanks,
Warren Klug
Lion Brothers

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
You have three main options.

With ODBC you could write external queries to the data but you would have to write code in the language of whatever program you use to perform the ODBC query. For example, you could write ODBC quries in Access and any logic could be written in Visual Basic.

You could purchase a full Progress license and then you could write your code in 4GL (.p) and compile it. Since we don't have a full Progress license, I can't expand on this any more than this.

You could write BAQs inside of Vantage and have the BAQ dump out the data to a CSV or XML file on a schedule.




________________________________
From: warren klug <pirateofthemagothy@...>
To: vantage@yahoogroups.com
Sent: Thu, November 19, 2009 2:26:26 PM
Subject: [Vantage] .p program

Â
Can anyone offer a suggestion on how to write a progress .p program that connects to the Vantage database without having Vantage opened? I am on Vantage 6.1 with Progress database. I currently have to open Vantage and manually run an extraction program that I then feed data into a third party applicaion used to present sales data in many different views. I am trying to automate the extraction process without having Vantage opened.
Â
Thanks,
Warren Klug
Lion Brothers

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
6
You can Also write VB Scripts that open an ODBC and dump the data out to a
flat file (csv). You could also open two ODBCs at once and transfer off one
and insert into the other if your Sales software allows you to open ODBC to
it's database. I do this to export data to F9.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Steven Gotschall
Sent: Thursday, November 19, 2009 3:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] .p program





You have three main options.

With ODBC you could write external queries to the data but you would have to
write code in the language of whatever program you use to perform the ODBC
query. For example, you could write ODBC quries in Access and any logic
could be written in Visual Basic.

You could purchase a full Progress license and then you could write your
code in 4GL (.p) and compile it. Since we don't have a full Progress
license, I can't expand on this any more than this.

You could write BAQs inside of Vantage and have the BAQ dump out the data to
a CSV or XML file on a schedule.

________________________________
From: warren klug <pirateofthemagothy@
<mailto:pirateofthemagothy%40yahoo.com> yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Thu, November 19, 2009 2:26:26 PM
Subject: [Vantage] .p program


Can anyone offer a suggestion on how to write a progress .p program that
connects to the Vantage database without having Vantage opened? I am on
Vantage 6.1 with Progress database. I currently have to open Vantage and
manually run an extraction program that I then feed data into a third party
applicaion used to present sales data in many different views. I am trying
to automate the extraction process without having Vantage opened.

Thanks,
Warren Klug
Lion Brothers

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
This is used with a legacy application that we migrated over to wotk with Vantage. The product is by Overdrive Solutions and provides a great way for our sales staff and management to slice and dice sales data.
Â
Are there other parameters needed on the db-connect statement?Â
Â
thanks,
warren

--- On Thu, 11/19/09, Calvin Dekker <calvind@...> wrote:


From: Calvin Dekker <calvind@...>
Subject: RE: [Vantage] .p program
To: vantage@yahoogroups.com
Date: Thursday, November 19, 2009, 3:14 PM


Â



Warren -

Use the DB-CONNECT statement and pass your db parameters.

Thank you in advance,

Calvin Dekker

Email: calvin@codabears. com <mailto:calvin@codabears. com>

http://www.codabear s.com <http://www.codabear s.com>

<http://www.codabear s.com/>

*New software/hardware Support & Maintenance Programs

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of warren klug
Sent: Thursday, November 19, 2009 1:31 PM
To: vantage@yahoogroups .com
Subject: [Vantage] .p program

Can anyone offer a suggestion on how to write a progress .p program that
connects to the Vantage database without having Vantage opened? I am on
Vantage 6.1 with Progress database. I currently have to open Vantage
and manually run an extraction program that I then feed data into a
third party applicaion used to present sales data in many different
views. I am trying to automate the extraction process without having
Vantage opened.

Thanks,
Warren Klug
Lion Brothers

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]











[Non-text portions of this message have been removed]
8
What are these fields in Order Line and Order Header Miscellaneous Charges
List View. Rpt1Amount,Rpt2Amount, etc.

no description in Technical Details/Data Dictionary Field Level Help


[Non-text portions of this message have been removed]
9
Steven wrote:
> You could purchase a full Progress license and then you could
> write your code in 4GL (.p) and compile it. Since we don't
> have a full Progress license, I can't expand on this any more than
> this.

And since Warren's email is PirateOfTheMagothy, you could compile your .p
programs into .Arrrrr programs.

(Sorry, I tried to stop myself...)

Marrrrrrk W.