Import Inspection Equipment in a Structured Way
The new inspection equipment import turns a spreadsheet into a controlled workflow. Memida reads CSV, Excel, and OpenDocument files, recognizes matching columns, checks each row, and shows before saving which data can be imported, corrected, or intentionally skipped.
This makes the import useful not only for initial data migration, but also for regular updates. Existing inspection equipment can be updated via its Memida ID, while new inspection equipment is created from rows that do not yet refer to the existing inventory.
Fig. 1: Import workflow
From Spreadsheet to Checked Import List
The import starts at (1) with file upload. The spreadsheet can be selected or dragged and dropped into the import area. Memida then analyzes the first worksheet and automatically suggests which columns match which inspection equipment fields. Before an import list is created, the field mapping is reviewed at (2): there you can see which file column is assigned to which import field, which mappings can be removed, and which required fields are relevant for new inspection equipment.
This checked mapping creates the import list at (3). Each row receives a clear status: ready, invalid, unchanged, imported, or import failed. From here, individual rows can be corrected, checked again, and then imported deliberately.
This is especially important for historically grown lists. Different spellings, empty fields, old cost centers, or mixed location information become visible before they change the data inventory.
Correct Data Without Leaving the Import
Rows with errors can be edited directly in the import. The editor shows all import fields, detects changes, and automatically checks the row again as soon as values are adjusted. For new inspection equipment, an existing master data record from the system can be selected. Manufacturer, model, and inspection equipment type are then taken from master data.
Fig. 2: Import editor
Domain Rules Remain in Place
The import uses the same domain guardrails as manual creation. New inspection equipment needs an ID no., a model, and a valid cost center. Date values, additional fields, sites, storage locations, cost centers, and calibration information are checked.
Common edge cases are covered as well. If calibration requirement is empty but an inspection interval or next inspection date is set, the calibration requirement is derived from that. If calibration requirement is explicitly "No", contradictory intervals are recognized.
You can find more information about the affected areas in the manual.