Migrating Accessibility Help

PeopleSoft provides the ability to migrate data for Accessibility Help using PeopleSoft Data Mover.

You can export Accessibility Help data from a development environment (source) and import the data into a testing or production environment (target). The following data types can be migrated:

  • Rich Text Editor data.

  • Images.

Example: Exporting Data for Accessibility Help

This is an example of a Data Mover Script export statement to export Accessibility Help content:

EXPORT PS_PT_ACCHELP;

This is an example of a Data Mover Script export statement to export Accessibility Help images:

EXPORT PS_PTRTDB;

This is an example of a Data Mover Script export statement to export specific Rich Text Editor images:

EXPORT PS_PTRTDB where attachsysfilename IN  ( 'image#1_name' , 'image#2_name',...'image#n_name' ) ;

The image name is appended with the timestamp, making it unique.

Example: Importing Data for Accessibility Help

This is an example of a Data Mover Script import statement to import Accessibility Help content:

IMPORT PS_PT_ACCHELP;

This is an example of a Data Mover Script import statement to import Accessibility Help images:

IMPORT PS_PTRTDB;

This is an example of a Data Mover Script import statement to import specific Rich Text Editor images:

IMPORT PS_PTRTDB where attachsysfilename IN  ( 'image#1_name' , 'image#2_name',...'image#n_name' ) ;

The image name is appended with the timestamp, making it unique.

Note:

If the target environment already has existing data, use the WHERE clause to import the Accessibility Help data to avoid overwriting the existing data. For more information, see Lifecycle Management Guide: Using PeopleSoft Data Mover Command Modifiers.