CSV import: bringing data over from your old system

Under Settings → "Import/Export", tab "Import", Gantway takes over existing data from Excel or your old system — only the Admin may run it.

Five data types

You can import employees, articles, workstations, stations and customers. For each type there is "Download template with sample data" — the safest start, because: "Only the mandatory columns need to be filled in." Details on the columns of individual types are in the specialized articles (articles, customers).

For slots and stations, the column type_key sets the type, as an English key such as workbench, area_material or cnc. All valid keys are listed in Types for stations and slots. The column is optional: if it stays empty, the object is created without a type. An unknown key or a type of the other kind (such as cnc in the slot file) marks the row as faulty. With the control room (Premium), imported objects are not placed yet and wait in "Storage" for their spot on the floor plan.

The file rules: "Max. 5 MB, UTF-8, separator: comma or semicolon" — German number and date formats are understood.

The three-step process

1. Upload — choose the file.
2. Preview — Gantway counts: "Valid", "Duplicates (will be skipped)", "Faulty (will be skipped)". Nothing is written, the preview is safe. Above 1,000 rows a note appears that it may take a moment.
3. Result — only the confirmation applies the valid rows.