Odoo 14 Data Cleaning Module

Channel:

Cybrosys Technologies

Subscribers:

28,000

Published on September 16, 2020 8:45:51 AM ● Video Link: https://www.youtube.com/watch?v=ORN7Yeew5to

Duration: 9:20

3,016 views

9

The New Data cleaning module helps to remove duplicate data in odoo database. Whenever we create records this module checks the redundancy of data and gives suggestions for deleting or archiving those data. Certain rules are created inside the module and according to that rule, redundant data are removed/archived.Data can be automatically merged to a single record or it can be done manually also. Let us see how the module works:

First, install the Data cleaning module from the app store.

Video Contents:
0:00 Introduction
0:49 Install and goto Data Cleaning Modules
1:27 Editing Deduplication Rules in odoo
3:20 Applying Deduplication Rules in odoo
4:00 How to create a new contact in odoo
6:13 Create new field cleaning rules
7:52 Suggestions of Records to clean


Open Data cleaning module go to - Configuration - Deduplication Rules
Already we have some deduplication rules applied on certain models.
Now let us create a new deduplication rule

The form contains:
--Name of the deduplication rule
--Model to which the rule is applied
--Domain to add filtration on records
--Switch to enable Cross-Company so that the rule is applied to all companies
--Deduplicate removal- There are two options: Archive, Delete
--Merge mode: Automatic, Manual
--Notify users: We can notify users whenever the process is done(Days, Weeks, Months)
--Suggestion threshold
Active- It can be made active or inactive
Below we have a tree view to add the rules. So inside a single form, we can add multiple rule lines. A rule line contains two fields: Unique ID field, merge if

Now save the form and create two records having duplicate values for the fields mentioned in deduplication rules. Make sure that the model is the same as given in the deduplication rule form.

Now if you come back to the data cleaning module and click DEDUPLICATE button inside the form. A new page will be shown with the rules on the left side and the corresponding duplicated datas are also shown with the created date, Name, field values, model in which it is used, ID, ismaster.

Here similarity percentage is also shown, so this helps users to make decision whether those records need to be merged or discarded.After merging the records duplicated records will be merged to single one.

There is one more feature in data cleaning module ie.Field cleaning

Same as we create deduplication rule we can create field cleaning rule that helps to clean fields in a model by trimming spaces between the letters, setting type case, format phone, scrap html.Spaces can be trimmed by removing all spaces or on;y superfluous spaces.Field cleaning can also be done manually and automatically on a particular model.

When you click CLEAN button inside the form it displays all the fields that need to be cleaned with details such as RecordID, records name, field, current(current value of the field), suggested(suggested value for the field). Looking at these details we can validate or discard the cleaning process.
#odoo14 #odoo14features #odoo

►► Visit our company website: https://www.cybrosys.com/

Connect with us:
► Facebook: http://ow.ly/Ty0Q30lc5TU
► twitter: http://ow.ly/s5cV30lc5Vc
► LinkedIn: http://ow.ly/GJfg30lc5WT
► Pinterest: http://bit.ly/2I2b5N0

About Us
Cybrosys is enriched with technical experts and research scholars producing high-end quality software tools. Our sophisticated infrastructure and lab facilities constantly bring in new technological innovations and attributions. Partnership with ODOO, MICROSOFT, IBM, Intel, HP, NASSCOM proves our strength and excellence.

We are Odoo Gold Partners standing par excellence in Odoo Implementation, Customization, and allied services. We do Source code sale and Employee outsourcing. The latest research and developments in Cybrosys are being conducted in Blockchain. Our robust quality product and services are widely used by clients residing across in India, USA, UK, Middle East & Europe.