Re: [Servingxml-help] Multiple record types per row in flatfile

[Daniel P. <dan...@sy...>]

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