Introduced in Feature Pack 3

Running the IBM Product Recommendations data extraction utility

Run the data extraction utility for IBM Product Recommendations, formerly known as Coremetrics Intelligent Offer from a command-line interface. The command generates both the EPCMF file and ECDF file at the same time.

Procedure

  1. Ensure that the WebSphere Commerce server is started.
  2. SolarisLinuxAIXEnsure that you run the utility as the wasuser user. To do so, issue the following command:
    su - wasuser_ID
    where wasuser_ID is the non-root user ID that is created before installing WebSphere Commerce. The default WebSphere Application Server user name is wasuser.
  3. Open a command prompt window.
  4. Run the data extraction utility:
    1. WebSphere Commerce DeveloperCall the utility script with the following command:
      • WindowsWCDE_installdir/bin/dataextract.bat path_to_config_file
      Where path_to_config_file is the path to the wc-dataextract.xml file to use. For example:
      C:/IBM/WCDE_ENT70/samples/DataExtract/Catalog/wc-dataextract.xml
      Alternatively, you can use the relative path to the configuration file for the path value. If the path contains spaces, enclose the path in quotation marks.
    2. WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalCall the utility script with the following command:
      • WindowsWC_installdir/bin/dataextract.bat path_to_config_file
      • SolarisLinuxAIXWC_installdir/bin/dataextract.sh path_to_config_file
      Where path_to_config_file is the path to the wc-dataextract.xml file to use. For example:
      C:/Program Files/IBM/WebSphere/CommerceServer70/samples/DataExtract/Catalog/wc-dataextract.xml
      Alternatively, you can use the relative path to the configuration file for the path value. If the path contains spaces, enclose the path in quotation marks.
  5. View the EPCMF and ECDF files that the utility creates.
    The two files are output to the directory configured in the <_config:DataOutputLocation> element in the corresponding business object configuration file (wc-dataextract-catalog-entry.xml and wc-dataextract-catalog-group.xml). The default location is:
    • WebSphere Commerce DeveloperWCDE_installdir/bin/
    • WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalWC_installdir/bin/
    The files are named according to the following syntax:
    Coremetrics_client_ID.epcmf.csv
    Coremetrics_client_ID.ecdf.csv

    For example:

    99999999.epcmf.csv
    99999999.ecdf.csv
  6. To check the results of the data extract, view the log file at the following path:
    • WebSphere Commerce DeveloperWCDE_installdir/logs/dataextract.log
    • WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalWC_installdir/logs/dataextract.log