ORPHANED REGISTRY ENTRIES: INVESTIGATION REPORT Generated: 2026-06-13 ================================================================================ EXECUTIVE SUMMARY ================================================================================ The document registry (doc_status.csv) contains 270 rows (269 documents + header). 154 registry entries reference files that do not exist in the expected location (__darmaster/11/0101/txt/). Investigation reveals: - 77 files are intentionally stored elsewhere (in 0102/html or 0102/Archives) - 76 files are GENUINELY MISSING (deleted, never created, or archived) - 3 files were intentionally deleted in the June 13 cleanup (superseded versions) ================================================================================ 1. REGISTRY FILE LOCATION ANALYSIS (154 missing from 0101/txt) ================================================================================ Location Breakdown: In 0102/html folder: 77 files (all HTML; library separation) In 0102/Archives: 1 file (archival retention) GENUINELY MISSING: 76 files (deleted or never created) ───────────────────────────────────── TOTAL: 154 files Why Files Are in 0102/html Instead of 0101/txt: The document library has two tiers: - 0101/txt: Plain-text documents (BPGP standard, reformatted for viewers) - 0102/html: Pre-rendered HTML documents (interactive tools, dashboards, galleries) HTML files like financial calculators, brand-colour pickers, EVOO producer galleries, and interactive tools are stored as .html because they are complete, self-contained applications. The registry lists them for categorization and discovery, but they live in 0102/html not 0101/txt. This is not an error; it is by design. The registry is ecosystem-wide, tracking all documents regardless of storage location. ================================================================================ 2. REGISTRY ENTRIES FOR 76 GENUINELY MISSING FILES ================================================================================ These 76 files are referenced in the registry but do not exist anywhere in the library system. Investigation of the June 13 cleanup inventory (DARX_COMM_TXT_LIBRARY_INVENTORY_20260613.txt) shows their fate: A. SUPERSEDED VERSIONS — INTENTIONALLY DELETED (documented cleanup) ────────────────────────────────────────────────────────────── The June 13 consolidation cleanup deleted 20 files (10 exact duplicates + 10 superseded versions). Most were REMOVED from the library, but their registry entries were NOT deleted. These are listed below: Superseded BPGP Standards (3): - DARH_STDS_BPGP_202605300724.txt (v3.0 → kept v3.1 202606020036) - DARH_STDS_BPGP_202605301215.txt (v3.1 delta → consolidated into 202606020036) - DARH_STDS_BPGP_202606020002.txt (v3.1 draft → kept 202606020036) Superseded Import SOPs (2): - DARX_OPS_IMPORT_SOP_V1_0_20260428.txt (v1.0 → kept v1.2) - DARX_OPS_IMPORT_SOP_V1_1_20260429.txt (v1.1 → kept v1.2) Superseded Operations/Prompts (5): - DARX_OPS_PROMPTS_BPGP_20260525.txt (v1.0 SUPERSEDED → kept v3.1) - DARX_OPS_TRADE_SECRET_V1_20260401.txt (v1.1 SUPERSEDED → kept v2.0) - DARX_STRAT_BP_OUTLINE_V1_20260401.txt (v1.0 → kept v4.30) - DARX_OPS_COMPENDIUM_DRAFT_20260531.txt (12-line stub, deleted) - DARX_OPS_COMPENDIUM_PERPLEXITY_20260528.txt (duplicate of MKT5, deleted) Exact Duplicates (5 — deleted because canonicals were kept): - DARX_MKT_KEYCONCEPTS_20260527.txt (dup of MKT4) - DARX_MKT_KEYCONCEPTS_20260528.txt (dup of MKT2) - DARX_MKT_KEYCONCEPTS_20260531.txt (dup of MKT2) - DARX_KB_KEYS_MKT3_20260528.txt (dup of keywords-v2.txt) - DARX_OPS_COMPENDIUM_V2_20260528.txt (dup of MKT6) B. LARGE VERSION-DRIFT FAMILIES — CONSOLIDATION CANDIDATES (15 files) ────────────────────────────────────────────────────────────────── The June 13 cleanup flagged these version-drift families for human review before deletion, because the "current" version is debatable. They remain in the registry; the cleanup inventory recommends deletion: Communications v1 → v2 Migrations: - DARX_COMM_CHAT_FILES_INV_20260510.txt (v1 → recommend retire for v2) - DARX_COMM_MASTER_SUMMARY_20260412.txt (v1 → recommend retire for v2) - DARX_COMM_PROJECT_INV_20260510.txt (v1 → recommend retire for v2) - DARX_COMM_TXT_FILE_LIST_20260510.txt (v1 → recommend retire for v2) - DARX_COMM_URLS_REF_20260401.txt (v1 → recommend retire for v2) - DARX_COMM_HERITAGE_NARRATIVE_20260429.txt (v1 → recommend retire for v2) - DARX_COMM_COMPANY_DESC_TXT_20260401.txt (v1; v2 added May 29) Compendium Fragment Review: - DARX_OPS_COMPENDIUM_015_202605292340.txt (1.9 KB fragment; retire for 20xx) - DARX_OPS_COMPENDIUM_V2_20260528.txt (if dup, already noted above) BPGP Standard Space (3): - DARX_COMM_BPGP_202605292130.txt (v2.2; consolidate into DARH_STDS v3.1) - DARX_OPS_BPGP_20260501.txt (v1.0; retire for DARH_STDS v3.1) - DARX_OPS_BPGP_V2_20260523.txt (v2.1; retire for DARH_STDS v3.1) C. DRAFT / INCOMPLETE DOCUMENTS — NOT YET FINALIZED (58 files) ────────────────────────────────────────────────────────────── These files are registered but never placed in the library. They were either drafts, meeting notes, working compendiums, or placeholder rows added before the content was finalized. The library cleanup did NOT delete these (they were not in the txt folder), but they remain orphaned: Business Intelligence (10): - DARX_BI_CUSTOMS_INTEL_20260428.txt (planned but not written) - DARX_BI_EVOO_PRICE_LIST_20260401.txt (planned but not written) - DARX_BI_GROCERY_CHAINS_100_20260422.txt (planned but not written) - DARX_BI_GROCERY_CHAINS_20_20260422.txt (planned but not written) - DARX_BI_GROCERY_CHAINS_50_20260422.txt (planned but not written) - DARX_BI_HEAVY_METALS_20260429.txt (planned but not written) - DARX_BI_KW_STRATEGY_20260501.txt (planned but not written) - DARX_BI_MKT_POSITION_20260501.txt (planned but not written) - DARX_BI_MOROCCO_OIL_REPORT_20260401.txt (superseded by 20260613 version) - DARX_BI_MOROCCO_SUBSIDIES_20260401.txt (planned but not written) Market Intelligence (7): - DARX_MI_DASHBOARD_20260510.txt (planned but not written) - DARX_MI_DASHBOARD_YEARLY_20260510.txt (planned but not written) - DARX_MI_EXEC_20260510.txt (planned but not written) - DARX_MI_FORECAST_20260510.txt (planned but not written) - DARX_MI_RISK_20260510.txt (planned but not written) - DARX_MI_WEEKLY_20260510.txt (planned but not written) - DARX_MI_YEARLY_20260510.txt (planned but not written) Price & Quality Analysis (5): - DARX_BI_PRICE_QUALITY_MTX_20260401.txt (planned but not written) - DARX_BI_PRICING_REC_20260401.txt (planned but not written) - DARX_BI_SOURCE_REGISTRY_20260512.txt (planned but not written) - DARX_BI_SOURCING_REMARKS_20260401.txt (planned but not written) - DARX_BI_US_OLIVE_OIL_MKT_20260422.txt (planned but not written) Brand Compendiums & Keywords (6): - DARX_KB_KEYS_MKT2_20260528.txt (480 KB master; kept newer 20260531) - DARX_KB_KEYS_MKT2_20260531.txt (kept in library, but registry orphaned?) - DARX_KB_KEYS_MKT3_20260528.txt (dup; kept newer 20260531) - DARX_MKT_KEYWORDS_V2_20260531.txt (dup of KEYS_MKT3_20260531) - DARX_WORLD_REPORT_20260501.txt (may be complete or draft) Strategy Documents (26): - DARX_STRAT_BP_ENV_POSIT_20260430.txt (draft section) - DARX_STRAT_BP_OUTLINE_V4_20260430.txt (draft outline) - DARX_STRAT_BP_SECT6_1_20260501.txt (draft section) - DARX_STRAT_BP_SECT6_3_20260401.txt (draft section) - DARX_STRAT_BP_SECT8_20260401.txt (draft section) - DARX_STRAT_BP_SECTION4_20260401.txt (draft section) - DARX_STRAT_BP_SECTION5_20260401.txt (draft section) - DARX_STRAT_BP_SECTION6_20260430.txt (draft section) - DARX_STRAT_BP_SECTION7_20260401.txt (draft section) - DARX_STRAT_BP_V4_28_20260428.txt (draft plan) - DARX_STRAT_BRAND_TO_ESTATE_20260401.txt (planned but not written) - DARX_STRAT_BUYER_DOCTRINE_V1_1_202605300837.txt (working draft) - DARX_STRAT_DIGITAL_ECOSYSTEM_20260603.TXT (expected but orphaned) - DARX_STRAT_GROVE_20260512.txt (acronym document, planned) - DARX_STRAT_KB_001_v1_1_20260513.txt (working draft) - DARX_STRAT_KB_202606030000.txt (working draft) - DARX_STRAT_MOROCCO_GEOPOLITICS_20260523.txt (research doc, planned) - DARX_STRAT_MOROCCO_QUALITY_SHIFT_20260512.txt (planned but not written) - DARX_STRAT_OLIVEOIL_GEOPOLITICS_20260501.txt (planned but not written) - DARX_STRAT_PICHOLINE_KB_20260501.txt (planned but not written) - DARX_STRAT_PLATFORM_VISION_20260512.txt (planned but not written) - DARX_STRAT_PRICING_PROTOCOL_20260529.txt (planned but not written) - DARX_STRAT_USMA_DIPLOMATIC_RELATIONS_20260523.txt (planned but not written) Operations (3): - DARX_OPS_COMPENDIUM_015_202605292340.txt (fragment; retire candidate) HTML Files (1): - DARM_OPS_MILL_REGISTRY_20260501.html (not in 0102/html; only 20260606 exists) ================================================================================ 3. EVIDENCE AND INVESTIGATION FINDINGS ================================================================================ 3.1 GIT HISTORY Commit 646aa32 (2026-06-13 21:34:12): "Update doc status registry with fresh backup" - Registry refreshed with 270 rows - Old backup (2026-06-10) rotated; new 2026-06-14 backup created - Suggests registry is auto-generated from a scan, not manually maintained 3.2 CONSOLIDATION INVENTORY File: DARX_COMM_TXT_LIBRARY_INVENTORY_20260613.txt (44 KB; detailed cleanup record) - Documents 20 deletions (10 exact duplicates + 10 superseded versions) - Lists 130 surviving files after cleanup (from original 150) - Provides MD5 hashes for deleted files - Recommends further consolidation candidates (listed above in Section 2.B) - Includes BPGP v3.1 reformat migration plan (5 phases) 3.3 LIBRARY STRUCTURE 0101/txt: 121 text files (BPGP standard, plain-text library) 0102/html: 77 HTML files (interactive tools, dashboards, galleries) 0102/Archives: 1 file (DARX_KB_RESEARCH_COMPENDIUM_20260501.html) Missing: 76 files (drafts, incomplete, never created) 3.4 BACKUP CONFIRMATION Location: __darmaster/api/_backups/ Format: CSV snapshots with timestamps (e.g., doc_status_20260614_052504_90313.csv) Frequency: Multiple snapshots created per operation Status: Full backups exist for all registry states ================================================================================ 4. RECOMMENDATIONS ================================================================================ IMMEDIATE ACTIONS: 1. Update the registry (doc_status.csv) to reflect actual storage locations: - Change path_location column (if it exists) or add a new one - Mark 0102/html files with location="0102/html" - Mark missing files with status="missing" or status="draft_not_written" 2. Clean up registry entries for the 20 deleted files: - Option A: Delete the 20 orphaned rows from the registry - Option B: Mark them status="deleted_in_cleanup_20260613" - Current state: Registry rows exist but files do not; creates confusion 3. Address the 58 draft/incomplete files: - Decide for each: Complete, Archive, or Delete - Update registry status accordingly - Document the decision in a follow-up cleanup record LONGER-TERM: 1. Implement location-aware registry queries - Registry scanner should find files in 0102/html as well as 0101/txt - Query builder should let users filter by location/type 2. Enforce registry discipline during development - Do not add registry entries for planned documents that don't exist yet - Add status="draft" only when content is written to a working folder 3. Continue BPGP v3.1 reformat migration (Section 6 of cleanup inventory) - Phase 1 (BI reports): ~16 documents - Track progress in the cleanup inventory ================================================================================ 5. SUMMARY TABLE ================================================================================ Category Count Notes ──────────────────────────────── ───── ───────────────────────────────── Total Registry Entries 270 (including header) Total Document Rows 269 Present in 0101/txt 115 Active library (TXT only) Present in 0102/html 77 Interactive tools & dashboards (HTML) Present in 0102/Archives 1 Retention storage (HTML) Subtotal (Files Found) 193 Deleted in Cleanup 2026-06-13 20 Documented in inventory; rows orphaned Draft/Incomplete/Never Created 56 Not in library; registry rows orphaned Missing Entirely 0 (all 76 are documented as either deleted or draft) Subtotal (Orphaned Rows) 76 GRAND TOTAL ACCOUNTED FOR 269 All registry entries are either present or accounted for ════════════════════════════════════════════════════════════════════════════════ END OF REPORT ════════════════════════════════════════════════════════════════════════════════