Properties for Data Import

These properties configure what types of data and attributes to import.

For more information, see Configuring Import.

These attributes are available in the `definition` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element. This value has to be unique in the XML.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Policy`	Describes the policy name used to create the element.	Text value.
`DBProjection`	Defines the element to modify in the database. It can be a basic or a symbolic link name.	Text value.
`Revision`	Defines the revision used to create the element.	Text value.
`DuplicateAttributeFormat`	Defines the list of code labels used to match the duplicated elements.	Text value (list of code labels separated by commas)
`AttributeProbe`	Defines the code label used to search the element in the database.	Text value.
`ProcessingClassName`	Defines the class used to import the current element. Note: You have to keep blank this element to use the generic import.	Blank.
`JPO`	Defines the JPO name used to import the current element.	Text value. jpoClass:jpoFunction
`JPOPreProcess`	Defines the JPO used to execute a preprocessing.	Text value. jpoClass:jpoFunction
`JPOPostProcess`	Defines the JPO used to execute a post-processing.	Text value. jpoClass:jpoFunction
`Overwrite`	Defines if the assortment to be imported must overwrite the existing assortment.	`true` `false` The Assortment Update Mode check box in the Import 3D Merchandising Data window is selected it this value is set to `true`. The check box appears cleared if this value is set to `false` or if this value is not defined.

These attributes are available in the `attribute` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element. This value has to be unique in the XML.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal`
`DBProjection`	Defines the element to modify in the database. It can be a basic or a symbolic link name.	Text value. You can retrieve and use custom attributes for the `DBProjection` attribute. For example, if you create a custom attribute named `Custom Attribute` for Merchandising Product, its database name will be `XP_MerchandisingProduct_Ext.Custom_Attribute`. You can use these extensions to retrieve custom attributes for various objects. `XP_MerchandisingAssetDrawer_Ext` `XP_MerchandisingAssetGondolaSection_Ext` `XP_MerchandisingAssetHangingBar_Ext` `XP_MerchandisingAssetPallet_Ext` `XP_MerchandisingAssetPegSupport_Ext` `XP_MerchandisingAssetPeg_Ext` `XP_MerchandisingAssetShelf_Ext` `XP_MerchandisingAssetShortShelf_Ext` `XP_MerchandisingAssetWithRepresentation_Ext` `XP_MerchandisingAsset_Ext` `XP_MerchandisingAssortment_Ext` `XP_MerchandisingComposition_Ext` `XP_MerchandisingGondola_Ext` `XP_MerchandisingProduct_Ext` `XP_MerchandisingRepresentation3D_Ext` `XP_MerchandisingRetailCategory_Ext` `XP_MerchandisingRetailCluster_Ext` `XP_MerchandisingRetailStore_Ext` `XP_MerchandisingScene_Ext` `XP_MerchandisingStore_Ext` `XP_MerchandisingStoryboard_Ext` `XP_MerchandisingSubAssortment_Ext`
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.

These attributes are available in the `related object` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal`
`DBProjection`	Defines the element to modify in the database. It can be a business object or an attribute.	Text value. You can retrieve and use custom attributes for the `DBProjection` attribute. For example, if you create a custom attribute named `Custom Attribute` for Merchandising Product, its database name will be `XP_MerchandisingProduct_Ext.Custom_Attribute`. You can use these extensions to retrieve custom attributes for various objects. `XP_MerchandisingAssetDrawer_Ext` `XP_MerchandisingAssetGondolaSection_Ext` `XP_MerchandisingAssetHangingBar_Ext` `XP_MerchandisingAssetPallet_Ext` `XP_MerchandisingAssetPegSupport_Ext` `XP_MerchandisingAssetPeg_Ext` `XP_MerchandisingAssetShelf_Ext` `XP_MerchandisingAssetShortShelf_Ext` `XP_MerchandisingAssetWithRepresentation_Ext` `XP_MerchandisingAsset_Ext` `XP_MerchandisingAssortment_Ext` `XP_MerchandisingComposition_Ext` `XP_MerchandisingGondola_Ext` `XP_MerchandisingProduct_Ext` `XP_MerchandisingRepresentation3D_Ext` `XP_MerchandisingRetailCategory_Ext` `XP_MerchandisingRetailCluster_Ext` `XP_MerchandisingRetailStore_Ext` `XP_MerchandisingScene_Ext` `XP_MerchandisingStore_Ext` `XP_MerchandisingStoryboard_Ext` `XP_MerchandisingSubAssortment_Ext`
`RelatedType`	Defines the related type name.	Text value.
`Relationship`	Defines the relationship name.	Text value.
`Direction`	Defines the related object direction.	`to`: the object to relate goes to the object. `from`: the object to relate comes from the object.
`Policy`	Defines the related object policy name.	Text value.
`WhereClause`	Defines the related retail category when you import category size data.	`to[SHORel_RetailCategoryCategorySize].from.attribute[Title] == #Category#` `#Category#` refers to the name of the column in the retail import data file, that contains the name of the associated retail category.

These attributes are available in the `relationship attribute` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal`
`DBProjection`	Defines the element to modify in the database. It can be a business object or an attribute.	Text value.
`Relationship`	Defines the relationship name.	Text value.
`Direction`	Defines the related object direction.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`MandatoryColumn`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.	Text value.
`TargetProjection`	Defines the object search. This attribute enables you to search for the object related to the required relationship. It can be a business object or an attribute.	Text value.

These attributes are available in the `relationship of relationship attribute` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal`
`DBProjection`	Defines the element to modify in the database. It can be a business object or an attribute.	Text value.
`TargetRelationship`	Defines the target relationship name.	Text value.
`Direction`	Defines the related object direction.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`MandatoryColumn1`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 1.	Text value.
`MandatoryColumn2`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 2.	Text value.
`Relationship1`	Defines the relationship name 1. This attribute is the target relationship coming from the element	Text value.
`Relationship2`	Defines the relationship name 2. This attribute is the target relationship going to the element.	Text value.
`TargetProjection1`	Defines the object search. This attribute enables you to search for the object related to the required relationship 1. It can be a business object or an attribute.	Text value.
`TargetProjection2`	Defines the object search. This attribute enables you to search for the object related to the required relationship 2. It can be a business object or an attribute.	Text value.


Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal`
`DBProjection`	Defines the element to modify in the database. It can be a business object or an attribute.	Text value.
`TargetRelationship`	Defines the target relationship name.	Text value.
`Direction`	Defines the related object direction.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`MandatoryColumn1`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 1.	Text value.
`MandatoryColumn2`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 2.	Text value.
`Relationship1`	Defines the relationship name 1. This attribute is the target relationship coming from the element	Text value.
`Relationship2`	Defines the relationship name 2. This attribute is the target relationship going to the element.	Text value.
`TargetProjection1`	Defines the object search. This attribute enables you to search for the object related to the required relationship 1. It can be a business object or an attribute.	Text value.
`TargetProjection2`	Defines the object search. This attribute enables you to search for the object related to the required relationship 2. It can be a business object or an attribute.	Text value.

These attributes are available in the `information` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.
`Type`	Defines the type of the object.	Text value.
`DBProjection`	Defines the element to find in the database.	Text value.

These attributes are available in the `path` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`RelatedType`	Defines the type of the object.	Text value.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal` `MultiplePath`
`DBProjection`	Defines the element to find in the database.	Text value.
`Type`	Defines the relationship name.	Text value.
`Direction`	Defines the related object direction.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`Policy`	Defined the related object policy name.	Text value.
`ExpandRelationship`	Defines the relationship that describes the connection between path segments.	Text value.
`ExpandDirection`	Defines the direction in which the relationship is expanded.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.

These attributes are available in the `RelatedRelationshipAttribute` tag.
Attributes	Description	Values
`CodeLabel`	Defines the element.	Text value.
`RegularExpression`	Describes the regular expression used to detect the matching column.	Text value.
`Format`	Describes the attribute format.	`StandardString` `PositiveReal` `PositiveInteger` `NegativeReal` `StandardReal` `Date`
`DBProjection`	Defines the element to set.	Text value.
`MandatoryColumn1`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.	Text value.
`MandatoryColumn2`	Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.	Text value.
`TargetRelationship`	Defines the relationship name.	Text value.
`TargetDirection`	Defines the target relationship direction.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`Relationship`	Defines the name of the relationship between the objects defined in `MandatoryColumn1` and `MandatoryColumn2`.	Text value.
`Direction`	Defines the direction of the relationship between the objects defined in `MandatoryColumn1` and `MandatoryColumn2`.	`to`: the object to search goes to the object. `from`: the object to search comes from the object.
`Mandatory`	Defines if the element is mandatory or not. This attribute is a boolean value.	`true` `false` Note: The default value is `false`.

These attributes are available in the `formatpatternlist` tag.
Attributes	Description	Values
`FormatId`	Defines the attribute format.	`Date`
`FormatString`	Describes the date format syntax. The date can be only a start date or a period.	`MM/dd/yyyy` `MM/dd/yyyy - MM/dd/yyyy`