Import & export
Import and export tooling lets you onboard data quickly and pull data out when you need it. It is restricted to admins or to roles granted import/export permission for the entity, and every run is audited and scoped to your organisation.
Importing data
Section titled “Importing data”You can bulk-load master data, such as customers, vendors, items and employees, from CSV or Excel.
- Download the import template for the entity. Each template includes column documentation and sample rows so you know exactly what to enter.
- Fill in your data.
- Upload the file. The import runs in the background; you can watch its progress.
- Each row is validated against the required format and business rules.
- When it finishes, valid rows are saved and invalid rows are skipped: there are no partial records. Download the error report to see the exact row numbers and messages for anything that failed, fix them, and re-upload.
Imports are resilient, a transient hiccup during the run is retried and resumed rather than losing your progress.
Exporting data
Section titled “Exporting data”- Any list can be exported. Per-entity export templates document their columns.
- Small exports download straight away; large exports run in the background and are made available as a download link when ready.
- Both CSV and Excel formats are supported.
Good to know
Section titled “Good to know”- The customer portal role has no access to import or export.
- Field masking still applies to exports, data a role isn’t allowed to see is masked in the exported file too. See Roles & permissions.