Voice‑Activated File Touch System — High School Technology Class

1. What the System Does

The program touch.exe runs once every minute (1 beat per minute). But it only activates when the PC microphone detects a voice.

When voice is detected:

It downloads a list of files from:
https://delacruz.belliniseven.ai/krollOntrack/TXT/selectFiles.txt
It “touches” each file — meaning it updates the timestamp.
It updates a SQLite database:
https://delacruz.belliniseven.ai/krollOntrack/DB/taggedFiles.db
It logs which files were touched and when.

After updating the database, an Intranet HTML Portal displays all the files stored in the database.

2. How the Python Script Works (Conceptual)

This is the basic logic the Python script follows:

# 1. Listen to microphone
if microphone_detects_voice():
    # 2. Download list of files
    files = download("selectFiles.txt")

    # 3. Touch each file (update timestamp)
    for f in files:
        touch(f)

    # 4. Update SQLite database
    update_db("taggedFiles.db", files)

    # 5. Wait 1 minute and repeat

The script repeats this cycle forever, but only runs the “touch” operation when your voice is detected.

3. The Intranet Portal

After the database is updated, the school’s local intranet displays a webpage listing all touched files. This page is automatically refreshed whenever new files are added.

Below is a sample output of what the portal might look like.

Sample Intranet Portal Output

Database: taggedFiles.db

File Name	Last Touched	Status
report_001.txt	2026‑06‑06 14:02:11	Updated
casefile_A12.txt	2026‑06‑06 14:02:11	Updated
notes_final.txt	2026‑06‑06 14:02:11	Updated

4. Why This Matters

This project teaches students how to combine:

Microphone input detection
File operations
Database updates
Automation timing (1 beat per minute)
Web‑based intranet dashboards

These are real‑world skills used in IT, cybersecurity, automation engineering, and enterprise software development.