You can import CSV files of up to 20 MB at a time.

Ensure that the CSV file doesn't contain special characters, such as

/ \ * ? % : | " < >

, and any columns with the headers named

'Key'

.

When you import code values into a code list, ensure that the CSV file doesn't contain leading or trailing spaces in the Code field values. Reference 360 uses the Code field values as source primary keys for code values. If the Code field values contain leading or trailing spaces, Reference 360 ignores these spaces in the source primary keys. When you update the code values, Reference 360 fails to create relationships because of mismatches between the Code field values and the source primary keys.

When you import code values into a hierarchical code list, don't add a child code value to multiple parent code values in hierarchical code lists.

Don't import code values with cyclic relationships into a hierarchical code list. If you import code values that contain cyclic relationships, you can't export the code values from the code list.

If you want to update an attribute of a code value, enter values for all the attributes of the code value in the input file. The import process doesn't retain the values of attributes that don't contain values in the input file.

The source file that you use for import must contain relationships and code values that exist in the hierarchy model.

When you import a CSV file to update the existing relationship between the code values in a hierarchy, the import fails.

When you import decimal values, you must consider the following guidelines:

The values must conform to the default precision and the defined scale.
The default precision is 34. The supported scale value ranges from 1 to 34.
The total number of digits before the decimal point must be lesser than or equal to the difference between the precision and the scale.