ImportFactuSOL — Dolibarr Module

Migrate your FactuSOL data to Dolibarr in one click.

ImportFactuSOL is a Dolibarr module for Spanish businesses that want to switch from FactuSOL — one of the most popular Spanish ERP and billing applications for SMEs — to Dolibarr without having to re-enter years of data by hand.

Upload your FactuSOL backup ZIP, click Start, and the module handles the rest: it reads the Access database files, maps every entity to its Dolibarr equivalent, and imports everything inside a single transaction. If anything goes wrong, a full rollback leaves your Dolibarr database untouched.

What gets imported

What is NOT imported (by design)

Historical invoices, quotes, delivery notes, and payments are intentionally left in FactuSOL. Your FactuSOL installation remains the archive for all past documents. You start creating new invoices in Dolibarr from day one, with all your customers, suppliers, products, and stock already in place.

Spanish VAT (IVA)

FactuSOL's VAT type codes are mapped to actual Spanish rates:

Why choose this module

• No data re-entry. Thousands of products, customers, and suppliers — imported in minutes, not months.
• Transaction-safe. The entire import runs inside a single database transaction. A failure at any point rolls everything back cleanly.
• Province resolution. Customer and supplier provinces are matched to Dolibarr's official Spanish province list, keeping the FK integrity intact rather than storing free text.
• EAN13 barcodes. Product barcodes come across if the EAN13 type is installed in Dolibarr.
• Supplier links. Each product's default supplier is linked in llx_product_fournisseur_price.
• Detailed reporting. After import, a table shows imported / skipped / warnings per entity so you can spot any issues immediately.
• Error notification. On failure, the developer is automatically notified by email for faster support.

Requirements

Server

Install mdbtools

Verify: mdb-tables --version

Shared hosting: If your host disables exec(), this module cannot run. A VPS or dedicated server is required.

Installation

1. Download the module ZIP from Dolistore and extract it.
2. Copy the importfactusol/ folder to htdocs/custom/ in your Dolibarr installation.
3. Log in as administrator and go to Home → Setup → Modules/Applications.
4. Search for ImportFactuSOL and click Activate.
5. Go to Home → Setup → ImportFactuSOL to open the import page.

How to use

1. In FactuSOL, go to File → Backup (or Archivo → Copia de seguridad). The result is a ZIP named like FactuSOL_0012026.ZIP.
2. On the Dolibarr ImportFactuSOL setup page, upload that ZIP.
3. Click Start Import and wait. Large databases (thousands of products and customers) may take a few minutes.
4. Review the summary table. Any records that could not be imported appear in the Warnings column.

Troubleshooting

"mdbtools is not installed" — Install mdbtools on your server (see table above) and reload the page. The upload button re-enables automatically.

Import fails mid-way — All changes are rolled back. No partial data is written. Check the error message in the UI and the Dolibarr log at DOL_DATA_ROOT/dolibarr.log.

Province warnings — A province name in FactuSOL did not match Dolibarr's province list. The third party is still imported; the province field is left blank. You can set it manually on the customer/supplier card.

exec() is disabled — Switch to a VPS or contact your hosting provider to enable exec().

Changelog

1.0.0

• Initial release
• Imports: product categories, warehouses, customers, suppliers, products (with VAT, EAN13, categories, supplier links), and stock levels
• Transaction-safe with full rollback on error
• Province resolution via Dolibarr's llx_c_departements
• Compatible with Dolibarr 17 – 22

License

This module is distributed under the GNU GPL v3 licence. Each purchased licence authorises installation on one Dolibarr instance. For multi-instance deployments, please purchase one licence per instance.

The source code is available under GPL v3 terms; however, redistribution or resale of this module — modified or unmodified — is not permitted without prior written authorisation from the author.

Author

Diego Cebrián — diego@cebrian-it.fr