A Small trick: How to extract a BizTalk BAM definition from an Excel sheet without installing Excel client

This is a small trick that I have been doing for sometime now and wanted to share. The scenario is that you have prepared the BizTalk BAM definition and you ready to deploy it to the production environment, you run the bm.exe command and you see the situation; the BAM definition file is an Excel sheet and since you do not have Excel installed on the production server the installation has failed. Sad smile

The options you have are either to your back to your development environment and export the XML from the Excel sheet or to install Excel on the production environment (not really an option).

The trick is actually to open the Excel sheet in notepad as a normal text file and you would see something like this:

image

WOW wait a minute this XML seems familiar, right?

Well you are correct this is the XML definition for the BAM view and activity. So simply copy this text and paste it in a new XML document and there you have it the XML definition of your BAM activity Smile

Happy BizTalking Winking smile

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.