Oracle Migration Tool On Demand Guide > Migrating Custom Fields > Migrating Custom Fields >

Creating a New Field Definition

This topic describes how to create a new field definition for your Oracle CRM On Demand environment. (Typically, the Create operation is used to manually create brand new XML content rather than extracting the definition from a company.)

NOTE:  System names (that is, the value between the <Name> tag) cannot be defined by a user, and it is a required field. A system name is a required field for an Upsert command. Any Field Management XML file extracted from a company tenant always has the system name defined. A net new field is a field that has not been extracted from another tenant but is defined in an XML file. To create a net new field, you must use the Create function. The Create function allows you to insert field definitions without having the system name defined.

The following is an example XML for using the Create method when you want to explicitly create a new field on the target:

<data:CustomField xmlns:data="urn:/crmondemand/xml/fieldmanagement/data">
  <data:ObjectName>Account</data:ObjectName>
  <data:DisplayName>My Customized Field</data:DisplayName>
  <data:CustomFieldType>Text (Long)</data:CustomFieldType>
  <data:IntegrationTag>My_Customized_Field</data:IntegrationTag>
  <data:Required>false</data:Required>
  <data:ReadOnly>false</data:ReadOnly>
  <data:DefaultValue/>
  <data:ListOfCustomFieldTranslations>
    <data:CustomFieldTranslation>
      <data:LanguageCode>ENU</data:LanguageCode>
      <data:DisplayName>My Customized Field</data:DisplayName>
    </data:CustomFieldTranslation>
</data:ListOfCustomFieldTranslations>
</data:CustomField>

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to create a new field definition:

migrationtool -u UserID -s ServerURL Create FieldManagement FieldManagementXML

where:

• UserID is the user sign-in ID that has the appropriate privileges to run the Oracle Migration Tool On Demand client commands.
• ServerURL is the URL for the Oracle CRM On Demand server where your company resides.
• FieldManagementXML is the fully qualified path name of the field management XML file, for example:

  C:\My Files\MyAccountField.xml

NOTE:  The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (using the pipe command) to the client program from standard input; that is, from a file, from the command line, or from another program.

Example of Creating a New Field Definition

The following is an example of creating a field definition for the Account object:

migrationtool -u UserID -s ServerURL Create FieldManagement "C:\My Files\MyAccountField.xml"

NOTE:  Quotation marks are required only if the name contains spaces.