Creating a Portal Registry Load File

To be usable by the Registry Load process, the number of columns and format in your registry load file must match those in the delivered portal_reg_load_sample.xls file. The sample portal registry load files can be found in the PS_APP_HOME\data folder.

Note: If the PeopleSoft Interaction Hub files were not installed in a separate PS_APP_HOME location, then these files will be found in PS_HOME\data instead.

To create a portal registry load file:

  1. Open portal_reg_load_sample.xls file.

  2. Save portal_reg_load_sample.xls with a different name.

  3. Replace the existing rows with your data. The number of rows of data is not limited.

    Note: Do not put commas or tabs in any of the Microsoft Excel file cells, including the description fields. Commas and tabs disrupt the data stored as a CSV file.

  4. Save the file with your data.

  5. Delete the row that contains the column headings.

  6. Save the file again, with the file type CSV (*.csv).

  7. Place the file in a directory that is accessible to the application server for your PeopleSoft Interaction Hub database.

    For example, you could place the CSV file in the PS_CFG_HOME\appserv\APP_SRV_DOMAIN\files folder.