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.

    This command includes ability to enable or disable object merge.

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> -DATATYPE <type> -DATATYPE <type> -FILEPATH <file path> -FILE <file name>

or

Changeassistant.bat -MODE UM -ACTION EXPCUSTDATA -INI <path to ini file>

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 5 type definitions: Package Definitions, Customization Repository, Test Repository, Merge Repository, and PUM Automated Updates. (Optional)

  • ALL = Select all the types. (default)

  • PKGDEFN = Export package definitions.

  • CUSTRPST = Export customization repository

  • TESTRPST = Export test repository

  • MERGERPST = Export merge repository.

  • PAU = Export PUM automated updates.

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.

-INI

Path to ini file.

See Using Change Assistant to Upgrade PeopleTools

The action IMPCUSTDATA is used to import the customer data from the selected data file to the new PUM source Database.

Command line format:

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

or

Changeassistant.bat -MODE UM -ACTION IMPCUSTDATA -INI <path to ini file>

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 5 type definitions: Package Definitions, Customization Repository, Test Repository, Merge Repository, and PUM Automated Updates. (Optional)

  • ALL = Select all the types. (default)

  • PKGDEFN = Export package definitions.

  • CUSTRPST = Export customization repository

  • TESTRPST = Export test repository

  • MERGERPST = Export merge repository.

  • PAU = Export PUM automated updates.

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)

-INI

Path to ini file.

See Using a Configuration File with Changeassistant.bat

The action UPLDCUSTDATA is used to upload customer data to the PUM source Database. This action is also used to enable or disable Object Merge.

Command line format:

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

or

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -INI <path to ini file>

Example command line to upload customization project from H9257P08 database project TEST_AE_PC.

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -RPSTTYPE CUST -PRJTYPE MO -PRJFROMDB H9257P08:TEST_AE_PC -REPLACE Y

Example command line to upload customization project from H9257P08 database project TEST_AE_PC and enable object merge.

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -RPSTTYPE CUST -PRJTYPE MO -PRJFROMDB H9257P08:TEST_AE_PC -REPLACE Y -MRGOPT Y

Note: This command first updates the merge option in PUM Source database and then uploads the project.

Example command line to enable object merge.

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -MRGOPT Y

Example command line to disable object merge.

Changeassistant.bat -MODE UM -ACTION UPLDCUSTDATA -MRGOPT N

The parameters for UPLDCUSTDATA action are:

Parameter

Description

-MODE

Change Assistant Action (Required)

UM = Update Manager

-ACTION

Action name (Required)

UPLDCUSTDATA = Upload customer metadata and test data.

-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.

-MRGOPT

Enable Object Merge (Optional)

  • Y = Enable object merge.

  • N = Disable object merge.

-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.

This option can’t be used with -MRGOPT.

-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

-INI

Path to ini file.

See Using a Configuration File with Changeassistant.bat