9.1 - Metadata Mapping Function List
Updated at: Created at:
Migration Accelerator provides built in functions for transforming source metadata and/or generating metadata values as part of migration. In addition to built-in functions, custom functions can be added using PowerShell or IronPython.
| 9.1.1 - String Functions | 9.1.2 - Math Functions |
| 9.1.3 - Date Functions | 9.1.4 - Misc Functions |
9.1.1 - String Functions
| Sr.No. | Function Name | Parameters | Description |
|---|---|---|---|
|
1 |
ConcateWithSeparator |
Separator, stringOne, stringTwo |
This function allows you to combine two different string with your separator. |
|
2 |
Concate |
stringOne, stringTwo |
This function will join two strings. |
|
3 |
StringContains |
stringToCheck, orgString |
This function will check one string contains other supplied string or not. It will return value in true or false. |
|
4 |
ReplaceString |
orgString, wantToReplace, replaceString |
This function will replace sting. |
|
5 |
SubstringByStartPosition |
orgString, startPosition |
This function will return sting from your supplied position . |
|
6 |
SubstringByPostionAndLength |
orgString, startPosition, length |
This function will return sting from your supplied position and length. |
|
7 |
ToUpper |
Name |
Changing text case to upper |
|
8 |
ToLower |
Name |
Changing text case to lower |
|
9 |
Compare |
stringOne, stringTwo |
Comparing two string values |
9.1.2 - Math Functions
| Sr.No. | Function Name | Parameters | Description |
|---|---|---|---|
|
1 |
SUM |
stringOne, stringTwo |
This function will return sum of given two numbers. |
|
2 |
Round |
Value, RoundUpto |
Returning a decimal value to the nearest integral value |
|
3 |
Absolute |
Value |
Returning the absolute value of a Decimal number |
|
4 |
Power |
Value, PowerUpto |
Returning a specified number raised to the specified power |
9.1.3 - Date Functions
| Sr.No. | Function Name | Parameters | Description |
|
1 |
Now() |
|
This function will return current datetime value. |
|
2 |
Get-Day |
Date |
This function will return day value from given date. |
|
3 |
Get-Month |
Date |
This function will return month value from given date. |
|
4 |
Get-Year |
Date |
This function will return year value from given date. |
|
5 |
Get-Time |
Date |
This function will return time value from given date. |
|
6 |
Get-DateFormat[yyyy-MM-dd] |
Date |
This function will return given date in yyyy-MM- dd format. |
|
7 |
Get-DateFormat[dd-MM-yyyy] |
Date |
This function will return given date in dd-MM- yyy format. |
9.1.4 - Misc Functions
| Sr.No. | Function Name | Parameters | Description |
|---|---|---|---|
|
1 |
GetMappedUser |
srcMetaValue |
This function will give target mapped for given source user based on user mapping. |
|
2 |
Substitute_Invalid_Characters |
inputString |
This function will substitute invalid characters in given input string that are not supported by target system. |
|
3 |
GetTargetTaxonomy |
sourceTaxonomy |
This function will give target taxonomy value for given source taxonomy value. |
|
4 |
Get-Newname |
Name, Ext |
This function will return a new name after combining name and extension of file. |
|
5 |
Get-PathSegment |
Url, SegmentNumber |
This function will return path segment from given Url. |
|
6 |
GetTargetContentItemIdBySourceUri |
srcMetaValue |
This function will return target content item id based on source item Uri. |
OCR Functions
| Sr. No. | Function Name | Parameters | Description |
| 1 | Get-OCRText | srcMetaValue | This function will read text field from Image file by rendering text pattern. |
| 2 | Get-OCRDateField | srcMetaValue | This function read date field from Image by rendering through date pattern. |
| 3 | Get-OCRWordField | srcMetaValue | This function will return specific word from string by rendering image |
| 4 | Get-OCRSpaceDelimitedField | srcMetaValue | This function will return field which is space separated with field value by rendering image |
| 5 | Get-OCRTerminatedField | srcMetaValue | |
| 6 | Get-OCRNumberField | srcMetaValue | |
| 7 | Get-OCRFourColumnNumber | srcMetaValue | This function will return four column values separated ‘/’. |
| 8 | Get-OCRMonthYear | srcMetaValue | This function will return Month year value from Date field. |
| 9 | Get-OCRYear | srcMetaValue | This function will return Year value from Date field. |
Comments