Data Load utility configuration properties
You can configure the load properties to change the behavior of the Data Load utility when you are loading data into WebSphere Commerce. You can edit the data load configuration files to add, update, or remove configuration property settings.
Data Load utility configuration properties can be added in the data load order or business object configuration files. The scope of a configuration property depends on where the property is specified within this file. Within a load order configuration file, properties can be set to affect all load items, or specific load items.
<_config:LoadOrder commitCount="1" batchSize="1" maxError="1" dataLoadMode="Replace">
<_config:property name="property1" value="a" />
<!-- Catalog business objects -->
<_config:LoadItem name="Catalog" loadSequence="1.0" businessObjectConfigFile="wc-loader-catalog.xml">
<_config:DataSourceLocation location="${Catalog}" />
</_config:LoadItem>
<_config:LoadItem name="CatalogDescription" loadSequence="1.5" businessObjectConfigFile="wc-loader-catalog-description.xml">
<_config:property name="property1" value="b" />
<_config:DataSourceLocation location="${CatalogDescription}" />
</_config:LoadItem>
For
information about where you can configure properties within a file, see - WC_installdir/components/foundation/samples/DataLoad
- WC_installdir\components\foundation\samples\DataLoad
- WCDE_installdir\components\foundation\samples\DataLoad
Property | Description | Configuration file available for property usage |
---|---|---|
actionOnError
|
Controls the action on error. You can set the following values for this property:
|
All load order or business object configuration files |
allowChangeAttributeType
|
Controls behavior of ATTRUSAGE column of ATTR table during a Data Load when the column is set
to null. You can set the following values for this property:
Note: When you use Catalog Upload, the default value for the
allowChangeAttributeType flag is false. |
Business object configuration files for attributes, such as:
|
allowDuplicateAdministrativeName
|
This property configures the Data Load utility to create a promotion instead of skipping the
promotion when the promotion has the same administrative name as an existing promotion. You can
set the following values for this property:
|
Business object configuration files for loading promotions with the
PromotionDOMMediator business object mediator. For instance:
|
attributeValueValidation
|
Indicates whether to validate the attribute value. The attribute value is mandatory except
within a product and defining attribute relationship. You can set the following values for this property:
Note: The attributeValueValidation flag is configured to be
false when you use Catalog Upload. |
Business object configuration files for attribute values, such as:
|
buildSearchIndex
|
Requests that the Solr search index is to be built for category and catalog entry
information. You can set the following values for this property:
|
All configuration files. |
createParentProductWhenMissing
|
Indicates whether to create the missing parent product of the catalog entry if no parent
product is provided. You can set the following values for this property:
|
Business object configuration files for catalog entries, such as:
|
customerSegmentNameIsFileName
|
Indicates whether the file name of the input file, excluding the file extension, is also the
name of an existing customer segment. This property is supported only for use with the
MemberGroupMemberMediator business object mediator. You can set the
following values for this property:
|
Business object configuration files for loading member group members into a customer segment
with the MemberGroupMemberMediator business object mediator. For instance:
|
DataCacheInvalidationEnabled
|
Indicates whether the load operation inserts records into the CACHEIVL
database table for the object that is being loaded. These records are picked up when the DynaCacheInvalidation URL
command runs to clear the data cache in the WebSphere Commerce server. Use this property to ensure
that the data cache is invalidated so the Management Center can pick up the new object
changes. You can set the following values for this property:
|
Data Load utility order and business object configuration files. If you want the property to
apply to all objects that are being loaded, include the property within the load order configuration
file. To have the property apply to only a specific object, include the property within the
appropriate business object configuration file. By default, all catalog upload load order configuration files include this property with a value of true. |
deleteSKUFromExistingParentProductWhenNewParentIsDifferent
|
Indicates whether to delete existing parent product of a SKU if the new parent product is
different. You can set the following values for this property:
|
Business object configuration files for catalog entries that have child SKUs, such as:
|
DeltaIndexingThresholdUponWorkspaceApproval
|
Specifies the delta indexing threshold for workspace indexes. If the threshold value is reached when a workspace approval occurs, a full index runs instead of a delta index. | Data Load utility order configuration files that are used to load objects that can be indexed with WebSphere Commerce search. |
fixSEO
|
Configures the load operation to replace invalid characters in the Keyword column for an SEO
URL with the underscore "_" character. You must apply the interim fix for
APAR JR53011 to use this configuration property. You can set the following
values for this property:
|
Business object configuration files for loading catalog entry objects with the
CatalogEntrySEOMediator business object mediator. For instance:
|
ignoreNonExistUser
|
Indicates how the Data Load utility is to handle loading email addresses when a member unique
ID cannot be resolved or created for the address. This property is supported only for use with the
MemberGroupMemberMediator business object mediator. You can set the
following values for this property:
|
Business object configuration files for loading member group members with the
MemberGroupMemberMediator business object mediator. For instance:
|
initAttribute
|
Indicates whether to implicitly initialize the attribute allowed value if it is not defined.
You can set the following values for this property:
|
Business object configuration files for attribute dictionary attribute and catalog entry
relationships, such as:
|
initAttributeDictionary
|
Indicates whether to initialize the attribute dictionary for the store. You can set the
following values for this property:
|
Business object configuration files for loading catalogs and catalog entries that use the
CatalogEntryMediator or CatalogMediator, such as:
|
loadSEO
|
Defines whether the Data Load utility can load SEO URLs. You can set the following values
for this property:
|
Data Load utility order configuration files for loading catalog entry or category information or files for loading page description information. |
markForDelete
|
Indicates whether to perform a physical delete or flag an object as marked for delete. You
can set the following values for this property:
|
Business object configuration files for catalog entries that use the CatalogEntryMediator,
such as:
The CatalogGroupMediator business object mediator supports the
markForDelete property. You can configure this property in the business object
configuration file for loading categories.
|
replaceAllElements
|
Indicates whether the Data Load utility replaces the existing elements for an activity with
the elements within the input file. This property is supported only for use with the
MarketingElementMediator business object mediator. You can set the following
values for this property:
|
Business object configuration files for loading activity elements with the
MarketingElementMediator business object mediator. For instance:
|
replaceAllExistingMembers
|
Indicates whether the Data Load utility replaces the existing users in a member group with
the members in the input file. This property is supported only for use with the
MemberGroupMemberMediator business object mediator. You can set the
following values for this property:
|
Business object configuration files for loading member group members with the
MemberGroupMemberMediator business object mediator. For instance:
|
replaceParentMasterCategory Note: To use this property, you need to install
interim fix JR55608. |
Indicated whether the Data Load utility can overwrite the parent master category of a catalog
entry that has an existing parent master category. You can set the following values for this property:
|
Business object configuration files for catalog entries.
|
rollbackForAnyException
|
Indicates whether the Data Load utility rolls back all of the data that is processed after
the last committed record when any type of exception occurs. This property is supported for use only
with the data load order configuration file. You can set this property within the configuration for
each load item or within the parent <_config:LoadOrder> element to have the
property setting apply to all load items. You can set the following values for this property:
|
Data load order configuration files. For instance,
|
shareAssignedAttributeValues
|
Indicates whether the Data Load utility supports reusing assigned values when duplicate
values are included for different catalog entries in the input file. You can set the following
values for this property:
|
Business object configuration files for loading catalog entry and attribute relationships.
Note: To have this configuration property and the ability to reuse assigned values available,
you must first apply the cumulative interim fix for Feature Pack 7. For more information, see Reuse attribute assigned values with the Data Load utility Support for reusing assigned values during a load operation is enabled by default. |
summaryReportLevel
|
Indicates whether to include extra information within the summary report that is generated
for the load process. If this property is not specified the default summary report generates. You
can set the following values for this property:
|
All load order configuration files. |
supportMultipleCalculationCodes
|
Indicates whether to multiple calculation codes for each calculation usage. You can set
the following values for this property:
|
Business object configuration files for catalog entries and categories that use one of the
following mediators
|
supportMultipleValuesForADAttributes
|
Indicates whether to support multiple values for attribute dictionary attributes. See, Enabling the support of multiple values for attribute dictionary attributes. You can set the following values for this property:
|
Business object configuration files for attribute dictionary attribute and catalog entry
relationships, such as:
|
syncSalesCatalogs
|
Indicates whether to synchronize the product relationships in linked sales catalogs when the
load process creates a product under a category. If this flag is set to true, the load process
searches all of the sales catalogs that this category is linked to. If the category-product
relationship does not exist in a catalog, the load process creates the relationship in the
catalog. You can set the following values for this property:
|
Business object configuration files for catalog entries, such as:
|
validateAttribute
|
Indicates whether to run the validation logic to validate that the attribute dictionary
attribute or its allowed values belong to the current store. This flag also checks whether the SKU
and the product have compatible defining attributes when it moves a SKU under this product. You
can set the following values for this property:
|
Business object configuration files for attribute dictionary attributes, such as:
|
validateCatalog
|
Indicates whether to validate the catalog for the store. Validation checks if more than one
master catalog is created for a store. If the store support sales catalog, checking whether a
catalog entry already belongs to more than one master category. The validation checks if an
attribute allowed value can be set to default in the current store. You can set the following
values for this property:
|
Business object configuration files for catalogs, categories, and catalog entries, such as:
|
validateCatalogEntry
|
Indicates whether to run the logic to validate that the load operations are valid for the
catalog entries. For example, if you set the value for the property to true, a validation exception
can occur when you load data to make a product the parent for another product. You can set the
following values for this property:
|
Business object configuration files for catalog entries that use the CatalogEntryMediator and
CatalogEntryParentProductMediator, such as:
|
validateCatalogGroup
|
Validates whether the category belongs to the specified catalog. You can set the following
values for this property:
Note: If you set the value to true, you must set the batchSize to 1 because the validation
depends on the committed data in the database. For more information, see Configuring the data load order. |
Business object configuration files for categories, such as:
|
validateDelete
|
Validates whether a category that is being deleted includes child categories. You can set
the following values for this property:
|
Business object configuration files for categories that use the CatalogGroupMediator business
object mediator, such as:
|
validateScope
|
Validation occurs to check whether an object belongs to the store that is specified within
business context of the environment configuration file. You can set the following values for this property:
|
All business object configuration files for loading catalog data. This parameter is not specified in any sample configuration files. |