Administer > Transforming, loading, and extracting data > Load data into workspaces

Load data into workspaces using the Data load utility

The Data Load utility now supports loading data into a workspace. Loading data into a workspace lets you make and preview changes to managed assets, without affecting what is currently running on the site.

Only data that resolves into managed assets is loaded into workspaces. Any data that resolves into non-managed assets is loaded into the production-ready data on the authoring server.

When loading data into a workspace, the data load utility respects the locking policy set in the workspace.

If you are loading data into a workspace, take note of the following considerations:

• Data that resolves into managed assets are loaded directly into the workspace, while data that resolves into non-managed assets are loaded directly into the production-ready data on the authoring server.

• If you load managed assets and non-managed assets together when workspace is enabled, you might get an ID resolver exception or a foreign key violation exception.

  To prevent getting an ID resolver exception or a foreign key violation exception:

  1. Load the managed assets data.
  2. Approve the managed assets data.
  3. Load the non-managed assets data.

Procedure

1. Enable workspace loading for the data load utility.

   To enable workspace loading when using the data load utility, specify some optional attributes in the business context element of the data load environment configuration file (wc-dataload-env.xml):

   <_config:BusinessContext storeIdentifier="Madisons" 
                            catalogIdentifier="Madisons" 
                            langId="-1" 
                            currency="USD"          
                            workspaceIdentifier="W_10001" 
                            taskGroupIdentifier="G_10001" 
                            taskIdentifier="T_10001">     
   
   </_config:BusinessContext>
   

   The workspace attributes that can be specified in the business context are:

   workspaceIdentifier

   The workspace code is the system generated identifier for the workspace, not the name assigned to the workspace by the Workspace Manager.

   taskGroupIdentifier

   The task group code is the system generated identifier for the task groups, not the name assigned to the task group by the Workspace Manager. Specify either this attribute or the "taskGroupName" attribute.

   taskGroupName

   The name assigned to the task group by the Workspace Manager.

   Specify either this attribute or the "taskGroupIdentifier" attribute.

   If you specify this attribute, since multiple task groups can have the same task group name, ensure that there is only one working task group with the specified task group name. Otherwise, the data load utility throws an exception.

   taskIdentifier

   The task code is the system generated identifier for the task, not the name assigned to the task by the Workspace Manager. Specify either this attribute or the "taskName" attribute.

   taskName

   The name assigned to the task by the Workspace Manager. Specify either this attribute or the "taskIdentifier" attribute. If you specify this attribute, since multiple tasks can have the same task name, ensure that there is only one working task with the specified task name. Otherwise, the data load utility throws an exception.

2. Run the data load utility to load data into the workspace.

+

Search Tips   |   Advanced Search