Siebel Email Marketing Stand-Alone (EMSA) provides a shell-launched utility, called purgeDb, that provides a number of access points into Siebel EMSA advanced reporting database for the purpose of removing old or irrelevant data.
This chapter covers the following topics:
■ “Execution” on page 68
■ “Examples” on page 68
Execution
Execution
On Windows environments, run the following command from under the installation directory:
.\purgeDb.bat
On Solaris, the purgeDb.csh shell is run from the installation directory.
In both cases, the shell executes a Java program that accesses the advanced reporting database and removes data based on the option selected and criteria entered.
Examples
The following examples show the appearance of the utility when run on a Solaris host. It is nearly identical from a command shell on Windows.
First, run the shell to begin the utility and see the menu of options.
# ./purgeDb.csh
Example 1
In this example, a mailing id is entered. All data in Siebel EMSA advanced reporting database for the specific mailing id is removed. To use this option, the precise mailing id must be known.
The purgeDB Utility Examples
To remove mailings with a mailing id
1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
1
2 Enter the mailing_id:
The data for the mailing is now removed.
Example 2
This example allows purging of all data for a campaign. A campaign may have, in general, many mailing ids associated with it. The data for each of the mailings for a campaign are removed from the advanced reporting database.
Examples
To purge all data for a campaign
1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
2
2 Enter the campaign_id:
Zaphod
The data for the campaign is now removed.
Example 3
This example deletes data for any mailings that were initiated before a specified date. This will remove mailings across campaigns.
The purgeDB Utility Examples
To delete data for any mailings initiated before a specified date 1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
3
2 Enter the date (MM-DD-YYYY):
04-01-1999
The data for the date is now removed.
Example 4
This example deletes data for any mailings sent out with a particular subject. This is an exact match and it removes mailings across campaigns.
Examples
To delete any mailings sent out with a subject
1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
4
2 Enter the Subject:
Ford Prefect
The data for the subject is now removed.
Example 5
This example removes data for all mailings associated with a particular Siebel EMSA list name. The data is removed from the advanced reporting database across campaigns.
The purgeDB Utility Examples
To remove data for a mailings associated with a list name 1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
5
2 Enter the listname:
Marvin
The data for the listname is now removed.
Example 6
This example will remove any detail records, that is, data stored at the email address within a mailing granularity level, that do not have a corresponding summary record. Such records are termed orphans and may result from incorrect mailing ids being retrieved from bounces, for example, for a variety of reasons.
Examples
To remove any details
1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
6
Example 7
This example does everything Example 6 does and also removes all data from the table that contains the orphan records culled from the detail tables.
The purgeDB Utility Examples
To remove any details and all data from the details tables 1 Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date 4) All mailings for a subject
5) All mailings for a Siebel Email Marketing Stand-Alone list 6) All detail table orphan records
7) All orphanage records 8) Exit
7
Example 8
The eighth and final option exits from the purgeDb utility.
To delete data from the purgeDb utility
■ Select one of the following options for removing mailings.
1) Individual mailing id 2) All mailings for a campaign 3) All mailings prior to a date
Examples
8
#