How To: Copy all Filenames in a Directory to a Text File

How To: Copy all Filenames

Got to know this last week! This works great if you want to save all the filenames in a directory to a text file.1. Open up your command prompt by typing cmd in the run dialog box and hitting Enter.

2. Navigate to the directory which has the files and type the following command -
DIR /B /O:N > filenames.txt
This will save all the filenames in the current directory to a text file. The text file will be saved in the same directory.
3. To save file names from any sub-directories in the current folder, just add /S like -
DIR /B /O:N /S > filenames.txt

Read more ...

Biz talk Deployment & Build Automation - Biz Talk 2009 TFS 2008

BizTalk Server 2009 comes with support for MSBuild. The question is, how can we use it, and how does it help us? The obvious advantage is of course, that this enables Visual Studio BizTalk projects to be deployed to the production environment without the pain of exporting/importing MSI packages. This is particular troublesome when dealing with large BizTalk implementations, with lots of assemblies, where you need to select and deselect assemblies to be included in the package.

It is possible to automate deployment using BizTalk Server 2006 R*, but not without installing Visual Studio on the production environment. This is because MSBuild can’t build BizTalk 2006 projects, and you need to use DevEnv to do the work. But since BizTalk 2009 projects are C# project, and C# projects is nothing less then MSBuild scripts, BizTalk 2009 projects can be built on environments without the need of Visual Studio.

But there is  a catch… –It can build, but there is no support for deployment :(

To manage Deployment, we need to do some customization.

When you create a new Build Type in Team Explorer and execute the build, the default build will execute a set of Build Tasks such as GetSources, Compile, Execute Tests etc. The result of the build will give you a folder with the output of the Build. That is a folder with a bunch of assemblies. To deploy these assemblies, we need to figure out where they should deployed to. The obvious place to find this information would be in the bindings files.

So to make use of the new MSBuild support, we need to create three custom tasks:

• Undeploy Bindings - Since we are going to redeploy the solution, we need to remove all previous assemblies and artifacts.
• Deploy Assemblies - This Task can optionally be disabled, in case you just want to undeploy. The bindings files will tell us to which BizTalk Application an assembly should get deployed to. if your build results in assemblies that should not get deployed to BizTalk, then these won’t get deployed since they are not included in the bindings files.
• Import Bindings - This is the last custom task to be executed, and will create all the port bindings. Similar to the Deploy Assembly task, this one is optional is case you just want to undeploy.

Next we need to include these tasks in our build. We do this by adding a single row to our already created Build Type:

<Project DefaultTargets="DesktopBuild" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="3.5">

  <Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\TeamBuild\Microsoft.TeamFoundation.Build.targets" />
  <Import Project="$(SolutionRoot)/TeamBuildTypes/Blogical.BizTalk.CustomTasks.targets"/>
  <ProjectExtensions>

The Blogical.BizTalk.CustomTasks.targets file includes all necessary targets, and will execute the Undeploy-, Deploy- and Import Bindings tasks after the Compilation Task has been successfully executed.

That’s it!

There are some architectural constraints and considerations you need to be aware of:

Isolated Solutions

The Visual Studio solution is central in this process, and it’s important that projects within this solution should not be part of, or referenced from within any other solution that is going to be used in any Build Type. The reason for this is that the solution might not be possible to undeploy if it’s referenced by any other assemblies.

Bindingsfile location

In order for the Custom Tasks to find the Bindings files, the Bindings files need to be checked in to a folder named Bindings which needs to be located in the same folder as the Visual Studio solution file. Also the Bindings files need to be named [Some Name].[Target Environment].xml. Where the Target Environment could be something like TEST, STAGE, PRODUCTION etc. Eg Navision.OrderConfirmation.STAGE.xml

Shared Components

Global artifacts, such as generic schemas and pipelines, needs to be handled separately from this Build Process, as these are referenced by any number of assemblies, ports and filters.

BizTalk Applications

This Build Process does not create BizTalk Applications. Nor does it manage its references. Therefore you need to create them manually before deploying. As Applications are normally not created on a daily basis, this should not be a big issue.

Utilizing undocumented BizTalk assemblies

The Custom Tasks does not use BtsTask.exe, as it’s difficult to handle exceptions using for example Process.Start. Instead it uses Microsoft.BizTalk.ApplicationDeployment.Engine (also used by BTSTask, ExplorerOM and Visual Studio). This is working very well, but this is not a documented library. I would really like to see Microsoft ship BizTalk with a better supported Deployment API similar to ExplorerOM.

Installation

The Zip file includes the Custom Tasks library and the CustomTask.target file.

1. Save the Blogical.Shared.Tools.BizTalkBuildTasks.dll file to preferred directory on each server running the Build Agent. You can use a network share.
2. Edit the Blogical.BizTalk.CustomTasks.targets file (line 44). Set the <Blogical_CustomTasks> to the directory where you saved the Blogical.Shared.Tools.BizTalkBuildTasks.dll.
3. Check in the Blogical.BizTalk.CustomTasks.targets file to the TeamBuildTypes folder in you TFS project.

Downloads

Read more ...

Mapping Inbound XML Data in to Single Element / Node in BizTalk Mapper

post by : A Technical Perspective

Requirement:

We need to call an SQL Server stored procedure based on parameters specified in an incoming XML message. In fact, the XML document contained a set of unbounded records that each needed to be associated with a call to a stored procedure.I could have used the debatching capabilities of the XML Disassembler pipeline component and implemented an orchestration implementing a scatter-gather like pattern, but since this solution was part of an ESB Toolkit 2.0 itinerary, I wanted to keep it as simple as possible.
Microsoft SQL Server offers native capabilities to process XML data. For instance, it is possible to supply an appropriately formatted XML document directly to a stored procedure for processing, thanks the OPENXML and other various T-SQL constructs.
That’s why I opted to bypass any pre-processing on the supplied XML document and hand it over directly to the stored procedure. This stored procedure would, in turn, iterate over the different records and process them accordingly.

In order to do that, the contents of the XML document must be specified in a single argument to the stored procedure, like so.

Serializing the entire contents of an XML document with the BizTalk Mapper

In my solution, the stored procedure is invoked through the WCF-SQL adapter. Therefore, a special document that conforms to an adapter-specific generated schema must be sent to the corresponding solicit-response send port.

In order to map the entire contents of an XML subtree structure from the source schema to a single element in the target schema, one can use the Call Template functoid in a BizTalk map.

How does it Work?

In the Call Template functoid, notice the use of two different templates.

The first one, is the entry-point for the Call Template functoid when running the map. It declares a single parameter that corresponds to the node on the source document under which the entire structure must be serialized to the target node.

<!--Uncomment the following xslt for a sample Xslt Call Template
that creates a Field element whose value is the concatenatation of the
two inputs. Change the number of parameters of this template to be 
equal to the number of inputs connected to this functoid.-->

<xsl:template name="called-template">
  <xsl:param name="param1" />
  <xsl:element name="xmlDocument" namespace="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo">
    <xsl:text disable-output-escaping="yes">&lt;![CDATA[</xsl:text>
    <xsl:call-template name="identity" />
    <xsl:text disable-output-escaping="yes">]]&gt;</xsl:text>
  </xsl:element>
</xsl:template>

First, the template produces an XML element, based upon its name and namespace as required in the target schema. In this case, the element corresponds to the name of the argument to the stored procedure as generated by the WCF-SQL adapter.

Notice that the serialized data is wrapped around a <!CDATA[]]> tag, so as to eliminate the need to escape XML-reserved characters.

The serialized data itself is produced by calling the second template. This one is none other than the identity template.

<xsl:template name="identity" match="@*|node()">
  <xsl:copy>
    <xsl:apply-templates select="@*|node()" />
  </xsl:copy>
</xsl:template>

This template iterates over all elements, texts, comments and processing instructions and recursively copies the contents to produce its output.

Read more ...

Advanced Users Biztalk WIKI : Useful How to Links Part - 3

Useful How to Links Part - 3

BizTalk Administrator's Checklist Compiled by Microsoft BizTalk Support

http://social.technet.microsoft.com/wiki/contents/articles/629.aspx?CommentPosted=true#commentmessage

Muenchian Grouping and Sorting in BizTalk Maps

http://blogs.msdn.com/b/chrisromp/archive/2008/07/31/muenchian-grouping-and-sorting-in-biztalk-maps.aspx

http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

Xslt Template StyleSheet For Biztalk Mapping : Query in Biztalk Map

http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/ecc69e42-f126-40b5-83c0-aefcfdf53a85

AppFabric-enabled WCF Data Service Walkthrough (C#)

http://blogs.msdn.com/b/rjacobs/archive/2010/06/30/appfabric-wcf-data-service-cs.aspx

Querying DataSets – Introduction to LINQ to DataSet

http://blogs.msdn.com/b/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx

Accessing BRE RuleEngine Using .Net Framework

http://arnulfowing.blogspot.com/2007/09/how-to-access-bre-vocabularies-from-net.html

Few links that may help:

http://msdn.microsoft.com/en-us/library/aa995566.aspx                                                                

(MSDN: Walkthrough: Executing the Policy Programmatically)

http://technet.microsoft.com/en-us/library/microsoft.ruleengine.sqlrulestore_members.aspx (SQLRuleStore)

http://arnulfowing.blogspot.com/2008_07_01_archive.html

http://biztalkwithshashikant.blogspot.com/2007/08/implementing-business-rule-engine.html

http://msdn.microsoft.com/en-us/library/aa951249.aspx

iFactRetriever: http://msdn.microsoft.com/en-us/library/aa560118.aspx

http://talentedmonkeys.wordpress.com/2011/01/17/improved-method-for-calling-the-bre-from-net-applications/

http://talentedmonkeys.wordpress.com/2010/08/23/calling-the-bre-from-net-applications/

Read more ...

Advanced Users Biztalk WIKI : Useful How to Links Part - 5

 Useful How to Links Part - 5

Bre Static Support Key

http://blogs.msdn.com/b/asgisv/archive/2010/04/29/troubleshooting-bre-policies-failing-to-return-results.aspx 

http://blogs.msdn.com/b/richardbpi/archive/2005/11/14/492489.aspx

http://technet.microsoft.com/en-us/library/aa950269(BTS.10).aspx

Calling Data Access from Ado.Net

http://support.microsoft.com/kb/310070

http://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET

http://msdn.microsoft.com/en-us/library/59x02y99.aspx

Sso Configuration Storing Values

http://biztalk-dev.blogspot.com/2008/03/using-sso-database-for-storing.html

Xml Document XPath Sample

http://www.codeproject.com/Articles/9494/Manipulate-XML-data-with-XPath-and-XmlDocument-C

http://support.microsoft.com/kb/318545

ESB Dynamic Routing using Itineraries

http://abhijitmahato.wordpress.com/2010/09/10/biztalk-esb-toolkit-2-0-samples-content-based-routing/

http://tenalinaga.wordpress.com/2010/11/12/esb-dynamic-resoultion-with-bre-and-uddi-and-itineraries/

http://www.go4answers.com/Example/dynamic-itinerary-orchestration-48755.aspx

http://talentedmonkeys.wordpress.com/2010/04/24/resolving-a-dynamic-send-port-in-a-biztalk-orchestration-using-esb-toolkit-2-0/

http://blogdoc.biztalk247.com/article.aspx?page=7f047745-aa05-4090-bab1-d8742ab23a58

http://allcomputers.us/windows_server/biztalk-2010-recipes---administration-and-operations---debugging-orchestrations.aspx

http://blogs.msdn.com/b/appfabriccat/archive/2010/06/23/4-different-ways-to-process-an-xlangmessage-within-an-helper-component-invoked-by-an-orchestration.aspx

Read more ...