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:

Feature Pack 6 or laterThe massload utility is deprecated for WebSphere Commerce Version 7 Feature Pack 6. The Data Load utility is the recommended command-line loading utility. If you are currently using the mass load utility, you are recommended to switch to the Data Load utility to load your CSV and XML input files into your target database. If your system contains scheduled and automated processes that use massload, it is recommended that you update these processes to use the Data Load utility. Other WebSphere Commerce utilities that use the massload utility, such as the acpload utility, continue to use the massload utility in WebSphere Commerce Version 7 Feature Pack 6. If you have business reasons to continue using the massload utility, you can continue to use this utility. For more information about the Data Load utility, see Overview of the Data Load utility. You can switch to the Data Load utility by using the TableObjectMediator to load your data when no business object mediator exists for the data that you are loading. For more about the TableObjectMediator formation, see Data Load utility table-based mediator and builder.

For more information about loading data with the Data Load utility, see Overview of the Data Load utility

Procedure

  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 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 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 using the Registry window of the Administration Console.
  6. Manually remove pages that show the currency from the cache.