there should be more to the log that would pinpoint what is going on.
I am guessing it is your input to the form, since this has not been
changed 09.
if you look at the file mentioned you will see
<script
location="component://webtools/webapp/webtools/WEB-INF/actions/datafile/viewdatafile.groovy"/>
that is where the error referenced.
your xml(not xsd) should have field names as you see them in webtools.
when you have underscores like manufacturer_party_id then that is what
is in the db but ofbiz will not recognize it in Webtools or code.
James Lawton sent the following on 11/30/2010 7:34 PM:
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
