I am not clear what you are doing.
the example you show is for an entity DataImportProduct
which does not exist in the OOTB ofbiz
take a look at
https://issues.apache.org/jira/browse/OFBIZ-2534
for tab examples.
also
https://issues.apache.org/jira/browse/OFBIZ-2518
=========================
BJ Freeman
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
James Lawton sent the following on 11/25/2010 6:36 PM:
I am probably doing something stupid here...I have dug into the link that was
posted and it looks simple enough...however the code snippet is for a fixed
width file rather than a comma delimited file...and my attempts to create the
right schema for importing product are failing...If someone has a CSV file
snippet to share that would be awesome
So heading in a different direction I created the entity data snippet below:
<!-- this file contains some sample products for testing the data import routine
-->
<entity-engine-xml>
<DataImportProduct productId="YG0081ATF" productTypeId="FINISHED_GOOD" description="1/8 x 1-59/64 CARBIDE DREAM DRILL W/O
COOLANT HOLES (3XD)" price="22.13" priceCurrencyUomId="USD" supplierPartyId="YG1" purchasePrice=""/>
<DataImportProduct productId="YG0081BTF" productTypeId="FINISHED_GOOD" description="1/8 x 15/64 CARBIDE DREAM DRILL W/
COOLANT HOLE" price="105.73" priceCurrencyUomId="USD" supplierPartyId="YG1" purchasePrice=""/>
</entity-engine-xml>
However every time I have tried to use the XML IMport tool it just keeps coming
back and saying that the either URL / file or the XML are not complete
What am I doing wrong?
-----Original Message-----
From: BJ Freeman [mailto:[email protected]]
Sent: November-09-10 6:00 PM
To: [email protected]
Subject: Re: How to import a pre existing product database
all web tools imports into memory so is limited to the amount of free memory of
the sever.
I imports files that are gigs in size so read in the files. I typical file has
25 columns and takes about 15min.
There is no need to write code to convert files to xml since the
https://cwiki.apache.org/confluence/display/OFBENDUSER/OFBiz%27s+Data+File+Tools
=========================
BJ Freeman
Strategic Power Office with Supplier
Automation<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com<http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
James McGill sent the following on 11/9/2010 12:38 PM:
On Tue, Nov 9, 2010 at 9:34 AM, James Lawton<[email protected]>wrote:
How would I import a pre existing product database? I currently have it in
a
CSV and I am looking for a method of getting that information into the
database so that the imported items will show up in the catalog
OFBiz ETL is best done as XML seed data.
In your scenario I would seriously consider converting the CSV into XML (a
job for Perl),
and perhaps doing some input validation as part of that conversion, and then
loading the XML
as seed data.
If you really have a lot of ETL to do (e.g., processing that will take hours
or days to run through the service interface) you might be better off going
straight to the database. You lose some of the traceability this way (e.g.,
logging and event side-effects) so it isn't recommended. (We ran into
problems when loading in several years worth of historical data, orders and
inventory transactions.)
--
James McGill
Phoenix AZ
