Getting Data Out of Vantage

Yahoo Archive
1
>The question is, where do you go to learn Provision. Epicor does not offer
>it, and I have not seen it on Progress's educational offerings.

I do not have the latest Progress Class list in front of me, but last time I
looked "GUI Programming in Progress" was still being offered by Progress at
several of their education sites.
2
What is the best way to get data out of Vantage? I need an automated
way of pulling data of multiple Vantage/Progress DBs into an Access
DB.

Thanks
-- Danny
3
Danny:

I am not sure if there is a best way. Their are many preferred ways:

You can write a report builder report and export that to Access
You can use the export utility within Vantage (which I recommend)
If you need live feeds you can use an ODBC connection and make that work.

I hope this helps, but just remember the biggest thing is make sure you use
your Data Dictionary for the cleanest approach.

Respectfully,

Mark Engemann
Business Application Manager
Hydromat, Inc. / Turmatic Systems
Voice: 314.432.4644
Fax: 314.692-9195
E-mail: mengemann@... / mengemann@...


-----Original Message-----
From: Danny Spell [mailto:danny.spell@...]
Sent: Friday, January 12, 2001 9:14 AM
To: vantage@egroups.com
Subject: [Vantage] Getting Data Out of Vantage


What is the best way to get data out of Vantage? I need an automated
way of pulling data of multiple Vantage/Progress DBs into an Access
DB.

Thanks
-- Danny


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
4
You can also, from within a progress program, use the Excel COM object to create and populate a spreadsheet. Requires some knowledge of Progress 4gl, and COM objects. There is an example of this at DLC\src\samples\activex\excelgraphs, where DLC is the install location
for Progress (often C:\program files\progress).

Danny Spell wrote:

> What is the best way to get data out of Vantage? I need an automated
> way of pulling data of multiple Vantage/Progress DBs into an Access
> DB.
>
> Thanks
> -- Danny
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
5
Danny,

If you really want an automated way to get Vantage data to Access, the only
way is ODBC. You can get the driver (which is a third party product from
Merant) from Epicor tech support. It will come with instructions that won't
help, but you can get good instructions from Epicor tech support.

Be careful not to expect too much from this approach. You will be able to
attach to the Vantage files, and most of them will allow browsing, sorting,
querying, reporting, etc. But, there are two problems that I have run into.
The first is a bug that will blow away your ODBC connection to the Vantage
database if you browse too quickly. When this happens, the user will have
to exit Access and re-open it. Sometimes, they will have to reboot. The
second is a bug where Access won't display the data from certain files.
JOBPROD is one example that I know of, but I also know there are others.
You can query against JOBPROD, and, in a linked query with other tables, you
will get the correct results, but the data from JOBPROD will not display as
data. The data will look like "#Deleted". I have contacted tech support
about these issues, with no acceptable response. In fact, they claim to not
be able to reproduce the errors. However, there have been other postings on
this list that would suggest that these problems are occurring throughout
their customer base.

Good luck...B

-----Original Message-----
From: Danny Spell [mailto:danny.spell@...]
Sent: Friday, January 12, 2001 8:14 AM
To: vantage@egroups.com
Subject: [Vantage] Getting Data Out of Vantage


What is the best way to get data out of Vantage? I need an automated
way of pulling data of multiple Vantage/Progress DBs into an Access
DB.

Thanks
-- Danny


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
6
UH Guys,
A recent experience regarding ODBC drivers, (I'm on 3.0),

ME: Hey Sales rep you got that 3.00 odbc driver.
Sales Rep - Sure We 've got it, $99.00 just give me a P.O.
ME - Great, here use P.O. 12345
(time passes)
ME - HEY Wheres my driver.
Epicor Product Person - (email) We don't sell that anymore. IT's on the
5.00 CD we just sent and its free. Call Tech support for help in getting it
off the CD
(time passes)
ME: Hey Tech support how 'bout helping get that ODBC driver off the 5.00 CD.
TECH Support: OH that doesnt work on 3.00 that costs $99.00. You need to
talk to your sales rep.
ME: Hey Sales rep you got that 3.00 odbc driver.
Sales Rep: No they don't sell that anymore, and dont have any, but I'll try
to find you one.
(time passes)
(time passes)
(time passes)
and its still passing. .................................................

I'm not venting, REAL CONVERSATION.
Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron

[Shirley Graver] Danny,

If you really want an automated way to get Vantage data to Access, the only
way is ODBC. You can get the driver (which is a third party product from
Merant) from Epicor tech support. It will come with instructions that won't
help, but you can get good instructions from Epicor tech support.





[Non-text portions of this message have been removed]
7
>If you really want an automated way to get Vantage data to Access, the only
>way is ODBC.

Not true. Learn to program with Provision and Visual Basic. Use Provision
to extract the data you want to a text file, develop a visual basic program
to read the data and fill in or update the Access Database. Then have it
run from an AT Command line in NT or the Windows 95/98 Task scheduler. No
human interaction. Now that's automated.......
8
The Provision --> Visual Basic --> Access approach is undoubtedly more
reliable than ODBC, but there are two advantages to ODBC. First, once the
ODBC driver is properly installed, you can write Access applications or
reports directly against the actual Vantage tables. There aren't any middle
steps that you need to make sure are running. Second, ODBC is real time
(although slow), meaning that the data is live, not a copy of the original
files. That's actually automated.

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Friday, January 12, 2001 2:57 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Getting Data Out of Vantage



>If you really want an automated way to get Vantage data to Access, the only
>way is ODBC.

Not true. Learn to program with Provision and Visual Basic. Use Provision
to extract the data you want to a text file, develop a visual basic program
to read the data and fill in or update the Access Database. Then have it
run from an AT Command line in NT or the Windows 95/98 Task scheduler. No
human interaction. Now that's automated.......


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
9
You'll have to start some classes of your own to teach us this stuff, Michael.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Podlin, Michael
To: 'vantage@egroups.com'
Sent: Friday, January 12, 2001 1:56 PM
Subject: RE: [Vantage] Getting Data Out of Vantage



>If you really want an automated way to get Vantage data to Access, the only
>way is ODBC.

Not true. Learn to program with Provision and Visual Basic. Use Provision
to extract the data you want to a text file, develop a visual basic program
to read the data and fill in or update the Access Database. Then have it
run from an AT Command line in NT or the Windows 95/98 Task scheduler. No
human interaction. Now that's automated.......


eGroups Sponsor

Click here for Business information

We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
10
At 03:38 PM 1/12/2001 -0500, you wrote:
>A recent experience regarding ODBC drivers, (I'm on 3.0),
>Epicor Product Person - (email) We don't sell that anymore. IT's on the
>5.00 CD we just sent and its free. Call Tech support for help in getting it
>off the CD

Wow... what a PITA. (you were going to install 5.0 the minute you got it, no?)

Some stuff I heard on one of the Progress lists makes it sound like
Progress 9.1 has some native ODBC capability included, and it's a lot
better than what we've had in the past. Can anyone confirm or deny??

-Wayne
11
The question is, where do you go to learn Provision. Epicor does not offer
it, and I have not seen it on Progress's educational offerings.

> >If you really want an automated way to get Vantage data to Access, the
> only
> >way is ODBC.
>
> Not true. Learn to program with Provision and Visual Basic. Use
> Provision
> to extract the data you want to a text file, develop a visual basic
> program
> to read the data and fill in or update the Access Database. Then have it
> run from an AT Command line in NT or the Windows 95/98 Task scheduler. No
> human interaction. Now that's automated.......
>
>
>
12
Dick -

The last time, about 6 months ago, I contacted Progress corporate and
spoke with Susan Eliades (1-800-477-6473 ). She's the director of
educational services. She will know if there are courses available near
you. She's been very helpful with the Midwest Vantage Users Group.

Calvin


----- Original Message -----
From: Plaman Dick <dick.plaman@...>
To: <vantage@egroups.com>
Sent: Sunday, January 14, 2001 6:31 AM
Subject: RE: [Vantage] Getting Data Out of Vantage


> The question is, where do you go to learn Provision. Epicor does not
offer
> it, and I have not seen it on Progress's educational offerings.
>
> > >If you really want an automated way to get Vantage data to Access, the
> > only
> > >way is ODBC.
> >
> > Not true. Learn to program with Provision and Visual Basic. Use
> > Provision
> > to extract the data you want to a text file, develop a visual basic
> > program
> > to read the data and fill in or update the Access Database. Then have
it
> > run from an AT Command line in NT or the Windows 95/98 Task scheduler.
No
> > human interaction. Now that's automated.......
> >
> >
> >
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)