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