Andrew Ballantine wrote:
How do I get data from an external application into the OFBiz database?
Entity-engine-xml formatted if you can, should be the cleanest (as in you can't
mess up) method. The only downside is that it has to be clean data loaded in the
proper order. You can load 180,000 records and have one fail and it'll fail the
whole thing.
http://ofbizwiki.go-integral.com/Wiki.jsp?page=ImportingData
If you are talking about Customers/Orders/Items/Payments, we are writing
services that take a few input tables and build the dozens of ofBiz tables.
We're still not done, but it writes back to the input tables so we know which
records actually get into ofBiz.
You haven't mentioned what DBMS you are using. I don't think anyone recommends
the built-in Derby (nee: Cloudscape) database for production or even prototyping.
I'm wondering if that's what is happening... you've only worked with ofBiz with
Derby. There are tools to work with Derby...
http://db.apache.org/derby/docs/10.1/tools/ctoolsimport13648.html
Or are you using MS-SQL, Oracle, PostgreSQL, MySQL 5+? As long as you load your
data in the proper order, you could use any of your DBMS's import tools.
--
Walter
