Bulk Import via the Excel Mapping Tool

▶ Bulk Import via the Excel Mapping Tool (~~4 min)

Clip: 16 | Duration: ~4 min | Recording segment: ~1:20:30 → 1:24:55

Prerequisites

Auxiliary Resources: pyArchInit and External Data Connections

Overview

Import thousands of SUs from an Excel spreadsheet using a JSON mapping file. The mapping file defines which Excel column maps to which EM property (human ID, material qualia, epoch, etc.). Demonstrated with the Basilica Iulia dataset: 2,039 SUs and 1,088 properties imported in seconds.

Basilica Iulia dataset overview: 2,039 stratigraphic units.

Fig. 54 Basilica Iulia dataset overview: 2,039 stratigraphic units.

Key Concepts

  • The mapping file is JSON: version, sheet name, start row, and column-to-property mappings.

  • Any Excel column can map to: human ID, epoch, node type, or a qualia property.

  • The import creates nodes, connects them, and assigns all mapped qualia automatically.

  • After import, the Visual Manager can filter by any mapped property (e.g., material type).

Screenshots

The JSON mapping file: version, sheet, start row, column definitions.

Fig. 55 The JSON mapping file: version, sheet, start row, column definitions.

Column mapping: Excel column → EM property (human ID, material qualia).

Fig. 56 Column mapping: Excel column → EM property (human ID, material qualia).

Import result: 1,088 properties created in the graph.

Fig. 57 Import result: 1,088 properties created in the graph.

Visual Manager filtering by material type after import.

Fig. 58 Visual Manager filtering by material type after import.

Try It Yourself

Create a mapping file for a 10-row sample spreadsheet and import it into a new EM.

Note

A video walkthrough for this tutorial will be available on the Extended Matrix YouTube channel.

See also

EM Nodes: Stratigraphic Units and Paradata