Extended Matrix

Extended Matrix Development Projects

← Back to Roadmap
DP-45

XLSX Auxiliary Data & US Image Resources

Tools v1.5 StratiGraph ↗ EMtoolss3Dgraphy

Description

Support for reading XLSX spreadsheets as auxiliary data files within the EM workflow, and linking images to Stratigraphic Units (US) as documentary resources. EMtools v1.4+ implements XLSX import for stratigraphic data. EMtools v1.5 adds XLSX merge wizard with conflict resolution, epoch compatibility validation, and merge UI. s3Dgraphy supports Excel import/export and Graph Merger with conflict resolution (v0.1.33). Enables richer documentation pipelines where tabular data and photographic evidence complement the stratigraphic graph. Validation pass pending before 1.5 cut: exercise the flow with real pyArchInit and EMdb datasets to flush out schema drift and orphan-matching edge cases. EMtools v1.6 roadmap includes Image Viewing System (JSON-LD, XLSX-based, folder-based).

Status

Incorporated

Target EM Version

1.5

Incorporated in

EM v1.5

Impacts

EMtoolss3Dgraphy

Components

  • XLSX import (EMtools, done since v1.4)
  • XLSX merge wizard with conflict resolution (EMtools v1.5, done)
  • s3Dgraphy Graph Merger with conflict resolution (done, v0.1.33)
  • s3Dgraphy Excel import/export (done)
  • Validation pass on pyArchInit + EMdb real data (pending, blocking 1.5 cut)
  • US image resource linker
  • Image Viewing System (EMtools v1.6, planned)

Key Study

Basilica

Notes

XLSX import and merge wizard functional. Graph Merger in s3Dgraphy. Validation pass with real pyArchInit + EMdb data planned before the 1.5 cut; image resources and Image Viewing System deferred to v1.6.