Import /export utility

Yahoo Archive
1
Dan, you mentioned "Unfortunately, if you want to migrate data
yourself, there is no getting around trial and error to learn the
Vantage database structure."

That is my big concern - how or where can I view the relationships
between the various tables? Is there a tool available that will show
this? Why am I updating PartDescription in more than one table
anyway?

We have been having Epicor do the conversion but that is not
something I want to continue. We are fully capable of handling that
ourselves, we just want to know/see the relationships so that we can
do it correctly.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> Following this conversation I am getting a little confused. I have
not seen any mention of cut/paste via grid entry for the smaller
(several hundred or less rows) master tables. My impression was that
when I get to that point I would be dumping these to Excel and then
cut/paste them into a grid for updating. Since these are one-off
tasks a day or of manual loading would nto be too bad. Yes, the
larger tables would be impossible but the smaller ones should be OK.
Am I missing something or making a wrong assumption about grid entry
bulk adds?
>
> Thanks,
> Todd C.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of Dan Snyder
> Sent: Wednesday, December 21, 2005 9:40 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] import /export utility
>
>
> Dump&Load? I suppose you are talking about upgrading from Vantage
v6 to v8?
> If that's the case, a dump&load might work, but I think it would
only work
> if the specific table in question hasn't changed from v6 to v8. The
> original poster was migrating from another product (Made 2 Manage)
to
> Vantage, so it wouldn't work for them.
>
> Progress does have import utilities built-in or you could use MS
Access or
> some other ODBC compliant tool. I'm considering the Pervasive tool
for it's
> data scrubbing capabilities (much easier than Access programming
for me).
> It would save time in our project, I'm just not sure it would save
enough
> time to be worth the cost. Unfortunately, if you want to migrate
data
> yourself, there is no getting around trial and error to learn the
Vantage
> database structure.
>
> Happy Holidays! Hope that helps.
>
> Dan Snyder
> IT Manager
> Mercury Electronics
> 717-854-9557 ext.224
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> PLAMAN DICK
> Sent: Wednesday, December 21, 2005 9:12 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] import /export utility
>
> Todd,
> I told Epicor that I wanted to load our master tables only. I did
not want
> to bring our Old customers, vendors, parts, etc into our V8 db. I
stated
> that our open SO's, PO's, WO's, Invoices would be manually
entered. I was
> told that they would have to do it via a dump N load.
>
>
>
>
>
>
>
>
>
> 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
>
>
>
>
> SPONSORED LINKS
> Manufacturing <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+
database+software&w3=Database+mortgage+software&w4=Pda+database+softwa
re&w5=Database+management+software&w6=Database+marketing+software&c=6&
s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership
<http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwar
e&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Members
hip+database+software&w3=Database+mortgage+software&w4=Pda+database+so
ftware&w5=Database+management+software&w6=Database+marketing+software&
c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
> Pda <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+d
atabase+software&w3=Database+mortgage+software&w4=Pda+database+softwar
e&w5=Database+management+software&w6=Database+marketing+software&c=6&s
=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database
<http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membe
rship+database+software&w3=Database+mortgage+software&w4=Pda+database+
software&w5=Database+management+software&w6=Database+marketing+softwar
e&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Member
ship+database+software&w3=Database+mortgage+software&w4=Pda+database+s
oftware&w5=Database+management+software&w6=Database+marketing+software
&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " vantage
<http://groups.yahoo.com/group/vantage> " on the web.
>
>
> * 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]
>
2
Does anyone know were I can purshase an import /expot utility to use
with vantage? Thanks Andrew
3
Ditto.
Don't dare ask Epicor. We are version 8. One of the reasons we bought
Vantage was the ease in which we were supposed to populate data. But it
has been a struggle in receiving a strait answer from support.
Migration says you need to be a genius in order to populate the
database. Obviously there are none to be found, because we struggle
with the data migration services we were rooked in to buying. When it
comes to databases we have one of the strongest players in town. At a
previous employer, we had M2M and had no problem in populating the data.
We knew the data mappings and I think it took us 20 minutes max. With
Epicor they treat us as if we were dummies. I think they use this as a
revenue stream. I have asked several times to give us the tool or data
mappings so I can add, or append, or update fields, but run into a brick
wall.

If you find let the rest of us know.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ap4584480
Sent: Tuesday, December 20, 2005 11:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] import /export utility

Does anyone know were I can purshase an import /expot utility to use
with vantage? Thanks Andrew






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 Links
4
I requested a quote for an import utility (8.0), and was told by epicor
that they would do a dump and load for a fee
If I sent them my database. With version 5.0, I used an import utility
to populate data, but apparently,
This is not do-able with version 8.




>Ditto.
>Don't dare ask Epicor. We are version 8. One of the reasons we bought
Vantage was the ease in which we were supposed to >populate data. But
it has been a struggle in receiving a strait answer from support.
>Migration says you need to be a genius in order to populate the
database. Obviously there are none to be found, because >we struggle
with the data migration services we were rooked in to buying. When it
comes to databases we have one of the >strongest players in town. At a
previous employer, we had M2M and had no problem in populating the data.
>We knew the data mappings and I think it took us 20 minutes max. With
Epicor they treat us as if we were dummies. I >>think they use this as a
revenue stream. I have asked several times to give us the tool or data
mappings so I can add, or> append, or update fields, but run into a
brick wall.

If you find let the rest of us know.
5
"Migration says you need to be a genius in order to populate the
database ."



Actually, all you need is the proper documentation for the database
structure.



With a relational database you must fill the lower level master tables
before you fill the mid-level tables before you fill the top level tables.
Etc.



Or, you can't fill a customer table until you first fill the related tables
like "Salesman".



You can't fill a routing table before you fill the work center tables which
can't be filled before you load the machine table.



Once the structure and the sequence are setup the rest is easy.



Typically what most companies want to load are the big three clusters -
CUSTOMER, VENDOR, ITEM/PART ( including BOM ).



This doesn't take a genius, just the proper documentation of the procedures
required.



If you tell support what data you want to bulk load into your database they
should be able to give you the proper sequence for the tables that need to
be loaded.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 5:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility



I requested a quote for an import utility (8.0), and was told by epicor
that they would do a dump and load for a fee
If I sent them my database. With version 5.0, I used an import utility
to populate data, but apparently,
This is not do-able with version 8.




>Ditto.
>Don't dare ask Epicor. We are version 8. One of the reasons we bought
Vantage was the ease in which we were supposed to >populate data. But
it has been a struggle in receiving a strait answer from support.
>Migration says you need to be a genius in order to populate the
database. Obviously there are none to be found, because >we struggle
with the data migration services we were rooked in to buying. When it
comes to databases we have one of the >strongest players in town. At a
previous employer, we had M2M and had no problem in populating the data.
>We knew the data mappings and I think it took us 20 minutes max. With
Epicor they treat us as if we were dummies. I >>think they use this as a
revenue stream. I have asked several times to give us the tool or data
mappings so I can add, or> append, or update fields, but run into a
brick wall.

If you find let the rest of us know.




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 LINKS



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]
6
You should contact your CAM again.

While Epicor no longer makes it's own import tool for v8, Epicor does sell a
third party tool (Pervasive Data Integrator
http://www.pervasive.com/dataintegrator/) and the associated data import
maps. The maps take data from a spreadsheet format that Epicor provides and
populates the proper tables. This is the tool that Epicor's consulting
services uses to migrate your data. The tool and the maps are pretty
expensive though.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224






-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 6:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

I requested a quote for an import utility (8.0), and was told by epicor that
they would do a dump and load for a fee If I sent them my database. With
version 5.0, I used an import utility to populate data, but apparently, This
is not do-able with version 8.




>Ditto.
>Don't dare ask Epicor. We are version 8. One of the reasons we bought
Vantage was the ease in which we were supposed to >populate data. But it
has been a struggle in receiving a strait answer from support.
>Migration says you need to be a genius in order to populate the
database. Obviously there are none to be found, because >we struggle with
the data migration services we were rooked in to buying. When it comes to
databases we have one of the >strongest players in town. At a previous
employer, we had M2M and had no problem in populating the data.
>We knew the data mappings and I think it took us 20 minutes max. With
Epicor they treat us as if we were dummies. I >>think they use this as a
revenue stream. I have asked several times to give us the tool or data
mappings so I can add, or> append, or update fields, but run into a brick
wall.

If you find let the rest of us know.
7
Where do you get the "proper documentation of the procedures required"
mentioned in Todds e-mail.

-----Original Message-----
From: Dan Snyder [mailto:sysadmin@...]
Sent: Wednesday, December 21, 2005 7:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility v8


You should contact your CAM again.

While Epicor no longer makes it's own import tool for v8, Epicor does
sell a
third party tool (Pervasive Data Integrator
http://www.pervasive.com/dataintegrator/) and the associated data import
maps. The maps take data from a spreadsheet format that Epicor provides
and
populates the proper tables. This is the tool that Epicor's consulting
services uses to migrate your data. The tool and the maps are pretty
expensive though.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224






-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 6:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

I requested a quote for an import utility (8.0), and was told by epicor
that
they would do a dump and load for a fee If I sent them my database.
With
version 5.0, I used an import utility to populate data, but apparently,
This
is not do-able with version 8.




>Ditto.
>Don't dare ask Epicor. We are version 8. One of the reasons we bought
Vantage was the ease in which we were supposed to >populate data. But
it
has been a struggle in receiving a strait answer from support.
>Migration says you need to be a genius in order to populate the
database. Obviously there are none to be found, because >we struggle
with
the data migration services we were rooked in to buying. When it comes
to
databases we have one of the >strongest players in town. At a previous
employer, we had M2M and had no problem in populating the data.
>We knew the data mappings and I think it took us 20 minutes max. With
Epicor they treat us as if we were dummies. I >>think they use this as a
revenue stream. I have asked several times to give us the tool or data
mappings so I can add, or> append, or update fields, but run into a
brick
wall.

If you find let the rest of us know.






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 Links









**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************
8
Todd,
I told Epicor that I wanted to load our master tables only. I did not
want to bring our
Old customers, vendors, parts, etc into our V8 db. I stated that our
open SO's, PO's, WO's,
Invoices would be manually entered. I was told that they would have to
do it via a dump N load.



>"Migration says you need to be a genius in order to populate the
database ."

>Typically what most companies want to load are the big three clusters -
CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
>If you tell support what data you want to bulk load into your database
they should be able to give you the proper >>>>>>>sequence for the
tables that need to be loaded.
9
Dump&Load? I suppose you are talking about upgrading from Vantage v6 to v8?
If that's the case, a dump&load might work, but I think it would only work
if the specific table in question hasn't changed from v6 to v8. The
original poster was migrating from another product (Made 2 Manage) to
Vantage, so it wouldn't work for them.

Progress does have import utilities built-in or you could use MS Access or
some other ODBC compliant tool. I'm considering the Pervasive tool for it's
data scrubbing capabilities (much easier than Access programming for me).
It would save time in our project, I'm just not sure it would save enough
time to be worth the cost. Unfortunately, if you want to migrate data
yourself, there is no getting around trial and error to learn the Vantage
database structure.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

Todd,
I told Epicor that I wanted to load our master tables only. I did not want
to bring our Old customers, vendors, parts, etc into our V8 db. I stated
that our open SO's, PO's, WO's, Invoices would be manually entered. I was
told that they would have to do it via a dump N load.
10
Our project is on hold, so I haven't ordered the tool/maps yet, and
therefore I don't know if they include specific directions or not. Maybe
someone that has purchased it can tell us what kind of directions are
included.

My guess would be that Epicor provides very little documentation since they
want to do the data conversions themselves. I'm sure they want the revenue,
but there are other good reasons for Epicor wanting to do it. Every
implementation has different requirements and if data isn't loaded properly
(like fields or tables are missed) it can cause problems with the operation
of the system. Unfortunately, if you want to do it yourself, there is no
getting around trial and error to learn the Vantage database structure.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Clint Muhlestein
Sent: Wednesday, December 21, 2005 9:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility v8

Where do you get the "proper documentation of the procedures required"
mentioned in Todds e-mail.
11
Following this conversation I am getting a little confused. I have not seen any mention of cut/paste via grid entry for the smaller (several hundred or less rows) master tables. My impression was that when I get to that point I would be dumping these to Excel and then cut/paste them into a grid for updating. Since these are one-off tasks a day or of manual loading would nto be too bad. Yes, the larger tables would be impossible but the smaller ones should be OK. Am I missing something or making a wrong assumption about grid entry bulk adds?

Thanks,
Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Dan Snyder
Sent: Wednesday, December 21, 2005 9:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility


Dump&Load? I suppose you are talking about upgrading from Vantage v6 to v8?
If that's the case, a dump&load might work, but I think it would only work
if the specific table in question hasn't changed from v6 to v8. The
original poster was migrating from another product (Made 2 Manage) to
Vantage, so it wouldn't work for them.

Progress does have import utilities built-in or you could use MS Access or
some other ODBC compliant tool. I'm considering the Pervasive tool for it's
data scrubbing capabilities (much easier than Access programming for me).
It would save time in our project, I'm just not sure it would save enough
time to be worth the cost. Unfortunately, if you want to migrate data
yourself, there is no getting around trial and error to learn the Vantage
database structure.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

Todd,
I told Epicor that I wanted to load our master tables only. I did not want
to bring our Old customers, vendors, parts, etc into our V8 db. I stated
that our open SO's, PO's, WO's, Invoices would be manually entered. I was
told that they would have to do it via a dump N load.









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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
12
Dick,



I usually break down database structures into 3 main layers -



"Master tables" - Major = Customer, Vendor, Part ... Minor = Workcenter,
salesman, tax codes, etc etc etc



"Production tables" - Major = Sales orders, Purchase Orders, Shop orders,
Invoices etc . Minor = History, log files, etc



"Work tables" - tables that only contain data during processing cycles or
reporting etc



Which "Master Tables" do you want to load if you don't want to load
Customers/Vendors/Parts?



I'd start with making a specific list of the tables you want to populate.



Todd



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 8:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility



Todd,
I told Epicor that I wanted to load our master tables only. I did not
want to bring our
Old customers, vendors, parts, etc into our V8 db. I stated that our
open SO's, PO's, WO's,
Invoices would be manually entered. I was told that they would have to
do it via a dump N load.



>"Migration says you need to be a genius in order to populate the
database ."

>Typically what most companies want to load are the big three clusters -
CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
>If you tell support what data you want to bulk load into your database
they should be able to give you the proper >>>>>>>sequence for the
tables that need to be loaded.




_____



[Non-text portions of this message have been removed]
13
Todd Anderson wrote...
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".

Sorry for butting into your conversation, but I don't believe these
statements are true, at least not with any relational DB's I've ever
dealt with. Master Files must be populated before the lower level
tables.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@s...>
wrote:
>
> "Migration says you need to be a genius in order to populate the
> database ."
>
>
>
> Actually, all you need is the proper documentation for the database
> structure.
>
>
>
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".
>
>
>
> You can't fill a routing table before you fill the work center
tables which
> can't be filled before you load the machine table.
>
>
>
> Once the structure and the sequence are setup the rest is easy.
>
>
>
> Typically what most companies want to load are the big three
clusters -
> CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
>
>
>
> This doesn't take a genius, just the proper documentation of the
procedures
> required.
>
>
>
> If you tell support what data you want to bulk load into your
database they
> should be able to give you the proper sequence for the tables that
need to
> be loaded.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> PLAMAN DICK
> Sent: Wednesday, December 21, 2005 5:50 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] import /export utility
>
>
>
> I requested a quote for an import utility (8.0), and was told by
epicor
> that they would do a dump and load for a fee
> If I sent them my database. With version 5.0, I used an import
utility
> to populate data, but apparently,
> This is not do-able with version 8.
>
>
>
>
> >Ditto.
> >Don't dare ask Epicor. We are version 8. One of the reasons we
bought
> Vantage was the ease in which we were supposed to >populate data.
But
> it has been a struggle in receiving a strait answer from support.
> >Migration says you need to be a genius in order to populate the
> database. Obviously there are none to be found, because >we
struggle
> with the data migration services we were rooked in to buying. When
it
> comes to databases we have one of the >strongest players in town.
At a
> previous employer, we had M2M and had no problem in populating the
data.
> >We knew the data mappings and I think it took us 20 minutes max.
With
> Epicor they treat us as if we were dummies. I >>think they use this
as a
> revenue stream. I have asked several times to give us the tool or
data
> mappings so I can add, or> append, or update fields, but run into a
> brick wall.
>
> If you find let the rest of us know.
>
>
>
>
> 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 LINKS
>
>
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * 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!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> _____
>
>
>
> [Non-text portions of this message have been removed]
>
14
Todd,

You are correct, you could do cut and paste to load some of the smaller
tables. Maybe even some of the larger tables with a scripting tool like
GroundControl. You could also do manual data entry and call it "user
training". Every implementation will be different, it will have different
data input needs and different skill sets for the people doing the
inputting. For new Vantage users there are also the considerations of
fields that Vantage requires that you didn't have before and custom fields
that you need that vantage doesn't have out of the box.

Happy Holidays,

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Wednesday, December 21, 2005 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

Following this conversation I am getting a little confused. I have not seen
any mention of cut/paste via grid entry for the smaller (several hundred or
less rows) master tables. My impression was that when I get to that point I
would be dumping these to Excel and then cut/paste them into a grid for
updating. Since these are one-off tasks a day or of manual loading would
nto be too bad. Yes, the larger tables would be impossible but the smaller
ones should be OK. Am I missing something or making a wrong assumption
about grid entry bulk adds?

Thanks,
Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Dan Snyder
Sent: Wednesday, December 21, 2005 9:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility


Dump&Load? I suppose you are talking about upgrading from Vantage v6 to v8?
If that's the case, a dump&load might work, but I think it would only work
if the specific table in question hasn't changed from v6 to v8. The
original poster was migrating from another product (Made 2 Manage) to
Vantage, so it wouldn't work for them.

Progress does have import utilities built-in or you could use MS Access or
some other ODBC compliant tool. I'm considering the Pervasive tool for it's
data scrubbing capabilities (much easier than Access programming for me).
It would save time in our project, I'm just not sure it would save enough
time to be worth the cost. Unfortunately, if you want to migrate data
yourself, there is no getting around trial and error to learn the Vantage
database structure.

Happy Holidays! Hope that helps.

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
PLAMAN DICK
Sent: Wednesday, December 21, 2005 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] import /export utility

Todd,
I told Epicor that I wanted to load our master tables only. I did not want
to bring our Old customers, vendors, parts, etc into our V8 db. I stated
that our open SO's, PO's, WO's, Invoices would be manually entered. I was
told that they would have to do it via a dump N load.
15
Brian,



A matter of definition I suppose.



I consider Customer a higher level master table than Salesman. You cannot
populate Customer until you populate Salesman first. Or, to put it
differently, you cannot populate a table that references other tables until
those tables are populated.



Both are master tables.



Todd



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian Stenglein
Sent: Wednesday, December 21, 2005 11:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: import /export utility



Todd Anderson wrote...
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".

Sorry for butting into your conversation, but I don't believe these
statements are true, at least not with any relational DB's I've ever
dealt with. Master Files must be populated before the lower level
tables.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@s...>
wrote:
>
> "Migration says you need to be a genius in order to populate the
> database ."
>
>
>
> Actually, all you need is the proper documentation for the database
> structure.
>
>
>
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".
>
>
>
> You can't fill a routing table before you fill the work center
tables which
> can't be filled before you load the machine table.
>
>
>
> Once the structure and the sequence are setup the rest is easy.
>
>
>
> Typically what most companies want to load are the big three
clusters -
> CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
>
>
>
> This doesn't take a genius, just the proper documentation of the
procedures
> required.
>
>
>
> If you tell support what data you want to bulk load into your
database they
> should be able to give you the proper sequence for the tables that
need to
> be loaded.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> PLAMAN DICK
> Sent: Wednesday, December 21, 2005 5:50 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] import /export utility
>
>
>
> I requested a quote for an import utility (8.0), and was told by
epicor
> that they would do a dump and load for a fee
> If I sent them my database. With version 5.0, I used an import
utility
> to populate data, but apparently,
> This is not do-able with version 8.
>
>
>
>
> >Ditto.
> >Don't dare ask Epicor. We are version 8. One of the reasons we
bought
> Vantage was the ease in which we were supposed to >populate data.
But
> it has been a struggle in receiving a strait answer from support.
> >Migration says you need to be a genius in order to populate the
> database. Obviously there are none to be found, because >we
struggle
> with the data migration services we were rooked in to buying. When
it
> comes to databases we have one of the >strongest players in town.
At a
> previous employer, we had M2M and had no problem in populating the
data.
> >We knew the data mappings and I think it took us 20 minutes max.
With
> Epicor they treat us as if we were dummies. I >>think they use this
as a
> revenue stream. I have asked several times to give us the tool or
data
> mappings so I can add, or> append, or update fields, but run into a
> brick wall.
>
> If you find let the rest of us know.
>
>
>
>
> 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/>
> (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 LINKS
>
>
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * 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!
> <http://docs.yahoo.com/info/terms/> Terms of 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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS


Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software

Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software


Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]
16
From the databases perspective, I don't think it matters which is loaded
first (master or control). At least it hasn't mattered in most SQL databases
that I've dealt with. That being said, I try to do the smaller control
tables first (simply as a matter of practice) since applications typically
require them to be setup first. For example, when in the Vantage you can't
set the part class in a part record unless the part class table is already
populated.

Happy Holidays!

Dan Snyder
IT Manager
Mercury Electronics
717-854-9557 ext.224




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian Stenglein
Sent: Wednesday, December 21, 2005 12:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: import /export utility

Todd Anderson wrote...
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".

Sorry for butting into your conversation, but I don't believe these
statements are true, at least not with any relational DB's I've ever dealt
with. Master Files must be populated before the lower level tables.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@s...>
wrote:
>
> "Migration says you need to be a genius in order to populate the
> database ."
>
>
>
> Actually, all you need is the proper documentation for the database
> structure.
>
>
>
> With a relational database you must fill the lower level master
tables
> before you fill the mid-level tables before you fill the top level
tables.
> Etc.
>
>
>
> Or, you can't fill a customer table until you first fill the
related tables
> like "Salesman".
>
>
>
> You can't fill a routing table before you fill the work center
tables which
> can't be filled before you load the machine table.
>
>
>
> Once the structure and the sequence are setup the rest is easy.
>
>
>
> Typically what most companies want to load are the big three
clusters -
> CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
>
>
>
> This doesn't take a genius, just the proper documentation of the
procedures
> required.
>
>
>
> If you tell support what data you want to bulk load into your
database they
> should be able to give you the proper sequence for the tables that
need to
> be loaded.
17
OK, gotcha. When I read it the first time, it didn't register that
you were talking about different levels of master files. Sorry.


--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@s...>
wrote:
>
> Brian,
>
>
>
> A matter of definition I suppose.
>
>
>
> I consider Customer a higher level master table than Salesman. You
cannot
> populate Customer until you populate Salesman first. Or, to put it
> differently, you cannot populate a table that references other
tables until
> those tables are populated.
>
>
>
> Both are master tables.
>
>
>
> Todd
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Brian Stenglein
> Sent: Wednesday, December 21, 2005 11:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: import /export utility
>
>
>
> Todd Anderson wrote...
> > With a relational database you must fill the lower level master
> tables
> > before you fill the mid-level tables before you fill the top
level
> tables.
> > Etc.
> >
> >
> >
> > Or, you can't fill a customer table until you first fill the
> related tables
> > like "Salesman".
>
> Sorry for butting into your conversation, but I don't believe these
> statements are true, at least not with any relational DB's I've
ever
> dealt with. Master Files must be populated before the lower level
> tables.
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "Todd Anderson"
<todd.anderson@s...>
> wrote:
> >
> > "Migration says you need to be a genius in order to populate the
> > database ."
> >
> >
> >
> > Actually, all you need is the proper documentation for the
database
> > structure.
> >
> >
> >
> > With a relational database you must fill the lower level master
> tables
> > before you fill the mid-level tables before you fill the top
level
> tables.
> > Etc.
> >
> >
> >
> > Or, you can't fill a customer table until you first fill the
> related tables
> > like "Salesman".
> >
> >
> >
> > You can't fill a routing table before you fill the work center
> tables which
> > can't be filled before you load the machine table.
> >
> >
> >
> > Once the structure and the sequence are setup the rest is easy.
> >
> >
> >
> > Typically what most companies want to load are the big three
> clusters -
> > CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
> >
> >
> >
> > This doesn't take a genius, just the proper documentation of the
> procedures
> > required.
> >
> >
> >
> > If you tell support what data you want to bulk load into your
> database they
> > should be able to give you the proper sequence for the tables
that
> need to
> > be loaded.
> >
> >
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > PLAMAN DICK
> > Sent: Wednesday, December 21, 2005 5:50 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] import /export utility
> >
> >
> >
> > I requested a quote for an import utility (8.0), and was told by
> epicor
> > that they would do a dump and load for a fee
> > If I sent them my database. With version 5.0, I used an import
> utility
> > to populate data, but apparently,
> > This is not do-able with version 8.
> >
> >
> >
> >
> > >Ditto.
> > >Don't dare ask Epicor. We are version 8. One of the reasons we
> bought
> > Vantage was the ease in which we were supposed to >populate
data.
> But
> > it has been a struggle in receiving a strait answer from support.
> > >Migration says you need to be a genius in order to populate the
> > database. Obviously there are none to be found, because >we
> struggle
> > with the data migration services we were rooked in to buying.
When
> it
> > comes to databases we have one of the >strongest players in
town.
> At a
> > previous employer, we had M2M and had no problem in populating
the
> data.
> > >We knew the data mappings and I think it took us 20 minutes
max.
> With
> > Epicor they treat us as if we were dummies. I >>think they use
this
> as a
> > revenue stream. I have asked several times to give us the tool
or
> data
> > mappings so I can add, or> append, or update fields, but run into
a
> > brick wall.
> >
> > If you find let the rest of us know.
> >
> >
> >
> >
> > 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/>
> > (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 LINKS
> >
> >
> >
> > * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> "
> > on the web.
> >
> > * 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!
> > <http://docs.yahoo.com/info/terms/> Terms of 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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
>
>
> Manufacturing
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing
>
+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=P
>
da+database+software&w5=Database+management+software&w6=Database+marke
ting+s
> oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
>
> Membership
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marke
> ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database
software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&
>
w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arketi
> ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
>
>
> Pda
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+
>
software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pd
>
a+database+software&w5=Database+management+software&w6=Database+market
ing+so
> ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marke
> ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management
software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufact
>
uring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftware
>
&w4=Pda+database+software&w5=Database+management+software&w6=Database+
market
> ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing
software
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * 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!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> _____
>
>
>
> [Non-text portions of this message have been removed]
>
18
Technically, you can populate tables in any sequence that you like providing
that:

1. You have no interaction with the application during the process and

2. You do not result in orphaned references once you are complete

It is easier for most people to view the process as beginning at the upper
end of the hierarchy and proceeding across the branches of foreign keys but
there is no technical requirement to proceed in that manner.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian Stenglein
Sent: Wednesday, December 21, 2005 10:11 AM
To: vantage@yahoogroups.com
Subject: Spam [Vantage] Re: import /export utility

OK, gotcha. When I read it the first time, it didn't register that you were
talking about different levels of master files. Sorry.


--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@s...>
wrote:
>
> Brian,
>
>
>
> A matter of definition I suppose.
>
>
>
> I consider Customer a higher level master table than Salesman. You
cannot
> populate Customer until you populate Salesman first. Or, to put it
> differently, you cannot populate a table that references other
tables until
> those tables are populated.
>
>
>
> Both are master tables.
>
>
>
> Todd
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Brian Stenglein
> Sent: Wednesday, December 21, 2005 11:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: import /export utility
>
>
>
> Todd Anderson wrote...
> > With a relational database you must fill the lower level master
> tables
> > before you fill the mid-level tables before you fill the top
level
> tables.
> > Etc.
> >
> >
> >
> > Or, you can't fill a customer table until you first fill the
> related tables
> > like "Salesman".
>
> Sorry for butting into your conversation, but I don't believe these
> statements are true, at least not with any relational DB's I've
ever
> dealt with. Master Files must be populated before the lower level
> tables.
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "Todd Anderson"
<todd.anderson@s...>
> wrote:
> >
> > "Migration says you need to be a genius in order to populate the
> > database ."
> >
> >
> >
> > Actually, all you need is the proper documentation for the
database
> > structure.
> >
> >
> >
> > With a relational database you must fill the lower level master
> tables
> > before you fill the mid-level tables before you fill the top
level
> tables.
> > Etc.
> >
> >
> >
> > Or, you can't fill a customer table until you first fill the
> related tables
> > like "Salesman".
> >
> >
> >
> > You can't fill a routing table before you fill the work center
> tables which
> > can't be filled before you load the machine table.
> >
> >
> >
> > Once the structure and the sequence are setup the rest is easy.
> >
> >
> >
> > Typically what most companies want to load are the big three
> clusters -
> > CUSTOMER, VENDOR, ITEM/PART ( including BOM ).
> >
> >
> >
> > This doesn't take a genius, just the proper documentation of the
> procedures
> > required.
> >
> >
> >
> > If you tell support what data you want to bulk load into your
> database they
> > should be able to give you the proper sequence for the tables
that
> need to
> > be loaded.
> >
> >
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > PLAMAN DICK
> > Sent: Wednesday, December 21, 2005 5:50 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] import /export utility
> >
> >
> >
> > I requested a quote for an import utility (8.0), and was told by
> epicor
> > that they would do a dump and load for a fee
> > If I sent them my database. With version 5.0, I used an import
> utility
> > to populate data, but apparently,
> > This is not do-able with version 8.
> >
> >
> >
> >
> > >Ditto.
> > >Don't dare ask Epicor. We are version 8. One of the reasons we
> bought
> > Vantage was the ease in which we were supposed to >populate
data.
> But
> > it has been a struggle in receiving a strait answer from support.
> > >Migration says you need to be a genius in order to populate the
> > database. Obviously there are none to be found, because >we
> struggle
> > with the data migration services we were rooked in to buying.
When
> it
> > comes to databases we have one of the >strongest players in
town.
> At a
> > previous employer, we had M2M and had no problem in populating
the
> data.
> > >We knew the data mappings and I think it took us 20 minutes
max.
> With
> > Epicor they treat us as if we were dummies. I >>think they use
this
> as a
> > revenue stream. I have asked several times to give us the tool
or
> data
> > mappings so I can add, or> append, or update fields, but run into
a
> > brick wall.
> >
> > If you find let the rest of us know.
> >
> >
> >
> >
> > 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/>
> > (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 LINKS
> >
> >
> >
> > * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> "
> > on the web.
> >
> > * 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!
> > <http://docs.yahoo.com/info/terms/> Terms of 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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
>
>
> Manufacturing
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing
>
+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=P
>
da+database+software&w5=Database+management+software&w6=Database+marke
ting+s
> oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
>
> Membership
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marke
> ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database
software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&
>
w4=Pda+database+software&w5=Database+management+software&w6=Database+m
arketi
> ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
>
>
> Pda
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+
>
software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pd
>
a+database+software&w5=Database+management+software&w6=Database+market
ing+so
> ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marke
> ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management
software
>
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufact
>
uring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftware
>
&w4=Pda+database+software&w5=Database+management+software&w6=Database+
market
> ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing
software
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * 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!
> <http://docs.yahoo.com/info/terms/> Terms of 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 Links