These rules apply to importing records into any module. Some modules have extra rules: see Preparing Data for Import (Risks) and Preparing Data for Import (Users).
Warning: Follow these rules carefully. Symbiant has safeguards against bad imports, but a file that gets past them can overwrite or lose data. If you’re unsure, raise a support ticket and we’ll help you through it.
An Example File #
Each row is one record and each column is one field. Here is a small file ready to import into Incidents:

The Rules #
- Save the file as CSV (UTF-8). In Excel, choose File > Save As and pick CSV UTF-8 (Comma delimited) (*.csv).
- One column per field. Multi-level data, such as reviews and actions, can’t be imported in a CSV file.
- Fill in every required field. Reference and Summary are always required. To find a module’s other required fields, open a new record and look for the red asterisks (*). If you try to save an empty record, the required fields show a warning.

- Make references unique. Use only letters, numbers, underscores (_), dashes (-) and dots (.), up to 15 characters, with no spaces.
- Match the case exactly. Values are case sensitive, so
Company/UKis not the same ascompany/uk. - Avoid commas and special characters in column headings and drop-down values. Free-text fields can contain them, as long as the file is saved as UTF-8. Copying and pasting between Office programs can change special characters (such as curly quotes), so check them.
- Write divisions as full paths with a forward slash (/) between levels, for example
Company/UK/Sales. – Include the top (root) division, for exampleCompany. – Don’t include the permission group name, for example notDivisions/Company/UK. - Write dates in UK format, DD/MM/YYYY.
- You can only import into divisions you have access to. To import a record into
Company/UK, your own account must be assigned toCompanyorCompany/UK. - Keep free text under 4,096 characters per field.
- Give checkbox fields a value on every row, for example
trueorfalse. - Owners are optional, but they must already exist as users. Use their full name or email address. Some features, such as reminders, only work once a record has an owner.
Critical: Importing a reference that already exists overwrites that record with the imported version.
