CRM migration
Field-level mapping, validation, and rollback between Insight Legal Case Management and Odoo CRM. We move data and schema; workflows are rebuilt natively in Odoo CRM.
Insight Legal Case Management
Source
Odoo CRM
Destination
Compatibility
12 of 12
objects map 1:1 between Insight Legal Case Management and Odoo CRM.
Complexity
BStandard
Timeline
48–72 hours
Overview
Insight Legal Case Management structures its data around Matters: each matter holds client information, key dates, correspondence history, time recording, and financial ledger entries tied to a specific area of legal practice. Odoo CRM models business relationships around Leads and Opportunities — the crm.lead record type holds prospect information and converts to an Opportunity when a deal is qualified, with the res.partner model handling all contact and company data separately. The migration carries clients and matter records into Odoo CRM's lead and contact model, translating matter-specific fields like fee structures and practice areas into custom fields on the Odoo crm.lead record. Odoo stores contact data in res.partner, which handles both company records and individual contacts — Insight Legal's separate client and contact records merge here. Time entries, correspondence history, and document attachments migrate to Odoo CRM's mail.message and ir.attachment models, with original timestamps preserved. Legal-specific metadata such as matter status codes and fee arrangements require value-mapping before they land cleanly in Odoo's pick-list fields. Workflows, templates, and automation rules do not transfer — those must be rebuilt using Odoo Studio or the built-in automation engine after data lands.
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 Insight Legal Case Management object lands in Odoo CRM, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
Insight Legal Case Management
Client
Odoo CRM
res.partner
1:1Insight Legal clients map directly to Odoo res.partner records. The partner record holds name, address, email, phone, and website. Insight Legal's client type (individual vs. organization) determines whether Odoo creates a person partner or a company partner, which then links to contacts within the partner record.
Insight Legal Case Management
Contact
Odoo CRM
res.partner (contact)
1:1Insight Legal contacts attached to clients become res.partner records with parent_id set to the client-partner record. This preserves the hierarchical relationship that Insight Legal models as client-contact associations. Role fields on the contact (e.g., Solicitor, Paralegal) migrate as custom fields on the partner record.
Insight Legal Case Management
Matter
Odoo CRM
crm.lead
1:1Insight Legal's Matter record is the core entity — it bundles client, matter details, time, billing, and documents. Odoo CRM's crm.lead model (in opportunity mode) receives these as a single record, with matter-specific fields added as custom fields. Matter number becomes a reference field; practice area maps to Odoo team or a custom tag on the lead.
Insight Legal Case Management
Matter Status
Odoo CRM
crm.stage
1:1Insight Legal matter statuses (Active, Pending, Closed, Archived) require value-by-value mapping to Odoo's crm.stage pick-list. Each stage in Odoo has a sequence number and a probability percentage that must be configured to match the firm's funnel reporting expectations. Stage-change timestamps from Insight Legal migrate as a custom datetime field on the lead.
Insight Legal Case Management
Time Entry
Odoo CRM
account.analytic.line
1:1Insight Legal time entries (date, duration, description, fee rate) map to Odoo account.analytic.line records. These link to the res.partner and crm.lead records created during the matter migration, enabling time reporting against the client and matter in Odoo's project and timesheets module.
Insight Legal Case Management
Document / Attachment
Odoo CRM
ir.attachment
1:1Insight Legal files attached to matters re-upload to Odoo's ir.attachment table, linked via res_model=crm.lead and res_id set to the migrated lead ID. File metadata (filename, create date, author) is preserved. Odoo's document management module provides the same kanban-style document view that Insight Legal users expect.
Insight Legal Case Management
Correspondence History
Odoo CRM
mail.message
1:1Insight Legal correspondence logs (email, letters, notes) migrate to Odoo mail.message records attached to the crm.lead. Each message preserves its original sent/received timestamp and author. Incoming and outgoing flags map to the mail.message.message_type field so the communication thread is readable within Odoo's chatter.
Insight Legal Case Management
Fee Structure
Odoo CRM
Custom field on crm.lead
1:1Insight Legal stores fee arrangements (fixed fee, hourly, conditional, legal aid) per matter. Odoo CRM has no native fee structure field on leads. FlitStack creates a custom selection field (fee_structure) on crm.lead to preserve this value, enabling the firm to report by fee type in Odoo's pivots and graph views.
Insight Legal Case Management
Practice Area
Odoo CRM
crm.team or custom tag
1:1Insight Legal practice areas (conveyancing, family law, employment, private client) map either to Odoo CRM teams or to tags on the crm.lead. Teams are preferred when the firm wants separate pipelines and salesmen assignments per practice area. Tags work when one team manages all practice areas and reporting by area is the only requirement.
Insight Legal Case Management
Trust Account
Odoo CRM
account.account (client trust ledger)
1:1Insight Legal trust account balances are financial records with regulatory requirements specific to UK solicitors' accounts. Odoo's accounting module can model these as separate bank accounts with client ledger entries, but the migration carries trust data as reference notes and reconciliation data for manual rebuild in Odoo Accounting rather than a direct object translation.
Insight Legal Case Management
AML / Compliance Check
Odoo CRM
Custom field on res.partner
1:1Insight Legal integrates AML compliance checks that produce a pass/fail result and date per client. Odoo has no built-in AML field on partners. FlitStack creates a custom boolean field (aml_verified) and a date field (aml_check_date) on res.partner, populated from the source data for compliance continuity.
Insight Legal Case Management
Calendar / Key Dates
Odoo CRM
calendar.event
1:1Insight Legal key dates attached to matters migrate as Odoo calendar.event records linked to the crm.lead. The event title, start datetime, end datetime, and partner_ids are preserved from the source. Location and description fields map to calendar.event location and description. Recurring events are handled as individual event series. Reminder settings reset to Odoo's default or are configured by the firm's admin post-migration.
| Insight Legal Case Management | Odoo CRM | Compatibility | |
|---|---|---|---|
| Client | res.partner1:1 | Fully supported | |
| Contact | res.partner (contact)1:1 | Fully supported | |
| Matter | crm.lead1:1 | Fully supported | |
| Matter Status | crm.stage1:1 | Fully supported | |
| Time Entry | account.analytic.line1:1 | Fully supported | |
| Document / Attachment | ir.attachment1:1 | Fully supported | |
| Correspondence History | mail.message1:1 | Fully supported | |
| Fee Structure | Custom field on crm.lead1:1 | Fully supported | |
| Practice Area | crm.team or custom tag1:1 | Fully supported | |
| Trust Account | account.account (client trust ledger)1:1 | Fully supported | |
| AML / Compliance Check | Custom field on res.partner1:1 | Fully supported | |
| Calendar / Key Dates | calendar.event1: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.
Insight Legal Case Management gotchas
No public API forces all migrations through vendor services
Hybrid hosting creates two distinct extraction paths
Thousands of fields per matter require explicit scoping
Trust account compliance data has regulatory retention requirements
Out-of-the-box workflows may not transfer to non-Insight systems
Odoo CRM gotchas
Odoo.sh version gating blocks assisted migrations from trial
Enterprise modules fail to install on Community after database restore
Custom module view inheritance breaks between Odoo major versions
Custom fields risk losing their application context on Community
API access for Community is gated behind the Custom Plan
Pair-specific challenges
Migration approach
Extract Insight Legal data via API or structured export
FlitStack connects to Insight Legal using your API credentials or requests a structured export of all Matters, Clients, Contacts, Time Entries, Documents, and Correspondence records. We validate record counts against your reported figures and flag any empty result sets before proceeding. The extraction runs read-only against Insight Legal; no data is modified in the source system during this step. You receive a data inventory report showing record counts per object and a sample of the exported field names.
Design Odoo schema: custom fields, stages, and teams
Based on the extracted data, FlitStack produces a schema setup plan specifying the custom fields to create on crm.lead and res.partner, the crm.stage records with sequence and probability values, and the crm.team assignments per practice area. This plan is shared with your Odoo admin for review and pre-creation in your Odoo instance. We can also create the fields directly via XML-RPC if your Odoo setup grants FlitStack technical admin access. The plan covers AML custom fields, fee_structure selection values, matter_number reference fields, and stage mappings.
Map, transform, and sequence the migration
FlitStack builds the migration map: Matters → crm.lead, Clients → res.partner, Contacts → res.partner with parent_id, Time Entries → account.analytic.line, Documents → ir.attachment, Correspondence → mail.message. Value-mapping tables handle matter status codes, client types, and correspondence directions. The sequence respects Odoo's foreign-key constraints: res.partner records are created first (with company partners before contacts), then crm.lead records, then analytic lines and attachments. Owner resolution matches Insight Legal fee-earners by email to Odoo res.users records.
Run sample migration with field-level diff
A representative slice — typically 50–200 records spanning multiple matter types, clients, and document sizes — runs first. FlitStack generates a field-level diff comparing source values against Odoo destination values for every mapped field. You review the diff to verify matter number mapping, practice-area-to-team assignment, fee_structure values, and AML flag preservation. Any mapping adjustments are made before the full run commits. This sample run typically completes within 2–4 hours and gives you confidence before the production migration.
Execute full migration with delta-pickup window
The full migration runs against your Odoo instance. FlitStack processes all validated records in sequence, respecting Odoo's XML-RPC rate limits and attachment size constraints. A delta-pickup window of 24–48 hours captures any matters opened or documents added in Insight Legal during the cutover. An audit log records every operation (create, link, update) with source record ID and destination record ID. If reconciliation fails — record counts don't match or foreign keys are missing — FlitStack provides a rollback script that removes migrated records so the run can be corrected and re-executed.
Platform deep dives
Insight Legal Case Management
Source
Strengths
Weaknesses
Odoo 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 Insight Legal Case Management and Odoo 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
Insight Legal Case Management: Not publicly documented.
Data volume sensitivity
Insight Legal Case Management 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 Insight Legal Case Management to Odoo CRM migration scoping. Not seeing yours? Book a call.
Walk through your Insight Legal Case Management to Odoo 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 Insight Legal Case Management
Other ways to arrive at Odoo 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.
