CRM migration

Migrate from Legal Files to Twenty CRM

Field-level mapping, validation, and rollback between Legal Files and Twenty CRM. We move data and schema; workflows are rebuilt natively in Twenty CRM.

Legal Files logo

Legal Files

Source

Twenty CRM

Destination

Twenty CRM logo

Compatibility

100%

12 of 12

objects map 1:1 between Legal Files and Twenty CRM.

Complexity

BStandard

Timeline

48–72 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Legal Files organizes legal work around matters, parties, documents, and deadlines. Twenty CRM uses a standard object model — People, Companies, Opportunities, Tasks — with a runtime custom data model that lets you add custom objects and fields without SQL migrations. The core challenge in this migration is translating Legal Files' matter-centric structure into Twenty's entity-relationship model: matters become either custom objects or Opportunities depending on whether they track revenue; parties map to People; document references migrate as text fields pointing to your chosen document storage; and deadlines become Tasks linked to the relevant record. We preserve the original matter number, filing date, responsible attorney, opposing counsel, and case status as custom fields in Twenty. Custom properties built in Legal Files' schema builder translate to custom fields in Twenty's Settings → Data Model. We do not migrate workflows, automated rules, or email templates — those must be rebuilt in Twenty's workflow engine. Our migration runs against Legal Files' database export or API, sequences the load into Twenty in dependency order (Companies → People → Custom objects → Tasks), runs a sample diff, then executes the full migration with a 24–48 hour delta pickup for in-flight changes.

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

Legal Files logo

Legal Files

What's pushing teams away

  • Reviewer feedback consistently flags the UI as 'outdated' and notes the platform 'may work better with Windows than Mac' — modern Mac-first in-house teams find this friction-heavy.
  • Initial learning curve is described as tricky; onboarding new users takes more time than reviewers expect from a 2020s SaaS product.
  • Enterprise pricing model ($100/user/month + $49/month base fee, billed annually) becomes expensive at scale and lacks transparent lower tiers for smaller teams.
  • Modern integration ecosystem is narrower than newer competitors — packaged connectors to popular SaaS tools are limited compared to native cloud-first platforms.
  • Primary value proposition skews to centralized matter management rather than collaborative or AI-driven workflows, so teams chasing AI demand drafting or generative review features migrate away.

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 Legal Files objects map to Twenty CRM

Each row shows how a Legal Files 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.

Legal Files

Matter

maps to

Twenty CRM

Custom Object (Matter) or Opportunity

1:1
Fully supported

Legal Files matters map to a Twenty custom object named Matter when the matter tracks legal case data (status, court, opposing counsel). When the matter also represents a revenue-generating engagement, it maps to Twenty's Opportunity object with the custom Matter object linked as a related record. We create the custom object in Twenty's Settings → Data Model before migration runs.

Legal Files

Party (Plaintiff, Defendant, Third Party)

maps to

Twenty CRM

People

1:1
Fully supported

All party roles — plaintiff, defendant, third party, interested party — map to Twenty's People object. The party role type migrates as a custom select field (PartyRole__c) so you can filter by role in Twenty views. Multiple parties on one matter link via the custom Matter object's N:1 relationship to People.

Legal Files

Attorney / Responsible Attorney

maps to

Twenty CRM

People

1:1
Fully supported

Attorney records from Legal Files migrate as People records with a custom field (AttorneyRole__c) set to 'Responsible Attorney' or 'Of Counsel' based on the source role. Attorney bar number, firm name, and contact info map to standard and custom fields on the People record. Attorney email is used for Twenty Workspace Member resolution.

Legal Files

Opposing Counsel

maps to

Twenty CRM

People

1:1
Fully supported

Opposing counsel migrates as a People record with AttorneyRole__c set to 'Opposing Counsel'. Firm name, address, phone, and email map to standard and custom fields. Opposing counsel records are flagged separately in Twenty views so your team can distinguish them from your own attorneys.

Legal Files

Document Reference

maps to

Twenty CRM

Note or Custom Text Field

1:1
Fully supported

Legal Files stores documents with version history inside the matter. Since Twenty has no native document management, we preserve the original document path or URL as a text field on the related Matter record (DocumentRef__c). Your team chooses whether to keep files in existing storage and link by path, or re-upload to a connected storage solution post-migration.

Legal Files

Deadline / Court Date

maps to

Twenty CRM

Task

1:1
Fully supported

Court dates, filing deadlines, and statute of limitations from Legal Files migrate as Twenty Tasks linked to the Matter custom object. The due date maps to Task dueDate, and the deadline description maps to Task subject. Task status tracks completion; incomplete deadlines appear as open tasks in Twenty's kanban or list view.

Legal Files

Matter Note / Case Note

maps to

Twenty CRM

Note

1:1
Fully supported

Free-form case notes from Legal Files migrate as Twenty Notes attached to the corresponding Matter custom object. Note body preserves text content; author and create date map to Note metadata. Rich-text formatting is simplified to plain text where the original contains unsupported markup.

Legal Files

Insurance Carrier / Billing Reference

maps to

Twenty CRM

Custom Field on Matter

1:1
Fully supported

Insurance carrier name, policy number, and billing reference from Legal Files have no direct Twenty equivalent. We create custom text fields on the Matter custom object (InsuranceCarrier__c, PolicyNumber__c, BillingReference__c) and preserve the values during migration. Billing integration requires separate configuration in Twenty.

Legal Files

Court / Jurisdiction

maps to

Twenty CRM

Custom Field on Matter

1:1
Fully supported

Court name, jurisdiction, and venue from Legal Files migrate as custom select fields on the Matter object (Court__c, Jurisdiction__c). The court address maps to a custom text field if present. These fields enable filtering by jurisdiction in Twenty's table or kanban views.

Legal Files

Custom Matter Property

maps to

Twenty CRM

Custom Field on Matter

1:1
Fully supported

Any custom fields defined in Legal Files' schema builder (e.g., CaseType, StatuteOfLimitations, TrialDate) map to identically named custom fields on the Twenty Matter custom object. Field type mapping follows: text → TEXT, number → NUMBER, date → DATE, picklist → SELECT. The custom fields must be created in Settings → Data Model before import.

Legal Files

Legal Files User / Staff

maps to

Twenty CRM

Workspace Member

1:1
Fully supported

Legal Files user accounts (attorneys, paralegals, administrative staff) map to Twenty Workspace Members. Resolution is by email address — if a Legal Files user email matches an existing Twenty Workspace Member, records assign to that user; otherwise the user is flagged and must be invited to Twenty before migration commits.

Legal Files

Matter Association (N:N Parties to Matters)

maps to

Twenty CRM

Custom Junction Object

1:1
Fully supported

Legal Files supports multiple parties linked to one matter and one party linked to multiple matters (N:N). Twenty's standard model is N:1 (one Company per People record via companyId). We handle this by creating a custom junction object (MatterParty__c) with relations to both Matter and People, preserving the full association graph from Legal Files.

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.

Legal Files logo

Legal Files gotchas

High

No API — migration requires direct SQL Server database access

High

Document file transfer is separate from database migration

Medium

Email routing rules do not auto-migrate

Medium

Custom field discovery requires schema inspection

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

  • Twenty ships with minimal standard fields — custom fields must exist before import

    A documented GitHub issue (#13953) notes that Twenty's People and Companies objects arrive with fewer standard fields than comparable CRMs — no built-in jobTitle, department, source, or tags on People by default. When migrating from Legal Files, your party names, addresses, and attorney contact details must be mapped to fields that first need to be created in Settings → Data Model. If you attempt to import before creating the fields, the import silently skips unmapped columns. FlitStack AI creates the full field schema in your Twenty workspace before any data loads, so unmapped columns do not occur.

  • Import order is enforced — Companies must precede People, People must precede Matters

    Twenty's CSV import enforces referential integrity: a People record with a companyId link requires the Company record to exist first, and a Matter custom object linked to a People record requires the People record to exist. Legal Files has no such constraint — parties and attorneys can be created independently. FlitStack AI sequences the migration in dependency order: Companies → People → Custom Objects (Matter) → Tasks. Attempting to import out of order results in validation errors that block the import. We deliver a sequenced import plan with CSV files labeled by load order.

  • Document file storage is not migrated — only references transfer

    Legal Files stores documents inside the matter context with version control and access controls. Twenty CRM has no native document management system — file attachments are basic, and there is no version history. FlitStack AI migrates the document file path or URL as a text field (DocumentRef__c) on the Matter record. The actual files must be re-hosted in your chosen storage (SharePoint, Google Drive, S3) post-migration, and your team updates DocumentRef__c with the new location. Document content, version history, and access permissions do not transfer automatically.

  • Workflows, automated rules, and email templates do not migrate

    Legal Files automated rules for deadline notifications, matter assignments, and status change triggers are platform-specific constructs that have no equivalent in Twenty's workflow engine. Twenty's workflow builder supports triggers (record creation, field change, scheduled) and actions (create record, update field, send webhook), but the logic is entirely new. Email templates from Legal Files must be recreated manually. FlitStack AI can export your Legal Files rule definitions as a reference document for your Twenty admin to use during the workflow rebuild phase, but the rules themselves do not transfer.

  • N:N party-to-matter associations require a custom junction object

    Legal Files supports multiple parties linked to a single matter (e.g., three defendants on one case) and a single party linked to multiple matters (e.g., one plaintiff with five matters). Twenty's standard People-to-Matter relationship is N:1 — a Matter links to one primary People record via a relation field. To preserve the full Legal Files association graph, FlitStack AI creates a custom junction object (MatterParty__c) with relations to both the Matter custom object and the People object. This is a pre-migration schema step; the junction records are populated during the migration load.

Migration approach

Six steps for a successful Legal Files to Twenty CRM data migration

  1. Audit Legal Files data model and export

    FlitStack AI connects to Legal Files via database export (direct SQL access or backup file) to extract all matters, parties, attorneys, deadlines, notes, and custom fields. We document every Legal Files custom field name, type, and pick-list values. If Legal Files exposes a REST or bulk export API, we use that; otherwise we run a direct database read. The audit produces a source schema map that forms the basis of the Twenty migration plan.

  2. Create Twenty custom objects and fields before import

    Before any data moves, FlitStack AI creates the Matter custom object, all custom fields (Court__c, Jurisdiction__c, CaseStatus__c, PartyRole__c, AttorneyRole__c, DocumentRef__c, and all custom properties from Legal Files), and the MatterParty__c junction object in your Twenty workspace via the Settings → Data Model interface. This step is required because Twenty's CSV import will not create fields — it only creates records. We also invite your team members to Twenty so Workspace Member records exist for owner resolution.

  3. Resolve users and attorneys by email

    Legal Files user accounts and attorney email addresses are matched against Twenty Workspace Members by email. If a Legal Files responsible attorney email matches an existing Twenty user, their matters and deadlines assign to that user. Unmatched attorneys are flagged before migration; your team either invites them to Twenty first or assigns them to a fallback user. No record lands in Twenty without a resolvable owner.

  4. Run sample migration with field-level diff

    A representative slice of records — typically 100–300 covering a cross-section of matter types, party roles, and deadline statuses — migrates first. FlitStack AI generates a field-level diff showing every source field, its mapped Twenty destination, and the actual value after transformation. You verify that matter numbers map correctly, party roles populate as select options, deadlines appear as Tasks with the right due dates, and the MatterParty__c junction records link parties to matters correctly. No full migration commits until you sign off on the sample diff.

  5. Execute full migration with delta pickup and rollback

    The full migration runs against your Twenty workspace in sequenced CSV loads (Companies → People → Matter → Tasks → Notes → Junction records). A delta-pickup window of 24–48 hours captures any matters or deadlines modified in Legal Files during the cutover. An audit log records every record created, updated, or linked. If reconciliation fails, one-click rollback reverts the Twenty workspace to its pre-migration state. Post-migration, we deliver a summary report showing record counts, any unlinked parties, and the status of owner resolution.

Platform deep dives

Context on both ends of the pair

Legal Files logo

Legal Files

Source

Strengths

  • Fully on-premise with data stored directly in Microsoft SQL Server, giving firms complete control over their database
  • Highly customizable by firm administrators without requiring developer assistance
  • Direct Microsoft Outlook email saving into case files is a workflow feature praised across reviews
  • iPad app available for attorneys working outside the office
  • Supports complex litigation case structures with deep matter hierarchies

Weaknesses

  • No public REST API — all data access requires direct SQL Server database queries
  • Desktop-first architecture means no native cloud sync or SaaS deployment model
  • Limited modern integrations compared to cloud-first competitors like Clio
  • Legacy UI is cited less favorably than newer alternatives on modern review platforms
  • Pricing is opaque and requires direct vendor contact, suggesting enterprise-level cost
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. 3 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 Legal Files and Twenty CRM.

  • Object compatibility

    B

    3 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

    Legal Files: Not applicable — no public API exposed.

  • Data volume sensitivity

    B

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

Estimator

Estimate your Legal Files 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 Legal Files to Twenty CRM data migrations

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

Can't find your answer?

Walk through your Legal Files to Twenty CRM migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most Legal Files to Twenty migrations complete in 48–72 hours for setups under 25,000 records. The longest planning step is creating the custom Matter object and all custom fields in Twenty's Settings → Data Model — plan 1–2 days for that before data begins loading. Larger setups with 25,000+ records, complex custom schemas, or extensive matter-party association graphs extend to 5–10 days. The delta-pickup window adds 24–48 hours at the end regardless of record count.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Legal Files.
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