A recent article I published in MSDN that covers the basics of working with Health Care Claims (837) in BizTalk Server:

http://msdn.microsoft.com/en-us/magazine/gg650658.aspx

Go to Amazon to check out my new book- BizTalk 2010 Recipes

Check out my latest book, BizTalk 2010 Recipes

Product Description

About the Author

Mark Beckner is a Technical Consultant specializing in business development and enterprise application integration. He runs his own consulting firm, Inotek Consulting Group, LLC, delivering innovated solutions to large corporations and small businesses.

His projects have included engagements with numerous clients throughout the U.S., and range in nature from mobile application development to complete integration solutions. He has co-authored BizTalk 2006: A Problem-Solution Approach (Apress, 2006), has spoken at a number of venues including Microsoft’s BizTalk 2004 in a Service Oriented World conference, and is certified in Microsoft Technologies, including MCSD.NET.

Mr. Beckner resides with his wife, Sara, in western Colorado with their dog Rosco, the Adventure Mutt. He can be contacted at mbeckner@inotekgroup.com for any questions regarding the concepts in this book, for advice on integration projects, BizTalk 2006 implementations, or other consulting endeavors.

BizTalk 2010 Recipes offers sound solutions to common problems, presented in a step-by-step format with clear code examples and explanations. Learn the new features of BizTalk Server 2010, and how to provide rich mapping support, extended EDI, and trading partner management capabilities.

When connecting to a SQL Server using Windows Authentication, there is no way to type in an alternate domain/username through the user interface.  It will default to the user that you are currently logged into the computer as.

To connect using an alternate windows domain name, run the following command line script (alter the path to SSMS.EXE based on your computer’s configuration).

runas /netonly /user:[DOMAIN]\[USERNAME] “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

This will open the tool.  You can connect to any SQL Server that the user has access to – however, the domain\username that you typed in will not actually appear in the SQL Credential window.  Don’t be confused – this will work, even though it doesn’t appear to.

To get a related entity to display in a CRM 4.0 IFRAME, use the following code:

function GetFrameSource(tabSet)
{
    if (crmForm.ObjectId != null)
    {
        var oId = crmForm.ObjectId;
        var oType = crmForm.ObjectTypeCode;
        var security = crmFormSubmit.crmFormSubmitSecurity.value;
        return “areas.aspx?oId=” + oId + “&oType=” + oType + “&security=” + security + “&tabSet=” + tabSet;
    }
    else
    {
        return “about:blank”;
    }
}

crmForm.all.IFRAME_RelatedActivities.src = GetFrameSource(“Opportunity_ActivityPointers”);
crmForm.all.IFRAME_RelatedOpenQuotes.src = GetFrameSource(“opportunity_quotes”);
crmForm.all.IFRAME_RelatedOrders.src = GetFrameSource(“opportunity_sales_orders”);

To remove certain buttons from the toolbar on the related entity (within the IFRAME), use the following:

var iFrame = crmForm.all.IFRAME_RelatedOpenQuotes;
iFrame.attachEvent( “onreadystatechange” , iFrameReady);

function iFrameReady()
{
  if(iFrame.readyState == “complete”)
  {
   //Get all of the List Elements
   var lis = crmForm.all.IFRAME_RelatedOpenQuotes.contentWindow.document.getElementsByTagName(‘li’);

   var i = 0;
   //Loop through the list items
   while (i < lis.length) {

    if (lis[i].getAttribute(‘title’) == ‘Add a new Quote to this record’ || lis[i].getAttribute(‘title’) == ‘Add existing Quote to this record’)
    {
     //hide the button
     lis[i].style.display = ‘none’;
    }
    i = i + 1;
   }
  }
}

You can get the titles of the fields using an alert on the innerHTML of the document.body, or by popping it up in the loop.

If you don’t want to loop, and you know the ids of the buttons (which can be accessed using:

crmForm.all.IFRAME_RelatedOpenQuotes.contentWindow.document

.body.innerHTML

Then you can use the following simplified code:

var iFrame = crmForm.all.IFRAME_RelatedOpenQuotes;
iFrame.attachEvent( “onreadystatechange” , iFrameReady);

function iFrameReady()
{
  if(iFrame.readyState != “complete”)
  {return;}

crmForm.all.IFRAME_RelatedOpenQuotes.contentWindow.document.getElementById(“_MBtoplocAssocOneToMany1084opportunityquotes”).style.display = ‘none’;

crmForm.all.IFRAME_RelatedOpenQuotes.contentWindow.document.getElementById(“_MBlocAddRelatedToNonForm10843GUID”).style.display = ‘none’;
}

This conversation was filmed during TechEd 2009 and includes Anush Kumar of S3Edge (s3edge.com).  We talk through the application of BizTalk RFID to enable business real time visibility into their RFID infrastructures.

The following video was delivered as a Breakout Session during TechEd 2009 (SOA301).  It is geared toward those who are looking at implementing a BizTalk solution and want to understand what is involved in the management and preparation of the solution.

There is an extremely good book on BizTalk mapping that has been recently released. Great value to any developer. Includes excellent EDI samples.

Pro Mapping in BizTalk Server 2009

http://www.amazon.com/Mapping-BizTalk-Server-Experts-Voice/dp/1430218576/ref=sr_1_4?ie=UTF8&s=books&qid=1239909911&sr=8-4

Pro RFID in BizTalk Server 2009 covers the end-to-end BizTalk RFID experience—learning, developing, deploying, and managing. Through real-world examples, readers of all experience level will gain insight into the vital steps to building solutions with BizTalk RFID.

Pro EDI in BizTalk Server 2006 R2 takes a unique approach to understanding BizTalk 2006 R2-based EDI functionality: by walking readers through an EDI project from inception to deployment.