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 Configuring the Loader for instructions on how to set the environment variables.
  2. Run the ID Resolver utilityto resolve entities. Open a database command window. Change the directory to WCDE_installdir/bin
  3. 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.
  4. 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.
  5. Refresh the Currency Manager registry using the Registry window of the Administration Console.
  6. Manually remove pages showing the currency from the cache.

Feedback