Complete the following steps to load data to the WebSphere Commerce database:
- Ensure that the environment variables are set in the WCDE_installdir/bin/setenv.bat file. If you loaded the sample catalog already, then these variables should be set correctly. If not, see Configuring the Loader for instructions on how to set the environment variables.
- Run the ID Resolver utilityto resolve entities. Open a database command window. Change the directory to WCDE_installdir/bin
- Run the ID Resolver utility: idresgen -dbname demo_dev -dbuser dbuser -dbpwd dbpwd -infile "infile" -outfile "outfile" -method mixed -schemaname schemaname
where:
- demo_dev
- is the name of the database.
- dbuser
- is the name of the user connecting to the database.
- dbpwd
- is the password for dbuser.
- infile
- is the full path and name of the XML input file.
- outfile
- is the full path and name of the output file.
- schemaname
- is the name of the schema.
- Run the Load utility: massload -dbname demo_dev -dbuser dbuser -dbpwd dbpwd -infile "infile" -method sqlimport -schemaname schemaname
where:
- demo_dev
- is the name of the database.
- dbuser
- is the name of the user connecting to the database.
- dbpwd
- is the password for dbuser.
- infile
- is the full path and name of the XML input file.
- schemaname
- is the name of the schema.
- Refresh the Currency Manager registry using the Registry window of the Administration Console.
- Manually remove pages showing the currency from the cache.