Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: pass (athena.apache.org: domain of pierre.smits@gmail.com
 designates 209.85.212.169 as permitted sender)
Subject: Re: Generic xml import & export functionality
References: 
 <CADPkm86=HQzNJNngv4uBAjvObvPrjgp00nmiwQQCfw=c24jM6A@mail.gmail.com>
 <24550384.46.1403988051790.JavaMail.taher@pythys-ultra>
 <CADPkm84J=TwOhUk=7CMwbE7Y=W81P8LheSDv0m7zgb-qBzq6ZA@mail.gmail.com>
 <53AF6EE5.2030306@yahoo.com> <53B072F2.30708@sandglass-software.com>
 <CADPkm86eiuQaXs9GCYFzfn7+Fmi-zL8NV_m3Ed30WQjGYroXAA@mail.gmail.com>
 <53B2C049.1040805@artifact-software.com>
From: "Pierre @GMail" <pierre.smits@gmail.com>
Content-Type: text/plain;
	charset=us-ascii
In-Reply-To: <53B2C049.1040805@artifact-software.com>
Message-Id: <E45A1CFD-1F33-4B4C-B231-B32424957653@gmail.com>
Date: Tue, 1 Jul 2014 17:12:55 +0300
To: "user@ofbiz.apache.org" <user@ofbiz.apache.org>
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (1.0)

Ron,

Thans!

Regards,

Pierre

Sent from my iPhone

> On 1 jul. 2014, at 17:06, Ron Wheeler <rwheeler@artifact-software.com> wro=
te:
>=20
> Have a good look at XSLT before starting to write code.
>=20
> http://www.w3schools.com/xsl/xsl_transformation.asp
> http://www.cs.toronto.edu/~ryanjohn/teaching/cscc43-s12/lectures/c43-xslt-=
v02.pdf
>=20
> A couple of good books from O'Reilly:
> XSLT Cookbook Solutions and Examples for XML and XSLT Developers
> http://shop.oreilly.com/product/9780596003722.do
>=20
> XSLT, 2nd Edition
> Mastering XML Transformations
>=20
> Ron
>=20
>> On 01/07/2014 5:37 AM, Pierre Smits wrote:
>> Hi All,
>>=20
>> Thanks for your contributions. So I found that there is a set of services=

>> related to handling XML in UtilXml.java. It looks like that file contains=

>> (parts of) the solution needed for my requirements.
>>=20
>> Question is: do you know of an example in OFBiz applying some of the
>> functions to process an external XML file?
>>=20
>> Regards,
>>=20
>> Pierre Smits
>>=20
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>=20
>>=20
>> On Sun, Jun 29, 2014 at 10:11 PM, Adrian Crum <
>> adrian.crum@sandglass-software.com> wrote:
>>=20
>>> I agree. Using a transformer seems the way to go.
>>>=20
>>> Adrian Crum
>>> Sandglass Software
>>> www.sandglass-software.com
>>>=20
>>>=20
>>>> On 6/28/2014 6:41 PM, Rajbir Saini wrote:
>>>>=20
>>>> Pierre,
>>>>=20
>>>> I would suggest you to create XML schema for your XML. Schema can do
>>>> some validation beyond well formed document. Write your business rules
>>>> validator for validation which are not handled by schema. Use XSLT to
>>>> transform your document to entity-engine XML. =46rom there on OFBiz can=

>>>> take care of importing the data into database using entity-engine XML.
>>>>=20
>>>> Regards,
>>>>=20
>>>> Raj
>>>>> On Sunday 29 June 2014 02:41 AM, Pierre Smits wrote:
>>>>>=20
>>>>> Taher,
>>>>>=20
>>>>> Any hint towards a direction is help. So, thank you.
>>>>>=20
>>>>> Yes, validating is essential. Thus, having to do custom business logic=
 is
>>>>> expected.
>>>>>=20
>>>>> On average, based on the example XML files I have received the
>>>>> majority of
>>>>> those files are below 100 kB. But, exceptions will always exist.
>>>>>=20
>>>>> Regards,
>>>>>=20
>>>>>=20
>>>>> Pierre Smits
>>>>>=20
>>>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>>> Services & Solutions for Cloud-
>>>>> Based Manufacturing, Professional
>>>>> Services and Retail & Trade
>>>>> http://www.orrtiz.com
>=20
>=20
> --=20
> Ron Wheeler
> President
> Artifact Software Inc
> email: rwheeler@artifact-software.com
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>=20