Importing code list elements

To import the code list elements:

  1. Select Configuration > Common > Code Lists. The Code List that are already defined are displayed.
    Note: You can also access the code list from the data management page.
  2. Click the Details icon for the required Code List.
  3. Click Import. The Import Code List window is displayed.
  4. Specify this information:
    Interface
    The interface service for which the elements are imported from the code list.
    Choose File (+)
    The CSV/Excel file to be imported.
    Note: This option is only displayed for the CSV or Excel interface service.
    Reject all rows if an error is found
    If this check box is selected, the import process is aborted when an error occurs.
    Note: If this check box is cleared, and if the code list data you are importing contains element attributes with the length greater than 253, an error is reported and the data row is transferred to a discard log.
  5. Click Import to start the import of elements for the code list defined in the .xlsx file or the interface service.
    Note: The value of Clear Destination before import field in the interface service, impacts the import behavior. Possible scenario:
    • On: The existing data is cleared before the import.
    • Off: The imported data is appended to the existing table.