Migrating to an Archer Server

Scope: ServiceNow -> RSA Archer projects

Currently, only migration from ServiceNow to an Archer Server is supported. The following should be noted when migrating to an Archer Server:

• Migration of Attachments is not currently supported
• Migration of User or Group records is not supported. These are considered Metadata in RSA Archer.
• Migration of values to certain Archer Field Types requires a specific format for the value being passed. The table below explains this

Migration to Archer Data Types

Archer Data Type	Expected Format of Values	Examples
Text	A text string Nulls will be passed as an empty string	This is a string
Numeric	Either an Integer or Decimal value Nulls will be passed as '0'	105 10.0
Value List	Either the Numeric Archer ID of a the value, or its display value. Multiple values (where the target field supports multiple selection) can be passed as a comma separated list with no spaces before or after the commas. Nulls will be passed as 'No Selection'	9624 High Environmental,IT Security  "Environmental","IT Security"
Date	A Date Value in the form yyyy-mm-dd. If a time part is given, it will be ignored. Nulls will be passed as an empty date value	2020-06-29
Cross Reference Related List	Either the numeric contend ID / Tracking ID for a record. Multiple values (where the target field supports multiple selection) can be passed as a comma separated list with no spaces before or after the commas. All values must be Numeric Nulls will be passed as 'No Selection'	56045 56045,56786
External Link	A single string, the URL for the link If a display value is also to be given, the format should be: <display value>#<url> Multiple values (where the target field supports multiple selection) can be passed as a comma separated list with no spaces before or after the commas.	www.google.com Search#www.google.com USA#www.google.com,UK#wwwogoogle.co.uk
User / Group List	Users and Groups should be passed in using the ID of the user or group record. If a group is to be passed, prefix the value with #USERS# If a group is to be passed, prefix the value with #GROUPS# If neither the #USERS# or #GROUPS# prefix is found, it will be assumed that the ID's belong to Users. Multiple ID's can be passed using a comma separated list. There should be no spaces between values. Both Users and Groups can be passed in the same value	207 #USERS#207 #GROUPS#306 #USERS#207,342#GROUPS#306
Matrix	Pairs of Numeric ID's with the id's matching a row and column as defined for the field. The format of each set should be [<rowid>|<columnid>] Multiple values can be passed as a comma delimited list	[101|102] [101|102],[103|105]