Le 17/11/2017 à 09:43, Javier H. a écrit :
On 2017-11-17 08:05, Michael Brohl <[email protected]> wrote:
Hi Javier,
why not directly export to the OFBiz datafile format?
Regards,
Michael
Am 17.11.17 um 09:03 schrieb Javier H.:
On 2017-11-14 08:21, "Javier H."<[email protected]> wrote:
On 2017-11-14 08:02, "pierre.gaudin" <[email protected]> wrote:
On 14/11/2017 08:55, Javier H. wrote:
Hello,
I have to import about 95.000 products into Ofbiz (mysql database).
I can import it to TXT or SQL formats, also to XLS but I get a error because
max is 65.000 rows.
What format do you recommend for import, TXT or SQL?
Best regards
Hi Javier
We used to import about 700 000 article for a customer.
We used XML import via XSLT transformation to do so. I don't think there
is a limit with xml import.
Pierre
Thank you Pierre,
I think that I can to export to XML, I have to check it.
Best regards
Hello,
I have exported the data to an XML file.
Something similar to this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<RECORDS>
<RECORD>
<ROW
CODE="1308051"
DESCR="DEMO PRODUCT"
PRICE="5,50"
TAX="21"
QUANTITY="40"
LASTPRICE="4,9"
TAXCODE="3"
PROVIDER="87"
CATEGORY="00099"
DATE="01012015"
/>
</RECORD>
.....
</RECORDS>
How can I make the definition file for this?
And how can I ignore the fields that I do not want to import? (For example
DATE).
Best regards
Hi Michael,
Because I have no idea.
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Data+File+Tools
I'm testing Data File Tools, I added this
"/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd" to Definition
Filename or URL" but I get this error:
No <data-file> elements found in
file:/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd
Best regards
Hi Javier,
Did you follow
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz's+Data+File+Tools ?
Did you have a look at
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data ?
HTH
Jacques
