Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Approaches to Maintaining Keyed Lists › Update a Keyed List with Export/Import

Update a Keyed List with Export/Import

If you store values that correspond to a key in an Excel spreadsheet, you can save that spreadsheet as a comma-separated values list (*.csv) and populate the Keyed List for the selected with an import.

You can update keyed list values you store in a CSV file in the following ways:

• If the CSV file contains current values for a given key and the displayed Values list is not current, you can import the values directly from the CSV file.
• If you want to create a CSV file or update one with obsolete values, use an export, edit, import sequence.

To update a keyed list with export or import

1. Click the Administration tab and then click the Services subtab.
2. Select Report Server from the Service List.

   Key Values appear in the Global Service Configuration: Report Server.

3. To update values for a selected key from a CSV file that contains current values:
   1. Select the key in the Key Values list for which values to update.

      Its obsolete values appear in the Values list.

   2. Click Import Values on the Values list toolbar.

      The Import file dialog appears.

   3. Click Browse

      The Select file to upload by CA Enterprise Log Manager <name> appears, with Files of type set to CSV Files (comma delimited)

   4. Navigate to the location where the CSV file containing the values for the selected key resides.
   5. Select the file to import and click Open.

      The selected file name appears in the File field.

   6. Click OK.

   The Values list is updated with the values from the CSV file.

4. To update the values for a selected key where the CSV file either does not exist or is not current:
   1. Select the key in the Key Values list for which values to update.
   2. In the Values toolbar, click Export Values.

      The Select location for download by <log manager name> appears, with file.csv in the File name field.

   3. Navigate to the location where the CSV file is to reside or does reside. Select it or enter the new file name manually in the File name field and click Save.

      A success confirmation appears.

   4. Click OK.
   5. Open Windows Explorer and navigate to the exported file.
   6. Open the spreadsheet, Modify or delete existing columns as required. Scroll to display the last column, and add new entries. Then, save the file as a CSV file.
   7. Select the same key and click Import Values.
   8. Click Browse, select the file you saved, and click Open.
   9. Click OK.

   The file is uploaded. You can scroll to the bottom of the Values list to confirm your new entry is present.

More information:

Update a Keyed List with a Dynamic Values Process