Skip to main content

Beta License: AGPL-3 OCA/server-backend Translate me on Weblate Try me on Runbot

By default, when importing data (like CSV import) with the base_import module, Odoo follows this rule:

  • If you import the XMLID of a record, make an update.

  • If you do not, create a new record.

This module allows you to set additional rules to match if a given import is an update or a new record.

This is useful when you need to sync heterogeneous databases, and the field you use to match records in those databases with Odoo’s is not the XMLID but the name, VAT, email, etc.

After installing this module, the import logic will be changed to:

  • If you import the XMLID of a record, make an update.

  • If you do not:

    • If there are import match rules for the model you are importing:

      • Discard the rules that require fields you are not importing.

      • Traverse the remaining rules one by one in order to find a match in the database.

        • Skip the rule if it requires a special condition that is not satisfied.

        • If one match is found:

          • Stop traversing the rest of valid rules.

          • Update that record.

        • If zero or multiple matches are found:

          • Continue with the next rule.

        • If all rules are exhausted and no single match is found:

          • Create a new record.

    • If there are no match rules for your model:

      • Create a new record.

By default 2 rules are installed for production instances:

  • One rule that will allow you to update companies based on their VAT, when is_company is True.

  • One rule that will allow you to update users based on their login.

In demo instances there are more examples.

Table of contents

Configuration

To configure this module, you need to:

  1. Go to Settings > Technical > Database Structure > Import Match.

  2. Create.

  3. Choose a Model.

  4. Choose the Fields that conform a unique key in that model.

  5. If the rule must be used only for certain imported values, check Conditional and enter the exact string that is going to be imported in Imported value.

    1. Keep in mind that the match here is evaluated as a case sensitive text string always. If you enter e.g. True, it will match that string, but will not match 1 or true.

  6. Save.

In that list view, you can sort rules by drag and drop.

Usage

To use this module, you need to:

  1. Follow steps in Configuration section above.

  2. Go to any list view.

  3. Press Import and follow the import procedure as usual.

Known issues / Roadmap

  • Add a setting to throw an error when multiple matches are found, instead of falling back to creation of new record.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Tecnativa

Contributors

  • Tecnativa: * Jairo Llopis * Vicent Cubells * Ernesto Tejeda

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

This module is part of the OCA/server-backend project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Release files for odoo12-addon-base-import-match 12.0.1.1.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for odoo12-addon-base-import-match 12.0.1.1.1
File Interpreter ABI Platform
odoo12_addon_base_import_match-12.0.1.1.1-py3-none-any.whl Python 3 none any Details

Release files / odoo12_addon_base_import_match-12.0.1.1.1-py3-none-any.whl

Download URL odoo12_addon_base_import_match-12.0.1.1.1-py3-none-any.whl
Size 135.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
7ee0655cb64f0691da03e7f2b576dab52e1cbee68712f8d8d7e142e7dcc029be
BLAKE2b-256 checksum
How to use checksums
40c377ec28ceae73c897ba5666ca48dd0b0027a50e7edb92b9628d9edcdeb2c8
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.1 CPython/3.8.5
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page