Report

The report command returns a "normal" Subscribe/Unsubscribe/Confirmation report.

The syntax of the report command is:

report listname [nochart | detail | CSV] [yyyymmdd-yyyymmdd]

The yyyymmdd-yyyymmdd modifier allows you to specify a starting and ending date. For example, to retrieve a report from January 1, 2000, to March 15, 2000, you would use the range 20000101-20000315, as shown in this example:

report jazztalk 20000101-20000315

By default the report is generated with a one-month history. Thus, if you do not specify a date range, the starting date is one month prior to today, and the ending date is today.

The nochart, detail, and CSV modifiers allow you to specify the format of the report you receive. These modifiers are mutually exclusive.

When you use the nochart modifier, the report excludes dates that do not contain any data. For instance, if no one subscribed on 3/14/00, the report does not include that date in the 'subscribe' section.

When you use the detail modifier, the report has an additional section at the end of the generaldata section. This additional section includes the email addresses associated with the data points present in the general data section.

The CSV modifier tells Aurea List Manager that you would like the report sent to you as a series of comma separated files. When you use this, the Aurea List Manager sends you an email that includes as attachments up to seven data files. These are data files, and are not designed to be human-readable. However, they are readable by most spreadsheet and database programs. Specifically, the format of these files is known as comma separated values (*.CSV).

You can use these files to synchronize your external database with your Aurea List Manager database. Since most database programs can read CSV files, these can be loaded directly into your database, where you can quickly run an update to put your database in synch with the Aurea List Manager database.

Six of the possible attachment files conform to the possible report types from the current report option. They are:

• Normal (subscribed) Members: The new subscribers for the report period is provided in the file "sub.csv".
• Unsubscribed Member: Those members that unsubscribed during the report period are listed in file "unsub.csv".
• Held Member: Members who were put on hold during the report period are listed in the "held.csv" file.
• Unconfirmed Members: Those members that subscribed during the report period but have not yet confirmed are listed in file "notcon.csv".
• Expired Members: Those memberships that expired during the report period are listed in the "expired.csv" file.
• Unapproved (private) Members: The members who have subscribed to private lists and are still awaiting List Admin approval are listed in "private.csv."

These data files are only attached to the email if they have any entries. For example, if no members were put on hold during the report period, there is no held data file attached to the email.

The column layout for these first six attachments is identical for all files. It is:

• Member ID,
• Email Address,
• Full Name,
• List,
• Date Joined,
• Expire Date,
• Number Bounces,
• Date Bounce,
• Confirm Date,
• Date Held,
• Date Unsubscribed,
• User ID,
• Comment,
• Additional

If any of the fields is missing data (this is common), then nothing is displayed.

The seventh file attachment is the totals. This has the same information as the report command but in a vertical arrangement. There are two columns of data, the total description and the value for that section:

• Total normal members
• Total unsubscribed members
• Total held members
• Total expired members
• Total unapproved (private) members
• Total unconfirmed members
• New normal members
• New unsubscribed members
• New held members
• New expired members
• New unapproved (private) members
• New unconfirmed members

This file is attached if there is any data at all.