Developer's schemaless CRM intake silently dropped files three times with no errors

A software developer building a personal CRM prototype over a weekend discovered that a schemaless, folder-based file intake system dropped files from the pipeline without raising any errors or warnings. The freeform design, which deferred schema decisions to a later interpretation layer, caused three separate silent failures including an unrecognized directory, a missing date field, and a misfiring keyword classifier. The core problem was that a permissive intake never validates input, so unrecognized or malformed files simply vanish from processing with no trace. The developer's fix was to insert a deterministic index layer between intake and interpretation that records the file path, date, and content hash for every file it encounters, without performing any interpretation itself. This approach turns file-pickup verification into a mechanical, diffable check rather than an assumption, though the solution remains a weekend-scale prototype and has not been tested against production data.