| Subject |
Required |
Any text string. Rows missing a subject will be skipped and reported as errors. |
| Description |
Optional |
Free text. HTML is stripped on import. |
| External ID |
Optional |
Alphanumeric identifier from your source system. Used for duplicate detection. |
| Ticket Status |
Optional |
New, Open, In Progress,
Additional, Resolved, Closed
Unrecognised values default to New.
|
| Priority |
Optional |
Normal, Medium, High,
Urgent, Rush
Unrecognised values default to Normal.
|
| Ticket Type |
Optional |
Exact name of an active Ticket Type configured for your company (case-insensitive).
Unmatched values are skipped with a warning; the ticket is still imported.
|
| Channel |
Optional |
Exact name of a Channel configured for your company (case-insensitive).
Unmatched values are skipped with a warning; the ticket is still imported.
|
| For |
Optional |
merchant or lead.
Unrecognised values are omitted (field left blank).
|
| Merchant Visibility |
Optional |
1 / yes / true / visible → visible to merchant.
Any other value → hidden.
|
| Group |
Optional |
Exact name of a Group configured for your company (case-insensitive).
Unmatched values are skipped with a warning; the ticket is still imported.
|
| Assigned To |
Optional |
User's email address (preferred) or full name First Last (case-insensitive fallback).
If the user is not found the ticket is still created; a warning is logged.
|
| Due Date |
Optional |
Any standard date format, e.g. 2025-06-30, 30/06/2025, June 30 2025.
Unparseable values are stored as null.
|
| Created |
Optional |
Original creation date. Same date formats as Due Date.
Overwrites the system-generated creation timestamp on the imported ticket.
|
| Last Modified |
Optional |
Same date formats as Due Date. |
| Last Status Update |
Optional |
Same date formats as Due Date. |
| Outcome |
Optional |
Exact name of an Outcome configured for your company (case-insensitive).
Unmatched values are skipped with a warning; the ticket is still imported.
|