CRM migration
Field-level mapping, validation, and rollback between openCRX and Pipedrive. We move data and schema; workflows are rebuilt natively in Pipedrive.
openCRX
Source
Pipedrive
Destination
Compatibility
8 of 12
objects map 1:1 between openCRX and Pipedrive.
Complexity
BStandard
Timeline
4-6 weeks
Overview
Migrating from openCRX to Pipedrive is a shift from a technically demanding open-source platform to a SaaS CRM designed for sales teams that want to move fast without dedicated Java administrators. openCRX stores its data in a J2EE layer with no published REST API; all extraction requires direct database access or application-layer scripting coordinated with the customer's DBA. The openCRX data model (Accounts as LegalEntity and Contact, Opportunities inheriting from abstract contract classes, Products with multi-currency price lists) is richer than Pipedrive's flat object model, so we collapse hierarchy levels during transform and migrate Opportunities as Deals with the openCRX contract-position detail folded into custom fields where the customer requires it. Pipedrive's native Import2 tool does not support openCRX as a source, so we run API-driven extraction against the customer's read-only database export, build the CSV, and load via Pipedrive's spreadsheet import or API. Workflow Processes, Alert Topics, and Topics are openCRX infrastructure objects; we document them fully but do not transfer them as code. Custom fields built via DataBinding PropertySet are enumerated during scoping and must be manually recreated in Pipedrive before migration begins.
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 openCRX object lands in Pipedrive, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
openCRX
Account (LegalEntity)
Pipedrive
Organisation
1:1openCRX LegalEntity records (the company-side of Account) map to Pipedrive Organisation. Company name, industry, revenue tier, and address fields migrate directly. The openCRX Account full-text search index does not have a Pipedrive equivalent; we do not replicate it. Multi-entity openCRX deployments require a segment-level filter during export that we apply before the Organisation import batch.
openCRX
Account (Contact)
Pipedrive
Person
1:1openCRX Contact records (the individual-side of Account) map to Pipedrive Person. Each Contact retains a link to its parent LegalEntity Organisation via the openCRX primaryAccount reference, which we resolve as a Pipedrive Organisation ID during the Person insert. openCRX Contact phone numbers and postal addresses (modelled as separate value objects) collapse into Pipedrive's flat Person fields.
openCRX
Opportunity
Pipedrive
Deal
1:1openCRX Opportunities inherit from abstract contract classes and carry stage, rating, owner, and estimated value. We map the openCRX opportunityState and salesPhase properties to Pipedrive Deal stage names, with a custom field ocrx_original_stage__c preserving the source value. openCRX contract-position detail (product, quantity, price) migrates to Pipedrive Deal products as line items if the Advanced plan is active; otherwise it is stored as structured text in a custom field ocrx_line_items__c.
openCRX
Quote
Pipedrive
Deal (custom fields)
lossyPipedrive has no native Quote object at Essential or Advanced tiers; only Smart Docs (Professional+) offers a structured Quote feature. For most openCRX-to-Pipedrive migrations, we treat Quotes as Deals with a custom field ocrx_quote_status__c and the quote body stored as structured text in a notes field. If the customer is on Pipedrive Professional or above, we evaluate Smart Docs as the Quote replacement and migrate quote line items as Deal products.
openCRX
Sales Order
Pipedrive
Deal (custom fields)
lossyopenCRX Sales Orders inherit from the same contract hierarchy as Quotes and Opportunities, with order positions modelled as contract positions. Pipedrive has no native Sales Order object. We map order headers to Deals with custom fields ocrx_order_id__c and ocrx_order_status__c, and order positions to structured custom fields or Deal products depending on plan tier. Order-to-Invoice lineage is preserved in a custom text field for audit.
openCRX
Invoice
Pipedrive
Deal (custom fields)
lossyopenCRX Invoices are terminal contract objects. Pipedrive does not have a native Invoice object. We migrate invoice headers and line items as custom fields on the parent Deal (ocrx_invoice_id__c, ocrx_invoice_total__c, ocrx_invoice_date__c) and flag that the customer should evaluate Pipedrive's billing integrations or a dedicated invoicing tool post-migration if invoice tracking inside the CRM is required.
openCRX
Product
Pipedrive
Product
1:1openCRX Products with bundles and design-to-order configurations map to Pipedrive Products. openCRX run-time pricing rules and multi-currency price lists are flattened into Pipedrive Product prices; we capture the base currency price and note any multi-currency variants in a custom field ocrx_additional_currencies__c for the customer's admin to configure in Pipedrive's multi-currency settings.
openCRX
Activity (calls, emails, meetings, tasks)
Pipedrive
Activity
1:1openCRX Activities are first-class objects with time-tracking and Activity Tracker grouping. We map call activities to Pipedrive call Activities, email activities to Pipedrive email Activities, meeting activities to Pipedrive meeting Activities, and task activities to Pipedrive task Activities. openCRX Activity Tracker grouping (which associates multiple activities under a single theme or campaign) cannot be reproduced natively in Pipedrive; we document the tracker groupings in a written handoff and the customer's admin can recreate them as Pipedrive labels or custom tag fields.
openCRX
Note
Pipedrive
Note
1:1openCRX Notes attach to objects as CrxObject attributes. We migrate note title and body to Pipedrive Notes linked via the activity reference to the parent Person, Organisation, or Deal. If the note contains embedded binary content, we extract the text and flag the attachment for manual re-upload in Pipedrive's file section.
openCRX
Workflow Process
Pipedrive
Workflow Automation (documented only)
1:1openCRX Workflow Processes are segment-scoped infrastructure objects that are not standalone data records and cannot be exported and re-imported. We do not migrate them. During scoping we enumerate every openCRX Workflow Process definition and deliver a written inventory with its trigger conditions, actions, and a recommended Pipedrive Workflow Automation equivalent. The customer's admin rebuilds them in Pipedrive's Automation editor (available from Advanced plan).
openCRX
Topic and Alert Subscription
Pipedrive
Email Notifications (documented only)
1:1openCRX Topics drive email notifications based on object lifecycle events and are tightly bound to the running openCRX instance. We do not migrate them. We document every active Topic subscription with its trigger object, event type, and notification target and deliver this as part of the automation handoff for the customer's admin to implement as Pipedrive Workflow Automation triggers or email notification rules.
openCRX
User-Defined Attributes (DataBinding PropertySet)
Pipedrive
Custom Fields
lossyCustom fields defined via openCRX DataBinding PropertySet are feature definitions in the UI customising layer, not data records. We enumerate all active PropertySet attributes during scoping, identify their bound object and data type, and deliver a custom field creation checklist for Pipedrive. The customer's admin creates the corresponding custom fields in Pipedrive before migration begins. We do not create Pipedrive custom fields programmatically as that requires the customer's Pipedrive admin credentials and direct API access.
| openCRX | Pipedrive | Compatibility | |
|---|---|---|---|
| Account (LegalEntity) | Organisation1:1 | Fully supported | |
| Account (Contact) | Person1:1 | Fully supported | |
| Opportunity | Deal1:1 | Fully supported | |
| Quote | Deal (custom fields)lossy | Fully supported | |
| Sales Order | Deal (custom fields)lossy | Fully supported | |
| Invoice | Deal (custom fields)lossy | Fully supported | |
| Product | Product1:1 | Fully supported | |
| Activity (calls, emails, meetings, tasks) | Activity1:1 | Fully supported | |
| Note | Note1:1 | Fully supported | |
| Workflow Process | Workflow Automation (documented only)1:1 | Fully supported | |
| Topic and Alert Subscription | Email Notifications (documented only)1:1 | Fully supported | |
| User-Defined Attributes (DataBinding PropertySet) | Custom Fieldslossy | Mapping required |
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.
openCRX gotchas
No public REST API with documented rate limits
WebDAV client quirks block document access on Windows
"Too many open files" on Linux blocks installation and export
Workflow Processes are segment-scoped and non-portable
Pipedrive gotchas
Custom field hash keys differ per account
Export access gated by visibility groups
Token-based API rate limits since December 2024
Sequences and Automations not exposed via REST API
Cost escalates via workflow caps and add-ons
Pair-specific challenges
Migration approach
Discovery and openCRX deployment assessment
We audit the source openCRX instance: version number, segment count, database type and access credentials, custom DataBinding PropertySet definitions, active Workflow Process definitions, Alert Topic subscriptions, and record volume per object. We identify whether the customer's DBA can provide a read-only database export or whether application-layer extraction scripts are required. We also confirm the openCRX deployment environment (on-premise Linux, Docker on cloud VM, hosted) to plan the export client accordingly. The discovery output is a written migration scope, a database export runbook, and a custom field creation checklist for Pipedrive.
Pipedrive plan and schema preparation
We confirm the customer's Pipedrive plan tier based on the required features: Essential ($14.90/user/mo) for basic contact, organisation, and deal migration; Advanced ($24.90/user/mo) if Workflow Automation is required; Professional ($49.90/user/mo) if Smart Docs quoting or advanced Insights reporting is part of the scope. We guide the customer's Pipedrive admin through creating all custom fields identified in the openCRX PropertySet audit before migration begins. Pipelines and stage names are configured in Pipedrive to match the openCRX salesPhase values as closely as the customer's revised sales process allows.
Database export and CSV transformation
Working with the customer's DBA, we obtain a read-only database export or run application-layer extraction scripts to produce structured CSV files for Account (LegalEntity and Contact), Opportunity, Product, and Activity objects. We run openCRX's file descriptor pre-flight check on Linux exports and execute attachment extraction from a compatible client to avoid WebDAV silent failures. We then transform the CSV files: resolving the Contact-to-LegalEntity parent relationship for Pipedrive Organisation ID injection, mapping openCRX stage values to Pipedrive Deal stage names, and collapsing multi-currency price list rows into base currency with currency notation preserved.
Sandbox import and reconciliation
We run a trial import into the customer's Pipedrive demo or sandbox environment using the transformed CSV files, with Pipedrive's spreadsheet import tool or API calls. We reconcile record counts per object, spot-check 25-50 random records against the openCRX source for field-level accuracy, and verify that Person-to-Organisation links resolved correctly. Any picklist validation failures (values present in source data but not configured in Pipedrive) are corrected by adding the missing picklist options before proceeding. The customer approves the sandbox import before production migration begins.
Production migration in dependency order
We run the production migration in this order: Pipedrive custom fields (pre-created during scoping, verified), Organisations (from openCRX LegalEntity), Persons (from openCRX Contact, with Organisation ID resolved from the parent LegalEntity), Products, Deals (with openCRX opportunity stage mapped to Pipedrive stage and openCRX contract positions stored as Deal products or structured custom fields), Activity history (calls, emails, meetings, tasks via Pipedrive API with rate-limit handling and exponential backoff). Each phase emits a row-count reconciliation report. openCRX Workflow Processes and Alert Topics are not migrated; they appear in the automation handoff document delivered at the end of the engagement.
Cutover, delta sync, and automation handoff
We freeze openCRX writes during cutover, run a final delta migration of any records created or modified after the export snapshot, then enable Pipedrive as the system of record. We deliver the automation handoff document: a full inventory of openCRX Workflow Process definitions, Alert Topic subscriptions, and Topic event rules with recommended Pipedrive Workflow Automation equivalents. We support a one-week hypercare window to resolve any reconciliation issues. We do not rebuild openCRX Workflow Processes or Alert Topics as Pipedrive Workflow Automations inside the migration scope; that work is handled by the customer's Pipedrive admin or a Pipedrive partner using the handoff document.
Platform deep dives
openCRX
Source
Strengths
Weaknesses
Pipedrive
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 3 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 openCRX and Pipedrive.
Object compatibility
3 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
openCRX: Not publicly documented.
Data volume sensitivity
openCRX 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 openCRX to Pipedrive migration scoping. Not seeing yours? Book a call.
Walk through your openCRX to Pipedrive migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave openCRX
Other ways to arrive at Pipedrive
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.