I think I am getting closer - thanks for the tips and the patience!
I have been through all the files and here is what I have gotten when running
my definition file through the data tools
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://webtools/widget/MiscScreens.xml#viewdatafile]:
groovy.lang.MissingPropertyException: No such property: definitionUrl for
class: viewdatafile (No such property: definitionUrl for class: viewdatafile)
Here is the xsd file I was running:
<data-file name="itemdatabasereport.txt" separator-style="delimited"
type-code="UTF-8"
delimiter="	" text-delimiter=""
description="this takes the product data from jeffs file"
has-header="true">
<record name="Product">
<field name="manufacturer_party_id" ignored="false" type="String"/>
<field name="productId" ignored="false" type="String"/>
<field name="primaryProductCategoryId" expression="true"
default-value="tools" type="String"/>
<field name="productTypeId" expression="true"
default-value="FINISHED_GOOD" type="String"/>
<field name="productName" ignored="false" type="String"/>
<field name="description" ignored="false" type="String"/>
<field name="quantityIncluded" expression="true" default-value="1"
type="String"/>
<field name="price" ignored="true" type="String"/>
</record>
</data-file>
What's wrong with my definition file which is causing the data tool to throw up?
Thanks
James
-----Original Message-----
From: BJ Freeman [mailto:[email protected]]
Sent: November-26-10 1:36 AM
To: [email protected]
Subject: Re: How to import a pre existing product database
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
>>
>
>
>
