Export And Import Lookup Property Values

The Lookup and Hierarchical Lookup property types can support many standard values. You can manage the values manually as described in View And Edit Lookup Property Values or you can manage them with spreadsheets as described in this task.

Importing new lookup property values does not affect existing document property values. If existing document property values do not match the lookup values, a warning is shown when a user edits the document metadata and they must select a new, valid value.

To perform the tasks described on this page, you must be assigned to the Tenant Administrator role.

ClosedExport Lookup Property Values

To export lookup property values:

  1. On the Meridian Portal Landing page, at the bottom of the navigation bar, click the Account Settings icon A gear symbol..

    The Account Settings page appears.

  2. In the menu, click Document Properties.

    The Document Properties list appears and shows the properties that are available in your tenancy.

  3. Click the Menu icon Three blue circles stacked in a column. of the property for which you want to export its values.

  4. Click Export.

    A comma-separated value (CSV) file is downloaded to your browser where you can open or save it. This file contains the current Label and Code values for the property.

    If the property is of the type Lookup, the file contains one set of Label and Code values.

    If the property is of the type Hierarchical Lookup, the file contains four sets of Label and Code values so that you can provide unique values for every combination.

ClosedImport Lookup Property Values

To import lookup property values:

  1. Export the current values as described in the preceding task.

  2. Edit the CSV file in your favorite spreadsheet editor and save your changes in UTF-8 comma-delimited (CSV) format.

  3. Click the Menu icon Three blue circles stacked in a column. of the property for which you want to import its values.

  4. Click Import on the menu that appears.

    The Import lookup values dialog box appears.

  5. Click Import .csv.

    An Open dialog box appears.

  6. Select the file that you edited in step 2 and click Open.

    The file is uploaded to Meridian Portal and the results are shown.

  7. Click Close.

 

Accruent logo in white text.

© Copyright Accruent 2024Privacy PolicyTerms of UseLegal