EDN Admin
Well-known member
Good Evening,
So essentially what Im attempting to do is to use BizTalk to map between a csv file to an XML file, the problem is the csv file schema can change depending on the document so I cannot seem to just use a pipeline like everyone suggests (you need to specify
the schema, but the schemas are dynamic so it will not let me do that).
My first attempt was to use the dynamic mapping in BizTalk, as thats what were using to do the XML to XML files, but the problem is you seem to need to pass it an XML document or I get a random error about a child having errors. Ive tried wrapping
the CSV in a message as well with no luck.
I attempted to use a pipeline, but short of writing my own pipeline component that will go and figure out the incomming schema, and map to it to create an XML Im not sure how exactly to do this.
Any assistance would be greatly appreciated,
Thank you,
Tony.
View the full article
So essentially what Im attempting to do is to use BizTalk to map between a csv file to an XML file, the problem is the csv file schema can change depending on the document so I cannot seem to just use a pipeline like everyone suggests (you need to specify
the schema, but the schemas are dynamic so it will not let me do that).
My first attempt was to use the dynamic mapping in BizTalk, as thats what were using to do the XML to XML files, but the problem is you seem to need to pass it an XML document or I get a random error about a child having errors. Ive tried wrapping
the CSV in a message as well with no luck.
I attempted to use a pipeline, but short of writing my own pipeline component that will go and figure out the incomming schema, and map to it to create an XML Im not sure how exactly to do this.
Any assistance would be greatly appreciated,
Thank you,
Tony.
View the full article