The 2026-08-13 export holds 177 articles. docs_document holds 161. They disagree, and the export is ground truth.
Also disagreeing: legacy -oolio-help-center URLs 100 (export) vs 101 (registry); titles containing '2.0' 20 (export) vs 27 (registry).
Work:
- Load the snapshot (
scripts/load_hubspot_export.py).
- Diff
hubspot_export against docs_document on url — in HubSpot but not the registry, in the registry but not HubSpot, and fields that differ.
- Populate
docs_document.body_html from the snapshot.
- Correct
docs_document.status — the registry assumes everything is published; the export shows 30 DRAFT and 1 archived.
- Fix the category mapping: export
Category (Back Office, Front of House…) maps to docs_document.section, and export Subcategory to docs_document.category. These are currently inverted in our naming.
The 2026-08-13 export holds 177 articles.
docs_documentholds 161. They disagree, and the export is ground truth.Also disagreeing: legacy
-oolio-help-centerURLs 100 (export) vs 101 (registry); titles containing '2.0' 20 (export) vs 27 (registry).Work:
scripts/load_hubspot_export.py).hubspot_exportagainstdocs_documentonurl— in HubSpot but not the registry, in the registry but not HubSpot, and fields that differ.docs_document.body_htmlfrom the snapshot.docs_document.status— the registry assumes everything is published; the export shows 30 DRAFT and 1 archived.Category(Back Office, Front of House…) maps todocs_document.section, and exportSubcategorytodocs_document.category. These are currently inverted in our naming.