MSDN Magazine - August 2008 - (Page 60)

Figure 2 Invoice Schema Excerpt Figure 3 Mapping Line Items After the schemas have been defined, you will need to create the BizTalk map. In this case it will be a map that transforms the data from the XML version of Company A’s invoice information into the standard EDI 810 Invoice instance. Mapping EDI documents is not unlike any other type of BizTalk mapping except that there are several complexities that are unique to EDI. In the case of the invoice, a total count of all line items in the IT1 nodes must be displayed in the CTT01 node. Let’s look closer at this to demonstrate what is unique about this type of mapping. Begin by looking at the IT1 repeating node, which represents line items on the invoice. As shown in Figure 3, there are two types of mapping occurring: simple source to destination (as in the case of PRICE to IT104) and complex (as in the case of TYPE, which determines whether a line item in the source is copied to the target). In the case of the complex mapping there is a combination of two scripting functoids and a single equal functoid. The first scripting functoid contains logic that determines whether the value in the TYPE field is something that should be mapped across. If the value is equal to a certain string, then it will be added to the IT1 loop. The logic of interest, though, is in the second functoid, which is connected to the IT101 node. The code in this functoid is actually keeping track of the number of line items that have been mapped across—not the total in the source document, but the total in the target document. This total is used both to populate the value of IT101 and to increment a global variable that can be used eventually to populate the CTT01 node. The code for the IT101 scripting functoid, which declares and increments a global parameter accessible throughout the map, is 60 msdn magazine shown in Figure 4. A global integer is created, and it’s incremented by 1 each time a line item that needs to be mapped is sent across. With each line item that needs to be mapped, this value is incremented, and the resulting value can then be populated in the IT101 node. Once all of the IT1 line items have been mapped, the map can move on to populating the CTT01 node with the total number of line items that occur in the EDI instance. This value is contained in the global integer and can be accessed in a separate scripting functoid specific to the CTT01 node using the code shown here: public int intAccessTotal() { return globalCtr; } Trading Partner Configuration Two trading partners must be set up in BizTalk Server, one as the sender and one as the receiver. Trading partners are created as parties within BizTalk and configured through the BizTalk Server Administration Console. Trading partner configuration consists of a number of settings that enable BizTalk to determine what documents belong to which partner. When EDI documents arrive, BizTalk matches documents to trading partners by comparing what is defined in the document Header (or what is in the Applicability Statement 2, or AS2, envelope) with what has been configured for the trading partner. Figure 4 Functoid to Ignore Certain Line Items // declare global variable, accessible throughout all other components // within current map int globalCtr; // declare function to increment and return the current value of the // global count public int keepCount (bool mapMe) { // the value of mapMe is the boolean returned by the equals // functoid (see map) if(mapMe) globalCtr++; // return the total value to be populated in IT101 return globalCtr; } BizTalk EDI

Table of Contents Feed for the Digital Edition of MSDN Magazine - August 2008

MSDN Magazine - August 2008 Toolbox CLR Inside Out Basic Instincts Cutting Edge Patterns in Practice Data 2.0 - Expose And Consume Data In A Web Services World Biztalk EDI - Build A Robust EDI Solution With BizTalk Server Silverlight - Create Animations With XAML And Expression Blend Write On! - Create Web Apps You Can Draw On With Silverlight 2 Wicked Code - Craft Custom Controls For Silverlight 2 Team System Foundations Windows With C++ Concurrent Affairs Going Places { End Bracket }

MSDN Magazine - August 2008

For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.