CRM migration
Field-level mapping, validation, and rollback between The Attorney Case File and Twenty CRM. We move data and schema; workflows are rebuilt natively in Twenty CRM.
The Attorney Case File
Source
Twenty CRM
Destination
Compatibility
11 of 12
objects map 1:1 between The Attorney Case File and Twenty CRM.
Complexity
BStandard
Timeline
48–72 hours
Overview
The Attorney Case File organizes legal work around Cases and Client Workbooks — a structure that prioritizes matter-centric billing and court-date tracking over the contact-opportunity model that Twenty CRM uses. This migration translates that model: clients become Twenty's People objects, cases map to Opportunities or custom objects depending on your pipeline complexity, and billable hours become custom number fields on the case record. We map documents to Twenty Notes, tasks to Twenty Tasks, and surface The Attorney Case File's custom fields as Twenty custom fields so case context carries across. The migration runs via Twenty's REST and GraphQL API at 100–200 calls per minute depending on your tier. We sequence the load so Companies land before People (Twenty's import order requirement) and we resolve attorney and paralegal users by email match against Twenty workspace members. Workflows, email templates, and document templates in The Attorney Case File do not migrate — we export them as a reference package for your team to rebuild in Twenty. A 24–48 hour delta pickup window captures any case updates made during cutover.
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 The Attorney Case File 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.
The Attorney Case File
Client / Contact
Twenty CRM
People
1:1The Attorney Case File clients map directly to Twenty People records. Email, phone, address, and job title fields transfer as-is. The primary attorney assignment in The Attorney Case File becomes a relation field pointing to the attorney user in Twenty's workspace.
The Attorney Case File
Client Organization
Twenty CRM
Company
1:1Corporate clients and law firm organizations map cleanly to Twenty Companies. Company name, domain, industry classification, and employee count fields migrate directly without transformation. Multi-contact relationships that exist in The Attorney Case File collapse to the primary contact link in Twenty's standard data model, requiring manual linking for secondary contacts.
The Attorney Case File
Case / Matter
Twenty CRM
Opportunity
1:1Cases translate to Twenty Opportunities using a practice-area or matter-type field as the pipeline stage source. Case number becomes a custom text field (Case_Number__c) on the Opportunity record for reference. Closed-won and closed-lost statuses from The Attorney Case File map appropriately to Twenty's resolved stage values to maintain workflow continuity.
The Attorney Case File
Case Status
Twenty CRM
Opportunity Stage
1:1The Attorney Case File's status values including Active, Pending, Closed, and On Hold map one-to-one to corresponding Twenty Opportunity stage values. We carefully preserve the original status-changed timestamp as a custom datetime field on the record for reporting continuity and historical tracking purposes.
The Attorney Case File
Billable Hours / Time Entries
Twenty CRM
Custom Object: Time_Entry__c
1:1Billable hours do not have a native Twenty equivalent. We create a custom object (Time_Entry__c) linked to the Case Opportunity with fields for date, hours, rate, description, and billing status. Invoice generation requires rebuilding in Twenty or a connected accounting tool.
The Attorney Case File
Court Dates / Deadlines
Twenty CRM
Task
1:1Court dates and filing deadlines migrate as Twenty Tasks with the original due date preserved and the case Opportunity linked as the parent record. Reminder settings reset to Twenty defaults — The Attorney Case File's custom reminder triggers do not carry over.
The Attorney Case File
Documents / Attachments
Twenty CRM
Note + Attachment
1:1Documents attached to cases in The Attorney Case File are downloaded and re-uploaded to Twenty as file attachments on the associated Opportunity record. Inline document links are replaced with Twenty's native attachment references. Version control history is not preserved through this process — only the latest current version migrates over to Twenty's attachment system.
The Attorney Case File
Notes / Observations
Twenty CRM
Note
1:1Free-form notes from case files migrate as Twenty Notes attached to the related People or Opportunity record. Original timestamps and author attributions are preserved in the Note record metadata. We maintain the full text content and associate each note with its parent record for complete case context accessibility.
The Attorney Case File
Custom Case Fields
Twenty CRM
Custom Field (Opportunity)
1:1Any custom properties on cases in The Attorney Case File — practice area codes, referral source, conflict check status — migrate as Twenty custom fields on the Opportunity object. We create these before migration and map values by type (text, number, select, date).
The Attorney Case File
User / Attorney
Twenty CRM
Workspace Member
1:1Attorneys and staff from The Attorney Case File resolve by email against Twenty workspace members. Unmatched users are flagged before migration — the team either creates their Twenty account or assigns records to a fallback user. Historical owner attribution is preserved on migrated records.
The Attorney Case File
Workflows / Automations
Twenty CRM
Not Migrated
1:1The Attorney Case File's workflow rules for case status triggers, deadline reminders, and document generation templates are not transferable due to platform-specific logic. We export workflow definitions as a structured JSON reference file listing all triggers, conditions, actions, and field dependencies for manual recreation in Twenty's workflow builder by your administrator.
The Attorney Case File
Client Workbook
Twenty CRM
Note + Custom Fields
many:1The client workbook aggregates case context, billing notes, and client preferences in The Attorney Case File. We strategically split this into a Note attached to the People record plus custom fields on the linked Opportunity records, preserving structured data that fits Twenty's relational model while maintaining accessibility to all historical client information.
| The Attorney Case File | Twenty CRM | Compatibility | |
|---|---|---|---|
| Client / Contact | People1:1 | Fully supported | |
| Client Organization | Company1:1 | Fully supported | |
| Case / Matter | Opportunity1:1 | Fully supported | |
| Case Status | Opportunity Stage1:1 | Fully supported | |
| Billable Hours / Time Entries | Custom Object: Time_Entry__c1:1 | Fully supported | |
| Court Dates / Deadlines | Task1:1 | Fully supported | |
| Documents / Attachments | Note + Attachment1:1 | Fully supported | |
| Notes / Observations | Note1:1 | Fully supported | |
| Custom Case Fields | Custom Field (Opportunity)1:1 | Fully supported | |
| User / Attorney | Workspace Member1:1 | Fully supported | |
| Workflows / Automations | Not Migrated1:1 | Fully supported | |
| Client Workbook | Note + Custom Fieldsmany: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.
The Attorney Case File gotchas
No public API — extraction requires vendor coordination
Export envelope is limited to workbook-level records
Trust accounting data is outside the export scope
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
Audit The Attorney Case File data and design Twenty schema
We extract a full export of all clients, cases, documents, notes, time entries, and custom fields from The Attorney Case File. We identify record counts per object, flag multi-party cases, document custom field types and pick-list values, and assess attachment sizes. Simultaneously, we create the Twenty workspace schema: custom fields on Opportunity, the Time_Entry__c custom object, and any custom selects for practice area and billing status. We deliver a schema setup checklist so your Twenty admin can pre-create fields before the migration runs.
Resolve users and attorneys by email match
We build an email lookup table matching The Attorney Case File user accounts to Twenty workspace members. Unmatched attorneys and staff are flagged with a recommendation: invite them to Twenty first, or assign their records to a fallback owner. No case or client record lands in Twenty without an owner — we enforce this constraint throughout the migration to preserve accountability on every record.
Run a sample migration with field-level diff on 100–500 records
We run a representative sample migration covering clients, cases, time entries, documents, and notes. The field-level diff compares source values against destination field values, flags any transformation errors, and surfaces cases that require N-to-N splitting. You review the diff output and confirm case-to-Opportunity mapping, practice area values, and billing status translation before the full run commits. This step catches mapping errors before they affect your entire dataset.
Execute full migration with delta-pickup window
The full migration loads Companies first (Twenty's import order requirement), then People with company links, then Opportunities with case data and custom fields, then Time_Entry__c records linked to Opportunities, and finally documents and notes as attachments. A 24–48 hour delta pickup window runs concurrently, capturing any case updates or new clients created in The Attorney Case File during the cutover. The audit log records every insert, update, and skip so reconciliation is traceable.
Reconcile, validate, and deliver rollback package
Post-migration, we run record-count reconciliation against the source export, spot-check field values on 50 random records, and verify attachment presence on case Opportunities. If reconciliation reveals discrepancies, one-click rollback reverts the Twenty workspace to pre-migration state while The Attorney Case File remains untouched. We deliver the migration audit log, the exported workflow reference JSON, and a handoff document with field mapping decisions for your Twenty admin.
Platform deep dives
The Attorney Case File
Source
Strengths
Weaknesses
Twenty CRM
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 2 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 The Attorney Case File and Twenty CRM.
Object compatibility
2 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
The Attorney Case File: Not publicly documented.
Data volume sensitivity
The Attorney Case File 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 The Attorney Case File to Twenty CRM migration scoping. Not seeing yours? Book a call.
Walk through your The Attorney Case File 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 The Attorney Case File
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.