Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1AA51200D3C for ; Tue, 14 Nov 2017 09:02:24 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 19294160BF4; Tue, 14 Nov 2017 08:02:24 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 5EE5E1609EF for ; Tue, 14 Nov 2017 09:02:23 +0100 (CET) Received: (qmail 89342 invoked by uid 500); 14 Nov 2017 08:02:17 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 89326 invoked by uid 99); 14 Nov 2017 08:02:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Nov 2017 08:02:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 32EC01A1A4D for ; Tue, 14 Nov 2017 08:02:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.28 X-Spam-Level: X-Spam-Status: No, score=0.28 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id nki8bZImTpHV for ; Tue, 14 Nov 2017 08:02:14 +0000 (UTC) Received: from relay2-d.mail.gandi.net (relay2-d.mail.gandi.net [217.70.183.194]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 57F9360DE4 for ; Tue, 14 Nov 2017 08:02:14 +0000 (UTC) Received: from [IPv6:2001:41d0:fe9c:7e00:7157:b188:75af:e16b] (unknown [IPv6:2001:41d0:fe9c:7e00:7157:b188:75af:e16b]) (Authenticated sender: pierre.gaudin@nereide.fr) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 9C99AC5AA4 for ; Tue, 14 Nov 2017 09:02:07 +0100 (CET) Subject: Re: File format to import products To: user@ofbiz.apache.org References: From: "pierre.gaudin" Message-ID: Date: Tue, 14 Nov 2017 09:02:06 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: fr archived-at: Tue, 14 Nov 2017 08:02:24 -0000 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