CRM migration
Field-level mapping, validation, and rollback between PANDA Perio and Twenty CRM. We move data and schema; workflows are rebuilt natively in Twenty CRM.
PANDA Perio
Source
Twenty CRM
Destination
Compatibility
11 of 12
objects map 1:1 between PANDA Perio and Twenty CRM.
Complexity
BStandard
Timeline
5–10 business days
Overview
PANDA Perio is clinical dental software — not a CRM — built for periodontists to manage periodontal charting, treatment planning, and automated letter generation. Its data model centers on patient records with 200+ clinical findings per examination, treatment plans structured by procedure phases, and provider notes. There is no native deal pipeline, contact scoring, or opportunity tracking in PANDA Perio. Twenty CRM's open-source model (People, Companies, Opportunities, Notes, Tasks plus unlimited custom objects) requires re-conceptualizing how dental data fits a general CRM schema. FlitStack AI maps PANDA's patient records to Twenty's People object, periodontal examination findings to a custom 'Perio Exam' object with clinical fields, treatment plans to a custom 'Treatment Plan' object, and letters to Notes. Provider and doctor records map to Twenty's People with a role field. We handle the translation through bulk CSV import (up to 10,000 records per file) for smaller practices and API-based batch import for larger datasets. Workflows, letter templates, and automated correspondence logic built in PANDA Perio must be recreated in Twenty's workflow builder post-migration — we export template definitions as reference documentation to assist your admin.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a PANDA Perio object lands in Twenty CRM, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
PANDA Perio
Patient Record
Twenty CRM
People
1:1PANDA's patient record maps directly to Twenty's People object without transformation logic. Patient name, date of birth, contact phone, email address, and physical address fields translate on a 1:1 field basis. Insurance carrier, policy number, group number, and coverage percentage data migrate as custom fields appended to the People record. Referral source information similarly maps to a custom field, preserving the original referring dentist or practice name.
PANDA Perio
Periodontal Chart
Twenty CRM
Custom Object: Perio Exam
1:1PANDA's periodontal examination data — pocket probing depths (6 sites per tooth), recession, clinical attachment level, furcation involvement, and tooth mobility — requires a custom Perio Exam object in Twenty. Each exam record links to a People record via a relation field. The 200+ clinical finding fields map to custom number, select, and text fields within the Perio Exam object.
PANDA Perio
Treatment Plan
Twenty CRM
Custom Object: Treatment Plan
1:1PANDA treatment plans structured by procedure phases (extraction, bone graft, implant placement, restoration) transform into a custom Treatment Plan object linked to People. Each phase becomes a child record or a multi-select field on the Treatment Plan, preserving procedure codes, tooth numbers, and phase descriptions.
PANDA Perio
Clinical Note / Progress Note
Twenty CRM
Notes
1:1PANDA's progress notes and clinical notes migrate to Twenty's Notes object. Each note links to the associated People record and retains the original author (provider), creation timestamp, and formatted note content. Rich-text formatting from PANDA converts to Twenty's note body format.
PANDA Perio
Letter Template / Generated Letter
Twenty CRM
Notes or Custom Object: Letter Archive
1:1PANDA's auto-generated correspondence letters have no direct Twenty equivalent. We preserve generated letter content as Notes linked to People records for reference. The letter template logic (dynamic field substitution from exam findings) must be rebuilt using Twenty's workflow builder or documented for external letter generation.
PANDA Perio
Provider / Doctor
Twenty CRM
People
1:1PANDA provider records (dentist name, credentials, NPI number) map to Twenty's People object with a 'Role' custom field set to 'Provider'. Provider-to-patient associations are preserved via the People-to-People relation where needed, or through the Perio Exam custom object linking patient to provider.
PANDA Perio
Insurance Information
Twenty CRM
Custom Fields on People
1:1PANDA insurance carrier, policy number, group number, and coverage percentages migrate as custom fields on the People record. Dental insurance is a flat structure in PANDA — no separate object — so we flatten it into People-level custom fields rather than creating a related object.
PANDA Perio
Referral Source
Twenty CRM
Custom Field on People + Companies
many:1PANDA referral source (referring dentist name, practice) merges into two Twenty fields: a custom 'Referral_Source__c' text field on People for the individual, and a Companies record created for the referring practice if not already present. This enables tracking both individual referrals and practice-level referral networks.
PANDA Perio
Appointment / Scheduling Data
Twenty CRM
Tasks
1:1PANDA appointment records containing appointment date, assigned provider, procedure type, and operatory assignment map directly to Twenty Tasks linked to People records via the personId relation field. The task title captures the procedure type and date, while task status maps from PANDA's appointment outcome flags: Completed, No-Show, Cancelled, or Rescheduled values translate into Twenty's task status select options, preserving the full appointment history and outcome for each patient.
PANDA Perio
Custom ADA Procedure Codes
Twenty CRM
Custom Field on Treatment Plan
1:1PANDA's ADA billing codes (D7210, D7953, etc.) attached to treatment plan phases migrate as a custom multi-select or text field on the Treatment Plan custom object. These are reference values only — PANDA Perio does not handle billing, so no accounting mapping is required.
PANDA Perio
Practice / Organization
Twenty CRM
Companies
1:1The practice's own organization details, including practice name, primary business address, phone number, and National Provider Identifier (NPI), migrate as a Companies record in Twenty. This Companies record serves as the primary organization entry for the workspace, establishing the practice as an entity within the CRM. For multi-location dental practices, FlitStack creates a separate Companies record for each physical practice location, enabling location-level tracking of patients, providers, and appointments while maintaining a unified view across the organization.
PANDA Perio
Comparison Charting History
Twenty CRM
Custom Object: Perio Comparison
1:1PANDA's multi-visit comparison charting (viewing up to 5 visits simultaneously, adjusting baseline post-surgically, graphical comparison of probing and mobility) requires a custom Perio Comparison object. Each comparison links multiple Perio Exam records and stores the baseline exam reference as a relation field.
| PANDA Perio | Twenty CRM | Compatibility | |
|---|---|---|---|
| Patient Record | People1:1 | Fully supported | |
| Periodontal Chart | Custom Object: Perio Exam1:1 | Fully supported | |
| Treatment Plan | Custom Object: Treatment Plan1:1 | Fully supported | |
| Clinical Note / Progress Note | Notes1:1 | Fully supported | |
| Letter Template / Generated Letter | Notes or Custom Object: Letter Archive1:1 | Fully supported | |
| Provider / Doctor | People1:1 | Fully supported | |
| Insurance Information | Custom Fields on People1:1 | Fully supported | |
| Referral Source | Custom Field on People + Companiesmany:1 | Fully supported | |
| Appointment / Scheduling Data | Tasks1:1 | Fully supported | |
| Custom ADA Procedure Codes | Custom Field on Treatment Plan1:1 | Fully supported | |
| Practice / Organization | Companies1:1 | Fully supported | |
| Comparison Charting History | Custom Object: Perio Comparison1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
PANDA Perio gotchas
No public API — database extraction requires SQL Server access
SQL Server Express 10GB limit can be migration-blocking
Open Dental bridge passes IDs only, not clinical data
Treatment plan PMS codes differ from clinical letter descriptions
Custom periodontal findings are practice-specific
Twenty CRM gotchas
Import order is enforced and critical
Export limited to 20,000 records and visible columns only
Soft-deleted records count toward uniqueness and trigger restores
API rate limits cap at 200 req/min on Organization tier
No native email sequences — follow-up cadences require external tools
Pair-specific challenges
Migration approach
Extract PANDA Perio data via SQL Server connection
FlitStack connects to your PANDA SQL Server database with read-only credentials to extract the full patient record table, periodontal charting examination data, treatment plans, clinical notes, provider records, and practice organization data. We pull data in a single pass with original timestamps and provider associations preserved. For practices using cloud-hosted PANDA Lite, we coordinate with PANDA support to obtain data exports or provide a structured export template.
Design Twenty custom objects and field schema
Before any data moves, FlitStack delivers a Twenty Data Model setup plan specifying the Perio Exam custom object (with all clinical field definitions: probing depths, recession, CAL, furcation class, mobility grade, BOP, plaque index), the Treatment Plan custom object (with procedure code, tooth number, phase description, plan status), and all custom fields on the People record (insurance fields, referral source, source chart number). Your Twenty admin creates these via Settings → Data Model — FlitStack provides the exact field names, types, and pick-list values required.
Import in dependency order: Companies → People → Opportunities → Custom Objects
We execute the migration in Twenty's required sequence. Companies (practice locations) import first. People records (patients and providers) import second with email or chart number as the unique identifier. Treatment Plans import third, linked to People records. Perio Exam records import last, linked to both People and provider. For practices exceeding 10,000 records per CSV file, we use Twenty's GraphQL API import with batch processing at 200 calls per minute on Pro tier.
Run sample migration with field-level validation
A representative slice of 100–500 patient records migrates first — spanning patients with single exams, multiple exam visits, and complex treatment plans. We generate a field-level diff between the PANDA source and the Twenty destination, verifying that charting measurements map correctly, treatment plan phases link to the right patient, and provider associations resolve. You review the sample before the full migration commits.
Full migration with delta pickup and letter archive
The full dataset migrates to Twenty. A delta-pickup window captures any new patients or exam data added in PANDA during the cutover period. We also export previously generated letter content as Notes linked to People records for reference. An audit log captures every record imported, and one-click rollback is available if reconciliation uncovers mapping errors. Post-migration, we deliver a letter-template documentation file summarizing PANDA's dynamic letter logic for your team to rebuild in Twenty's workflow builder.
Platform deep dives
PANDA Perio
Source
Strengths
Weaknesses
Twenty CRM
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across PANDA Perio and Twenty CRM.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
PANDA Perio: Not publicly documented.
Data volume sensitivity
PANDA Perio doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during PANDA Perio to Twenty CRM migration scoping. Not seeing yours? Book a call.
Walk through your PANDA Perio to Twenty CRM migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave PANDA Perio
Other ways to arrive at Twenty CRM
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.