Thread: [Servingxml-help] Multiple record types per row in flatfile
Brought to you by:
danielaparker
|
From: Keysers W. <Won...@re...> - 2005-10-21 07:26:53
|
Hi,
=20
I need to parse and transform a flatfile (fixed length) file into XML.
The flatfile contains multiple kinds of records on one single row and =
they all go into separate sections in the XML.
=20
Here is a small example of a person with address data on the same line. =
An important side effect is that a person may have multiple lines in the =
flatfile indicating multiple addresses. (e.g. professional / private / =
...)
=20
FlatFile (Positional):
PersonId PersonName PersonFirstName Street Postcode CityTown
=20
Resulting XML file should look like:
<Example>
<Persons>
<Person>
<PersonId/>
<Name/>
<FirstName/>
</Person>
</Persons>
=20
<PersonAddresses>
<PersonAddress>
<PersonId/>
<Addresses>
<Addres>
<Street/>
<PostCode/>
<CityTown/>
<Addres>
</Addresses>
</PersonAddress>
</PersonAddresses> =20
</Example>
=20
The problem could be solved when multiple recordContent elements could =
be specified for a row, but after reading the online documentation, I =
don't think this is currently possible?
=20
What solution do you propose?
=20
Thanks in advance!
=20
/Wonne=20
|
|
From: Daniel P. <dan...@sy...> - 2005-10-22 03:17:02
|
Hello Keysers,
As it happens, the next version, due shortly, will support repeating =
groups of record segments on one row, which should answer your needs. =
I'll include your example below in the Examples. Would you be able to =
provide a sample flat file with some representative groups of addresses? =
=20
Thanks,
Daniel Parker
----- Original Message -----=20
From: Keysers Wonne=20
To: ser...@li...=20
Sent: Friday, October 21, 2005 3:26 AM
Subject: [Servingxml-help] Multiple record types per row in flatfile
Hi,
I need to parse and transform a flatfile (fixed length) file into XML.
The flatfile contains multiple kinds of records on one single row and =
they all go into separate sections in the XML.
Here is a small example of a person with address data on the same =
line. An important side effect is that a person may have multiple lines =
in the flatfile indicating multiple addresses. (e.g. professional / =
private / ...)
FlatFile (Positional):
PersonId PersonName PersonFirstName Street Postcode CityTown
Resulting XML file should look like:
<Example>
<Persons>
<Person>
<PersonId/>
<Name/>
<FirstName/>
</Person>
</Persons>
<PersonAddresses>
<PersonAddress>
<PersonId/>
<Addresses>
<Addres>
<Street/>
<PostCode/>
<CityTown/>
<Addres>
</Addresses>
</PersonAddress>
</PersonAddresses> =20
</Example>
The problem could be solved when multiple recordContent elements could =
be specified for a row, but after reading the online documentation, I =
don't think this is currently possible?
What solution do you propose?
Thanks in advance!
/Wonne |
|
From: Daniel P. <dan...@sy...> - 2005-11-01 03:54:59
|
Serving XML version 0.3.0 has been released, which supports this =
feature. See the example "persons" in the on-line examples. If there =
are any issues, please report them, and they will be addressed. =20
Note that the 0.3.0 release introduces some changes to namespaces, Java =
package names, and markup. If you are upgrading from a previous =
version, check the release notes carefully.
Regards,
Daniel Parker
----- Original Message -----=20
From: Keysers Wonne=20
To: ser...@li...=20
Sent: Friday, October 21, 2005 2:26 AM
Subject: [Servingxml-help] Multiple record types per row in flatfile
Hi,
I need to parse and transform a flatfile (fixed length) file into XML.
The flatfile contains multiple kinds of records on one single row and =
they all go into separate sections in the XML.
Here is a small example of a person with address data on the same =
line. An important side effect is that a person may have multiple lines =
in the flatfile indicating multiple addresses. (e.g. professional / =
private / ...)
FlatFile (Positional):
PersonId PersonName PersonFirstName Street Postcode CityTown
Resulting XML file should look like:
<Example>
<Persons>
<Person>
<PersonId/>
<Name/>
<FirstName/>
</Person>
</Persons>
<PersonAddresses>
<PersonAddress>
<PersonId/>
<Addresses>
<Addres>
<Street/>
<PostCode/>
<CityTown/>
<Addres>
</Addresses>
</PersonAddress>
</PersonAddresses> =20
</Example>
The problem could be solved when multiple recordContent elements could =
be specified for a row, but after reading the online documentation, I =
don't think this is currently possible?
What solution do you propose?
Thanks in advance!
/Wonne |