Loading data and files from an external source into workspaces

When loading data from an external source into a workspace, the WebSphere Commerce database referential constraints are not imposed. This limitation in workspaces permits bad data to loaded into the workspace. Bad data in the workspace prevents the workspace data from being committed to the production-ready data.

To load data from an external source into a workspace, task group, or task:

1. Ensure that you completed the following configuration tasks on the authoring server:

   1. Configure the loading utilities.

   2. Configure tracing and logging for the loading utilities.

   3. Configure the massload utility.

   4. (Optional) Configure the MassLoadCustomizer.properties file.

2. If this is the first time that the data is being loaded, generate a DTD and schema for use with the loading utilities.

3. If you have not already resolved identifiers, resolve them now.

4. Run the massload utility to load data into the workspace.

5. Run the fileloader utility to load managed files into the workspace.

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

If you have loaded bad data into a workspace, run the massload utility using the same XML input file and specifying the delete method. This removes the bad data from the workspace. After that, you can correct the data and try to load the data into the workspace again.

Related Concepts

Workspaces, task groups, and tasks
Loading utilities

Related tasks

Loading data
Configure the MassLoadCustomizer.properties file

Related Reference

Considerations when loading data and files into workspaces
massload utility (Server environment)