ODBC vs. Data Convert Tool

system · September 2, 2004, 12:27pm

Thank you, Bruce. I will contact my Epicor CR for pricing.

Mario Aguirre
Lakin General

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Thursday, September 02, 2004 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

I don't remember exactly, but I'm sure it's over $1000.
Also, Epicor has been pretty stingy with support.
They have steered me to programming services every time I mention the Data
Convert Tool..
If you have the time, you can figure most things out on your own.
If you're on a tight schedule, I'd budget a few hours of programming
services.

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Thu 9/2/2004 9:13 AM
To: vantage@yahoogroups.com
Cc:
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Bruce,

Data convert tool seems the way to go (I would never use ODBC for
updates or
add again!). How much you pay for it? Is it a part of package, etc?

Thanks!

Mario Aguirre
Lakin General

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Thursday, September 02, 2004 8:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Try one field at a time in your query,
If no data is being returned it's usually been a typing error in my
query.

-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 02, 2004 7:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Vantage 6.00.521

I recently received the conversion tool. I've mapped it to an access
database ready for import. But when I view the results of the source
query, the data is not there. The column headings are there, but no
data. I can open the tables in access and they are fully propagated.
I
have connected to both databases using ODBC.

What am I doing wrong? Any help would be appreciated.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 02, 2004 12:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

I'm using the Conversion Tool as well. Tech Support told me they will

not provide support if I use Access to blast the tables (how would
they
know???) so I am only using Access to view the imported data and
prepare
the import tables. I've done parts, inventory, costs, BOMs,
operations,
vendors, customers and a few of the master tables. I'm not having any

problems getting the data in but still working out some of the kinks
associated with rolling the BOMs - too many fields and so little time.

Butch

________________________________

From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 6:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Mario,

>I second Aaron's opinion on writing to Vantage using Access.<
>Work always in a test environment and test a lot<

We are migrating from Dataflo.
With 30,000+ unique parts importing is a must for us.

>and started to pray right away<

I'm getting past the point of praying.
So far I've done Parts, BOM's, BOO's, Inventories (with the required
transactions), Costs (with the required transactions), Prices and
Vendors. Testing of the imported data has been very promising.

We'd still like to get our Clientel calls (60,000+) and Machine
Profiles
(3000?) imported.

Calls are turning out to be a little more complicated than I expected.

There is a table called IMCRMCall that has copies of all the calls
entered using the Vantage interface. I'm still studying this. Anybody
know what is going on with the IMCRMCall table? It almost seems like
it's for some functionality that may be added to Vantage in the
future.

Anyway, I'd STILL like to hear thoughts if any of you have used both
the
Data Conversion Tool and Access to import/update Vantage data. The one

thing I've noticed is that an Access query tends to crash if I am
updating more than 1000 records. As long as I break my updates into
smaller chunks, it seems to work just as well as the Data Convert
Tool.
I'm just wondering if I wasted a few thousand dollars.

Thanks,

Bruce

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/>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<

http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
<http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/>

<http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
<http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/> >

D=groups/S=1705007183:HM/EXP=1094174464/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<

http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group> >
s/S=:HM/A=2319498/rand=831922246>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>

> > .

>

oups/S=1705007183:HM/EXP=1094219745/A=2128215/R=0/SIG=10se96mf6/*http:/compa

nion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=

>

:HM/A=2128215/rand=602849379>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>

> Service.

[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/.
<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>
Yahoo! Groups Links

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<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>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129qssl3k/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1094226055/A=2319498/R=0/SIG=11thfntfp/*http:/www.n
etflix.com/Default?mqso=60185352&partid=5285298> click here

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2319498/rand=282498280>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

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

system · September 1, 2004, 2:10pm

First...I will let you know that using ODBC to write info into Vantage
by-passes any triggers in the progress code. Therefore you risk data
corruption. It is wise to avoid entering data via ODBC. But if you do,
be very careful you are writing to a field that will not have a trigger
associated (for instance you are fairly safe with the VB form fields)
but be very very careful.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: cooner_55421 [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC vs. Data Convert Tool

Hi,

We purchased the Data Conversion Tool to import our Dataflo
records.
I've been using it for about 6 months & in most cases it works
pretty
well. However, today I was having trouble trying to import our
Clientel calls into the CRMCall table. The Data Conversion Tool
was
having trouble with the index. ( I had a similar problem when I
tried
to import Vendors. )

Just for the heck of it, I tried an append query in Access using
the
Merant ODBC driver. I was able to add the calls with no problem.

This made me wonder, why do I even need the Data Conversion
Tool? Can
anybody explain the pro's and con's of these two methods of
importing
data?

Thanks,
Bruce

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

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=1296a5qod/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094148131/A=2195326/R=2/SIG=12iaqvv6s/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940617314
77981>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
s/S=:HM/A=2195326/rand=585316415>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]

system · September 1, 2004, 5:13pm

I second Aaron's opinion on writing to Vantage using Access. I did associate
all my customers to price lists by writing directly into the table using
Access. At the beginning, it did not show any records. I had to stop and
start the database and started to pray right away. The price lists were
there, but I started to get an error message... Fortunately, it did not have
anything to do with what I had done. Customer names with an ampersand (&)
generates an error message when you are working in the price lists screen.
Work always in a test environment and test a lot before doing something like
I did above.

Good luck!

Mario Aguirre
Lakin General

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Wednesday, September 01, 2004 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

First...I will let you know that using ODBC to write info into Vantage
by-passes any triggers in the progress code. Therefore you risk data
corruption. It is wise to avoid entering data via ODBC. But if you do,
be very careful you are writing to a field that will not have a trigger
associated (for instance you are fairly safe with the VB form fields)
but be very very careful.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: cooner_55421 [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC vs. Data Convert Tool

Hi,

We purchased the Data Conversion Tool to import our Dataflo
records.
I've been using it for about 6 months & in most cases it works
pretty
well. However, today I was having trouble trying to import our
Clientel calls into the CRMCall table. The Data Conversion Tool
was
having trouble with the index. ( I had a similar problem when I
tried
to import Vendors. )

Just for the heck of it, I tried an append query in Access using
the
Merant ODBC driver. I was able to add the calls with no problem.

This made me wonder, why do I even need the Data Conversion
Tool? Can
anybody explain the pro's and con's of these two methods of
importing
data?

Thanks,
Bruce

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>

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=1296a5qod/M=296572.5305651.6444487.3001176/
<http://us.ard.yahoo.com/SIG=1296a5qod/M=296572.5305651.6444487.3001176/>
D=groups/S=1705007183:HM/EXP=1094148131/A=2195326/R=2/SIG=12iaqvv6s/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940617314
77981>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group>
s/S=:HM/A=2195326/rand=585316415>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> > .

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<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>

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129hq9dme/M=296572.5305651.6444487.3001176/D=gr
oups/S=1705007183:HM/EXP=1094148655/A=2195326/R=2/SIG=12icts0r2/*http:/clk.a
tdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=1094062255594561>

<http://view.atdmt.com/VON/view/yhxxxvon00700677von/direct/01/&time=10940622
55594561>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=groups/S=
:HM/A=2195326/rand=337124431>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

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

system · September 2, 2004, 12:08am

I'm using the Conversion Tool as well. Tech Support told me they will
not provide support if I use Access to blast the tables (how would they
know???) so I am only using Access to view the imported data and prepare
the import tables. I've done parts, inventory, costs, BOMs, operations,
vendors, customers and a few of the master tables. I'm not having any
problems getting the data in but still working out some of the kinks
associated with rolling the BOMs - too many fields and so little time.

Butch

________________________________

From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 6:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Mario,

>I second Aaron's opinion on writing to Vantage using Access.<
>Work always in a test environment and test a lot<

We are migrating from Dataflo.
With 30,000+ unique parts importing is a must for us.

>and started to pray right away<

I'm getting past the point of praying.
So far I've done Parts, BOM's, BOO's, Inventories (with the required
transactions), Costs (with the required transactions), Prices and
Vendors. Testing of the imported data has been very promising.

We'd still like to get our Clientel calls (60,000+) and Machine Profiles
(3000?) imported.

Calls are turning out to be a little more complicated than I expected.
There is a table called IMCRMCall that has copies of all the calls
entered using the Vantage interface. I'm still studying this. Anybody
know what is going on with the IMCRMCall table? It almost seems like
it's for some functionality that may be added to Vantage in the future.

Anyway, I'd STILL like to hear thoughts if any of you have used both the
Data Conversion Tool and Access to import/update Vantage data. The one
thing I've noticed is that an Access query tends to crash if I am
updating more than 1000 records. As long as I break my updates into
smaller chunks, it seems to work just as well as the Data Convert Tool.
I'm just wondering if I wasted a few thousand dollars.

Thanks,

Bruce

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

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1094174464/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2319498/rand=831922246>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]

system · September 2, 2004, 8:30am

Vantage 6.00.521

I recently received the conversion tool. I've mapped it to an access database ready for import. But when I view the results of the source query, the data is not there. The column headings are there, but no data. I can open the tables in access and they are fully propagated. I have connected to both databases using ODBC.

What am I doing wrong? Any help would be appreciated.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 02, 2004 12:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

I'm using the Conversion Tool as well. Tech Support told me they will
not provide support if I use Access to blast the tables (how would they
know???) so I am only using Access to view the imported data and prepare
the import tables. I've done parts, inventory, costs, BOMs, operations,
vendors, customers and a few of the master tables. I'm not having any
problems getting the data in but still working out some of the kinks
associated with rolling the BOMs - too many fields and so little time.

Butch

________________________________

From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 6:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Mario,

>I second Aaron's opinion on writing to Vantage using Access.<
>Work always in a test environment and test a lot<

We are migrating from Dataflo.
With 30,000+ unique parts importing is a must for us.

>and started to pray right away<

I'm getting past the point of praying.
So far I've done Parts, BOM's, BOO's, Inventories (with the required
transactions), Costs (with the required transactions), Prices and
Vendors. Testing of the imported data has been very promising.

We'd still like to get our Clientel calls (60,000+) and Machine Profiles
(3000?) imported.

Calls are turning out to be a little more complicated than I expected.
There is a table called IMCRMCall that has copies of all the calls
entered using the Vantage interface. I'm still studying this. Anybody
know what is going on with the IMCRMCall table? It almost seems like
it's for some functionality that may be added to Vantage in the future.

Anyway, I'd STILL like to hear thoughts if any of you have used both the
Data Conversion Tool and Access to import/update Vantage data. The one
thing I've noticed is that an Access query tends to crash if I am
updating more than 1000 records. As long as I break my updates into
smaller chunks, it seems to work just as well as the Data Convert Tool.
I'm just wondering if I wasted a few thousand dollars.

Thanks,

Bruce

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

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
< http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1094174464/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

< http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2319498/rand=831922246>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]

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

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129ng8gl8/M=296572.5305651.6444487.3001176/D=groups/S=1705007183:HM/EXP=1094184529/A=2195326/R=2/SIG=12idv7utv/*http://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=1094098129211210>

<http://view.atdmt.com/VON/view/yhxxxvon00700677von/direct/01/&time=1094098129211210>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=groups/S=:HM/A=2195326/rand=853026743>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.

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

system · September 2, 2004, 10:11am

Bruce,

Data convert tool seems the way to go (I would never use ODBC for updates or
add again!). How much you pay for it? Is it a part of package, etc?

Thanks!

Mario Aguirre
Lakin General

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Thursday, September 02, 2004 8:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Try one field at a time in your query,
If no data is being returned it's usually been a typing error in my
query.

-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 02, 2004 7:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Vantage 6.00.521

I recently received the conversion tool. I've mapped it to an access
database ready for import. But when I view the results of the source
query, the data is not there. The column headings are there, but no
data. I can open the tables in access and they are fully propagated. I
have connected to both databases using ODBC.

What am I doing wrong? Any help would be appreciated.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 02, 2004 12:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

I'm using the Conversion Tool as well. Tech Support told me they will
not provide support if I use Access to blast the tables (how would they
know???) so I am only using Access to view the imported data and prepare
the import tables. I've done parts, inventory, costs, BOMs, operations,
vendors, customers and a few of the master tables. I'm not having any
problems getting the data in but still working out some of the kinks
associated with rolling the BOMs - too many fields and so little time.

Butch

________________________________

From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 6:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Mario,

>I second Aaron's opinion on writing to Vantage using Access.<
>Work always in a test environment and test a lot<

We are migrating from Dataflo.
With 30,000+ unique parts importing is a must for us.

>and started to pray right away<

I'm getting past the point of praying.
So far I've done Parts, BOM's, BOO's, Inventories (with the required
transactions), Costs (with the required transactions), Prices and
Vendors. Testing of the imported data has been very promising.

We'd still like to get our Clientel calls (60,000+) and Machine Profiles
(3000?) imported.

Calls are turning out to be a little more complicated than I expected.
There is a table called IMCRMCall that has copies of all the calls
entered using the Vantage interface. I'm still studying this. Anybody
know what is going on with the IMCRMCall table? It almost seems like
it's for some functionality that may be added to Vantage in the future.

Anyway, I'd STILL like to hear thoughts if any of you have used both the
Data Conversion Tool and Access to import/update Vantage data. The one
thing I've noticed is that an Access query tends to crash if I am
updating more than 1000 records. As long as I break my updates into
smaller chunks, it seems to work just as well as the Data Convert Tool.
I'm just wondering if I wasted a few thousand dollars.

Thanks,

Bruce

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>

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<
http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
<http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/>
D=groups/S=1705007183:HM/EXP=1094174464/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<
http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group>
s/S=:HM/A=2319498/rand=831922246>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> > .

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<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>

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129ng8gl8/M=296572.5305651.6444487.3001176/
<http://us.ard.yahoo.com/SIG=129ng8gl8/M=296572.5305651.6444487.3001176/>
D=groups/S=1705007183:HM/EXP=1094184529/A=2195326/R=2/SIG=12idv7utv/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940981292
11210>

<http://view.atdmt.com/VON/view/yhxxxvon00700677von/direct/01/
<http://view.atdmt.com/VON/view/yhxxxvon00700677von/direct/01/&time=1094>
&time=1094
098129211210>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group>
s/S=:HM/A=2195326/rand=853026743>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
Service.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<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>
Yahoo! Groups Links

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>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=12943cvuq/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1094219745/A=2128215/R=0/SIG=10se96mf6/*http:/compa
nion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=602849379>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

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

system · September 2, 2004, 11:08am

Make sure if you have a comma at the end of a line that you leave a
space after it. The tool concatenates the strings together so if you
don't have a space the field names will look like this PartNum,Revision
instead of PartNum, Revision.

Butch

________________________________

From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 02, 2004 5:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Vantage 6.00.521

I recently received the conversion tool. I've mapped it to an access
database ready for import. But when I view the results of the source
query, the data is not there. The column headings are there, but no
data. I can open the tables in access and they are fully propagated. I
have connected to both databases using ODBC.

What am I doing wrong? Any help would be appreciated.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 02, 2004 12:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

I'm using the Conversion Tool as well. Tech Support told me they will
not provide support if I use Access to blast the tables (how would they
know???) so I am only using Access to view the imported data and prepare
the import tables. I've done parts, inventory, costs, BOMs, operations,
vendors, customers and a few of the master tables. I'm not having any
problems getting the data in but still working out some of the kinks
associated with rolling the BOMs - too many fields and so little time.

Butch

________________________________

From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, September 01, 2004 6:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC vs. Data Convert Tool

Mario,

>I second Aaron's opinion on writing to Vantage using Access.<
>Work always in a test environment and test a lot<

We are migrating from Dataflo.
With 30,000+ unique parts importing is a must for us.

>and started to pray right away<

I'm getting past the point of praying.
So far I've done Parts, BOM's, BOO's, Inventories (with the required
transactions), Costs (with the required transactions), Prices and
Vendors. Testing of the imported data has been very promising.

We'd still like to get our Clientel calls (60,000+) and Machine Profiles
(3000?) imported.

Calls are turning out to be a little more complicated than I expected.
There is a table called IMCRMCall that has copies of all the calls
entered using the Vantage interface. I'm still studying this. Anybody
know what is going on with the IMCRMCall table? It almost seems like
it's for some functionality that may be added to Vantage in the future.

Anyway, I'd STILL like to hear thoughts if any of you have used both the
Data Conversion Tool and Access to import/update Vantage data. The one
thing I've noticed is that an Access query tends to crash if I am
updating more than 1000 records. As long as I break my updates into
smaller chunks, it seems to work just as well as the Data Convert Tool.
I'm just wondering if I wasted a few thousand dollars.

Thanks,

Bruce

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

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<
http://us.ard.yahoo.com/SIG=12988m3dc/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1094174464/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<
http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2319498/rand=831922246>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]

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

Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129ng8gl8/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094184529/A=2195326/R=2/SIG=12idv7utv/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940981292
11210>

<http://view.atdmt.com/VON/view/yhxxxvon00700677von/direct/01/&time=1094
098129211210>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
s/S=:HM/A=2195326/rand=853026743>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1297hle8a/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1094214620/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=662659212>

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]