For agencies📥 Portal, Import & Reports

Import your data from another system

Two guided wizards migrate your existing data: Import Your Data builds your customers, groups, locations, and consumers, and the Schedule & Assignment Importer brings in the schedule.

If you're moving from another scheduling system, run Import Your Data first to rebuild your customer directory, then the Schedule & Assignment Importer to bring in jobs. Both read CSV or Excel exports, detect your columns for you, walk you through mapping and review, and are safe to re-run.

Step by step

  1. 1Open Settings, Data & Backups, then Import Your Data. Upload your customer/group export (required) and, if you have them, the contact, location, and assignment files alongside it.
  2. 2Confirm the column mappings for each file; OneTerp guesses them from your headers.
  3. 3Review the suggested customer groupings: departments exported as separate flat entries (for example a college and its finance office) are clustered into one customer with a billing group per department. Rename, split, merge, or skip clusters as needed.
  4. 4Check the preview of what will be created versus updated, download the issues list if anything needs fixing in your file, then commit.
  5. 5Next, open the Schedule & Assignment Importer and upload your schedule export. Rows are grouped into jobs (including multi-interpreter teamed jobs), and each old customer name is resolved to the right customer and billing group; anything ambiguous is flagged for you to pick or skip.
  6. 6Review the preview and commit; past jobs import as history records only, they are never billed or metered.

Tips

  • Your files are read entirely in your browser, so the raw spreadsheet never leaves your device until the reviewed records are saved.
  • Both importers are re-run-safe: matching is by name/identity, so importing the same file twice creates no duplicates and never overwrites details you've since edited.
  • Column mapping is detected from your headers, so most files need only a quick check rather than field-by-field setup. If a preview looks wrong, reset it and remap before you commit.
  • The customer importer can also derive consumers from your assignment file, with the dominant language detected per consumer.
  • There is no interpreter importer anymore: build your roster from the Team Roster tab by inviting interpreters by email or adding placeholders (see the roster article).
  • Excel files import the first sheet only.

Related articles

Still need help?

If this article didn't solve it, submit a ticket and the OneTerp team will follow up.

Submit a ticket
← Back to Help Center