Help · Admin and security
Import your data
Bring parts, suppliers, machines and more in from a CSV or Excel file, and keep them in step with other systems.
You do not have to type your master data. Settings → Integrations imports it for you.
What can be imported
Parts, suppliers, customers, machines, employees, gauge types, gauges, non-conformances, production orders, purchase orders and goods receipts, plus any custom fields you have added. NCs always arrive as drafts.
Import a file
Choose CSV or Excel file and follow the steps:
- Choose the kind of record you are importing.
- Read the file. Fortress works out the encoding and separator. Check the first rows and change the settings if they look wrong.
- Map the columns. Pick the column that identifies each record, then match columns to Fortress fields. Required fields without a source are marked, and each row shows an example from your file. Links to other records, such as a part’s customer, use codes.
- Preview. Nothing is written yet. You see which rows would be added, changed, skipped or rejected, with the reason for each.
- Import.
Choose what an import may do: add new records only, add and update, or update only. Rejected rows stay listed. Fix the source, import again, and rows that have not changed write nothing.
Templates
Your mapping is saved as a template with versions, so next month’s file is one click. Changing a template asks for a reason and makes a new version. Where it is switched on, a formula editor handles values the standard steps cannot.
When the source and Fortress disagree
For each field you choose whether the source wins, Fortress wins, or a person should review the difference. Parked differences wait on the Review page.
Connecting other systems
- REST APIs can be read on a schedule, with API key, bearer, basic or OAuth sign-in.
- The connector agent is a small Windows service you install inside your network. It reads SQL Server, PostgreSQL and MySQL databases, network folders and internal APIs. It only connects outwards, and your database password stays on that machine.
Integrations are managed by people holding a Controller seat. The person who runs an import needs permission to write that kind of record.