Import and export your data

Bring customers, companies and tickets from another help desk with a CSV file, and export tickets, customers, ratings or everything.

Web
On this page
  1. Import from CSV
  2. What each import does
  3. Export to CSV
  4. Full export

Go to Settings, then Import and export.

Import from CSV

Importing is for admins.

  1. Under Import from CSV, choose the Data: Customers, Companies or Tickets with messages.
  2. Choose the CSV file: UTF-8, separated by commas, semicolons or tabs, with a header row first. At most 4 MB and 5,000 rows; split bigger files.
  3. Check the Columns. Aoun recognises usual column names, in English, French and Arabic and from other help desks. Pick the right Field for any column it did not guess, or Do not import.
  4. Select Check (dry run). Nothing is saved: you see how many rows would be New, Updated or Unchanged, and each problem with its Row number as your spreadsheet shows it.
  5. Fix the file if needed, then select Import.

What each import does

  • Customers: one row per customer; the e-mail address is required. Existing customers keep their values: only empty ones are filled in, if Fill in empty values of existing records is on. A company given by name is created if needed.
  • Companies: one row per company. Domains separated by semicolons link customers by their e-mail address.
  • Tickets with messages: one row per message. Rows with the same Ticket id form one ticket; the first row carries the Subject and the Requester e-mail. Each message's author is found by Message author e-mail: an agent, the requester or another customer. Dates are read in the help desk time zone.

Imported tickets send no e-mail, run no rules and get no SLA targets, so customers are not disturbed. They are tagged imported. If you import the same file again, tickets already imported are skipped and shown as Already imported.

Export to CSV

  1. Under Export to CSV, choose the Data: tickets, customers, companies or Satisfaction ratings.
  2. Optionally set From and To (help desk dates), a status or rating, and a team.
  3. Select Download CSV.

The file opens in any spreadsheet, Arabic included. Only the tickets your role can see are exported, and exporting tickets or ratings needs permission to view reports. Cells that a spreadsheet would run as a formula are written as text, so a customer's message cannot run anything on your computer.

Full export

Admins can select Download JSON under Full export to get everything of the help desk in one file: settings, agents, roles, teams, customers, companies, fields, rules, views, macros, saved replies, the knowledge base, and every ticket with its messages and history.

Secrets are left out (connected mailboxes, webhooks, API tokens, identity secret), and so are file contents: attachments are listed with their name, size and checksum.

Every import and export is recorded in the audit log.