Create a Pending Content Change File

Creating a Pending Content Changes file is done in the Classic UI. To do so:

  1. Open the repository, open the Reports dropdown, click the arrow to the right of Pending, and select All Pending.

    The Pending Request Listing for Repository window will appear. It lists all the scheduled Events for all the records in the repository that have pending Events.

  2. Export the events for one record or for all the records in the repository.

    • To export the events for a single record, select the record, open the Utilities dropdown and select Export. A .csv file in the correct format will be created.

    • To export the events for the entire repository, make sure no records are selected. Open the Utilities dropdown and select Export. A .csv file in the correct format will be created.

  3. Go to the Job Monitor, find the completed Pending Request job, and download the job's output file.
  4. Warning: The date format should be compatible to the system. Excel may change the format if you open the .csv file. To avoid this, import the file into Excel instead. This will preserve the original format.
    To import the file into Excel:
    1. The .csv file produced may insert \r\n to indicate a new line. If so, edit the file and for each \r\n, begin a new row and delete the \r\n.
    2. Open a blank Excel spreadsheet.
    3. Open the Data tab, and in the Get & Transform Data section, click From Text/CSV .
    4. Navigate to the unzipped Export file.
    5. In the Delimited dropdown, select Comma.
    6. Click the Transform Data button.
    7. In the Transform section of the ribbon, click Use First Row as Headers.
    8. Select the EFFECTIVE_DATE column, and in the Transform section, set Data Type to Text. A Change Column Type pop-up will appear that asks how to perform the text conversion. Select Replace Current.
    9. Select the EXPIRATION_DATE column, and in the Transform section, set Data Type to Text. A Change Column Type pop-up will appear, asking how to perform the text conversion. Select Replace Current.
    10. In the Close section of the ribbon, open the Close & Load dropdown and select the Close & Load button.
    11. Edit the file as desired.
    12. Save the file as a .csv file.