Beginners query on mapping / transforms

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Beginners query on mapping / transforms

Viewing 1 reply thread
  • Author
    Posts
    • #20255

      Hi there

      Absolute beginner with BizTalk (… I know it shows …)

      I’ve got an XML message which I think I need to use a map for transforming, but I’m really confused over
      what needs to go in the map …

      – I’ve been looking at the Looping, Table Looping functoids but not getting it
      …

      Basic problem is I have XML like so

      …

      <DocTypes>

          <Primary>

         
      <Secondary>

         
      <Alternative>

      <\DocTypes>

      <AccountRef>

      ….

      And I’m trying to get three records so I can output a flat file

      …

      <Primary> <AccountRef>
      <other fields>

      <Secondary> <AccountRef>

      <other fields>

      <Auxilary> <AccountRef>
      <other fields>

      There isn’t an XML schema for the source data …

      – the extract I attempted to type comes from an office system that simply
      “fills in the blanks”, i.e. it adds element values to corresponding elements
      in a provided XML “template”

      – the values come from a form, and there is a config file which sets which
      element name gets which value

      – I left out the rest of the XML as it’s more of the same … field / value
      pairs, some nested

      – everything is pure string, no validation, no XSD, nada …

      Conversely the other system has to have a CSV data file with one line per
      document type

      Any help/guidance much appreciated

       

    • #20257

      Got there in the end …

      Found this about the Table Loop functoid …
      http://geekswithblogs.net/evankoch/archive/2007/08/07/114470.aspx
      which had a link to a downloadable working example 

      —
      Cheers,
      Steve C.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.