CRM migration

Migrate from PANDA Perio to Twenty CRM

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 logo

PANDA Perio

Source

Twenty CRM

Destination

Twenty CRM logo

Compatibility

92%

11 of 12

objects map 1:1 between PANDA Perio and Twenty CRM.

Complexity

BStandard

Timeline

5–10 business days

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

PANDA Perio logo

PANDA Perio

What's pushing teams away

  • The on-premise-only deployment requires dedicated Windows Server infrastructure and IT maintenance, pushing cost-conscious practices toward cloud-based alternatives with no local setup overhead.
  • No public REST API means integrations beyond Open Dental must be custom-built and maintained, frustrating practices that need bidirectional data flow with modern cloud platforms.
  • The small vendor team — three named employees with a 2-person management structure — raises concern for practices worried about long-term support continuity and software updates.
  • Larger multi-clinic periodontal groups report that SQL Server Express hits its 10GB database limit sooner than expected, forcing a costly SQL Server upgrade with no clear migration path documented.

Choosing

Twenty CRM logo

Twenty CRM

What's pulling them in

  • Top open-source CRM on GitHub with 40.6K stars, giving teams full source code access and infrastructure ownership without per-feature licensing surprises.
  • Free self-hosting under AGPL-3.0 means unlimited users and custom objects for the cost of cloud infrastructure alone, typically $20–100/month.
  • Pricing page explicitly mocks competitors for charging add-on fees for API access, webhooks, and workflows — transparency that resonates with RevOps teams burned by Salesforce.
  • Unlimited custom objects and fields with no price impact, letting teams shape the data model to their business rather than forcing business into rigid schemas.
  • Modern TypeScript/React/PostgreSQL stack means developer-led teams can extend, self-host, or integrate without fighting legacy architecture.

Object mapping

How PANDA Perio objects map to Twenty CRM

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

maps to

Twenty CRM

People

1:1
Fully supported

PANDA'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

maps to

Twenty CRM

Custom Object: Perio Exam

1:1
Fully supported

PANDA'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

maps to

Twenty CRM

Custom Object: Treatment Plan

1:1
Fully supported

PANDA 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

maps to

Twenty CRM

Notes

1:1
Fully supported

PANDA'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

maps to

Twenty CRM

Notes or Custom Object: Letter Archive

1:1
Fully supported

PANDA'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

maps to

Twenty CRM

People

1:1
Fully supported

PANDA 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

maps to

Twenty CRM

Custom Fields on People

1:1
Fully supported

PANDA 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

maps to

Twenty CRM

Custom Field on People + Companies

many:1
Fully supported

PANDA 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

maps to

Twenty CRM

Tasks

1:1
Fully supported

PANDA 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

maps to

Twenty CRM

Custom Field on Treatment Plan

1:1
Fully supported

PANDA'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

maps to

Twenty CRM

Companies

1:1
Fully supported

The 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

maps to

Twenty CRM

Custom Object: Perio Comparison

1:1
Fully supported

PANDA'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.

Gotchas + challenges

What specifically takes care here

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 logo

PANDA Perio gotchas

High

No public API — database extraction requires SQL Server access

High

SQL Server Express 10GB limit can be migration-blocking

Medium

Open Dental bridge passes IDs only, not clinical data

Medium

Treatment plan PMS codes differ from clinical letter descriptions

Low

Custom periodontal findings are practice-specific

Twenty CRM logo

Twenty CRM gotchas

High

Import order is enforced and critical

High

Export limited to 20,000 records and visible columns only

Medium

Soft-deleted records count toward uniqueness and trigger restores

Medium

API rate limits cap at 200 req/min on Organization tier

Low

No native email sequences — follow-up cadences require external tools

Pair-specific challenges

  • Periodontal charting data requires extensive custom object creation in Twenty

    PANDA Perio's core value — 200+ clinical findings per examination across six probing sites per tooth — has no native equivalent in Twenty CRM. Each practice's charting configuration must be modeled as custom fields on a Perio Exam custom object before CSV import can begin. If your practice uses customized finding sets (beyond standard probing, recession, furcation, and mobility), each custom finding requires a new custom field. This pre-configuration work is the longest planning step in a PANDA-to-Twenty migration and must be completed before any data import runs. FlitStack delivers a custom object and field creation plan as part of the migration engagement.

  • Import order constraints requireCompanies → People → Opportunities → Custom Objects sequence

    Twenty's CSV import enforces referential integrity: parent records must exist before child records can reference them via ID. This means practices must import Companies (practice locations), then People (patients and providers), then any Opportunities, and only then the custom Perio Exam and Treatment Plan objects. For practices with 10,000+ patient records, this creates a staged migration timeline where data validation occurs across multiple import passes. Additionally, soft-deleted records in Twenty still count toward uniqueness checks — importing a record with the same email as a previously deleted patient will restore the deleted record.

  • Letter template logic does not migrate and has no Twenty equivalent

    PANDA Perio's signature feature — auto-generating dynamic correspondence letters from exam findings in real time — is a template-and-logic construct that does not export as data. There is no Twenty-native equivalent for this automated letter generation. We preserve the content of previously generated letters as Notes linked to People records, but the template definitions (which findings trigger which letter sections, conditional paragraphs, referring-dentist formatting) must be rebuilt using Twenty's workflow builder or documented for external letter generation. This is a post-migration rebuild item that typically requires 1–2 weeks of practice-admin time.

  • PANDA's SQL Server backend requires custom extraction; no documented REST API

    Unlike CRMs with well-documented APIs (Salesforce, HubSpot), PANDA Perio's data extraction relies on its SQL Server backend. FlitStack connects directly to the PANDA database to extract patient records, charting data, and treatment plans. This requires read-only database credentials and network access to the PANDA server. Practices using PANDA Lite (cloud-hosted by PANDA) may have limited direct database access — in those cases, extraction relies on PANDA's built-in export functionality or manual CSV exports, which may not capture all charting fields in a single pass.

  • Multi-tooth per-exam records expand record count beyond patient count

    A single PANDA periodontal exam generates 32 teeth × 6 sites = 192 individual probing measurements, plus recession, furcation, and mobility fields. In Twenty's flat custom object model, each exam is one record, but if your practice prefers per-tooth exam records, the migration multiplies record counts significantly. A practice with 3,000 active patients and 5 years of exam history could be importing 15,000+ Perio Exam records. At Twenty's CSV limit of 10,000 records per file, practices at this scale need to batch imports or use the API import method.

Migration approach

Six steps for a successful PANDA Perio to Twenty CRM data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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

Context on both ends of the pair

PANDA Perio logo

PANDA Perio

Source

Strengths

  • Comprehensive tooth-by-tooth periodontal charting with 200+ clinically relevant findings in a single chart view.
  • Real-time letter generation directly from charting data, eliminating manual transcription for referral correspondence.
  • Treatment-plan memorization learns individual clinician phrasing, reducing repetitive typing over time.
  • Comparison charting across up to 5 historical visits with adjustable surgical baseline, unique among periodontal tools.
  • Clinical Workflow Manager flags overdue charts and generates task lists from charting entries, improving recall compliance.

Weaknesses

  • On-premise Windows/SQL Server deployment only — no cloud hosting, SaaS option, or macOS/Linux support.
  • No public API documented; data extraction requires direct SQL Server database access or Open Dental bridge export.
  • Small vendor team of fewer than 10 employees raises long-term viability and support responsiveness concerns.
  • Pricing is per-workstation and per-month, which scales cost higher for multi-location practices faster than per-provider SaaS models.
  • No mobile or tablet-native application; only Windows-based Tablet PC support, limiting hardware flexibility.
Twenty CRM logo

Twenty CRM

Destination

Strengths

  • AGPL-3.0 open-source license with full source code on GitHub — no vendor lock-in, no sunset risk.
  • Unlimited users and unlimited custom objects on self-hosted, with no feature gating based on headcount.
  • REST and GraphQL APIs available on all paid tiers, not locked behind an enterprise add-on fee.
  • MCP server and webhooks shipped as standard features, not premium upgrades.
  • Modern PostgreSQL-backed data model that developer teams can query, extend, and self-host.

Weaknesses

  • Recent v1.0 release means limited production hardening compared to CRMs with multi-year operational track records.
  • No native email sequencing or sales engagement tools — follow-up cadences require a separate platform.
  • No native two-way email sync or inbox integration, requiring third-party connectors for full activity logging.
  • Self-hosting 'free' pricing hides real infrastructure and DevOps costs that stack up over time.
  • Workflow automation is functional but lacks the complexity needed for sophisticated multi-step sales motions.

Complexity grading

How hard is this migration?

Standard CRM migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across PANDA Perio and Twenty CRM.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    PANDA Perio: Not publicly documented.

  • Data volume sensitivity

    B

    PANDA Perio doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your PANDA Perio to Twenty CRM migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about PANDA Perio to Twenty CRM data migrations

Answers to the questions buyers ask most during PANDA Perio to Twenty CRM migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Most PANDA Perio to Twenty CRM migrations complete in 5–10 business days for practices with under 25,000 patient records. The longest phase is designing and creating the custom Perio Exam and Treatment Plan objects in Twenty's Data Model settings before data can import. Practices exceeding 25,000 records or those with multi-year exam histories extending to 5+ visits per patient typically require 3–5 weeks. The custom object schema setup alone takes 3–7 days depending on the number of charting fields your practice uses.

Adjacent paths

Related migrations to explore

Ready when you are

Move from PANDA Perio.
Land in Twenty CRM, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day