BizTalk Mapper Extensions UtilityPack v1.5 – New version available with 7 new functoids

Posted: April 22, 2013 in BizTalk
Tags: , ,

Exciting news… I just release a new version of “BizTalk Mapper Extensions UtilityPack” project (available on CodePlex and Code Gallery) with 7 new functoids for BizTalk Server 2010 (I will soon publish for older and new versions).

BizTalk-Mapper-Extensions-UtilityPack-2010-v1.5

Project Description

BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities. This is the list of previous functoids available:

  • Conversion Functoids
    • Convert from human readable to epoch date Functoid: This functoid allows you to convert a traditional date (Human Readable Date) into a unix date (Epoch Date).
    • Convert from epoch to human readable date Functoid: This functoid allows you to convert a unix date (Epoch Date) into a traditional date (Human Readable Date).
    • Convert datetime format Functoid: This functoid allows you to convert datetime format.
  • Dynamic Generators Functoids
    • Password Generator Functoid: Use this functoid to build a random password.
    • Guid Generator Functoid: This functoid allows you to generate a new Guid.
    • Tiny Id Generator Functoid: This functoid allows you to generate a new Tiny Id.
  • Encoder Functoids
    • Base64 Decoder Functoid: This functoid allows you to decode Base64-encoded text strings.
    • Base64 Encoder Functoid: This functoid allows you to convert string object into base64 encoded string.
  • Configuration Functoids
    • BTSNTSvc Config Get Functoid: This functoid allows you to get configuration parameters from BTSNTsvc.exe.config. If there is no section specified, the functoid reads from the AppSettings
    • System Environment Variable Get Functoid: This functoid allows you to get configuration parameters from machine System Environment Variable.
    • Custom Config Get Functoid: This functoid allows you to get configuration parameters from a custom configuration file.
    • Windows Registry Config Get Functoid: This functoid allows you to get configuration parameters from Windows Registry.
    • SSO Config Get Functoid: This functoid allows you to get configuration parameters from SSO Database.
  • CRM Functoids
    • CRM Lookup Functoid: This functoid allows you to retreive a value from CRM lookup field.
What’s new in this version?

Although BizTalk Server provides many functoids to support a range of diverse operations when working with strings, we are limited to the number of existing operations. This new version will provide a new library that enables to perform 7 new methods for safely creating, manipulating, and comparing strings that you can use this inside BizTalk mapper.

String Constant functoid

This functoid allows you to set constant values (strings) inside de maps.

Parameters

The functoid takes one mandatory input parameters:

  1. String value to be return out

The output of the functoid is the sring set in the outuput, Example: “P0011”

String-Constant-functoid

String ToTitleCase Functoid

This functoid allows you to Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms)

Parameters

The functoid takes one mandatory input parameters:

  1. The string to convert to title case

The output of the functoid is a string converted to title case., Example: “Sandro Augusto Sousa Pereira”

String-ToTitleCase-functoid

String Advance Compare Functoid

This functoid allows you to compare two specified String objects, ignoring or honoring their case, and returns an boolean that indicates if they are equal or not.

Parameters

The functoid takes three mandatory input parameters:

  1. The first string to compare
  2. The second string to compare
  3. True to ignore case during the comparison; otherwise, False.

The output of the functoid is an boolean that indicates if they are equal or not, Example: True

String-Advance-Compare-Functoid

String Replace Functoid

This functoid returns a new string in which all occurrences of a specified string (second parameter) found in the first string are replaced with another specified string (third parameter).

Parameters

The functoid takes three mandatory input parameters:

  1. String where we will replace the values
  2. The string to be replaced.
  3. The string to replace all occurrences of oldValue.

The output of the functoid is a string that is equivalent to the current string except that all instances of oldValue are replaced with newValue. If oldValue is not found in the current instance, the method returns the current instance unchanged, Example: “Sandro Pereira: BizTalk”

String-Replace-Functoid

String Normalize Functoid

This functoid allows you to normalize the text. It will remove two or more consecutive spaces and replace them with a single space, remove two or more consecutive newlines and replace them with a single newline and “condense” multiple tabs into one.

Parameters

The functoid takes one mandatory input parameters:

  1. The string to normalize

The output of the functoid is a string normalize without consecutive spaces, lines or tabs, Example: “Sandro Augusto Sousa Pereira”

String-Normalize-Functoid

String PadLeft Functoid

This functoid allows you to set a new string that right-aligns the characters in this instance by padding them on the left with a specified Unicode character, for a specified total length.

Parameters

The functoid takes three mandatory input parameters:

  1. String that will be pad on the left with a specified Unicode character
  2. The number of characters in the resulting string, equal to the number of original characters plus any additional padding characters.
  3. A Unicode padding character.

The output of the functoid is a new string that is equivalent to this instance, but right-aligned and padded on the left with as many paddingChar characters as needed to create a length of totalWidth. However, if totalWidth is less than the length of this instance, the method returns a reference to the existing instance. If totalWidth is equal to the length of this instance, the method returns a new string that is identical to this instance, Example: “*****BTS”

String-PadLeft-Functoid

String PadRight Functoid

This functoid allows you to set a new string that left-aligns the characters in this string by padding them on the right with a specified Unicode character, for a specified total length.

Parameters

The functoid takes three mandatory input parameters:

  1. String that will be pad on the left with a specified Unicode character
  2. The number of characters in the resulting string, equal to the number of original characters plus any additional padding characters.
  3. A Unicode padding character.

The output of the functoid is a new string that is equivalent to this instance, but left-aligned and padded on the right with as many paddingChar characters as needed to create a length of totalWidth. However, if totalWidth is less than the length of this instance, the method returns a reference to the existing instance. If totalWidth is equal to the length of this instance, the method returns a new string that is identical to this instance, Example: “BTS*****”

String-PadRight-Functoid
You can found and download Source Code, Application Binaries and Documentation in CodePlex BizTalk Mapper Extensions UtilityPack home page:

BizTalk Mapper Extensions UtilityPack
CodePlex

or from MSDN Code Gallery:

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2010 (522.1 KB)
Microsoft | MSDN Code Gallery

Comments
  1. Anonymous says:

    Hi.Currently i am running biztalk 2010 what if i upgrade to biztalk 2013 in the future.Will the maps which i develop using these functoids will be good?

    • I need to test this scenario but I don’t see any problem for not working,
      Also I soon will make the upgrade to this project to BizTalk Server 2013 and Visual Studio 2012 however they should work fine.

  2. […] BizTalk Mapper Extensions UtilityPack v1.5 – New version available with 7 new functoids […]

  3. […] BizTalk Mapper Extensions UtilityPack v1.5 – New version available with 7 new functoids – Great utility Pack that will save us a lot of time, and it's free! […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s