Data Import Hub (Archi, XML, CSV, Excel)

Few organizations start enterprise architecture from scratch. Teams frequently possess years of legacy Archi models (.archimate), application inventories in Excel, or exports from commercial tools (Sparx Systems Enterprise Architect, LeanIX, Mega HOPEX, BiZZdesign).

EasyEA’s Data Import Hub consolidates these legacy repositories into a validated graph in minutes.

1. Supported Import Channels

graph LR
    A[Native Archi 4.x/5.x .archimate] --> Hub[EasyEA Data Import Hub]
    B[The Open Group Model Exchange XML] --> Hub
    C[Excel Spreadsheets .xlsx] --> Hub
    D[Standard Tabular CSV] --> Hub
    Hub --> Model[Unified & Validated Graph Repository]

1. Native Archi Files (`.archimate`)

Parses the full folder hierarchy (Strategy, Business, Application, Technology, Motivation, Relations, Views).
Preserves internal GUIDs, documentation blocks, and custom tagged values.

2. The Open Group Model Exchange Standard (XML)

Canonical interoperability standard defined by The Open Group.
Seamlessly ingests models exported from any ArchiMate 3.x-compliant tool with full connector preservation.

3. Excel Spreadsheets (`.xlsx`) & CSV Files

Rapidly bootstrap application inventories:
- Visual Column Mapper: Map spreadsheet headers to EasyEA schema attributes (e.g., Application Name ➔ name, Operating Cost ➔ tco_annual, Hosting Provider ➔ hosting).
- Batch Ingestion: Populate hundreds of assets in a single transactional operation.

2. Deduplication & Conflict Reconciliation

Prior to persisting changes, the engine previews detected assets and lets architects select a merge policy:

Append Only: Inserts novel items while leaving matching existing GUIDs/names untouched.
Merge & Overwrite: Updates attributes of existing items (refreshed TCO numbers, updated vendor SLAs) without severing diagram connections.
Conflict Diagnostics: Flags contradictory layer classifications (e.g., an incoming row classifying an existing ApplicationComponent as a BusinessProcess).

3. Ingestion Audit Trail

Following import completion, EasyEA exports an audit ledger:

Element count breakdown per ArchiMate layer.
Connector count created and verified.
Error log detailing rejected rows with specific validation feedback.