Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Approaches to Maintaining Keyed Lists › Example: Update a Keyed List with a CSV File

Example: Update a Keyed List with a CSV File

You can supply values for keyed lists in the following three ways:

• Enter the key values manually
• Import the key values from a CSV file
• Import the key values from a specified CA IT PAM process

Use the following example as a guide to updating the values in any user-defined keyed list where the values are stored in an Excel spreadsheet saved as a comma-separated values list (*.csv).

To update a keyed list with a CSV file

1. Click the Administration tab, the Library subtab, and the Keyed List folder.
2. Expand the Keyed List folder, and select the keyed list you want to update, such as Default_Accounts, and click Export Values.

   An Export dialog appears with file.csv as the default filename.

3. Select the directory where you want to save the exported file. Change the file name, for example, Default_Accounts.csv and click Save.

   A confirmation message appears.

4. Click OK.
5. Browse to the exported .csv file, open it and scroll to display the last column, and add the entry you want to include. Optionally, delete the column for any default entry you want to remove from the keyed list for Default_Accounts.
6. Save and close the .csv file and return to the CA User Activity Reporting Module interface.
7. Click Import Values for the list you want to update here, the Default_Accounts keyed list.
8. Click Browse, select the file you saved, and click Open.
9. Click OK.

   The file is uploaded. Scroll to the bottom of the Values list to confirm that your new entry is present.