Import/Export Normalizer Rows and Values

In addition to adding and modifying normalizer rows and values manually or through a normalizer value list, you can bulk load select pricing data directly into certain types of normalizers using a CSV file. Export a CSV file that contains the current information from My MATRIXX, update the CSV file, and then import the updated CSV file into your normalizer.

About this task

Note: This feature is only supported for the following normalizers:
  • IPv4 Match and IPv6 Match
  • Integer Equality and Unsigned Integer Equality
  • Phone Number Match and Phone Number Pattern Match
  • String Match
  • Zoning
The Name (required), Description (optional), Color (optional), and FieldValue (required) row columns are imported from the CSV file. All other columns in the CSV file are ignored.
Note: The Name value is unique. Modifying this value creates a new name. It does not overwrite the original name.
For each to-be-imported CSV row, the following validation occurs:
  • If a normalizer value with the given name does not exist in the normalizer, a new normalizer value is created and added to the normalizer.
  • If a normalizer value with the given name already exists in the normalizer, the normalizer value is updated with the information from the CSV file.
  • If the row in the CSV file contains normalizer row information (that is, FieldValue or FieldValue and ExactMatch for string match and phone pattern match normalizers), then a normalizer row is created in the normalizer that maps the field value to a normalizer value.

No values in the normalizer are deleted during an import. If the normalizer contains normalizer values that are not referenced in the CSV file, those normalizer values are retained.

Procedure

  1. In Normalizers, select a normalizer.
  2. Click or hover over the Rows menu icon and select Export CSV.
  3. Select Include all normalizer values to export both the normalizer values that do not have any associated mapping (that is, the values defined in the Value List) and the normalizer's row values. By default, this box is unchecked and only the normalizer's row values are exported.
    Note: If exporting a normalizer without any rows and Include all normalizer values is not selected, then the exported normalizer will contain the correct header row for that type of normalizer, and you can then load that into a spreadsheet and fill in values for all the columns. If Include all normalizer values is selected, then the resulting CSV file will contain all the correct columns and rows for all the values. The last column(s) in the normalizer will be empty because there are no rows to provide the FieldValue or FieldValue and ExactMatch cells.
  4. Click Export. The exported CSV file can be loaded into a spreadsheet application for bulk data entry and editing.
  5. Once you have all your information added to the CSV file, return to your normalizer's edit page, click or hover over the Rows menu icon and select Import CSV.
  6. Click Choose File and browse to your CSV file.
  7. In Number of Errors Before Abort, enter the maximum number of errors that can be encountered before the import is aborted. The default is 25.
  8. Click Import. One of the following displays:
    • If the import is successful, a success dialog displays for two seconds indicating the number of rows imported.
    • If the import failed, an error message displays. If some rows have errors, a table of errors displays showing the type of error found in each affected row. The maximum number of errors displayed is defined by the Number of Errors Before Abort limit. No data is imported if any errors are found.
  9. In Synchronize Changes, either commit the imported data to the pricing repository by synchronizing your changes or revert your normalizer's data back to the data it had before the import.