Share via


Config. Package - Process Batch Job

Specifies and applies text transformations that you want to apply to customer data after you import it into Microsoft Dynamics NAV. For example, you can modify the batch job to support transforming specified text into uppercase.

When you import data from an external source, you may need to adjust it slightly to follow the rules and conventions applied to the data which is already in the application. You can write custom processing rules that will be run by the report. You can create simple text replacements as well as more complex regular expressions.

The following standard rules are provided.

  • Uppercase: All text is placed in uppercase letters.

  • Lowercase: All text is placed in lowercase letters.

  • TextToTitleCase: Capitalizes the first letter in a string, depending on the language ID that is provided. The method does not guarantee that it will be capitalized correctly in accordance with grammar rules. For more information, see TextInfo.ToTitleCase Method.

  • Trim: Removes space characters from the beginning and end of a string.

  • StringReplace: Replaces the text. The replacement is case sensitive.

  • RegularExpression: Replaces the text based on a regular expression provided. This advanced replace method is case insensitive. For more information, see Regular Expression Language - Quick Reference.

  • RemoveNonAplhaNumericCharacters: Removes all characters that are not alphanumeric. The method respects Unicode characters. This is useful for bank account numbers, phone numbers, and other types of ID.

  • DateTimeFormatting: Converts data and time to a different format. It is able to handle text such as 14.April.2014. It is also able to handle local languages, for example, it is possible to concert 14 Mart 2014 (Danish) to 03/14/14 (US) format if the language ID is provided.

  • Substring: Replaces the value with the substring value. It will take position and length. The default position is the first character. The default length is the entire string.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.

See Also

Other Resources

How to: Map Customer Data