Reference > Data load utility CSV column definitions
Attribute dictionary attribute and allowed values
Use the AttributeDictionaryAttributeAndAllowedValues keyword to load attribute dictionary attributes and allowed values into the database using a CSV file. If you are loading attributes to the store for the first time, log out of the Management Center and then log on again to be able to see the attribute dictionary attributes. 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.
- Type
- (String) This field defines the data type of the attribute. This field cannot be NULL. Examples of data types are STRING, INTEGER, and FLOAT.
- Name
- (String) The name of this attribute. This field is language sensitive.
- Description
- (String) A description of this attribute. This field is language sensitive.
- SecondaryDescription
- (String) The secondary description of this attribute. This field is language sensitive.
- GroupName
- (String) The name of the attribute group this attribute belongs to.
- LanguageId
- (String) The language ID for language sensitive fields. For example: -1 for English, -2 for French.
- Field1
- (String) A custom field for the attribute.
- Footnote
- (String) Use this field to store auxiliary attribute data such as a footnote.
- UnitOfMeasure
- (String) The unit in which the attribute is measured.
- AllowedValue1
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue2
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue3
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue4
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue5
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue6
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue7
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue8
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue9
- (String|Integer|Float) An allowed value of the attribute.
- AllowedValue10
- (String|Integer|Float) An allowed value of 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.