Utility to export Customers from one database and import into an

Yahoo Archive
1
We use a tool called DMT from a company called Dot Net IT (www.dotnetit.co.uk) for all our data imports. It works by calling the Business Objects (so everything's validated properly) without the overheads associated with SC (i.e. Web services) and can handle Parts, Inventory, Bill of Materials, Customers, Suppliers, Inventory, Sales Orders and UD tables. It's also lightning-fast and all it requires as inputs are Excel or CSV files!

To solve your problem, I would export your Customer info using a BAQ or ODBC and reimport using the above tool.

Dele Oyebande

IT Manager
Autac Products

--- In vantage@yahoogroups.com, "vanb1950" <van.backeris@...> wrote:
>
> We need to start from scratch and create a new clean database before we go live. Does anybody have a utility to export and import Customers from one Vantage database into another? We are on Vantag8.03.400 using the Progress database.
>
2
We need to start from scratch and create a new clean database before we go live. Does anybody have a utility to export and import Customers from one Vantage database into another? We are on Vantag8.03.400 using the Progress database.
3
The only thing I could think is build a VB.net script to open up an ODBC
dump them out to a CSV or the like and open an ODBC to the new DB and put
them back in. the only problem is this is a big no no with epicor.



Does any one know of a screen in vantage that do a paste update for
customers?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
vanb1950
Sent: Thursday, March 05, 2009 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Utility to export Customers from one database and import
into another database



We need to start from scratch and create a new clean database before we go
live. Does anybody have a utility to export and import Customers from one
Vantage database into another? We are on Vantag8.03.400 using the Progress
database.



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00




[Non-text portions of this message have been removed]
4
I know one way is to pay epicor.

You can do a dump of your customers into Excel, and then they have a SC
Routine they are willing to run to import it for you. I think a run costs
around $1500 so that would be an option, or you could spend the time and
build a SC routine yourself to map the ODBC dump into a clean Vantage DB.

----- Original Message -----
From: "Charlie Wilson" <foamdesigncsw@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, March 05, 2009 2:01 PM
Subject: RE: [Vantage] Utility to export Customers from one database and
import into another database


> The only thing I could think is build a VB.net script to open up an ODBC
> dump them out to a CSV or the like and open an ODBC to the new DB and put
> them back in. the only problem is this is a big no no with epicor.
>
>
>
> Does any one know of a screen in vantage that do a paste update for
> customers?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> vanb1950
> Sent: Thursday, March 05, 2009 1:44 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Utility to export Customers from one database and
> import
> into another database
>
>
>
> We need to start from scratch and create a new clean database before we go
> live. Does anybody have a utility to export and import Customers from one
> Vantage database into another? We are on Vantag8.03.400 using the Progress
> database.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
> 13:27:00
>
>
>
>
> [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/linksYahoo! Groups Links
>
>
>
5
We have the CRM module which does allow for the import of customer/prospects/suspects into Vamtage via a csv file.
Â
-Karl-

--- On Thu, 3/5/09, Charlie Wilson <foamdesigncsw@...> wrote:


From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] Utility to export Customers from one database and import into another database
To: vantage@yahoogroups.com
Date: Thursday, March 5, 2009, 11:01 AM






The only thing I could think is build a VB.net script to open up an ODBC
dump them out to a CSV or the like and open an ODBC to the new DB and put
them back in. the only problem is this is a big no no with epicor.

Does any one know of a screen in vantage that do a paste update for
customers?

~Charlie

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
vanb1950
Sent: Thursday, March 05, 2009 1:44 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Utility to export Customers from one database and import
into another database

We need to start from scratch and create a new clean database before we go
live. Does anybody have a utility to export and import Customers from one
Vantage database into another? We are on Vantag8.03.400 using the Progress
database.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00

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



















[Non-text portions of this message have been removed]
6
Dump and Load. It is possible to do this with a single table if necessary.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: Karl Dash
To: vantage@yahoogroups.com
Sent: Thursday, March 05, 2009 3:21 PM
Subject: RE: [Vantage] Utility to export Customers from one database and import into another database


We have the CRM module which does allow for the import of customer/prospects/suspects into Vamtage via a csv file.

-Karl-

--- On Thu, 3/5/09, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] Utility to export Customers from one database and import into another database
To: vantage@yahoogroups.com
Date: Thursday, March 5, 2009, 11:01 AM

The only thing I could think is build a VB.net script to open up an ODBC
dump them out to a CSV or the like and open an ODBC to the new DB and put
them back in. the only problem is this is a big no no with epicor.

Does any one know of a screen in vantage that do a paste update for
customers?

~Charlie

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
vanb1950
Sent: Thursday, March 05, 2009 1:44 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Utility to export Customers from one database and import
into another database

We need to start from scratch and create a new clean database before we go
live. Does anybody have a utility to export and import Customers from one
Vantage database into another? We are on Vantag8.03.400 using the Progress
database.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00

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

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





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