Administer > Transforming, loading, and extracting data > Load data into workspaces
Load data and files from an external source into workspaces using the mass load utility
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.
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.
When loading data and files into workspaces using the loading utilities, take note of the following considerations:
- The loading utilities load all data that resolves into managed assets into workspaces. Any data that resolves into non-managed assets loads into the production-ready data on the authoring server.
- The loading utilities do not observe the WebSphere Commerce database referential constraints when loading data into a workspace. 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.
Procedure
- Ensure that you completed the following configuration tasks on the authoring server:
- Configure the loading utilities.
- Configure tracing and logging for the loading utilities.
- Configure the massload utility.
- Optional: Configure the MassLoadCustomizer.properties file.
- If this is the first time that the data is being loaded, generate a DTD and schema for use with the loading utilities.
- If you have not already resolved identifiers, resolve them now.
- Run the massload utility to load data into the workspace.
- Run the fileloader utility to load managed files into the workspace.