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
