Configuring Import

You can configure the import elements. You can configure the imported types, attributes or create elements to import.


Before you begin: You must have the Administrator role (VPLMAdmin). For more information, see: Managing Persons, Roles, Organizations, and Collaborative Spaces in the People & Organizations and Content - Administration guide.
See Also
Access Configuration Files
  1. Access the configuration files.
  2. In the Configuration Files page, download the ENOSHO_Import_Configuration.xml file.
  3. Modify the attributes.
    • Configure the attributes in the definition tag. The definition tag aims at defining a type of object to import.

      You can define the attribute, related object, relationship attribute, relationship of relationship attribute, and the information tags within the definition tag.

      AttributesDescriptionValues
      CodeLabelDefines the element. This value has to be unique in the XML.Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      PolicyDescribes the policy name used to create the element.Text value.
      DBProjectionDefines the element to modify in the database.

      It can be a basic or a symbolic link name.

      Text value.
      RevisionDefines the revision used to create the element.Text value.
      DuplicateAttributeFormatDefines the list of code labels used to match the duplicated elements.Text value (list of code labels separated by commas)
      AttributeProbeDefines the code label used to search the element in the database.Text value.
      ProcessingClassNameDefines the class used to import the current element.
      Note: You have to keep blank this element to use the generic import.
      Blank.
      JPODefines the JPO name used to import the current element.Text value.

      jpoClass:jpoFunction

      JPOPreProcessDefines the JPO used to execute a preprocessing.Text value.

      jpoClass:jpoFunction

      JPOPostProcessDefines the JPO used to execute a post-processing.Text value.

      jpoClass:jpoFunction

      OverwriteDefines 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.

    • Configure the attributes in the attribute tag. The attribute column aims at defining an attribute on the current object.
      AttributesDescriptionValues
      CodeLabelDefines the element. This value has to be unique in the XML.Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      FormatDescribes the attribute format.
      • StandardString
      • PositiveReal
      • PositiveInteger
      • NegativeReal
      • StandardReal
      DBProjectionDefines 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

      MandatoryDefines if the element is mandatory or not. This attribute is a boolean value.
      • true
      • false
      Note: The default value is false.
    • Configure the attributes in the related object tag. The related object column aims at connecting the current element to another object. The object to connect is created if it does not exist.
      AttributesDescriptionValues
      CodeLabelDefines the element.Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      MandatoryDefines 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
      DBProjectionDefines 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

      RelatedTypeDefines the related type name.Text value.
      RelationshipDefines the relationship name.Text value.
      DirectionDefines the related object direction.
      • to: the object to relate goes to the object.
      • from: the object to relate comes from the object.
      PolicyDefines the related object policy name.Text value.
      WhereClauseDefines 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.

    • Configure the attributes in the relationship attribute tag. The relationship attribute column aims at defining an attribute on a relationship connected to the current object.
      AttributesDescriptionValues
      CodeLabelDefines the element.Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      MandatoryDefines if the element is mandatory or not. This attribute is a boolean value.
      • true
      • false
      Note: The default value is false.
      FormatDescribes the attribute format.
      • StandardString
      • PositiveReal
      • PositiveInteger
      • NegativeReal
      • StandardReal
      DBProjectionDefines the element to modify in the database.

      It can be a business object or an attribute.

      Text value.
      RelationshipDefines the relationship name.Text value.
      DirectionDefines the related object direction.
      • to: the object to search goes to the object.
      • from: the object to search comes from the object.
      MandatoryColumnDefines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.Text value.
      TargetProjectionDefines 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.
    • Configure the attributes in the relationship of relationship attribute tag. The relationship of relationship attribute aims at defining an attribute of a relationship connected to the current object through another relationship.
      AttributesDescriptionValues
      CodeLabelDefines the element.Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      MandatoryDefines 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
      DBProjectionDefines the element to modify in the database.

      It can be a business object or an attribute.

      Text value.
      TargetRelationshipDefines the target relationship name.Text value.
      DirectionDefines the related object direction.
      • to: the object to search goes to the object.
      • from: the object to search comes from the object.
      MandatoryColumn1Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 1.Text value.
      MandatoryColumn2Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship 2.Text value.
      Relationship1Defines the relationship name 1. This attribute is the target relationship coming from the elementText value.
      Relationship2Defines the relationship name 2. This attribute is the target relationship going to the element. Text value.
      TargetProjection1Defines 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.
      TargetProjection2Defines 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.
    • Configure the attributes in the information tag. The information columns are ignored and do not generate any warning.
      AttributesDescriptionValues
      CodeLabelDefines the element. Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      MandatoryDefines if the element is mandatory or not. This attribute is a boolean value.
      • true
      • false
      Note: The default value is false.
      TypeDefines the type of the object.Text value.
      DBProjectionDefines the element to find in the database.Text value.
    • Configure the attributes in the path tag.
      AttributesDescriptionValues
      CodeLabelDefines the element. Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      RelatedTypeDefines the type of the object.Text value.
      FormatDescribes the attribute format.
      • StandardString
      • PositiveReal
      • PositiveInteger
      • NegativeReal
      • StandardReal
      • MultiplePath
      DBProjectionDefines the element to find in the database.Text value.
      TypeDefines the relationship name.Text value.
      DirectionDefines the related object direction.
      • to: the object to search goes to the object.
      • from: the object to search comes from the object.
      PolicyDefined the related object policy name.Text value.
      ExpandRelationshipDefines the relationship that describes the connection between path segments.Text value.
      ExpandDirectionDefines 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.
    • Configure the attributes in the RelatedRelationshipAttribute tag.
      AttributesDescriptionValues
      CodeLabelDefines the element. Text value.
      RegularExpressionDescribes the regular expression used to detect the matching column.Text value.
      FormatDescribes the attribute format.
      • StandardString
      • PositiveReal
      • PositiveInteger
      • NegativeReal
      • StandardReal
      • Date
      DBProjectionDefines the element to set.Text value.
      MandatoryColumn1Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.Text value.
      MandatoryColumn2Defines the mandatory column of the code label. This attribute enables you to search for the object related to the required relationship.Text value.
      TargetRelationshipDefines the relationship name.Text value.
      TargetDirectionDefines the target relationship direction.
      • to: the object to search goes to the object.
      • from: the object to search comes from the object.
      RelationshipDefines the name of the relationship between the objects defined in MandatoryColumn1 and MandatoryColumn2.Text value.
      DirectionDefines 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.
      MandatoryDefines if the element is mandatory or not. This attribute is a boolean value.
      • true
      • false
      Note: The default value is false.
    • Configure the attributes in the formatpatternlist tag.
      AttributesDescriptionValues
      FormatIdDefines the attribute format.Date
      FormatStringDescribes the date format syntax. The date can be only a start date or a period.
      • MM/dd/yyyy
      • MM/dd/yyyy - MM/dd/yyyy
  4. Upload the updated file.
    For more information, see Update a Configuration File.