Loading the data to the WebSphere Commerce database

Complete the following steps to load data to the WebSphere Commerce database:

  1. 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 Configure the massload utility for instructions on how to set the environment variables.

  2. Run the idresgen utility to resolve entities. Open a database command window. Change the directory to WCDE_installdir/bin

  3. Run the idresgen utility: idresgen -dbname demo_dev -dbuser dbuser -dbpwd dbpwd -infile "infile" -outfile "outfile" -method mixed -schemaname schemaname

    Where:

    demo_dev

    The name of the database.

    dbuser

    The name of the user connecting to the database.

    dbpwd

    The password for dbuser.

    infile

    The full path and name of the XML input file.

    outfile

    The full path and name of the output file.

    schemaname

    The name of the schema.

  4. Run the massload utility: massload -dbname demo_dev -dbuser dbuser -dbpwd dbpwd -infile "infile" -method sqlimport -schemaname schemaname

    Where:

    demo_dev

    The name of the database.

    dbuser

    The name of the user connecting to the database.

    dbpwd

    the password for dbuser.

    infile

    The full path and name of the XML input file.

    schemaname

    The name of the schema.

  5. Refresh the Currency Manager registry using the Registry window of the Administration Console.

  6. Manually remove pages showing the currency from the cache.

Related concepts

Related tasks

Related reference