Data Conversion via ODBC (V8)

Yahoo Archive
1
Thanks for the reply!



Maybe I will try it in a test DB first!



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of senderName
Sent: Monday, December 04, 2006 6:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Data Conversion via ODBC (V8)




I did some uploads via odbc(in access) and the part stuff worked fine,
but the customer upload populated the table fine, but now you can not
add any new customer records via Vantage. :(

Roger Rabus
Logical Solutions





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



Has anyone done a data conversion to an 8.X database on their own?

We are looking to convert Parts, PartOpr, PartMtl, Cost & Quantities,
and Open A/R.



Is it just as simple as running an INSERT statement against these tables
or is it more complex?

If you have done this, any gotchas?





Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]
3
Yes, For parts things like Part, PartCost, PartWhse, PartPlant,
PlantWhse must all be populated.

If you miss items such as SalesUM and others you can cause strange
problems later on so ensure you fully test the system.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Monday, December 04, 2006 1:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Data Conversion via ODBC (V8)



Hello,

Has anyone done a data conversion to an 8.X database on their own?

We are looking to convert Parts, PartOpr, PartMtl, Cost & Quantities,
and Open A/R.

Is it just as simple as running an INSERT statement against these tables
or is it more complex?

If you have done this, any gotchas?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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





[Non-text portions of this message have been removed]
4
I did some uploads via odbc(in access) and the part stuff worked fine, but the customer upload populated the table fine, but now you can not add any new customer records via Vantage. :(


Roger Rabus
Logical Solutions