Reference > Data load utility CSV column definitions
Attribute dictionary attribute allowed values
Use the AttributeDictionaryAttributeAllowedValues keyword to load attribute dictionary attributes allowed values (in other languages) into the database using a CSV file. If you are loading attributes in a different language for the first time, log out of the Management Center and then log on again to be able to see the attribute dictionary attributes.. Also, ensure that the store supports the language. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
CSV file column definitions
- Identifier
- (String) The attribute identifier. This field cannot be NULL in Insert or Replace, and it must be unique. In Delete, either this field or the AttributeUniqueId is required.
- AttributeUniqueId
- (Integer) The unique reference number of the attribute. In Delete, either this field or the Identifier is required.
- LanguageId
- (String) The language ID for language sensitive fields. For example: -1 for English, -2 for French.
- ValueIdentifier
- (String) The attribute value identifier.
- Sequence
- (Decimal) A sequence number used to control the order in which attribute values are displayed in a product. The default value is 0.
- Value
- (String) The attribute value. This field is language-sensitive.
- ValueUsage
- (Integer) The attribute value usage. 1 for predefined allowed value (for example, one of the allowed values for a color attribute is blue). If this field is NULL then it is used for assigned attribute value (for example, the length of a product is 30. A length attribute does not have allowed values).
- Image1
- (String) The language sensitive full image path of the attribute value. The forward slash '/' should be used in the path. Do not use backward slash '\'. For example, images/G1.jpg .
- Image2
- (String) The language sensitive full image path of the attribute value. The forward slash '/' should be used in the path. Do not use backward slash '\'. For example, images/G1.jpg .
- Field1
- (String) A custom field for the attribute.
- Field2
- (String) A custom field for the attribute.
- Field3
- (String) A custom field for the attribute.
- Delete
- (String) Indicates whether to delete. If you are performing a delete operation, specify this column. A value of "1" indicates that the row should be deleted.