Skip to main content
Version: Latest (4.60.0)

Transformation (4a. Replace Invalid Characters)

This flow replaces target system specific invalid characters found in the target.name.systemName field of RECORD and CONTAINER documents. This is useful for ensuring that the target system does not encounter any incompatible characters that would cause issues in the load stage of the migration. The flow does update the target.hierarchies of the object, but not for its children.

Settings​

mongoConnection​

The Mongo connection string including the database name to connect to.

targetSystem​

Specifies the target system. Valid values are: alfresco, documentum, opentextcs, spembedded, spoand other.

When this value is set to alfresco:

  • the following characters will be replaced by the replacementChar: ", *, :, <, >, ?, /, \, |
  • trailing dots will be removed

When this value is set to documentum:

  • the following character will be replaced on CONTAINER objects by the replacementChar: /

When this value is set to opentextcs:

  • the following character will be replaced on CONTAINER objects by the replacementChar: /

When this value is set to spo or spembedded:

  • the following characters will be replaced by the replacementChar: ", *, :, <, >, ?, /, \, |
  • invalid XML characters and names starting with ~ will be replace by the replacementChar
  • trailing dots will be removed
  • _vti_ will be replaced by vti

When this value is set to other the characters defined in the invalidChars flow variable are replaced.

In all cases the name will be trimmed.

invalidChars​

The characters that will be replaced by the replacementChar when the targetSystem variable is set to other. In other cases, this setting will be ignored. Example: [":", "<", ">", "?", "/", "\\\\", "|"]

replacementChar​

The character that will replace the invalid characters.