Bulk import
The "Workforce" tab of "Import data" (Administration › My Organisation) loads from a CSV or an Excel file what you would otherwise have to type one by one: work centres, departments, job positions, people, equipment, contractors, certificates and also the history of a company that comes from another product. If what you have is loose documents, use the "Documents" tab (guide "Import documents").
1. What you can import and in what order
Each card is a data type with its number of columns and two buttons, "Import" and "Download template". The list is provided by the server and, in this order, includes: work centres, departments, job positions, people, equipment and machinery, chemical products, contractors, worker certificates, contractor documents, risk assessments, preventive measures, incidents and accidents, training history, medical examinations and fitness results, PPE, PPE deliveries, inspections, inspection findings, emergency plans and planning activities.
As the screen says, the order matters: first the work centres, then the departments and job positions, and finally the people and equipment, which rely on the previous ones. The history goes after the people it refers to.
2. Preparing and uploading the file
Press "Download template" to get the exact columns and fill it in. Then press "Import" on that card and, on the importer screen, "Choose a file": CSV or Excel (.xlsx or .xlsm) of up to 20 MB. If the file has more than 20 000 rows, only the first ones are read: split it.
If the workbook has several sheets or tables, "Sheet and table to import" lets you choose which one; the header is detected even if it is not in the first row ("Header found on row N"). The importer shows each field next to the column of your file that corresponds to it and an example, and marks what the AI suggested ("Suggested by AI") or took from a previous import. Required fields must have a column; correct the ones that do not match and press "Check".
3. Reviewing and importing
Before checking, "If a row already exists" lets you choose between "Stop and tell me", "Update the existing one" or "Skip it". The check says how many rows there are, how many will be created, how many will be updated and how many have errors, and lists separately the rows that will be imported with warnings. Rows with errors are shown with their line, field and reason and can be downloaded with "Download errors as CSV".
The import is all or nothing: with errors, "Import" is disabled, and the only thing it offers is "Import only the valid rows (N)". When it finishes, "Import complete" summarises what was created, updated and skipped, and offers "Back to the list" or "Import another file".
4. Other entry points and permissions
The importers can also be opened with "Import", in the "More" menu of the lists of Organisation, Departments, Job positions, Workforce, Equipment, Contractors and Certificates. Importing requires being a company administrator: the "Import data" menu is offered only to that role and the server rejects everyone else.