Deprixa Plus — Import & Migration · Method 2: Deprixa Pro SQL Migration
For users migrating from the older Deprixa Pro system, Deprixa Plus can parse SQL dump files exported from phpMyAdmin and create shipment records from them.
How to Migrate
- In your Deprixa Pro server, open phpMyAdmin and export the relevant tables as .sql files.
- In Deprixa Plus, navigate to Finance → Import and select the Deprixa Pro (SQL) tab.
- Upload your SQL dump files (drag and drop or click to browse).
- Click Import. The system parses the INSERT statements, maps old fields to the new schema, and creates shipment records.
- A summary displays imported and skipped counts with detailed reasons for any skipped rows.
Supported Tables
| Deprixa Pro Table | Purpose | Required? |
|---|---|---|
| cdb_add_order | Shipment/order records (tracking, status, weight, dates, amounts) | Required |
| cdb_users | Customer records (resolves sender/receiver IDs to names and emails) | Optional |
Security Protections
The SQL parser includes built-in safety checks. The following SQL operations are blocked and will cause the import to be rejected:
- DROP statements
- TRUNCATE statements
- DELETE statements
- UPDATE statements
Only INSERT INTO statements are processed. All other SQL content in the file is ignored.
File Limits
| Constraint | Value |
|---|---|
| Maximum files per upload | 6 files |
| Maximum file size (each) | 20 MB |
| Accepted file formats | .sql, .txt |
SQL Safety
The importer only reads INSERT statements from the uploaded SQL files. Any file containing DROP, TRUNCATE, DELETE, or UPDATE operations will be rejected entirely to protect your database.