Hello all!

You all know I get data in via email on vessels plying the
big blue and compile them and make them available via email
along with other notes.

I've two sources of this data.  ONe, when it works reliably, is emails when
they're posted on the web from the web site
direct to the bbs machine.  THis is processed automatically.

A second source of this data comes from an associate, is
posted once per day, last 48 hours' activity.    sO, I"ve
got four fields in both files that I can compare, keeping
only those which I want to post.
FIelds are not fixed width,  but I can pull off certain
information.  NOte the following entries:

06/06/2009 00:16 N6ABC KI4MMZ

06/06/2009 01:57 W5EIM KI4MMZ

06/06/2009 13:19 KB1ILA KC5AGO

06/06/2009 15:15 N1YT KI4MMZ

Extra cr/lf between them so they wouldn't word wrap funny.
NOte we've got the date, the time, call sign of vessel, and
call sign of poster.
I can pipe the last 48 hours file through listmod pulling
out first four fields.  BUild a batch using listmod which
looks like this ...

NOte we want to capture complete lines if the data is not
already present in our master file.  Anybody see any easier
ways to go about this I"m not thinking of?

::postrec.bat reconciles data from second source with first ...{at}echo off
echo reconciliation of boat list data from kr4or.
rem %1 is vessel's call sign
rem %2 is posting date
rem %3 posting time
rem %4 posted by
cd \temp
fgrep386 -s %1 boatdump.txt >> chekpost.txt
rem move data to location of received reconciliation data and process ...
move chekpost.txt c:\nettamer\mail
cd \nettamer\mail
:: get count of line number in backhanded way
echo * >> lognum.sem
type lognum.sem | find "*" /i /c >> lognum.txt
nset lognum=$1 > dumpdate.out
if errorlevel 1 goto chktime
if errorlevel 0 if not errorlevel 1 goto postit
:chktime
:: we're good on date of posting of that vessel now to see if we've got
correct time stamp ...

fgrep386 -s %3 chekpost.txt >> dumptime.out
if errorlevel 1 goto gottime
if errorlevel 0 if not errorlevel 1 goto postit
:gottime
fgrep386 -s %4 chekpost.txt >> dumpsub.out
if errorlevel 1 goto nopost
if errorlevel 0 if not errorlevel 1 goto postit
:nopost
logecho %1 posted by %4 at %3 on %2 previously on file at $h:$m >>
report.log goto end
:postit
logecho entry for %1 on %2 at %3 by %4 not seen in boat list as of $h:$m
>> report.log sed -n %LOGNUM%p > postrec.txt
goto end
:end
del dump*.out
del chekpost.txt
set lognum=
:: end of reconciliation batch

Any ideas welcome on how to streamline this.  OF course,
we're backing up our input data before we do this until
we're sure we've found all the bugs.


Regards,
           Richard
--- timEd 1.10.y2k+