CRM migration
Field-level mapping, validation, and rollback between Insight Legal Case Management and Freshsales. We move data and schema; workflows are rebuilt natively in Freshsales.
Insight Legal Case Management
Source
Freshsales
Destination
Compatibility
12 of 12
objects map 1:1 between Insight Legal Case Management and Freshsales.
Complexity
BStandard
Timeline
48–72 hours
Overview
Insight Legal Case Management is a UK-based legal practice platform built on Microsoft SQL Server that stores clients, matters, fee earner assignments, time recordings, and financial ledger data in a unified schema designed for law firms. Freshsales is a Freshworks SMB CRM with standard Lead, Contact, Account, and Deal objects, custom fields, and a REST API rated at 100 calls per minute per account. The migration challenge is translating Insight Legal's client-matter structure into Freshsales' lead-account-deal model — a fundamentally different data shape that requires custom field creation for legal-specific properties, value mapping for matter status, and owner resolution by fee-earner email. We extract data directly from the Insight Legal SQL Server database, transform records against Freshsales' API constraints, and load via the Freshsales REST API. Workflows, document templates, and legal accounting logic do not transfer; FlitStack surfaces them as export-for-rebuild deliverables so your team can recreate automation logic in Freshsales after go-live. A delta-pickup window captures any new or modified matters created during the cutover window, and one-click rollback is available if reconciliation identifies data integrity issues.
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 Freshsales, 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
Freshsales
Account
1:1Insight Legal clients map directly to Freshsales Accounts. Client name, address, contact email, and telephone transfer as Account.Name, billing address fields, and Account Phone. Clients without a matter association migrate as standalone Accounts with a source_system_id for audit traceability. This ensures every client record maintains its original identifier for reference matching and reconciliation during the migration process.
Insight Legal Case Management
Contact
Freshsales
Contact
1:1Insight Legal contacts (parties on a matter: opposing counsel, witnesses, referrers) map to Freshsales Contacts. Email, phone, job title, and address fields transfer directly. Contacts without a linked Client in Insight Legal attach to a default 'No Account' placeholder Account in Freshsales.
Insight Legal Case Management
Matter
Freshsales
Deal
1:1Insight Legal matters translate into Freshsales Deals. Matter title becomes Deal Name, and matter reference numbers are preserved in a custom field (matter_reference__c). Insight Legal's matter status (Open, Closed, Archived) maps to Freshsales Deal stage via a value-mapping table, with Open routing to the first pipeline stage and Closed routing to a Won or Lost stage based on billing outcome.
Insight Legal Case Management
Matter Type / Case Category
Freshsales
Deal Custom Field: Case_Type__c
1:1Insight Legal stores matter type as a database column (e.g., Family, Conveyancing, Employment). Freshsales has no native case-type field on Deals. We create a custom picklist field Case_Type__c on the Deal object and populate it via value mapping from the source matter type string. Firms must define the picklist values in Freshsales Settings before migration.
Insight Legal Case Management
Fee Earner
Freshsales
User / Deal Owner
1:1Insight Legal fee earners (solicitors, paralegals) map to Freshsales Users by email match. The primary fee earner on a matter becomes the Deal Owner in Freshsales. Secondary fee earners are preserved as a custom multi-select text field (Secondary_Fee_Earners__c) on the Deal. Unmatched fee earners require Freshsales user provisioning before migration or fallback assignment to a designated admin user.
Insight Legal Case Management
Time Record
Freshsales
Task
1:1Insight Legal time records (date, duration, narrative, billing rate) map to Freshsales Tasks linked to the parent Deal. Task Subject carries the time-record narrative, Task Due Date carries the record date, and duration in minutes transfers as a custom number field (Time_Minutes__c). Billable vs. non-billable flag from Insight Legal maps to Task Type in Freshsales.
Insight Legal Case Management
Document / Attachment
Freshsales
Freshsales Files
1:1Documents and files attached to Insight Legal matters are downloaded from the document management path, re-uploaded to Freshsales Files, and linked to the corresponding Deal record by Deal ID. Original filenames and create dates are preserved in Freshsales File metadata. Files over 25MB require chunked upload via the Freshsales file API.
Insight Legal Case Management
Client Account / Ledger Entry
Freshsales
Custom Object: Client_Trust__c
1:1Insight Legal's client account ledger (monies held, disbursements) has no direct Freshsales equivalent. We create a custom object Client_Trust__c with fields for transaction_type, amount, date, and matter_reference. Trust account data is migrated for audit continuity but Freshsales does not process financial transactions — billing must be handled in an accounting system post-migration.
Insight Legal Case Management
Billing / Invoice
Freshsales
Custom Field on Deal: Last_Bill_Date__c, Total_Billed__c
1:1Insight Legal bills and invoice records carry total billed amount and last bill date. These values migrate as custom fields on the Deal (Last_Bill_Date__c as date, Total_Billed__c as currency). Freshsales does not have native billing or invoicing — invoice history is preserved as reference data, not as actionable billing records.
Insight Legal Case Management
Key Date / Deadline
Freshsales
Task
1:1Insight Legal stores key dates and deadlines against matters. These transfer as Freshsales Tasks with Task Type = 'Deadline' and the original deadline date as the Task Due Date, linked to the parent Deal. Overdue deadlines flagged in Insight Legal carry a custom 'Overdue_at_Migration__c' checkbox set to true for admin review.
Insight Legal Case Management
Custom Field (any)
Freshsales
Custom Field on corresponding object
1:1Insight Legal supports user-defined custom fields per firm. Each custom field requires a corresponding Freshsales custom field to be created before migration. Field type parity is enforced: if Insight Legal stores a date, the Freshsales custom field must be Date type. We deliver a custom-field creation checklist as part of the migration plan.
Insight Legal Case Management
User / Staff Record
Freshsales
Freshsales User
1:1Insight Legal staff records (name, email, role, department) map to Freshsales Users. Email is the primary match key. Role and department transfer as User custom fields (Role__c, Department__c). Insight Legal's access-control permissions have no Freshsales equivalent — access rules must be rebuilt in Freshsales Profile and Role settings post-migration.
| Insight Legal Case Management | Freshsales | Compatibility | |
|---|---|---|---|
| Client | Account1:1 | Fully supported | |
| Contact | Contact1:1 | Fully supported | |
| Matter | Deal1:1 | Fully supported | |
| Matter Type / Case Category | Deal Custom Field: Case_Type__c1:1 | Fully supported | |
| Fee Earner | User / Deal Owner1:1 | Fully supported | |
| Time Record | Task1:1 | Fully supported | |
| Document / Attachment | Freshsales Files1:1 | Fully supported | |
| Client Account / Ledger Entry | Custom Object: Client_Trust__c1:1 | Fully supported | |
| Billing / Invoice | Custom Field on Deal: Last_Bill_Date__c, Total_Billed__c1:1 | Fully supported | |
| Key Date / Deadline | Task1:1 | Fully supported | |
| Custom Field (any) | Custom Field on corresponding object1:1 | Fully supported | |
| User / Staff Record | Freshsales User1: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
Freshsales gotchas
Freddy AI is Pro-tier only despite heavy marketing
Post-migration emails and sequences are disabled
Bot session credits are a one-time 500-session allocation
Phone credits charged per minute with no cap
File storage limits scale with plan tier
Pair-specific challenges
Migration approach
Audit Insight Legal database and design Freshsales custom field schema
FlitStack connects to the Insight Legal SQL Server database using read-only credentials and inventories all tables: clients, contacts, matters, time_records, key_dates, documents, and staff. We cross-reference with Freshsales' available standard fields and identify every custom field required (Case_Type__c, fee_earner_reference__c, matter_reference__c, Time_Minutes__c, Total_Billed__c, Last_Bill_Date__c, Original_Create_Date__c, Source_System_ID__c). We deliver a Freshsales pre-configuration checklist specifying field names, types, and picklist values your admin creates before migration runs.
Provision Freshsales users and resolve fee earner ownership
We export Insight Legal staff records and match them to Freshsales Users by email. Any fee earner without a Freshsales account is flagged in a User Mapping Report. Your team provisions those users or designates a fallback owner before the migration run. Unresolved fee earner references do not block the migration — unmatched records assign to the designated fallback owner with a custom field flag (Original_Fee_Earner__c) preserving the original name for post-migration audit.
Extract and transform data, then run sample migration with field-level diff
FlitStack runs SQL queries against the Insight Legal database to extract all clients, contacts, matters, time records, and key dates in a single coordinated export. We apply field mapping transformations (status-to-stage value mapping, fee earner-to-owner resolution, date format normalization) and write to Freshsales via the REST API. A representative sample — typically 200–500 records spanning multiple matter types and time periods — migrates first. We generate a field-level diff showing every mapped value side-by-side so you verify matter-type mapping, fee earner ownership, and time-record linkage before the full run commits.
Migrate documents and re-link attachments to parent Deal records
After core data lands in Freshsales, FlitStack downloads documents from the Insight Legal file path, re-uploads them to Freshsales Files, and links each file to the corresponding Deal record by matching matter reference. A document migration manifest records original filename, file path, upload date in Freshsales, and parent Deal ID. Any files exceeding Freshsales' 25MB limit are flagged and chunked upload is used. The document metadata export step runs concurrently, preserving author and version data in a companion CSV.
Run full migration with delta pickup and post-migration validation
The full dataset migrates to Freshsales in batched API writes respecting Freshsales' rate limit of 100 calls per minute. After the primary migration window closes, a delta-pickup run captures any clients, matters, or time records created or modified in Insight Legal during the cutover period. We run a post-migration validation comparing record counts, field-level totals (total billed, time record minutes), and owner resolution rates against the Insight Legal source. A reconciliation report flags any discrepancies for manual review. One-click rollback reverts all migrated records if critical issues are found before go-live.
Platform deep dives
Insight Legal Case Management
Source
Strengths
Weaknesses
Freshsales
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 Insight Legal Case Management and Freshsales.
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
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 Freshsales migration scoping. Not seeing yours? Book a call.
Walk through your Insight Legal Case Management to Freshsales 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 Freshsales
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.