THE WELCH COMPANY
440 Davis Court #1602
San Francisco, CA 94111-2496
415 781 5700


S U M M A R Y


DIARY: November 30, 1997 00:37 AM Sunday; Rod Welch

Complete develop processor for HTML data base for SDS.

1...Summary/Objective
2...06116 - Integrate 070405 and Fix Errors
3...070405 - Modify to Call from 06116
....Eliminate "Memo" Format for Full Record Below Exec Summary
4...0704013 - Crashing


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

CONTACTS 

SUBJECTS
Configure for network s: drive
Intranet, HTML Code

0504 -    ..
0505 - Summary/Objective
0506 -
050601 - Follow up ref SDS 7 4959, ref SDS 6 1869.
050602 - ..
050603 - Completed first generation processor format SDS records in HTML
050604 - for viewing on a Web Browser, per objective to deliver business
050605 - intelligence as discussed on 971021. ref SDS 4 3636
050606 -
050607 - Found a number of errors in the code from yesterday, ref SDS 7 4959,
050608 - and fixed them.  The main problem is memory.  If there are a lot of
050609 - "large" files, say over 40K, it gets mixed up.
050610 -
050611 -
0507 -
0508 -
0509 - Progress
0510 -
051001 - Incorporate code in 0704050 so it will work with the code in 06116
051002 - which is a little different from the code in 070413 which 070405 was
051003 - originally designed to support.
051004 - ..
051005 - The overall routine in 06116 now runs better than the code
051006 - initially created in 06112 that used both 0704013 and 070405 as
051007 - external calls. ref SDS 5 0702
051008 -
051009 - This code can convert two months of SDS records for the U.S. Army
051010 - Corps of Engineers, account 04 00065, into HTML format. When the
051011 - program ends, we get a message Error Calling Command.Com, which is the
051012 - last command called to delete temporary files.
051013 -
051014 -      [See improvement on 971209 running up to 6 months. ref SDS 10
051015 -      1428]
051016 -
051017 -      [Explanation of overall system on 971206. ref SDS 8 6000.
051018 -
051019 - It is still far from perfect.  It will only do a month of SDS account
051020 - 03 00050.
051021 -
051022 - We also need a way to update the record rather than copy all of the
051023 - records.  We want to get only the ones that have changed.
051024 -
051025 -      [See completion of Update system on 971208. ref SDS 9 0630]
051026 -
051027 - A major problem is the thing crashes when it encounters a defective
051028 - line number field, which can happen when a record is saved and memory
051029 - is close to full.
051030 -
051031 -      Seems like I have fairly recently tried to fix this.
051032 -
051033 -
051034 -
0511 -
0512 -
0513 - Coding
0514 -
051401 -  ..
051402 - 06116 - Integrate 070405 and Fix Errors
051403 -
051404 - Follow up ref SDS 7 5916.
051405 -
051406 - Test record after processing with 070405, ref OF 1 2287,
051407 -
051408 - Problem
051409 -
051410 -    Record for 961016, ref SDS 2 4864, this is crashing.
051411 -
051412 -    Record for 961217, ref SDS 3 1960, system crashed on this record.
051413 -
051414 -    Solution
051415 -
051416 -       Problem seems to have been that the line number field was
051417 -       messed up due to a memory problem when the record was last
051418 -       saved.
051419 -
051420 - Problem
051421 -
051422 -    Record at 960921, ref SDS 1 3521, has no Contacts.
051423 -
051424 -    The code in 06116 is entering a "Contacts" field, and 070405 is
051425 -    crashing because it does not want an empty contact field.
051426 -
051427 -    Line 950 -label lp02v, ref OF 1 5626, the code should figure out
051428 -    there are no contacts, and not enter a Contact field, as in
051429 -    0704013.
051430 -
051431 -
051432 - Problem
051433 -
051434 -    Seems like we are reading record IDs into 1y that are outside of
051435 -    the spec.
051436 -
051437 -    Line 255 -label lpInt1 ref OF 1 2292, testing with debug.
051438 -
051439 -        Was unable to establish this as a problem.
051440 -
051441 -
051442 - Problem
051443 -
051444 -    Seems like the headlines which are entered in the Executive
051445 -    Summary do not have the correct line numbers.  They seem to be two
051446 -    digits off.
051447 -
051448 -    Line 500 -label lpx12, ref OF 1 3008, test with debug.
051449 -
051450 -    Actually that does not turn out to be the case.  There is no
051451 -    problem, the numbers I was examining begin on line 2000...
051452 -
051453 -    Line 360 -label asci, ref OF 1 2287, test 070405 with debug.
051454 -
051455 -    Real problem is that we are changing line number for
051456 -
051457 -                041A - Summary/Objective
051458 -
051459 -        ...so it ends in "A", line 430 -label okY8, ref OF 1 3237,
051460 -
051461 -       This occurs on the first pass to create Executive Summary.
051462 -
051463 -       Then we read the record in again to complete processing for
051464 -       ascii, but we do not change the Summary/Objective line number
051465 -       so it ends in "A".
051466 -
051467 -    Solution
051468 -       ..
051469 -       Line 870 -label dGk, ref OF 1 4008, added routine to
051470 -       change the last char in the line number for Summary/Objective to
051471 -       "A" when the code removes the Control Field lines.
051472 -
051473 - Problem
051474 -
051475 -    Similar problem to 0704013. ref SDS 0 3992
051476 -
051477 -    Solution
051478 -
051479 -       Same as at ref SDS 0 5240 and entered it in 06116 at line 260
051480 -       -label Hdlin. ref OF 1 5253.
051481 -
051482 - Problem
051483 -
051484 -    Not processing current records correctly.
051485 -
051486 -    Solution
051487 -
051488 -       Line 265 -label lpInt1 ref OF 1 3543, the code examines if
051489 -       record is for today, and if so, goes to...
051490 -
051491 -       Line 280 -label 2_day, ref OF 1 2286, changed code here so the
051492 -       Q1 file is opened to load the filename spec.
051493 -
051494 - Problem
051495 -
051496 -    When no record is read, the code is not jumping to the next
051497 -    record.
051498 -
051499 -    Solution
051500 -
051501 -       Line 425 -label ascii, ref OF 1 1666, added code for flag if no
051502 -       record is loaded, and to kick out.
051503 -
051504 -       Line 365 -label asci, ref OF 1 5904, this is where the flag is
051505 -       evaluate that is set at ref OF 1 1666.
051506 -
051507 -
051508 -  ..
051509 - 070405 - Modify to Call from 06116
051510 -
051511 - Follow up ref SDS 5 1350.
051512 -
051513 -
051514 -     ..
051515 -    Eliminate "Memo" Format for Full Record Below Exec Summary
051516 -
051517 -    The reports produced by 06116 have a different format from formal
051518 -    documents issued within an individual SDS record that start with
051519 -    0704013.
051520 -
051521 -    Records produced by 06116 do not have a memorandum heading for the
051522 -    full record, nor do they have a "From" entry.  So the code in
051523 -    0704050 needs to jump over the code that adds HTML to these
051524 -    elements that are not in the records for 06116.
051525 -
051526 -    Line 245 -label LHdr, ref OF 3 3098, jump to Contacts after
051527 -    processing page break between Executive Summary and  main SDS
051528 -    record, since it no longer has a heading, per ref SDS 7 4753,
051529 -
051530 - Problem
051531 -
051532 -    An HTML code string is entered at bottom of record for a link,
051533 -    where none is needed.
051534 -
051535 -    Line 160 -label lp1, ref OF 3 1653, loop for making headline links
051536 -    is here.
051537 -
051538 -    Solution
051539 -
051540 -       Turned out the problem is in 06116 per ref SDS 0 3804,
051541 -
051542 -
051543 -
051544 -  ..
051545 - 0704013 - Crashing
051546 -
051547 - Problem
051548 -
051549 -    The record on 971021 with Tom Keesling is having a problem. ref
051550 -    SDS 13 2410
051551 -
051552 -    Line 40 -label begin, ref OF 2 1666,
051553 -
051554 -    Solution
051555 -       ..
051556 -       Distinguish Headlines from regular underlines.
051557 -
051558 -       Line 230 -label lpyy, ref OF 2 2933, does a fr/-/ to look for a
051559 -       headline.
051560 -
051561 -       This can result in offsetting the screen if, for example, there
051562 -       is a mathametical calculation beyond the column where Medit off
051563 -       sets the screen.
051564 -       ..
051565 -       Line 260 -label Hdlin, ref OF 2 5253, added control to
051566 -       check to see if the screen is offset, to set it back to 0 and to
051567 -       omit this line as a headline.
051568 -
051569 -
051570 - Line 120 -label subjul, ref OF 2 1624, try doing the work in the
051571 - original record instead of stufq.
051572 -
051573 -    This will save memory by avoiding reading the record into memory
051574 -    twice.
051575 -
051576 -    We will get stufq after creating the summary in the original
051577 -    record.
051578 -
051579 -    Finally, decided against this for now, because it requires thinking
051580 -    through a number of related matters that I do not have time today
051581 -    to consider.
051582 -
051583 -
051584 -
051585 -
051586 -
051587 -