![]() |
The SPORTS PAGE ARCHIVE Serving the Tri-Cities from 1976 to 1984 |
SECTIONS
SPI Menu
100: Full DB List 400: Contact Sheet List 130: Search 800: Documentation You find links to 750 in 100 and 720. 740: Database Records 720: OLD Auto Load 760: DIR CONVERT (2023). 770: Audit issues 710: Test LINE read Directory test FTP test 500-ERROR analysis and tests: "Auto Load" basics to test 500 error Force 500 (NO flush) Error, but NO 500. (with cfFLUSH) SPI-t010 rev 12/01/2023 16:30 |
SPI-0720.cfm rev 12/01/2023 16:35
SPORTS PAGE AUTO LOAD
{ts '2023-12-01 23:44:48'}
Replaced by SPI-0760 Defaults: {ts '2023-12-01 23:44:48'} SPIf_FileNumber [2] SPIf_RunLive [N] SPIuse_Prefix [d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/] This just tells us the folder where the raw files are found. SPI_Raw_list shown in a textarea: This is a list of all the rew files we want to process. The fils are found in the [SPIuse_Prefix] shown above As files are finished, new files are uploaded and we change this list. The list is hand build within this script. SPI_Raw_list has 12 entries. Loop over SPI_Raw_list and build table of contents of the 12 entries: cfloop index="AITix1" from="1" to="12"
BOTTOM OF TABLE OF FILES {ts '2023-12-01 23:44:50'} {ts '2023-12-01 23:44:50'} Default SPIuse_ListItem to 1. (numeric) SPIuse_ListItem [2] SPIuse_FileName [] Original value SPIuse_FileName [04-20-1979_SPORTS PAGE18.txt] RAW VERSION SPIuse_FileName [04-20-1979_SPORTS PAGE18] fixed .TXT SPIuse_FileName [04-20-1979_SPORTS PAGE18] fixed .HTML SPIuse_DataFile [d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/04-20-1979_SPORTS PAGE18.txt] SPIuse_Date [04-20-1979] FIXED [1979-04-20] SPIwk_pageStartCol [23] SPIuse_PageNumber [18] SPIs_Background [ background:pink; ] SPIflag_Include [N] SPIcondition_Inc_1 [next ->] SPIcondition_Inc_2 [<- Previous] SPIcondition_Inc_3 []]]] First] show SPIuse_Date again [1979-04-20] Now show SPI_DteWork [1979-04-20]
TEST FOR FILE EXIST [d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/04-20-1979_SPORTS PAGE18.txt] FILE WAS FOUND Look for SPIcondition_Inc_1 [next ->], SPIcondition_Inc_2 [<- Previous], SPIcondition_Inc_3 []]]] First]
Block contains 5,204 bytes. SPI_DteWork IS a valid date. PROCESS ADD or UPDATE Use date [1979-04-20] Use page [18] TEST RECORD PRIOR TO ADD or UPDATE <cfquery name="SPIq_TestIssue" datasource="MyBayCity" > SELECT * FROM mbc_tsportspage_idx WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '18' </cfquery> SPIq_TestIssue returned 1 stories. SPI_ProgramID [3246] Record AIF. UPDATE that record SPIq_UpdKey: [ SPI_Type = 'P' and SPI_ProgramID = '3246' ] <cfquery name="SPIq_UpdateIssue" datasource="MyBayCity" > UPDATE mbc_tsportspage_idx SET SPI_IssueDate = '1979-04-20', ------ date SPI_Issue_Page = '18', SPI_Issue = '04-20-1979_SPORTS PAGE18', SPI_Type = 'P', SPI_Link = 'CS_1979_04_20.jpg', SPI_Data = '#SPIwk_Block#', SPI_Changed = '2023-12-01 23:44:50', SPI_ChangedBy = 'SPI-0720' WHERE SPI_Type = 'P' and SPI_ProgramID = '3246' </cfquery> Run is NOT LIVE. Record was NOT Updated END OF RIGHT COLUMN, ROW, Table (in t900 rev 05/08/2022 13:46 ) |
0720 Tick Now | 1,701,492,290,084 |
0720 Tick Begin | 1,701,492,288,731 |
0720 Tick Now | 1,353 |
0720 Tick Now | 1,701,492,290,116 |
0720 Tick Begin | 1,701,492,288,731 |
0720 Tick Now | 1,385 |
| |
---|---|
SPI_TickNow | 1,701,492,290,116 |
SPI_TickBegin | 1,701,492,288,731 |
SPI_Elapsed | 1,385 |