VB And Progress

Yahoo Archive
1
As long as you know how to write the ODBC connection to the db and your
other language can use ODBC you could technically use any language to talk
to the DB. You could easily write an ASP.NET website to pull data from the
DB and display it on a website. You could even use it to manipulate the
website. If you wanted to take on the risk of wrecking the DB.



~Charlie.



PS we use PHP to generate a small website that is constantly displayed on a
Terminal on the Foreman stand that display some info about which employees
are and are not logged into jobs.



I didn't write the PHP for this it has been here since before I started
working here. I don't really have any PHP experience.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Friday, August 08, 2008 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] VB And Progress



> I wasn't planning to use the VBS from with in vantage I was planning to
> it just to extract data from the database for a secondary piece of
> software we are planning on using.

Charlie,

Could you write you extract as a WebService? Is your other program capable
of making http requests?

BTW, I would not worry too much about the performance of ODBC. In fact, if
you wanted to, you could write a Java/JDBC program that accesses the
Progress database and that could certainly be launched by a batch file.

Mark W.



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008
9:02 AM




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



I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.



I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.



Much Appreciated,

Charlie









[Non-text portions of this message have been removed]
3
You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.



That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/reports/[username]
folder.



Ross



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage]



All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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





[Non-text portions of this message have been removed]
4
That would work but I will need to be able to run it on demand without
logging into vantage via a batch job. Is there a way to make it execute via
a batch job?



This is why I was think about going to vb route.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, August 06, 2008 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]



You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/reports/[username]
folder.

Ross

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008
6:03 AM




[Non-text portions of this message have been removed]
5
We are on Vantage 6.1 and I was wondering if there was an easy way to
find out where and what are all the VB forms our company uses. I am not
an IT person and we are pretty much in between IT people and our corp.
office wants to know what all fields we are using for VB information.





[Non-text portions of this message have been removed]
6
Charlie:
Â
     I've just uploaded a text file w/some sample code, using ODBC driver to get data from Progress, write data out to a .csv :
Â
sample_code_vb_csvFile_data.txt
Â
 In Vantage Group, Files, Visual Basic section
Â
 Hope it helps a bit.

--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups.com
Date: Wednesday, August 6, 2008, 9:34 AM






That would work but I will need to be able to run it on demand without
logging into vantage via a batch job. Is there a way to make it execute via
a batch job?

This is why I was think about going to vb route.

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Ross Hughes
Sent: Wednesday, August 06, 2008 9:28 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage]

You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/ reports/[ username]
folder.

Ross

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008
6:03 AM

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


















[Non-text portions of this message have been removed]
7
Try looking in the VBFormDetail table.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Geary, Stephanie
Sent: Wednesday, August 06, 2008 9:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] VB forms


We are on Vantage 6.1 and I was wondering if there was an easy way to
find out where and what are all the VB forms our company uses. I am not
an IT person and we are pretty much in between IT people and our corp.
office wants to know what all fields we are using for VB information.

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






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





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Allen Tucker
Sent: Wednesday, August 06, 2008 11:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] VB forms



Try looking in the VBFormDetail table.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Geary, Stephanie
Sent: Wednesday, August 06, 2008 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] VB forms

We are on Vantage 6.1 and I was wondering if there was an easy way to
find out where and what are all the VB forms our company uses. I am not
an IT person and we are pretty much in between IT people and our corp.
office wants to know what all fields we are using for VB information.

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

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


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
9
> That would work but I will need to be able to run it on demand without
> logging into vantage via a batch job. Is there a way to make it execute
> via a batch job?

You can run the BAQ Export Process on demand or schedule it to run like any
other process (like MRP).

Mark W.
10
Bill I looked at your file and it seems it was written for VB I was
wondering if you had a VBScript example



Thank you



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bill Jackson
Sent: Wednesday, August 06, 2008 9:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] VB And Progress



Charlie:

I've just uploaded a text file w/some sample code, using ODBC driver
to get data from Progress, write data out to a .csv :

sample_code_vb_csvFile_data.txt

In Vantage Group, Files, Visual Basic section

Hope it helps a bit.

--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@
<mailto:foamdesigncsw%40yahoo.com> yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Wednesday, August 6, 2008, 9:34 AM

That would work but I will need to be able to run it on demand without
logging into vantage via a batch job. Is there a way to make it execute via
a batch job?

This is why I was think about going to vb route.

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Ross Hughes
Sent: Wednesday, August 06, 2008 9:28 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage]

You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/ reports/[ username]
folder.

Ross

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008
6:03 AM

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

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.12/1595 - Release Date: 8/6/2008
8:23 AM




[Non-text portions of this message have been removed]
11
 No, that's all I've got - haven't done any VBScript.

--- On Thu, 8/7/08, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups.com
Date: Thursday, August 7, 2008, 8:52 AM






Bill I looked at your file and it seems it was written for VB I was
wondering if you had a VBScript example

Thank you

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Bill Jackson
Sent: Wednesday, August 06, 2008 9:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] VB And Progress

Charlie:

I've just uploaded a text file w/some sample code, using ODBC driver
to get data from Progress, write data out to a .csv :

sample_code_ vb_csvFile_ data.txt

In Vantage Group, Files, Visual Basic section

Hope it helps a bit.

--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@
<mailto:foamdesignc sw%40yahoo. com> yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesignc sw%40yahoo. com>
yahoo.com>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Wednesday, August 6, 2008, 9:34 AM

That would work but I will need to be able to run it on demand without
logging into vantage via a batch job. Is there a way to make it execute via
a batch job?

This is why I was think about going to vb route.

_____

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Ross Hughes
Sent: Wednesday, August 06, 2008 9:28 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage]

You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/ reports/[ username]
folder.

Ross

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008
6:03 AM

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1595 - Release Date: 8/6/2008
8:23 AM

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


















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



Set cn = CreateObject("ADODB.Connection")



strCS = "Driver=DataDirect 4.20 32-BIT OpenEdge SQL
v10.0B;HOST=servername;DB=DBname;UID=Username;PWD=UserPWord;PORT=Port#;"



cn.open strCS



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bill Jackson
Sent: Thursday, August 07, 2008 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] VB And Progress



No, that's all I've got - haven't done any VBScript.

--- On Thu, 8/7/08, Charlie Wilson <foamdesigncsw@
<mailto:foamdesigncsw%40yahoo.com> yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Thursday, August 7, 2008, 8:52 AM

Bill I looked at your file and it seems it was written for VB I was
wondering if you had a VBScript example

Thank you

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Bill Jackson
Sent: Wednesday, August 06, 2008 9:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] VB And Progress

Charlie:

I've just uploaded a text file w/some sample code, using ODBC driver
to get data from Progress, write data out to a .csv :

sample_code_ vb_csvFile_ data.txt

In Vantage Group, Files, Visual Basic section

Hope it helps a bit.

--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@
<mailto:foamdesignc sw%40yahoo. com> yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesignc sw%40yahoo. com>
yahoo.com>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Wednesday, August 6, 2008, 9:34 AM

That would work but I will need to be able to run it on demand without
logging into vantage via a batch job. Is there a way to make it execute via
a batch job?

This is why I was think about going to vb route.

_____

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Ross Hughes
Sent: Wednesday, August 06, 2008 9:28 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage]

You may want to build your required queries in the BAQ writer and then use
the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML
file. The final file will reside in the /mfgsysdata/ reports/[ username]
folder.

Ross

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, August 06, 2008 8:03 AM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting
tool we are going to start using. I need to write a vb script that will pull
a bunch of data based on a select statement and place it in a CSV file. I
was wondering if anyone would mind giving me an example of this that I could
work from. I have written script to hook into a MS SQL db but have never
done one for progress and was wondering if I could get some help so I don't
have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to
send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008
6:03 AM

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.138 / Virus Database: 270.5.12/1595 - Release Date: 8/6/2008
8:23 AM

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

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.12/1597 - Release Date: 8/7/2008
5:54 AM




[Non-text portions of this message have been removed]
13
Contrary to what Vantage Sales said 'oh yea' to, and much to my chagrin, vbScripting capabilities don't exist in 8.03. The needed interpreter and 'vantage-ized' libraries simply don't exist.

(If anyone can demonstrate otherwise, I'd be forever great full.)

That said, the languages just aren't that different. You can write a VB.NET subroutine (triggered by say an added custom control button press) that essentially can do anything vbscript would do. The difference is you would be invoking the business objects methods and/or changing field values directly from within the Sub that accomplish the same thing as a 'recorded' vbscript accomplishes (by simply mimicing a users series of actions).

It would have though, added a LOT of value to the product if Epicor had licensed vbscript from MS and provided it as another tool (perhaps at the personalization level as well as customization) for simple automation of repetitive tasks that VB.NET and BPM are overkill for.

It undoubtedly would also have allowed for some neat, powerful, simple integration with basic office apps that now must be accomplished through bandwidth hogging ODBC, or BAQ exports to XML (and xml as an excel data source leaves a lot to be desired.)

Rob Brown


--- On Thu, 8/7/08, Charlie Wilson <foamdesigncsw@...> wrote:
From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups.com
Date: Thursday, August 7, 2008, 8:52 AM











Bill I looked at your file and it seems it was written for VB I was

wondering if you had a VBScript example



Thank you



_____



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of

Bill Jackson

Sent: Wednesday, August 06, 2008 9:56 AM

To: vantage@yahoogroups .com

Subject: RE: [Vantage] VB And Progress



Charlie:



I've just uploaded a text file w/some sample code, using ODBC driver

to get data from Progress, write data out to a .csv :



sample_code_ vb_csvFile_ data.txt



In Vantage Group, Files, Visual Basic section



Hope it helps a bit.



--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@

<mailto:foamdesignc sw%40yahoo. com> yahoo.com> wrote:



From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesignc sw%40yahoo. com>

yahoo.com>

Subject: RE: [Vantage] VB And Progress

To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

Date: Wednesday, August 6, 2008, 9:34 AM



That would work but I will need to be able to run it on demand without

logging into vantage via a batch job. Is there a way to make it execute via

a batch job?



This is why I was think about going to vb route.



_____



From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf

Of

Ross Hughes

Sent: Wednesday, August 06, 2008 9:28 AM

To: vantage@yahoogroups .com

Subject: RE: [Vantage]



You may want to build your required queries in the BAQ writer and then use

the BAQ Query Export utility in the Utilities folder to export it.



That will keep the headers and move the data in to a CSV file or an XML

file. The final file will reside in the /mfgsysdata/ reports/[ username]

folder.



Ross



From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On

Behalf Of

Charlie Wilson

Sent: Wednesday, August 06, 2008 8:03 AM

To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

Subject: [Vantage]



All,



I have to dump a bunch of data out of the vantage database for a reporting

tool we are going to start using. I need to write a vb script that will pull

a bunch of data based on a select statement and place it in a CSV file. I

was wondering if anyone would mind giving me an example of this that I could

work from. I have written script to hook into a MS SQL db but have never

done one for progress and was wondering if I could get some help so I don't

have to reinvent the wheel.



I'm most interested in how to set up the Connection and a sample of how to

send a select statement in and get the results of that select.



Much Appreciated,



Charlie



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



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



No virus found in this incoming message.

Checked by AVG - http://www.avg com

Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008

6:03 AM



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



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



No virus found in this incoming message.

Checked by AVG - http://www.avg com

Version: 8.0.138 / Virus Database: 270.5.12/1595 - Release Date: 8/6/2008

8:23 AM



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



I wasn't planning to use the VBS from with in vantage I was planning to use
it just to extract data from the database for a secondary piece of software
we are planning on using. But I agree it would be nice to be able to use VBS
within vantage to do custom work. However I feel to use to effectively you
would have to have a really good understanding of the internals of the
software.



~Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Friday, August 08, 2008 12:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] VB And Progress



Contrary to what Vantage Sales said 'oh yea' to, and much to my chagrin,
vbScripting capabilities don't exist in 8.03. The needed interpreter and
'vantage-ized' libraries simply don't exist.

(If anyone can demonstrate otherwise, I'd be forever great full.)

That said, the languages just aren't that different. You can write a VB.NET
subroutine (triggered by say an added custom control button press) that
essentially can do anything vbscript would do. The difference is you would
be invoking the business objects methods and/or changing field values
directly from within the Sub that accomplish the same thing as a 'recorded'
vbscript accomplishes (by simply mimicing a users series of actions).

It would have though, added a LOT of value to the product if Epicor had
licensed vbscript from MS and provided it as another tool (perhaps at the
personalization level as well as customization) for simple automation of
repetitive tasks that VB.NET and BPM are overkill for.

It undoubtedly would also have allowed for some neat, powerful, simple
integration with basic office apps that now must be accomplished through
bandwidth hogging ODBC, or BAQ exports to XML (and xml as an excel data
source leaves a lot to be desired.)

Rob Brown


--- On Thu, 8/7/08, Charlie Wilson <foamdesigncsw@
<mailto:foamdesigncsw%40yahoo.com> yahoo.com> wrote:
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
Subject: RE: [Vantage] VB And Progress
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Thursday, August 7, 2008, 8:52 AM

Bill I looked at your file and it seems it was written for VB I was

wondering if you had a VBScript example

Thank you

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of

Bill Jackson

Sent: Wednesday, August 06, 2008 9:56 AM

To: vantage@yahoogroups .com

Subject: RE: [Vantage] VB And Progress

Charlie:

I've just uploaded a text file w/some sample code, using ODBC driver

to get data from Progress, write data out to a .csv :

sample_code_ vb_csvFile_ data.txt

In Vantage Group, Files, Visual Basic section

Hope it helps a bit.

--- On Wed, 8/6/08, Charlie Wilson <foamdesigncsw@

<mailto:foamdesignc sw%40yahoo. com> yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesignc sw%40yahoo. com>

yahoo.com>

Subject: RE: [Vantage] VB And Progress

To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

Date: Wednesday, August 6, 2008, 9:34 AM

That would work but I will need to be able to run it on demand without

logging into vantage via a batch job. Is there a way to make it execute via

a batch job?

This is why I was think about going to vb route.

_____

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf

Of

Ross Hughes

Sent: Wednesday, August 06, 2008 9:28 AM

To: vantage@yahoogroups .com

Subject: RE: [Vantage]

You may want to build your required queries in the BAQ writer and then use

the BAQ Query Export utility in the Utilities folder to export it.

That will keep the headers and move the data in to a CSV file or an XML

file. The final file will reside in the /mfgsysdata/ reports/[ username]

folder.

Ross

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On

Behalf Of

Charlie Wilson

Sent: Wednesday, August 06, 2008 8:03 AM

To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com

Subject: [Vantage]

All,

I have to dump a bunch of data out of the vantage database for a reporting

tool we are going to start using. I need to write a vb script that will pull

a bunch of data based on a select statement and place it in a CSV file. I

was wondering if anyone would mind giving me an example of this that I could

work from. I have written script to hook into a MS SQL db but have never

done one for progress and was wondering if I could get some help so I don't

have to reinvent the wheel.

I'm most interested in how to set up the Connection and a sample of how to

send a select statement in and get the results of that select.

Much Appreciated,

Charlie

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

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

No virus found in this incoming message.

Checked by AVG - http://www.avg com

Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008

6:03 AM

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

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

No virus found in this incoming message.

Checked by AVG - http://www.avg com

Version: 8.0.138 / Virus Database: 270.5.12/1595 - Release Date: 8/6/2008

8:23 AM

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














No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.12/1597 - Release Date: 8/7/2008
5:54 AM




[Non-text portions of this message have been removed]
15
> It would have though, added a LOT of value to the product if Epicor had
> licensed vbscript from MS and provided it as another tool (perhaps at the
> personalization level as well as customization) for simple automation of
> repetitive tasks that VB.NET and BPM are overkill for.

Oh, my mouth is watering thinking about the possibilities with Product
Configuration, BAQs, BPMs, etc. (Yeah, My wife is correct. I am a geek...)

> It undoubtedly would also have allowed for some neat, powerful, simple
> integration with basic office apps that now must be accomplished through
> bandwidth hogging ODBC, or BAQ exports to XML (and xml as an excel data
> source leaves a lot to be desired.)

Or slow web services...

Mark W.
16
> I wasn't planning to use the VBS from with in vantage I was planning to
> it just to extract data from the database for a secondary piece of
> software we are planning on using.

Charlie,

Could you write you extract as a WebService? Is your other program capable
of making http requests?

BTW, I would not worry too much about the performance of ODBC. In fact, if
you wanted to, you could write a Java/JDBC program that accesses the
Progress database and that could certainly be launched by a batch file.

Mark W.