| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 800 |
| Technical Name |
gb_datimport_mapper_validator |
| License | OPL-1 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 800 |
| Technical Name |
gb_datimport_mapper_validator |
| License | OPL-1 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
Data Import Mapper & Vali
Map any CSV/Excel column to any model field, validate, dry-run and get an error report
The native importer fails silently on bad data and offers no reusable mapping or custom validation. This module turns messy spreadsheets into clean records in any Odoo model through a saved, repeatable pipeline — with validation that runs before a single record is created and a persistent error log for every run.
Key Features
Reusable import templates
Save a target model, file type, delimiter, encoding and header settings as a template you can reuse for every recurring import.
Auto column detection
Upload a sample file and the template detects its columns automatically, ready for you to map.
Flexible field mapping
Map each source column to a target field or skip it, set default values for gaps, and resolve relations by a chosen search field.
Per-field validation rules
Required, numeric, email, regex, min/max length, value-in-set and unique — checked row by row with a custom error message.
Safe dry-run
Parse, map and validate every row and get a full line-by-line error report — with nothing written to the database.
Create or update modes
Insert new records or match-and-update existing ones by a key field; invalid rows are skipped, reported and exportable as a CSV error report.
No more silent failures
Every rejected row is captured with the exact reason, so you fix the source data instead of guessing what broke.
Repeatable, not one-off
Saved mappings and validation rules turn a painful one-time migration into a reliable, repeatable data-onboarding process.
Screenshots
Import Runs
Import Templates
Why Choose This Module
Data migration teams, ERP implementers and consultants, finance and operations staff loading recurring spreadsheets, and anyone onboarding products, contacts, leads or stock from CSV/Excel into Odoo.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: LGPL-3
- Languages: 35+
- Author: Baris Genc
- Dependencies: base
- Support: odoo@gencbaris.com
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module