Special reports for Conni:
In /ReportingFourth/stats/Reporting/ConniRequest/bin/ there are several Perl
scripts for producing special reports that Conni sometimes requests.
These typically have a row per journal and a column per customer, for a list
of customers provided by Conni. Conni supplies customer IDs - these have to be
converted to customer OIDs using the script getCustomerOIDFromID.sh.

    getCustomerOIDFromID.sh -f <customer file> -i <customer id file>
        Where <customer file> is usually EALipdata
        and <customer id file> is list of customer IDs (one per line)
        Standard output conists of lines of form OID|ID - edit this to just
        have OID on each line.
    extractYearToDateColumn.pl -p <product> -c <customer OID file> -o <output file> -t <temporary directory> -d <db file directory> -n <column number>
        where <product> is usually Journal (default)
            <customer OID file> is output from getCustomerOIDFromID.sh
            <output file> - not used?
            <temporary directory> should be an empty directory (don't use default /usr/tmp!!!)
            <db file directory> is usually ~/Reporting/UsageReportsCounter/CustomerReports/2006/06 (used to get Journal.db - does year-to-date, so use last month of year)
            <column number> is 9 for fulltext (default), 10 for access-denied
        For example:
            ./extractYearToDateColumn.pl -c NERLoids -o foo -t tmp -d ~/Reporting/UsageReportsCounter/CustomerReports/2006/06

    joinColumns.sh -s <filename stem> -t <temporary directory> -o <output directory>
        where <filename stem> is whatever you want as report name
            <temporary directory> should be same directory as given to
                extractYearToDateColumn.sh
            <output directory> is where output files are put

The output file produced by joinColumns.sh is a CSV file (with all values in
double quotes). Conni can't import this format if it is sent as an email
attachment. There are 3 ways of dealing with this:
    1. Put the file on the wis-stats website and give Conni the URL of the
    file. This is what Zhiming does - but Conni told me she prefers having an
    email attachment.
    2. Edit the file to globally replace "," (quote comma quote) by tab, and
    to remove the quotes from start and end of each line. Be careful with this
    edit since titles can contain commas. This is what I did for Conni before.
    3. Import the file into OpenOffice and save it as an XLS file (i.e. as
    Microsoft Excel 97/2000/XP). This is what I did for Patrick, and is
    probably the best solution.