-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Basic rule if it static data then use the import. I use excel to create the xml which saves a lot of typing.
for the dynamic, you can create a datasource for the legacy and use a delegator. This is a little more fancy but then can use the entity engine to query the legacy and write to the new database using services. the services can be then setup in the sand box to run every so often. you can also update the legacy system using the method. This approach also means you have to generate the entities for the legacy database. I don't think this is documented anywhere, so let me know if you interested and I will work on putting something on the wiki. Kevin M. Myer sent the following on 1/2/2009 8:42 AM: > Hello, > > I am continuing to look at Ofbiz as an option for ERP software for our > company. I have two cases where I will need to import data into Ofbiz > and I am curious what the best practice recommendation for how to do > this would be. > > The first would be during initial setup, when I would be loading our > product catalog. Would the best method of doing this be to create an > XML Entity Engine file that I import through the WebTools interface? > This process would be performed by me, so ease of import is not a > large issue. > > The second would be to import orders from a legacy database > application. This would be ongoing, until the point in time that the > legacy system is completely replaced by the new ERP solution. The > legacy system generates an Excel spreadsheet with an order number and > various other data. This process would be performed by end-users, so > it would either need to be automated, or a very simple step for them > to import a file containing the data. > > Thanks for any advice or feedback. > > Kevin > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJXnwNrP3NbaWWqE4RAswmAJ9+xsAjhykaiOEUYC+xjD1P1TxiZgCfSdgf G8lkmQxSmQtX9oI/te+7Qvw= =Y4Tk -----END PGP SIGNATURE-----
