Skip to main content

Importing Data from Clientbase / Trams

This article is a guide on what data will be necessary to ensure a clean import into PlanitEasy from Clientbase/Trams using our template.

Written by Robbie

Importing Data from Clientbase / Trams to PlanitEasy

If you're migrating from Clientbase (Trams) to PlanitEasy, our team can help import your client profiles, vendor lists, and reservation data. Here's what you need to know to prepare.

Before You Start

Complete these steps before submitting your data for import:

  1. Create all agents/advisors in your PlanitEasy account first — imported data gets mapped to existing advisors

  2. Export your data from Clientbase as Excel (.xlsx) or CSV files

  3. Clean up your data using the instructions below

Import Order

Data is imported in this sequence:

  1. Vendors/Suppliers list — so reservations can link to the correct supplier

  2. Clients/Profiles list — so trips can link to the correct traveler

  3. Reservation cards (ResCards) — the actual trip/booking data

The goal is to get a master export from Clientbase of ALL ResCards so they can be pulled into PlanitEasy. The file will typically have a name like: allrescardstester - Copy (1).csv

PlanitEasy CB Template / Data Cleanup Requirements

Go to the Profiles page on PlanitEasy and click Import Profiles.

Select the Client Base template and download it to your computer.

Use this template above to import your data.

Before submitting your files, check the following:

  • All columns have the appropriate data in our CLIENTBASE TEMPLATE in PlanitEasy — make sure rows aren't misplaced or shifted.

  • Address fields must be in separate columns — Address, City, State, Zip, Country (do NOT put the entire address in one column)

  • Each vendor must have only ONE travel category — e.g., "Carnival Cruise Line" should be categorized as "Cruise" only, not "Tour, Air & Cruise"

  • Every reservation must have: Trip Status, Start Date, End Date, and Trip Name (only if importing reservations)

  • Phone numbers should be in a consistent format

  • Remove any test or dummy records

Agent/Advisor Mapping

⚠️ Important: Clients and reservations are mapped to existing advisors in PlanitEasy. If an agent in your Clientbase export is no longer with your agency, you must choose a replacement advisor (or the company account) to receive their data.

How to Submit Your Data

  1. Export your Vendors, Clients, and ResCards from Clientbase as CSV or Excel

  2. Clean up the files per the requirements above and use our template

  3. Import using our template.

  4. Reach out with any questions

After the Import

  • Review a sample of imported profiles, vendors, and trips to verify accuracy

  • Check that advisor assignments are correct

  • Use Merge duplicate profiles if any duplicates were created during import

Related Articles

Did this answer your question?