9.1 - Metadata Mapping Function List

Follow

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.
Was this article helpful?
0 out of 0 found this helpful

Comments