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.