CONTACTS 

SUBJECTS
HTML Convert Record and Save to HTML Data
HTML Macro - 070405, 06116
SDS Linking System
Subject Internet Datab Base
Headings
Summary

0709 -  ..
0709 - <0<0001
0710 - Summary/Objective
0711 -
071101 - Follow up ref SDS 6 4880.
071102 -
071103 - We needed to reset the counter for numbering the Summary list of
071104 - headings.  It was working okay for a single memo, but when the data
071105 - base is processed to update the Web site, the code keeps a processor
071106 - file in memory, so the counter has to be reset for each new record
071107 - read in for formatting.
071108 -
071109 -
071110 -
071111 -
071112 -
0712 -
0713 - Problems
0714 -   ..
071401 - We do not seem to be getting all of the records.
071402 -
071403 - The record on our Web site for the SDS record of the discussion with
071404 - Max Wideman on 980218, ref SDS 5 4860, does not show the correct
071405 - format for the Executive Summary in that the summary shows:
071406 -
071407 -              34...
071408 -
071409 - ...when it should show:
071410 -
071411 -              Summary/Objective
071412 -
071413 -
071414 - I have now checked the code to convert the record to HTML and it is
071415 - correct.
071416 - ..
071417 - I used the "save" to HTML function and it puts the correct
071418 - record onto the h: drive.
071419 -
071420 - This suggests that the operation using 06116 with 070405 may fail due
071421 - to a memory problem or something.
071422 -
071423 - Will now check to see if any other records are messed up.
071424 -
071425 - The record for 980209, ref SDS 4 1092, is also messed up and shows
071426 -
071427 -              33...
071428 -
071429 -      ...instead of
071430 -
071431 -              Summary/Objective
071432 - ..
071433 - The record for 971229, ref SDS 3 3462, should have:
071434 -
071435 -              <A HREF="#L2413">1...Summary/Objective</A><BR>
071436 -              <A HREF="#L241801">2...CRM Films Has Strong Messa
071437 -              <A HREF="#L241897">3...Communication on-the-Cheap
071438 -              <A HREF="#L241918">4...Investing Intellectual Cap
071439 -              <A HREF="#L241953">5...$240K Annual Cost of Miss-
071440 -              ...
071441 -
071442 -      ...instead it shows:
071443 -
071444 -              <A HREF="#L2413">20...
071445 -              <A HREF="#L241801">21...CRM Films Has Strong Me
071446 -              <A HREF="#L241897">22...Communication on-the-Ch
071447 -              <A HREF="#L241918">23...Investing Intellectual
071448 -              <A HREF="#L241953">24...$240K Annual Cost of Mi
071449 -              ...
071450 - ..
071451 - We are not getting "Summary\Objective" heading.
071452 -
071453 - Somehow we are accumulating the summary numbers each pass, instead of
071454 - starting over.
071455 -
071456 - The first record that does not seem to have a Summary/Objective is,
071457 -
071458 -              970516........ ref SDS 1 2237,
071459 -
071460 -
071461 -
0715 -
0716 -
0717 - Investigate Code
0718 -
071801 -  ..
071802 - 070405 - Headline Links Add Code to Reset Task Numbers
071803 -
071804 - Line 1035, ref OF 2 1653, -label lp1, this is the loop that links the
071805 - Summary to the headings in the record.
071806 -
071807 -
071808 - Line 1815, ref OF 2 5382, -label convNum this uses counter 262 to
071809 - increment summary tasks.
071810 -
071811 - This number needs to be set to 0 each time a new file is read in.
071812 -
071813 - I did this above ref OF 2 1653.
071814 -
071815 -
071816 -
071817 -
0719 -
0720 -
0721 - 2252 Test
0722 -
072201 -  ..
072202 - Test Indicates Problem Solved
072203 -
072204 - I moved the Web data base records to i: and deleted them from h.
072205 -
072206 - Ran a report for 6 months.
072207 -
072208 - These records seem to have the correct numbering and they all show a
072209 - Summary/Objective, as they should. Not sure what the numbering has to
072210 - do with whether Summary/Objective being entered, but it seems to be
072211 - working, so...
072212 -
072213 - Will try a larger sample.
072214 -
072215 - Ran a one year sample.
072216 -
072217 -
072218 -
072219 -
0723 -

SUBJECTS
Update HTML Data Base for SDS, 06116,

0804 -    ..
080401 - 06116 - Test Processing of Last 20 Records
080402 - ..
080403 - When we run a regular subject report for something we get 85
080404 - records from current date to a year ago.  The HTML report is only
080405 - getting 80 records.  We are 5 records short.
080406 -
080407 - I have a hunch this is not working correctly and so results in us not
080408 - getting all of the records in our sample.
080409 -
080410 - Line 440, ref OF 1 3339, -label lpInt1 testing with debug.  This is
080411 - where we process the last 20 records.
080412 -
080413 - The 5 missing records are showing up in the test sample.
080414 - ..
080415 - Why are they not being processed?
080416 -
080417 - The reason seems to be that we are processing the records in 1y, but
080418 - it has been changed.  The remaining records are in 1v.
080419 -
080420 - So I changed the code to use 1v.
080421 -
080422 - This caused a problem of running an update operation for a long
080423 - period.
080424 -
080425 - The problem turned out to be that I originally set up a series of
080426 - temporary files in 06116, including 1R, 1V and 1W in addition to 1y,
080427 - which is the standard temporary file for report pointers.
080428 -
080429 - When we had the problems with 06116 running out of memory on reports
080430 - that covered more than evey 50 records, which normally is only a few
080431 - months, one of the methods I tried to solve this was to use temporary
080432 - files for reasons that are not clear now, but related to the idea of
080433 - setting up memory space to try avoiding fragemented RAM from opening
080434 - and closing multiple files.
080435 - ..
080436 - That method did not solve the problem of enabling the process to
080437 - run continuously. I eventually used the dose command suggested
080438 - initially by Morris, to process a maximum of 20 records per pass.
080439 -
080440 - The other day, when I changed the update code to use the same dose
080441 - method, I got the various temporary files out of sync.
080442 -
080443 - Today, I was able to eliminate 1R and 1V and simply use 1W and 1y.
080444 -
080445 - This seems to enable everything to run better.
080446 -
080447 - Simplify, simplify.
080448 -
080449 -
080450 -
080451 -
080452 -
0805 -