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

Posted: April 22, 2013  |  Categories: BizTalk Maps

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 a 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 the 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 retrieve 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 returned out

The output of the functoid is the string set in the output, 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 a 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 a 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. A string that will be a 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. A string that will be a 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:

Download

You can download Source Code and Application Binaries here:
BizTalk Mapper Extensions UtilityPack GitHub RepositoryBizTalk Mapper Extensions UtilityPack
GitHub

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

4 thoughts on “BizTalk Mapper Extensions UtilityPack v1.5 – New version available with 7 new functoids”

  1. 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?

    1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Back to Top