Stack Overflow
Stack Overflow

Questions tagged [biztalk-mapper]

A component of Microsoft BizTalk Server allowing the creation of maps (XSLT) in a graphical environment

A component of Microsoft BizTalk Server allowing the creation of maps (XSLT) in a graphical environment

197 questions
8
votes
3 answers

XSLT Transforming sequential XML to hierarchical XML

I have a requirement to transform a sequential XML node list into a hierarchical, but I run into some XSLT specific knowledge gap. The input XML contains articles, colors and sizes. In the sample below 'Record1' is an article, 'Record2' represents a…
Jean-Paul Smit
  • 83
  • 4
4
votes
1 answer

XSLT Muenchian grouping from BizTalk WCF-SQL Adapter Schema by ID across groups

I am working on a BizTalk application that performs typed polling from a database using the WCF SQL adapter. After researching how to group data from the generated schema to my canonical schema, I came across Muenchian Grouping as the common…
NspectorHector
  • 143
  • 1
  • 8
3
votes
0 answers

EDI FILE Convert into XML Using Biztalk

I have multiple EDI files and I try to convert those EDI files into XML using BizTalk. Here is my EDI file: ISA*00* *00* *16*SENDER1 *1B*RECEIVER1 …
Hardik
  • 116
  • 1
  • 10
3
votes
1 answer

Avoid duplicates in the destination schema

I have a little problem. I want to map every detail line to one OrderInfo. The destination schema can not have any duplicate OrderInfo. All the detail lines should be in the destination orderInfo, but the SuppliersOrderNo and BuyersOrderNo should…
Sindresvends
  • 180
  • 1
  • 1
  • 10
3
votes
3 answers

Biztalk mapper: how to detect a node that do not come in the xml

I would like to know how to detect that a node is not present in the origin. I have tried hundreds of things with the logical functoids with no success. The third case of this page is what I am looking…
Pablo Castilla
  • 2,723
  • 2
  • 28
  • 33
3
votes
3 answers

Biztalk maps: Grouping different nodes into a list

Is there a way of achieve the following transformation in the BT mapper? if not, any smart…
Pablo Castilla
  • 2,723
  • 2
  • 28
  • 33
3
votes
1 answer

If record exists then map, if not map another - Biztalk mapping

Can someone help me with this? I have a biztalk mapping. In the source scheme there are two address records with address elements. Address record 1 always exists in the source scheme, but if address record 2 exists in the source I would like to map…
b777
  • 69
  • 1
  • 1
  • 4
3
votes
1 answer

How to create a Biztalk Map that transforms hierarchical XML to flat file

I try to transform a hierarchical XML file to a flat file schema using Biztalk 2010. It works fine. Every file is mapped. But the hierarchy is destroyed. My input xml structure looks like this: …
Tonn Ski
  • 47
  • 1
  • 7
2
votes
0 answers

Edi File Header is not convert into XML Using BizTalk

I have create BizTalk project that convert EDI into XML. It will convert all the transaction segment into XML but the Header segment n (eg. ISA) is not convert into XML format. Here is configuration in BizTalk for EDI file. I have not creating any…
Hardik
  • 116
  • 1
  • 10
2
votes
1 answer

BizTalk - create log file for pipeline fault (There was a failure executing the receive pipeline)

Starting with this version, BizTalk can route fault messages, and that's pretty good. Let's say I'm receiving a badly-formatted positional txt file and a receive pipeline can't let the message get into the orchestration. I can see that between the…
Hardik
  • 116
  • 1
  • 10
2
votes
2 answers

Creating a variable number of nodes on target document without corresponding data on source document

I'm trying to map two documents witht the BizTalk Mapper and my target document should look like this: example 9999999 …
Eric
  • 3,143
  • 2
  • 16
  • 16
2
votes
1 answer

How to use XSLT2.0 in BizTalk?

I'm trying to using XSLT 2.0 in BizTalk 2020. But I'm getting this below error. 'current-dateTime()' is an unknown XSLT function. How to get rid of this? Do I need Saxon Engine to use 2.0?
iamramanavenkat
  • 33
  • 4
2
votes
1 answer

BizTalk mapping - Scripting Functoid Object life cycle, when is it initialized and destructed

In a BizTalk map when you call a scripting functiod, is the object (the class you are calling) initialized at the time of the first call and kept in memory for the entire time the transformation is occurring? Or is is destroyed and initialized every…
aceinthehole
  • 5,122
  • 11
  • 38
  • 54
2
votes
1 answer

XSLT muenchian grouping by value in child node

I'm trying to convert an sap iDoc to another xml file with a BizTalk map written in xslt. The problem is I need to group nodes based on a value that we can find in a specific subnode. Muenchian grouping (I use XSLT 1.0) seems to be the solution but…
Gosfly
  • 1,240
  • 1
  • 8
  • 14
2
votes
1 answer

Biztalk schema variable number of columns in delimited file permitted?

Hiyas. I have a customer sending orders to us in a flat file. There isn't really any complexity to the file but there are some inconsistencies from file to file. The format of the file is like this: 1,2,3[CRLF] 1,2,3[CRLF] No problems creating a…
Doug Griffin
  • 43
  • 3
1
2 3
…
13 14