Import Marketing Statistics utility

This utility imports marketing statistics from a source XML file.

Attention: Instead of following the procedure in this topic, you can use the DownloadStatistics scheduled job to transfer your marketing and search rule statistical data from your production environment to your staging environment. For more information, see Scheduling the DownloadStatistics job to copy marketing and search statistics.

Import Marketing Statistics command

ID Resolve Syntax Diagram

Note:
  1. The preceding diagram is intended primarily as a reference for the parameters. The script that is provided and listed in Copying statistical data from the production environment acts as a wrapper to the actual Java command and accepts the same parameters. You are recommended to use the command file or script rather than invoke the Java command directly.
  2. File names that are specified as parameters for this command can be preceded by relative or absolute paths.

Parameter values

database_type
The type of database that you are using. Accepted values are db2, or oracle.
database_name
DB2The name of your database. This name identifies the host name of the database server, the port number of the server, and the system ID. -Njdbc:db2://db:serverport/dbname where db2 is the database type, db is the server name, serverport is the database server port number, and dbname is the name of the database. For example,
-Njdbc:db2://db:50000/mall 
where "db2" is the db type, "db" is the server name, "50000" is the db port, and "mall" is the dbname.
Use the following format with DB2:
./ImportStats.sh -DDB2 -Njdbc:db2://db:50000/mall -Uwcs -Pwcs1 -Fsearchdata.xml -Tsrchstat

Oracle Identify the database by using the following format: hostname:port:sid. This name identifies the hostname of the database server, the port number of the server, and the system ID

database_user_id
The user ID of the database owner.
database_password
The password for the database owner ID.
input_file_name
The path and name of the output file that is created with the ExportStats command (if no path is specified, the default is the current directory).