Stax Digital Garden

LOG-1010 - Liberating Proprietary Daily Notes: Parsing Roam and Day One Archives

2 min read

Living Document Notice
Published 2026-09-17. The evolving architecture, revisions, and connected notes for this dispatch live in the Stax Digital Garden.

Liberating Proprietary Daily Notes: Parsing Roam and Day One Archives

Liberating Proprietary Daily Notes: Parsing Roam and Day One Archives: Dual-trace Phosphor P7 monochromatic ice blue and P4 paper white vector CRT macro showing recursive JSON graph tree deconstructions, proprietary schema liberation filter funnels, and plain-text structural coordinate grids

Engineers seeking data sovereignty often possess years of daily entries locked inside proprietary walled gardens like Roam Research (JSON graph dumps) or Day One (plist / proprietary SQLite schemas). Migrating these archives into clean markdown files requires deterministic parsing that reconstructs accurate temporal metadata.

Roam Research JSON Graph Deconstruction

Roam structures daily notes as hierarchical trees nested under title: "September 17th, 2026". The Logbook liberation script parses the tree recursively, flattening block references into standard markdown lists:

import json
from datetime import datetime
 
def convert_roam_date(title_str):
    # Strip ordinal suffixes (1st, 2nd, 3rd, etc.)
    clean_str = "".join([c for c in title_str if not c.isdigit() or c in "0123456789 "])
    return datetime.strptime(clean_str.strip(), "%B %d %Y").strftime("%Y-%m-%d")
 
def flatten_children(children, indent=0):
    lines = []
    for child in children:
        prefix = "  " * indent + "- "
        lines.append(prefix + child.get("string", ""))
        if "children" in child:
            lines.extend(flatten_children(child["children"], indent + 1))
    return lines

Every extracted daily node is written directly into the appropriate year/month directory with correct ISO timestamps.

Preserving Media and Location Geometry

Day One exports include GPS coordinates, weather tags, and embedded image UUIDs. Logbook maps these into standardized YAML frontmatter:

---
title: "2024-06-12"
date: 2024-06-12
source: day_one_liberated
geo:
  lat: 45.5152
  lon: -122.6784
weather:
  temp_c: 21.5
  condition: clear
---

Images are extracted from the zip payload, renamed with SHA256 hashes, and placed into the local assets/ directory. By transforming proprietary silos into plain text, decades of personal journaling are insulated against vendor shutdown, subscription price hikes, and proprietary database corruption.

  • Directus Target: logbook
  • Garden Source Reference: MOC - Daily Log & Chronological Journal, MOC - Bosun PKM Tools
  • Garden Source Reference: [LOG-1010 - Liberating Proprietary Daily Notes - Parsing Roam and Day One Archives](LOG-1010 - Liberating Proprietary Daily Notes - Parsing Roam and Day One Archives)

Graph View