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
Questions tagged [biztalk-mapper]
197 questions
1
vote
1 answer
BizTalk - mapping a source that has a Parent-Child relationship a flat destination
I have seen this question about a parent child relationship, but it is not exactly the same since I have nothing to tag with.
I have a source flat file that look like this
Location Route Prod Company Date Amount
XXX RT00008…
aceinthehole
- 5,122
- 11
- 38
- 54
1
vote
1 answer
BizTalk Mapping: How to show a parent record once only if there are 1 or more child records. Otherwise, do not show parent record
I would like to show a parent record only if one or more child records have values. Otherwise, I do not want the parent record to show up in the output at all.
If this is the input
armysgt97
- 13
- 5
1
vote
1 answer
How to map list of attributes to column-based schema with condition in BizTalk?
I have two schema one is for input xml file and second is for database table.
Please look below for source data of above schema:
- 83
- 1
- 7
Vijay Mandanka
1
vote
2 answers
Is it possible to insert 50 000 record in single statement in BIzTalk Server?
I have 1 flat file it will contains more than 100k rows. I need to entry in table (Dynamic table based on data). so it is possible to insert data in batch wise in BizTalk?
Here is my Biztalk Mapping.
Biztalk project Configuration.(Batch size in 100…
Hardik
- 116
- 1
- 10
1
vote
0 answers
BizTalk XSLT Map - Execution of scripts was prohibited
I'm programming with BizTalk Server 2020 (Visual Studio 2019).
I have this xsl code (simplified), that is in an external xsl file of a btm map:
lorenzo
- 11
- 4
1
vote
1 answer
Deploy BizTalk 2010 Map (btm) to BizTalk 2006 R2 server?
I know it is not a normal practice for someone to deploy 2010 map to 2006 server but I have no choice. The questions I have is "Can I deploy a 2010 map to 2006 R2 server"? It seemed to me that since they are both btm files, the only difference…
rizalp1
- 6,346
- 2
- 17
- 19
1
vote
0 answers
Set default value for a segment
I have for example 3 lines for DTM (EDIFACT schema) segment:
DTM+2:20200619:102'
DTM+137:20200617:102'
DTM+11:20200619:102
If the first value is not 361 I have to set a default value but in the output should to appear one time not three times (for…
Anca Muresan
- 31
- 3
1
vote
2 answers
Inline XSLT 1.0 Count on Repeating Record BizTalk Map
I have a problem in writing a Inline XSLT 1.0 in my BizTalk Project , I am trying to get the count for a field Status if its equal to INactive , below is the Input xml , Expected xml and XSLT what i tried
Input XML :
sukra
- 123
- 1
- 10
1
vote
1 answer
Mapping multiple source structures to a single looping destination structure in BizTalk
I am trying to map parts of the following source structure that has two sets of properties - one flat and one looped:
Source Document
foo
bar
...
…
Jens Ehrich
- 573
- 1
- 6
- 19
1
vote
1 answer
Concatenating values from the repeating nodes under repeating nodes in BizTalk Maps
I have something like this in an input XML
- item1
- item2
- item3
- item4
- item5
From this input,…
Gaurav Rawat
- 15
- 2
1
vote
1 answer
How to generate XSLT from BTM within pipeline?
We have some BizTalk-style maps - BTM files. In order to generate XSLT from a BTM, we can simply do this in visual studio:
How do we perform this same functionality within the Azure DevOps release pipeline?
Alex Gordon
- 57,446
- 287
- 670
- 1,062
1
vote
1 answer
How to fix 'The string was not recognized as a valid DateTime.' error in BizTalk Test map?
I'm working on a BizTalk orchestrations with a map which contains an XSLT script. When I launch the orchestration I got this error
Error encountered while executing the transform. Error: Unable to create the transform.
So I go back to the map …
Davon
- 121
- 2
- 9
1
vote
1 answer
How to map from same source node to different destination elements based on qualifiers using BizTalk functoids
I need to map:
when C51601 =64 map C51602 to FreightCost
when C51601 = 9 map C51602 to InvoiceTotalAmount.
But only FreightCost or InvoiceTotalAmount is getting mapped. I want both
FreightCost and InvoiceTotalAmount to to be displayed in the…
Manu
- 13
- 3
1
vote
2 answers
Best way to store key value pairs in BizTalk
We have requirements where we need to store Key-Value pair type data for quick retrieval in BizTalk Map.
Is there any best practice by which we can store it. The data stored should be easy to maintain and should have a cache mechanism for easy…
Saroj Kumar
- 21
- 2
1
vote
1 answer
Using a CSV to XML map in a two-way send port that polls data from a public REST API
My situation is like this:
I need to get CSV data from a REST API using the Wcf-WebHttp adapter, map this data to XML using a map I have deployed (along with the CSV and XML schema) and store it in an SQL Server database.
For now I have created a…
Leth
- 1,033
- 3
- 15
- 40