Copy statistical data from the production server


To copy Marketing Event statistical data from a production machine to a development or staging server:

  1. From a command line, change to the following directory on the production server:

  2. Run the ExportStats command by entering the following: 
    database_type -N database_name -U database_user_id 
      -P database_password -F output_file_name -T table_name

    Where:

    database_type

    AIX|Linux|Solaris|Windows:

    The type of database you are using, either DB2 or Oracle.

    I5/OS: The type of database you are using, DB400.

    database_name

    • (DB2) Enter the simple name of the database.

    • (Oracle) Identify the database using the following format: hostname:port:sid identifying 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.

    I5/OS: This is also known as the instance user profile.

    database_password

    The password for the database owner ID.

    output_file_name

    The path and name of the output file with an .xml extension (if no path is specified, the default is the current directory).

    table_name

    The name of the database table that you want to export. The table to export depends on your requirements from among the following choices:

    • CPGNSTATS for campaign statistics

    • EXPSTATS for experiment statistics

    • PASTATS for Product Advisor statistics

    • PCSTATS for Product Comparison statistics

    • PESTATS for Product Explorer statistics

    • SASTATS for Guided Sell statistics

    This creates an XML file.

  3. Transfer the XML file to the development or staging server.

  4. Place the XML file in the following directory on the development or staging server:

  5. Run the ImportStats command by entering the following 
    database_type -N database_name -U database_user_id 
      -P database_password -F input_file_name
    Where

    database_type

    AIX|Linux|Solaris|Windows:

    The type of database you are using, either DB2 or Oracle.

    I5/OS: The type of database you are using, DB400.

    database_name

    AIX|Linux|Solaris|Windows:

    The name of your database. DB2 users enter the simple name of their database.

    (Oracle) Identify the database using the following format: hostname:port:sid identifying 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.

    I5/OS: This is also known as the instance user profile.

    database_password

    The password for the database owner ID.

    input_file_name

    The path and name of the output file created with the ExportStats utility in step 2 (if no path is specified, the default is the current directory).


This deletes any statistical information in the development or staging server database, and imports the statistics.

 

Related Concepts


Campaigns
Web activities
Operational reports

 

Related tasks


Configure Marketing Events statistical counters
View a campaign activity's statistics