Constructing Command Lines for Migrating and Uploading Customer Data

Commands for migrating and uploading customer data include:

  • IMPCUSTDATA = Import customer data from the data file to the new PUM source

  • EXPCUSTDATA= Export customer data from existing PUM source and save it as a data file

  • UPLDCUSTDATA = Upload customer metadata and test data.

In order to migrate customer data, you will need to:

  1. Export the customer data from the old PUM source database and save it as a data file.

  2. Import the customer data from the selected data file to the new PUM source database.

The action EXPCUSTDATA is used to Export the customer data from the old PUM source Database and save it as a data file.

Command line format:

Changeassistant.bat -MODE UM -ACTION EXPCUSTDATA –SRCENV <old PUM DB> -PUMDATATYPE <type> -FILEPATH <file path> -FILE <file name>

The parameters for EXPCUSTDATA action are:

Parameter

Description

-MODE

Change Assistant Action (Required)

UM = Update Manager

-ACTION

Action name (Required)

EXPCUSTDATA = Export the customer data

- SRCENV

Name of the old PUM source Database. (Required)

-DATATYPE

The definition type to export. There are 3 type definitions: Package Definitions, Customization Repository and Test Repository. (Optional)

  • ALL = Select all the types. (default)

  • PKGDEFN = Export package definitions.

  • CUSTRPST = Export customization repository

  • TESTRPST = Export test repository

You can specify multiple data type by separating them by semicolon. For instance -DATATYPE PKGDEFN;CUSTRPST;TESTRPST

- FILEPATH

Specify the configuration backup file location (optional)

If the file path is not specified, the Output Directory is used.

- FILE

Specify the configuration backup file name (Optional)

If the backup file name is not specified, customerdata.DAT is used.

The action IMPCUSTDATA is used to Import the Change Package definition from the selected data file to the new PUM source Database.

Command line format:

Changeassistant.bat -MODE UM -ACTION IMPCUSTDATA –NEWTGTENV <new PUM DB> -PUMDATATYPE <type> -FILEPATH <file path> -FILE <file name> -OVERWRITE <Y|N>

The parameters for IMPCUSTDATA action are:

Parameter

Description

-MODE

Change Assistant Action (Required)

UM = Update Manager

-ACTION

Action name (Required)

IMPCUSTDATA = Import Customer data from the selected data file to the New PUM Source

-NEWSRCENV

Name of the new PUM source Database. (Required)

-DATATYPE

The definition type to export. There are 3 type definitions: Package Definitions, Customization Repository and Test Repository. (Optional)

  • ALL = Select all the types. (default)

  • PKGDEFN = Export package definitions.

  • CUSTRPST = Export customization repository

  • TESTRPST = Export test repository

You can specify multiple data type by separating them by semicolon. For instance -DATATYPE PKGDEFN;CUSTRPST;TESTRPST

- FILEPATH

Specify the configuration backup file location (optional)

If the file path is not specified, the Output Directory is used.

- FILE

Specify the configuration backup file name (Optional)

If the backup file name is not specified, customerdata.DAT is used.

- OVERWRITE

Overwrite the Change Package definition if it exists (Optional)

  • Y = Overwrite if exists.

  • N = Ignore duplicate. (default)

The action UPLDCUSTDATA is used to Import the Change Package definition from the selected data file to the new PUM source Database.

Command line format:

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -RPSTTYPE <CUST|TEST> -PRJTYPE <MO|ADS> -PRJFROMDB <DB:project> -PRJFROMFILE <file name> -NEWPRJ <DB:project> -REPLACE <Y|N> -ERRORCONTINUE <Y|N>

This is an example of a command line to upload the database project MY_CUSTOMIZATIONS from the database H92CD855 to the PUM Source.

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -RPSTTYPE CUST -PRJTYPE MO -PRJFROMDB H92CD855:MY_CUSTOMIZATIONS

The parameters for UPLDCUSTDATA action are:

Parameter

Description

-MODE

Change Assistant Action (Required)

UM = Update Manager

-ACTION

Action name (Required)

IMPCUSTDATA = Import Customer data from the selected data file to the New PUM Source

-RPSTTYPE

Target Repository Type (Required)

  • CUST

  • TEST

-PRJTYPE

Select the customer metadata type (Required)

  • MO = Managed Object Project

  • ADS = ADS Project

Note: If the repository type is TEST, MO is the only valid option.

-PRJFROMDB

Select Existing Database Project(s)

Example: -PRJFROMDB DB1:custprj1;DB2:custprj2

Note: Use this option if the project exists in the database.

-PRJFROMFILE

Select Existing Project File(s)

Example: -PRJFROMFILE c:/temp/custprj1;c:/temp/custprj2.

Note: Use this option if the project has been copied to file.

-NEWPRJ

Create new database project

Example: -NEWPRJ DB1:custprj1

-REPLACE

Replace existing data if it exists (Optional)

  • Y = Replace Existing Values if they Exist (default)

  • N = Do Not Replace Values if they Exist

-ERRORCONTINUE

Proceed with Uploading Customer Data even if errors are found (Optional)

  • Y = Proceed with Apply even if Errors found (default)

  • N= Stop apply when Errors encountered