# meta

key: last_import_report
value:
{"imported_at": "2026-07-22 11:55:12", "source_name": "/Users/andy/Workspace/iCast/Asset/Asset File 12.09.2025 2.xlsx", "sheets": [{"name": "Group 1", "team": "Team #1 \u2014 Jon Fuller, Evan and Shane", "data_rows": 1201, "imported": 1201, "skipped_blank": 1}, {"name": "Group 2", "team": "Team #2 \u2014 David J, Brallan, Olivia and Zach", "data_rows": 2722, "imported": 2722, "skipped_blank": 0}, {"name": "Tools", "team": "Team #3 \u2014 Larry and Noah", "data_rows": 594, "imported": 557, "skipped_blank": 0}, {"name": "Mobile Equipment", "team": "Team #3 \u2014 Jim and Olivia", "data_rows": 55, "imported": 55, "skipped_blank": 0}], "vocab": {"asset_type": 8, "form_id": 32, "area": 12}, "total_rows": 4572, "imported": 4535, "skipped_blank": 1, "normalized": 1, "exception_counts": {"blank area": 290, "blank asset type": 21, "unknown area (imported verbatim)": 19, "missing asset tag (row skipped)": 37}, "exceptions": [{"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 273, "tag": "30270", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 274, "tag": "30271", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 275, "tag": "30272", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 276, "tag": "30273", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 277, "tag": "30274", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 278, "tag": "30275", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 279, "tag": "30276", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 280, "tag": "30277", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 281, "tag": "30278", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 282, "tag": "30279", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 283, "tag": "30280", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 284, "tag": "30281", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 285, "tag": "30282", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 286, "tag": "30283", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 287, "tag": "30284", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 288, "tag": "30285", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 289, "tag": "30286", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 290, "tag": "30287", "value": "Rebar"}, {"issue": "unknown area (imported verbatim)", "sheet": "Tools", "row": 291, "tag": "30288", "value": "Rebar"}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 560, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 561, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 562, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 563, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 564, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 565, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 566, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 567, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 568, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 569, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 570, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 571, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 572, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 573, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 574, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 575, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 576, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 577, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 578, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 579, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 580, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 581, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 582, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 583, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 584, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 585, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 586, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 587, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 588, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 589, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 590, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 591, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 592, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 593, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 594, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 595, "tag": "", "value": ""}, {"issue": "missing asset tag (row skipped)", "sheet": "Tools", "row": 596, "tag": "", "value": ""}]}


key: last_photo_extract_report
value:
{"source": "/tmp/asset_file_source.xlsx", "dry_run": false, "assets_with_photos": 2364, "photos_written": 2591, "orphan_photos": 0, "orphans": [], "sheets": {"Group 1": 1081, "Group 2": 1000, "Tools": 434, "Mobile Equipment": 76}}


key: last_sync_report
value:
{"synced_at": "2026-07-30 02:01:20", "source_name": "Asset File 12.09.2025 2.xlsx", "source_rows": 4535, "added": 0, "updated": 0, "unchanged": 4534, "togen_edits_preserved": 1, "hash_backfilled": 0, "missing_from_source": 0, "details": [{"change": "togen edit preserved", "tag": "40027", "sheet": "Mobile Equipment"}], "parse_exception_counts": {"blank area": 290, "blank asset type": 21, "unknown area (imported verbatim)": 19, "missing asset tag (row skipped)": 37}}


key: last_sync
value:
{"at": "2026-08-18 02:00:54", "status": "ok", "actor": "nightly-scheduler", "error": "", "inbound": {"skipped": "source unchanged since last sync"}, "export": {"target": "Asset File - sync from Togen.xlsx", "assets": 4546, "web_url": "https://icastinc.sharepoint.com/sites/InfrastructurePrecastInc/_layouts/15/Doc.aspx?sourcedoc=%7B65CBA0E3-27CC-4E11-A521-8AF6CBE8B64B%7D&file=Asset%20File%20-%20sync%20from%20Togen.xlsx&action=default&mobileredirect=true"}}


key: sync_settings
value:
{"source_url": "https://icastinc.sharepoint.com/:x:/s/InfrastructurePrecastInc/IQA44iRoyZxGRrSmxwCmwOXoAQkqguLXexn7uxlUXREVKr0", "nightly": true}


key: equipment_migration_report
value:
{"migrated_at": "2026-08-18 20:09:40", "total": 80, "already_linked": 0, "linked_by_asset_no": 0, "linked_by_name": 2, "created": 77, "ambiguous": [{"name": "B&N REBAR CUTTER", "candidates": ["30012", "30147", "30148", "30224", "30225", "30290", "30299"]}], "exception_counts": {"ambiguous name match (not linked)": 1}}


