Importing Classification Code Hierarchy

In addition to creating the Classification Code using the Classification Scheme tree control, you can also import the existing Classification Code hierarchy from the CSV files into the Classification Scheme.

The CSV file format should contain the hierarchy level along with their code and description. The CSV file should be of specific format. The headers should be grouped as Columnsets. The columnset can have a value either 2 or 3. For example, code name desc or code, name. The Classification-code hierarchy is defined by adding the parent and child relationship of the ClassificationCode in the CSV file specified as a columnset. The Classification-code attribute can be specified after the Classification-code columns e.g. code1, name1, desc1, code2, name2, desc2, attributeName.

Below is a sample CSV format with column set as 2.

Procedure

  1. Right click on the newly created Classification Scheme, select Import > Import > Classification Code.

    .

  2. The CSV file import Wizard is displayed.
  3. Click Browse to navigate to the path where you have saved the CSV file.
  4. Define the ColumnSet field based on selected CSV column set definition.
  5. Click Finish.
  6. The Classification Code hierarchy is created. If the Classification Codes are already present then they are merged.