Importing Access into Vantage (Vantage 5.2)

also my concern about the conversion tool is make sure it will change the
table / fields that you want it to. In Epicor's vast "wisdom" this tool is
only to transfer data from a legacy system into vantage not to maintain
vantage. :)



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Wednesday, November 10, 2004 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Access into Vantage (Vantage 5.2)


Carol,

You would never want to update from Access information (database triggers,
data integrity, etc.). Conversion tool will run in the thousands. If you
have the money, it is recommended. If you are budget conscious and have
someone that will spend the time, Ground Control and other macro software
will read your Access information, and do all the clicks, adds, and data
entry for you. Ground control should be about $40.00. You can re-use the
macros whenever you need them. I added and continue adding customer and ship
to maintenance for our partner with over 4,000 customers and 7,000 ship-to
addresses. Also, separated 2 divisions into companies with Ground Control.

I also had the opportunity to do BOM's, but I realized that by creating a
master part and copying the BOM from the master part, it would be easier to
make adjustments than to enter them from scratch (a lot of subassemblies in
the process).

Good luck!

Mario Aguirre
Lakin General Corporation, Inc.

-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)

Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>


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=129uv9522/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1100197763/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=807051815>

_____

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]



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

<http://us.ard.yahoo.com/SIG=129oa8pi0/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100203037/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here

<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=735492998>


_____

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/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]
Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>
We have looked at this extensively. Our quoting system is Access based. We would really like to import BOM structures into Vantage. But....we have determined that it would require custom programming from Epicor )or someone very knowledgeable in the Vantage DB and Progress), this would be really expensive (minimum $20K), and there would be large inefficiencies remaining (two customer tables, parallel shop configs, lack of reporting, etc...). So for now we exist with two systems. The ray of hope for the future is extreme screen customization capabilities in Vantage 8.0 which will allow us to use native Vantage, by far the best and cleanest solution.
-Todd C.

-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)


Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>


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
<http://us.ard.yahoo.com/SIG=129uv9522/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1100197763/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=807051815>


_____

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]
I would think this is a vantage custom, you have to deal with progress db
triggers. They only had to tell me once that any db corruption problems
will be billable on a time and materials basis :-)



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 1:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)



Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>


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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129uv9522/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1100197763/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=807051815>



_____

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.


<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]
I was told by Epicor they will not support imported data from any source
other than their Conversion Tool software so I didn't try. You might
want to contact Epicor about the Conversion Tool to get your data
loaded.

Butch

________________________________

From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 10:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)


Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@...
<mailto:cengen@...>


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=129uv9522/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1100197763/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=807051815>

________________________________

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]
ditto, we read from progress but that is all.

how we have worked around this to create our own tables in access or sql and
write to them.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, November 10, 2004 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Access into Vantage (Vantage 5.2)


I was told by Epicor they will not support imported data from any source
other than their Conversion Tool software so I didn't try. You might
want to contact Epicor about the Conversion Tool to get your data
loaded.

Butch

________________________________

From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 10:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)


Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@...
<mailto:cengen@...>


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=129uv9522/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1100197763/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=807051815>

________________________________

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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=1290q955c/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1100201084/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

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


_____

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/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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

You would never want to update from Access information (database triggers,
data integrity, etc.). Conversion tool will run in the thousands. If you
have the money, it is recommended. If you are budget conscious and have
someone that will spend the time, Ground Control and other macro software
will read your Access information, and do all the clicks, adds, and data
entry for you. Ground control should be about $40.00. You can re-use the
macros whenever you need them. I added and continue adding customer and ship
to maintenance for our partner with over 4,000 customers and 7,000 ship-to
addresses. Also, separated 2 divisions into companies with Ground Control.

I also had the opportunity to do BOM's, but I realized that by creating a
master part and copying the BOM from the master part, it would be easier to
make adjustments than to enter them from scratch (a lot of subassemblies in
the process).

Good luck!

Mario Aguirre
Lakin General Corporation, Inc.

-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, November 10, 2004 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Access into Vantage (Vantage 5.2)

Does anyone have experience with importing information from an Access
Database into Vantage?

Has it worked? How easy/difficult is it? Vantage custom services?

We currently have a large quote database in Access and need to make
improvements...possibly by bringing it into Vantage Quoting.

Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>


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=129uv9522/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1100197763/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=807051815>

_____

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]