[community-content]

I’m trying to debatch a fixed length flat file with the following format

headerheaderheaderheaderheader
fieldfieldfield[b:f9cd062ba1]X[/b:f9cd062ba1]fieldfieldfieldfield
fieldfieldfield[b:f9cd062ba1]Y[/b:f9cd062ba1]fieldfieldfieldfield
fieldfieldfield[b:f9cd062ba1]Z[/b:f9cd062ba1]fieldfieldfieldfield
fieldfieldfield[b:f9cd062ba1]Y[/b:f9cd062ba1]fieldfieldfieldfield
fieldfieldfield[b:f9cd062ba1]X[/b:f9cd062ba1]fieldfieldfieldfield
trailertrailertrailertrailertrailer

The record files are of different formats in a random order, identifiable by a single character at a fixed position in the record.

I want to be able to split the body records into single messages with headers retained.

Using tag Identifiers and one global schema I was able to output xml or the same format as the input file into a single message but not sure how to debatch.

Any ideas? Thanks in advance.

[community-content]

Yes, you need to modify the Url in Biztalk Explorer by adding a suffix

i.e.
‘SQL://vs2/comm/firstreceivelocation’
and
‘SQL://vs2/comm/secondreceivelocation’

[community-content]

Here is one way of selecting the <choice> nodes.

Count = count(/MainSchema/child::*[not(a)])

xpathStr = System.String.Format(/MainSchema/child::*[not(a)][{0}], Counter)

However the tricky bit is ordering the output, you will probably need a map with some custom XLST using the <xsl:sort> feature [url]http://www.biztalkgurus.com/newsletter/TheBizTalker-volume-03.html[/url]

[community-content]

Greetings,

To simplify my point here…

given this article http://codebetter.com/blogs/jeff.lynch/articles/128664.aspx, instead of a [b:45a01d3a98]Record[/b:45a01d3a98] that is [i:45a01d3a98]Unbounded[/i:45a01d3a98], it is the [b:45a01d3a98]<Choice>[/b:45a01d3a98] which is [i:45a01d3a98]unbounded[/i:45a01d3a98].

How can I debatch the Choices?

Thanks again,
Fred

[community-content]

One option is to create a simple pipeline component that reads the BTS.ReceivedFileName strips off the header and promotes just the filename into your own property. You should be able to correlate on your new property

[community-content]

Some answers to your questions

[i:2b9fdc3733]- Is BizTalk automatic setting up a LDAP registery? [/i:2b9fdc3733]
No Biztalk does not have an LDAP registry. It maintains a number of databases, none of which are accessible via LDAP.

[i:2b9fdc3733]- Does BizTalk has any capacity limits?[/i:2b9fdc3733]
Yes. Biztalk is able to scale up significantly using multiple processing servers and multiple database servers. however there will be a point where it will reach capacity. Application design will have a big impact on the capacity limits.

[i:2b9fdc3733]- Is there a maximum of processingload or transfercapacity? [/i:2b9fdc3733]
Again Yes. There will be a point where Biztalk will reach a limit. This maximum load point will be application dependent.
check out the Biztalk Performance Blog @ [url]http://blogs.msdn.com/biztalkperformance/[/url]
And there are some whitepapers on performance and architecture

[i:2b9fdc3733]- Does BizTalk supports XBRL? [/i:2b9fdc3733]
Biztalk does not support any Xml \”language\”. It is able to process Xml messages and can provide Xml Schema validation of a document. This would not be sufficient for Full Conformance validation of XBRL. This functionality could be added by extending Biztalk, if Biztalk was creating or directly consuming XBRL. If Biztalk is just an intermediary between two XBRL processors then these endpoints should be responsible for conformance testing.

[i:2b9fdc3733]- Is it possible to simulate the designed business processes? [/i:2b9fdc3733]
Biztalk currently does not provide Business Process Modelling tools that are capable of process simulation. There are a number of third party tools available. Most of these tools now support BPEL and Biztalk is capable of importing BPEL specifications.

[i:2b9fdc3733]- Is it possible to define business rules and monitor business processes against that business rules? [/i:2b9fdc3733]
Yes. Biztalk includes a Business Activity Monitoring (BAM) module that provides reporting and alerting capabilities

[i:2b9fdc3733]- In which languages is BizTalk available? [/i:2b9fdc3733]
English, Japanese, German, French, Spanish, Italian, Korean, Simplified Chinese, Traditional Chinese

[i:2b9fdc3733]- Is it easy to generate different reports or manual reports?[/i:2b9fdc3733]
Probably depends on what you wish to report on. The BAM module is fairly straight forward, although you need to specify what activities and events are monitored. The Tracking database also provides comprehensive data on events and messages, although generating reports off the tracking database is probably not as easy.

[community-content]

Hi,

I would really like to find some kind of recommendations on when to (and NOT to) use BizTalk. Wich kind of projects, requirements, environments etc.

Have anyone published this kind of information on the net?

[community-content]

I remember having the same problem and we just put the Receive outside the Scope.

The act of Receiving a message in BizTalk is not a persistence point – thus if it fails on the Receive Shape or any shape before a persistence point it will be like the Orchestration never happened in the first place.

Make sense?

[community-content]

Thanks for the response. I am attempting to correlate by ReceivedFileName but it appears that BTS.ReceivedFileName returns the entire file path. Is there a way to change this message context to just the filename w/o the path?

I am not able to use anything in the message for correlation that’s why I am looking into the ReceivedFileName.

Thanks

[community-content]

When our company are going from BizTalk 2002 to 2004 ve must be able to control a number of exicuted orchestrations. In todays environment we are able to do that with an own created Batch Controller that lissten on events from BizTalk and from that control the flows,

We know how we should control the number that have started and thus not yet executed but we need also be able to controll thus that are in \”dehydrated\” mode.
but with BizTalk 2004 togheter with SQL 200 this opertunity is missing?

Could any body say if there are any way to make this happen with BizTalk 2004 & SQL 2000

Best Regards
Peter

[community-content]

Hi, i’m just started to learn BTS 2006, also i don’t have any experience with later version (BTS2004) and i try to find some stuff regarding the BAM.
There are MSDN WebCast on 06/04 concerning the BAM 2206, but maybe someone have some stuff to read (links) how to define activities , views, and so on something like tutorials, step by step or something like that. i don’t know from what to start, i read some articles about BAM bu did see something that explain how to configure and so on … .. .. .. . .. . . . . . . .

[community-content]

thanks,

i figured it out

[community-content]

Sounds like you need a Correlation. Convoys are used in scenarios when you don’t have the Send Shape (to greatly simplify what a convoy is).

You can initialize your correction on the Send based on something inside the message or Received File Name. Then, use a Receive and a file drop in a different location to pick up the message. When someone updates the file, just have them move it to the new location.

Hope this helps.

[community-content]

Hi All

While Working on Parllel Shape in orchestration, I have Counter Variable , I want to increment that counter variable in all Parllel Shapes,Could you people tell me how can i do that one by using this Parllel Shape process.

Thanks in Advance…

Ahmed

[community-content]

Ok, there has been a change. Here’s what I need to implement now.

1. I receive an XML Message such as:

<XML>
<ID>xxxxx</>
<Branch>0000</>
<Destination>Somewhere</>
<Data>………….</Data>
</XML>

2. I extract the <Data> element, assemble it into a flat file(based on a schema), and send it to a drop location.

3. Someone will manually need to modify this file text file and send it back to my orchestration.

4. I then need to send it to the location in <Destination>

Do I need to use a convoy or just correlation? How can I correlate on a filename?

Thanks.

[Author]

Posts