The following example shows the batch file produced by the Scheduler (shown above) with several modifications:
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS SCHEDULER BATCH FILE-- DO NOT MODIFY IN
REM MARKETFOCUS BETWEEN COMMENTS
REM MARKETFOCUS CREATED 4/11/97 4:38:08 PM
REM MARKETFOCUS ACTIVE False
REM MARKETFOCUS OCCURS 2
REM MARKETFOCUS DAYS 7
REM MARKETFOCUS TIME 12:00:00 AM
SET IMPORT="C:\Program Files\Usage Analyst\IMPORT.EXE"
SET ANALYSIS="C:\Program Files\Usage Analyst\ANALYSIS.EXE"
SET METADATA="C:\Program Files\Usage Analyst\METADATA.EXE"
SET MAIL="C:\Program Files\Usage Analyst\UTILITY\MAIL.EXE"
REM MARKETFOCUS END DO NOT MODIFY
Commands added to use FTP to copy a log file from a remote web site.
REM ADD-IN COMMAND
REM DOWNLOAD COMPRESSED LOG FILE FROM FTP SITE USING COMMAND LINE FTP
REM See ftp help screen for more details
REM ftpdown.txt is simply a list of ftp commands
ftp -v -i -n -s:ftpdown.txt www.webserver.com
Commands added to decompress the log file.
REM ADD-IN COMMAND
REM UNCOMPRESS LOG FILE USING COMMAND LINE UNZIP UTILITY
REM You must supply your own unzip utility
unzip C:\LogFiles\logfile.zip
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Import"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" log="G:\LogFiles\in$i.log" logsource="LogSource1"
REM MARKETFOCUS END DO NOT MODIFY
Commands added to remove the old log file from the local file system after it has been imported.
REM ADD-IN COMMAND
REM DELETE LOG FILE TO MAKE ROOM FOR NEXT ONE
echo y|erase C:\LogFiles\logfile.log
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Title lookup"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" titles='Title=""'
REM MARKETFOCUS END DO NOT MODIFY
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "IP resolution"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" action="IP resolution"
REM MARKETFOCUS END DO NOT MODIFY
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Whois lookup"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" action="Who is"
REM MARKETFOCUS END DO NOT MODIFY
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Analysis"
%ANALYSIS% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" report="C:\Program Files\Usage Analyst\Reports\executive_summary.htm" analysis="C:\Program Files\Usage Analyst\Catalog\Summary\Executive summary.mfa"
REM MARKETFOCUS END DO NOT MODIFY
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Analysis"
%ANALYSIS% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" report="C:\Program Files\Usage Analyst\Reports\request detail.htm" analysis="C:\Program Files\Usage Analyst\Catalog\Summary\Request detail.mfa"
REM MARKETFOCUS END DO NOT MODIFY
Commands added to use FTP to copy reports to a web site for viewing by others.
REM ADD-IN COMMAND
REM UPLOAD REPORTS TO REMOTE WEB SERVER USING COMMAND LINE FTP
REM See ftp help screen for more details
REM ftpup.txt is simply a list of ftp commands
ftp -v -i -n -s:ftpup.txt www.webserver.com
Commands added to remove reports from the local file system.
REM ADD-IN COMMAND
REM CLEAN OUT REPORT DIRECTORY
echo y|erase C:\Progra~1\Usagea~1\Reports\*.htm
echo y|erase C:\Progra~1\Usagea~1\Reports\*.jpg
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Delete data over 6 months old"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" db="C:\Program Files\Usage Analyst\MSUsage.mdb" delete="Date>ThisMonth-6"
REM MARKETFOCUS END DO NOT MODIFY
REM MARKETFOCUS START DO NOT MODIFY
REM MARKETFOCUS TASK "Compact database"
%IMPORT% -silence messagelog="C:\Program Files\Usage Analyst\Message\MUA$M$Y.log" sourcedb="C:\Program Files\Usage Analyst\MSUsage.mdb" destdb="C:\Program Files\Usage Analyst\temp.mdb"
REM MARKETFOCUS END DO NOT MODIFY