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 |