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:
Create all agents/advisors in your PlanitEasy account first — imported data gets mapped to existing advisors
Export your data from Clientbase as Excel (.xlsx) or CSV files
Clean up your data using the instructions below
Import Order
Data is imported in this sequence:
Vendors/Suppliers list — so reservations can link to the correct supplier
Clients/Profiles list — so trips can link to the correct traveler
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
Export your Vendors, Clients, and ResCards from Clientbase as CSV or Excel
Clean up the files per the requirements above and use our template
Import using our template.
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
