THE WELCH COMPANY
440 Davis Court #1602
San Francisco, CA 94111-2496
415 781 5700
rodwelch@pacbell.net


S U M M A R Y


DIARY: December 23, 2003 02:41 PM Tuesday; Rod Welch

Conform SDS records with Reference data bases.

1...Summary/Objective


..............
Click here to comment!

CONTACTS 

SUBJECTS
Diary Records on Disk Out of Sync with SDS Reference Data Base Files
Utility to Find and Report on Diary Records on Disk Out of Sync with
Program PERL Utility to Find and Report on Diary Records on Disk Out
Synchronize Reference Data Base Files for Pointers and SDS Records Ma

0706 -
0706 -    ..
0707 - Summary/Objective
0708 -
070801 - Follow up
070802 -
070803 - Gary developed a utility to maintain SDS Reference data bases in sync
070804 - with actual records on the disk.
070806 -  ..
070807 - Gary submitted a letter with results from running the new utility that
070808 - lists SDS records for account 00101 that do not have a description in
070809 - the 04 reference data base files.
070811 -  ..
070812 - Review shows this is not a general problem with the code, but that
070813 - occassionally records are out of sync with the data base.
070814 -
070815 -    1.  Many records have a time filename of 24mmss that should be
070816 -        identified as 12mmss.  There are a lot of records where the
070817 -        correction has been created, but the erroneous record was never
070818 -        deleted.
070820 -         ..
070821 -    2.  In some cases there is a report that the record does not exist,
070822 -        that is listed as having a record without a description.  In
070823 -        those cases, ran "delete record" command in the Diary menu.
070825 -         ..
070826 -    3.  There are a few cases where the date is different on line one
070827 -        (1) in the file where the record ID is located from the date in
070828 -        the actual filename.  These situations required investigation
070829 -        to determine a variety of factors that result in deleting the
070830 -        file or saving it, after conforming these to the correct
070831 -        parameter.  Either the filename could be correct or the date on
070832 -        the record ID line could be correct.
070834 -         ..
070835 -    4.  There many situations where a record has the same content as
070836 -        the prior record linked on the Summary-Objective line.  These
070837 -        situations indicate that a prior record was used to make a new
070838 -        record, but no actual content was developed.  Therefore, these
070839 -        could be deleted.
070841 -         ..
070842 -    5.  Other than issues in para 1, there does not seem to be an
070843 -        identifiable pattern causing mismatches between pointers and
070844 -        the records, that can be addressed with code changes.  The
070845 -        increase in the rate of problems the past few weeks can be
070846 -        attributed to work on 0702051 beginning a few months ago.  This
070847 -        is mainly speculation, and so requires continued attention to
070848 -        evaluate where these kind of problems occur again, now that the
070849 -        SDS record has been synchronized with the pointers.
070850 -
070851 -            [On 031226 corrected mismatch between 01 record description
070852 -            lines and SDS records. ref SDS O0 0001
070853 -
070855 -  ..
070856 - After getting about 10% through the list, discovered that the macro
070857 - file....
070858 -
070859 -                          c: sd 03 070201
070860 -
070861 -
070862 - ...was incorrect.  Modifications were made to build a delete file op
070863 - using the actual filename rather than get it from the record ID on
070864 - line 1.  This was necessary to address the problem in para 3 above.
070865 - ref SDS 0 GS5H
070867 -  ..
070868 - Since 070201 is used for a variety of tasks, needed to develop
070869 - multiple ways for constructing the filenames being processed.
070871 -  ..
070872 - After getting about 80% through the list, discovered that the macro
070873 - file....
070874 -
070875 -                          c: sd 03 070201
070876 -
070877 -
070878 - ...was still incorrect, and so had to fix prior work with a
070879 - refinement.
070881 -  ..
070882 - This means that in some cases pointers may still exist for records
070883 - processed in this record.
070884 -
070885 -
070886 -
070887 -
070888 -
070889 -
070890 -
070891 -
070892 -
0709 -