Deprecated feature: Loading the data to the WebSphere Commerce database

You can load currency information to the WebSphere Commerce database.

About this task

Complete the following steps to load data to the WebSphere Commerce database with the massload utility:

Procedure

  1. Ensure that the environment variables are set in the WCDE_installdir/bin/setenv.bat file.
  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 that is 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 that is 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 by using the Registry window of the Administration Console.
  6. Manually remove pages that show the currency from the cache.