ERP migration

Migrate from TechnologyOne to Dolibarr ERP

Field-level mapping, validation, and rollback between TechnologyOne and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.

TechnologyOne logo

TechnologyOne

Source

Dolibarr ERP

Destination

Dolibarr ERP logo

Compatibility

83%

10 of 12

objects map 1:1 between TechnologyOne and Dolibarr ERP.

Complexity

BStandard

Timeline

6-10 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from TechnologyOne to Dolibarr is a structural migration from a monolithic SaaS ERP built for Australian and New Zealand government and education sectors to an open-source modular ERP/CRM suitable for small and medium organisations. TechnologyOne's single-tenanted dataset architecture requires direct database or API access extraction, while Dolibarr receives data via its REST API or direct database import. We extract from the Business View API or directly from the dataset, map the chart of accounts and GL structure to Dolibarr's accounting module, sequence open AP and AR items to avoid triggering duplicate payment runs, and migrate fixed assets with their depreciation schedules. The end of on-premise TechnologyOne CI support in October 2024 has accelerated migration demand from councils and universities that want to move to an open-source platform rather than upgrade within the TechnologyOne ecosystem. Workflows, XlOne reports, and sector-specific compliance templates do not migrate; we deliver a written inventory of these for the customer's admin to rebuild or reconfigure in Dolibarr.

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

TechnologyOne logo

TechnologyOne

What's pushing teams away

  • Customers report that the user interface, particularly the CI legacy interface, feels dated compared to modern SaaS ERP alternatives, driving preference for cleaner UX platforms like NetSuite or Workday.
  • The monolithic bundled model means organisations pay for modules they may not use; customers seeking modular per-user or per-transaction pricing find the model inflexible and costly at scale.
  • Limited public API documentation and a historically API-light architecture make integrations with modern third-party tools difficult, pushing technical teams toward more open platforms.
  • Gartner Peer Insights scores are modest at 3.6 stars with a small review pool, indicating lower customer satisfaction and advocacy compared to competitors in the ERP space.
  • Upgrade cycles from CI to CiA have required significant consulting effort and custom role rebuilding, creating churn among customers who want a cleaner migration path.

Choosing

Dolibarr ERP logo

Dolibarr ERP

What's pulling them in

  • Free open-source core with no per-user license fee makes it the lowest-cost entry point for small teams needing ERP and CRM in one package.
  • Self-hosted deployment gives full data ownership and eliminates vendor lock-in, especially attractive to businesses with compliance requirements.
  • Modular architecture means teams enable only the features they use, keeping the interface uncluttered and reducing learning curve.
  • Fast installation with no technical knowledge required — one reviewer set up multiple businesses in minutes using their own hosting.
  • Active community forum and marketplace of third-party add-ons provide support and extension options without mandatory subscription costs.

Object mapping

How TechnologyOne objects map to Dolibarr ERP

Each row shows how a TechnologyOne object lands in Dolibarr ERP, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

TechnologyOne

Chart of Accounts

maps to

Dolibarr ERP

Account (Accounting module)

1:1
Fully supported

TechnologyOne's general ledger account hierarchy (account codes, account names, classification, balance type) maps directly to Dolibarr's accounting chart of accounts. We extract the full account structure via the Business View API or direct dataset query, preserving parent-child relationships as account groupings. Active and inactive account flags transfer. Balance-mapping rules require attention when organisations carry forward GL balances rather than starting from a clean ledger.

TechnologyOne

Supplier Master

maps to

Dolibarr ERP

Third-Party (Supplier)

1:1
Fully supported

TechnologyOne supplier records (supplier code, name, address, payment terms, bank details, tax registration) map to Dolibarr Third-Party records with the Supplier flag enabled. Custom fields added to supplier records in TechnologyOne require field-level discovery during the scoping phase because there is no unified custom field registry. Payment terms migrate as Dolibarr code and label pairs.

TechnologyOne

Customer Master

maps to

Dolibarr ERP

Third-Party (Customer)

1:1
Fully supported

TechnologyOne customer records map to Dolibarr Third-Party records with the Customer flag enabled. Contact details, billing addresses, and credit limits transfer. Customer-specific pricing rules require mapping to Dolibarr's price list system. Historical payment behaviour recorded in TechnologyOne's debtors module does not transfer as a behavioural score; the finance team recreates this assessment in Dolibarr manually.

TechnologyOne

Open AP Records

maps to

Dolibarr ERP

Supplier Invoice (status: unpaid)

1:1
Fully supported

Outstanding accounts payable records with payment arrangements, direct debit mandates, and prepayment schedules require careful sequencing to avoid triggering duplicate payment runs during import. We extract open AP items with their original invoice dates, amounts, due dates, and payment method references, then import them into Dolibarr as supplier invoices in unpaid status. Payment method mappings (BPAY, direct credit, cheque) must be configured in Dolibarr before AP import.

TechnologyOne

Open AR Records

maps to

Dolibarr ERP

Customer Invoice (status: unpaid)

1:1
Fully supported

Outstanding accounts receivable with payment arrangements and bulk transaction histories migrate to Dolibarr customer invoices in unpaid status. We preserve original invoice numbers, invoice dates, due dates, and amount outstanding. Historical payment receipts linked to AR records are migrated as Dolibarr payment records after the parent invoice is imported. Credit notes and debit notes map to Dolibarr's credit note and reposition invoice types.

TechnologyOne

Employee Records

maps to

Dolibarr ERP

User + HR Module

1:1
Fully supported

TechnologyOne HR module records (employee number, name, job title, department, compensation history, effective-dated changes) map to Dolibarr User records for system access and to HR/Payroll module records for employment details. Dolibarr's HR module stores hire date, position, salary, and leave balances. Compensation history requires mapping to Dolibarr's salary history feature if the module is activated. Effective-dated changes require careful sequencing to preserve the correct historical record.

TechnologyOne

Fixed Asset Register

maps to

Dolibarr ERP

Asset Module

1:1
Fully supported

TechnologyOne asset records with acquisition dates, acquisition cost, depreciation method, useful life, accumulated depreciation, and asset classification map to Dolibarr Asset records. Depreciation method mapping (straight-line, reducing balance, units of production) requires value-mapping between the two systems because terminology differs. Residual value and capital gain tracking fields migrate as Dolibarr custom fields if the standard asset record does not cover the requirement.

TechnologyOne

Purchase Orders

maps to

Dolibarr ERP

Supplier Order / Purchase Order

1:1
Fully supported

Purchase orders and purchase requisitions in TechnologyOne's procurement module map to Dolibarr Supplier Orders. We extract PO number, line items, quantities, unit costs, and approval status. Workflow state and approval history from TechnologyOne requires mapping to Dolibarr's validation workflow or manual re-approval after import. Partially received purchase orders map to Dolibarr reception records linked to the supplier order.

TechnologyOne

ECM Documents

maps to

Dolibarr ERP

Document Management (ECM)

1:1
Fully supported

TechnologyOne ECM stores documents, document sets, compound documents, and custom document fields accessible via EzeScan CMIS-compatible endpoints. We extract document metadata (filename, classification, version, custom fields) and the document binary where accessible. Custom ECM fields require manual discovery by querying the source dataset directly because there is no self-documenting schema endpoint. Any missed custom fields result in blank values in migrated document records.

TechnologyOne

Property and Rating Assessments

maps to

Dolibarr ERP

Third-Party + Contract (custom mapping)

lossy
Mapping required

TechnologyOne's Property and Rating module (specific to local government customers) stores assessments, charge runs, and fee schedules. These do not have a direct Dolibarr equivalent. We map property records to Third-Parties with a custom type flag, rate assessments to Contract records, and charge runs to Dolibarr invoice generation templates. The billing engine's custom calculation rules require transformation logic built during the migration because Dolibarr's billing engine is general-purpose rather than rating-engine-specific.

TechnologyOne

Users and Roles

maps to

Dolibarr ERP

User

1:1
Not supported

TechnologyOne user accounts and role-based security profiles are tied to the CiA internal identity layer and UI configuration. We do not migrate user accounts because these must be recreated in Dolibarr as new User records with appropriate permissions configured by the customer's admin. Role mappings from TechnologyOne's security profiles do not transfer because Dolibarr's permission model is module-based rather than profile-based.

TechnologyOne

XlOne Reports

maps to

Dolibarr ERP

Report Writer / ODT Templates

lossy
Fully supported

XlOne financial reports built against TechnologyOne's GL structure do not migrate directly because they reference TechnologyOne-specific field names and dataset IDs. We document every XlOne report during discovery with its data sources, filters, and calculation logic. The finance team receives a report remapping guide for Dolibarr's built-in report writer and ODT-based document templates. The underlying GL data migrates cleanly; only the reporting layer requires rebuild.

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.

TechnologyOne logo

TechnologyOne gotchas

High

CI-to-CiA hybrid environments complicate data scoping

High

Single-tenanted dataset requires direct database access

Medium

Custom document fields in ECM require manual discovery

Medium

XlOne and custom financial reports do not auto-migrate

Dolibarr ERP logo

Dolibarr ERP gotchas

High

Foreign key constraint errors on cross-distribution database restore

High

SQL injection vulnerabilities in version 9.0.1

Medium

Custom fields stored as JSON in extraoptions require field-by-field deserialization

Medium

Decimal precision and rounding configuration affects price fields

Low

No native iOS/Android app forces reliance on browser

Pair-specific challenges

  • Direct dataset access required for complete extraction

    TechnologyOne's single-tenanted architecture gives each customer environment its own isolated dataset with no multi-tenant API endpoint covering all objects. We negotiate direct dataset access or use the Business View API for financials and the ITP API for invoice operations. API rate limits and endpoint availability vary by module and by whether the customer has SaaS+ or on-premise deployment. During discovery, we confirm access method for each module being migrated. Incomplete extraction leads to missing ledger balances, absent employee records, or blank document metadata in Dolibarr.

  • Hybrid CI and CiA environments require dual extraction

    Many TechnologyOne customers operate with both the legacy CI interface and the newer CiA platform simultaneously, with different modules potentially on different environments. We treat each module's environment as a separate data source during scoping. We identify which modules are still on CI and extract from the appropriate environment before mapping everything into Dolibarr. Failure to identify hybrid environments results in incomplete data extraction where CI-held records are never moved to the destination.

  • Custom ECM document fields require manual field audit

    The TechnologyOne ECM module allows custom document fields beyond standard metadata with no self-documenting schema endpoint. We obtain all field definitions by querying the EzeScan connector or reviewing the source dataset directly. Any missed custom fields result in blank values in migrated documents. We run a pre-migration field audit against the live ECM environment to enumerate every custom field before building the Dolibarr document import mapping.

  • Dolibarr file permissions can block document upload and validation

    Dolibarr is sensitive to file system permissions during document import and PDF generation. Incorrect permissions on the /documents/ directory prevent Dolibarr from renaming folders during invoice or order validation, causing silent failures. We validate Dolibarr's file permission configuration (755 for directories, 644 for files) before importing document records. The conf.php database parameters must also be correctly set after any server migration to avoid the 'Dolibarr config file content seems to be not correctly defined' error.

  • Dolibarr database import key length and charset constraints

    Dolibarr's database schema uses MySQL/MariaDB with specific charset settings (utf8 or utf8mb4) and key length limits. Database migrations between different Linux distributions or MySQL versions can trigger 'Specified key was too long' errors (DB_ERROR_1071) if the target database uses a stricter utf8mb4 encoding with InnoDB. We test the database import on a staging Dolibarr instance before production migration and use the /install/repair.php endpoint to resolve missing fields and orphaned records post-import.

Migration approach

Six steps for a successful TechnologyOne to Dolibarr ERP data migration

  1. Discovery and access method confirmation

    We audit the TechnologyOne environment to identify which modules are on CI and which are on CiA, confirm data extraction access method (direct dataset or API per module), enumerate custom ECM fields, and document the chart of accounts hierarchy, open AP/AR volume, employee headcount, asset register size, and document repository scope. We also identify whether the customer has Property and Rating module data requiring government-sector mapping. The discovery output is a written migration scope with object-level record counts and an extraction method per module.

  2. Dolibarr instance provisioning and module selection

    We provision a Dolibarr instance (self-hosted or DoliCloud) and activate the modules required for the migration scope: Accounting, Third-Party/Customer/Supplier, Invoice, Supplier Order/PO, HR/Employee, Asset, and ECM. We configure the chart of accounts structure in Dolibarr's accounting module to match the source hierarchy. File permission configuration (755/644) and conf.php database parameters are validated on the destination instance before any data import begins.

  3. Custom ECM field audit and field mapping build

    We run a field-level audit against TechnologyOne's ECM module by querying the EzeScan connector or reviewing the source dataset directly. Every custom document field is enumerated with its data type, valid values, and whether it is active or unused. We build a Dolibarr ECM field mapping document that matches each TechnologyOne custom field to a corresponding Dolibarr attribute or creates a new metadata field. This mapping is validated in a test import before production migration.

  4. Sandbox migration and reconciliation

    We run a full migration into the Dolibarr staging environment using production-like data volumes. The customer's finance lead reconciles account code counts, GL balance totals (debit and credit), open AP/AR record counts, employee headcount, asset count and total net book value, and document metadata completeness. Any mapping corrections (account codes, payment terms, custom fields) are applied before production migration begins. This step also validates that Dolibarr's file permissions and database charset settings are correct.

  5. Production migration in dependency order

    We run production migration in record-dependency order: accounting chart of accounts first, then Third-Party records (suppliers and customers), then fixed assets, then open AP and AR records (sequenced to avoid payment run triggers), then employee records, then purchase orders, then ECM documents with custom metadata. Each phase emits a row-count reconciliation report and a balance-check against the TechnologyOne source before the next phase begins.

  6. Cutover, XlOne report inventory, and admin handoff

    We freeze TechnologyOne writes during cutover, run a final delta migration of any records modified during the migration window, then enable Dolibarr as the system of record. We deliver the XlOne report inventory document with data source references and recommended Dolibarr report writer equivalents for each report. We provide a written inventory of TechnologyOne workflows, sector-specific compliance templates, and approval workflows that require rebuild in Dolibarr. We support a one-week hypercare window for reconciliation issues raised by the finance or operations team.

Platform deep dives

Context on both ends of the pair

TechnologyOne logo

TechnologyOne

Source

Strengths

  • Deep vertical fit for Australian and New Zealand local government, education, and health sectors with pre-built compliance templates.
  • Single-tenanted dataset architecture provides strong data isolation and clear extraction boundaries.
  • Well-established finance module with solid chart of accounts and general ledger capabilities used by hundreds of councils.
  • Sector-specific pre-configured solutions like OneCouncil and OneEducation reduce initial configuration effort.
  • Strong cash position and no debt give the company financial stability, reducing vendor continuity risk.

Weaknesses

  • API-light architecture historically, with limited public API documentation, making programmatic data extraction harder than modern SaaS ERPs.
  • Legacy CI interface coexists with CiA, meaning customers often have hybrid environments that complicate migration scoping.
  • Monolithic bundled pricing model lacks flexibility for organisations wanting to pay per module or per user.
  • User interface and experience design lag behind modern ERP competitors, reducing user adoption in organisations with tech-savvy staff.
  • Limited ecosystem of third-party integrations compared to SAP, Oracle, or NetSuite.
Dolibarr ERP logo

Dolibarr ERP

Destination

Strengths

  • Free core software with AGPL license and no per-user mandatory fee for self-hosted deployments.
  • Modular architecture lets teams activate only needed features, keeping the interface focused and the database lean.
  • Self-hosted option provides full data sovereignty and avoids recurring SaaS subscription costs.
  • Built-in CSV/Excel import and export wizard with saved profiles simplifies recurring data operations.
  • Low-code Module Builder allows functional extensions without writing PHP code.

Weaknesses

  • No native documented REST API for programmatic bulk operations — all migrations depend on the import/export wizard or direct database access.
  • Reporting and analytics are weak without paid add-ons, and built-in charts are limited compared to modern SaaS platforms.
  • UI design is described as dated by multiple reviewers, with infrequent visual updates to the default theme.
  • Community-only support for self-hosted deployments means no SLA or guaranteed response time for issues.
  • Security vulnerabilities (CVE-2024-5314, CVE-2024-5315) in version 9.0.1 with no immediate patch reported.

Complexity grading

How hard is this migration?

Standard ERP migration. All 8 core objects map 1:1 between TechnologyOne and Dolibarr ERP.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across TechnologyOne and Dolibarr ERP.

  • Object compatibility

    A

    All 8 core objects map 1:1 between TechnologyOne and Dolibarr ERP.

  • 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

    TechnologyOne: Not publicly documented. Customers receive rate limit details from their TechnologyOne project manager during integration onboarding, and limits vary by module and by whether the customer is on SaaS+ or self-hosted..

  • Data volume sensitivity

    B

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

Estimator

Estimate your TechnologyOne to Dolibarr ERP 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 TechnologyOne to Dolibarr ERP data migrations

Answers to the questions buyers ask most during TechnologyOne to Dolibarr ERP migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your TechnologyOne to Dolibarr ERP migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Migrations under 15,000 employees and 50,000 ledger transactions with standard AP/AR and fixed assets land between six and ten weeks. Migrations with local government rating modules, large historical transaction volumes, custom ECM document fields, or hybrid CI/CiA environments requiring dual extraction move to fourteen to twenty-two weeks. The TechnologyOne side typically requires more discovery time than API-first platforms because we must identify the correct extraction method (direct dataset or API) for each module and audit custom fields manually.

Adjacent paths

Related migrations to explore

Ready when you are

Move from TechnologyOne.
Land in Dolibarr ERP, 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