데이터 정리¶

The Odoo Data Cleaning app keeps the database neat and organized throughout the use of its provided features:

• Deduplicates: merges or removes duplicate entries to ensure data is unique.

• Recycles: identifies outdated records to either archive or delete them.

• Merges: combines multiple similar entries into one streamlined record.

• Formats: standardizes text data by finding and replacing it according to specified needs.

Through customizable automated rules (or manual praxis), individual records and accompanying text data in the database will remain up-to-date and consistently formatted, tailored to company specifications.

Install modules¶

The Data Cleaning application consists of several modules. Install the following to access all available features:

중복 제거¶

중복 현황판 (데이터 정리 앱 ‣ 중복 제거)에서 Odoo는 중복 제거 규칙 에서 설정한 레코드 내에 조건을 적용하여 병합 할 유사한 레코드 그룹을 제안합니다.

The RULE sidebar lists each of the active deduplication rules, and displays the total number of duplicates detected beside each rule.

By default, the All rule is selected. Displayed records are grouped by their rule, with a Similarity rating (out of 100%) in the list view, with the following columns:

• Created On: the date and time the original record was created.

• Name: the name or title of the original record.

• Field Values: the original record’s values for the fields used to detect duplicates.

• Used In: lists other models referencing the original record.

• ID: the original record’s unique ID.

• Is Master: the duplicates are merged into the master record. There can be one master record in a grouping of similar records.

Select a specific rule in the RULE sidebar to filter the duplicate records.

Merge duplicate records¶

레코드를 병합하려면 먼저 유사한 레코드 그룹 내에 있는 마스터 레코드를 선택합니다. 마스터 레코드는 유사한 레코드에 대한 추가 정보를 병합할 때.기준이 되는 역할을 합니다.

Optionally, no master record can be set, leaving Odoo to choose a record at random to merge into.

Next, click the Merge button at the top of the similar records grouping. Then, click Ok to confirm the merge.

레코드가 병합되면 마스터 레코드의 메시지창에 병합에 대한 설명 메시지가 기록됩니다. 프로젝트 작업 등 일부 레코드는 간편하게 참조할 수 있도록 메시지창에 이전 레코드 링크가 같이 기록됩니다.

Deduplication rules¶

The Deduplication Rules page (Data Cleaning app ‣ Configuration ‣ Rules: Deduplication) is where the conditions for records to be detected as duplicates can be set.

These rules can be configured for each model in the database, and with varying levels of specificity.

Modify a deduplication rule¶

Select a default rule to edit, or create a new rule by clicking on the New button, on the Deduplication Rules page (Data Cleaning app ‣ Configuration ‣ Rules: Deduplication).

First, choose a Model for this rule to target. Selecting a model updates the rule title to the chosen model.

Optionally, configure a Domain to specify the records eligible for this rule. The number of eligible records is shown in the # record(s) link.

Depending on the selected Model, the Duplicate Removal field appears. Choose whether to Archive or Delete merged records.

Next, select a Merge Mode:

• Manual: requires each duplicate grouping to be manually merged, also enables the Notify Users field.

• Automatic: automatically merges duplicate groupings, without notifying users, based on the records with a similarity percentage above the threshold set in the Similarity Threshold field.

Enable the Active toggle to start capturing duplicates with this rule as soon as it is saved.

Lastly, create at least one deduplication rule in the Deduplication Rules field, by clicking Add a line, under the Unique ID Field column.

• Select a field in the model from the Unique ID Field drop-down menu. This field is referenced for similar records.

• Select a matching condition in the Match If field to apply the deduplication rule, depending on the text in the Unique ID Field:

  • Exact Match: the characters in the text match exactly.

  • Case/Accent Insensitive Match: the characters in the text match, regardless of casing and language-specific accent differences.

With the rule’s configuration complete, either close the rule form, or run the rule manually to instantly capture duplicate records.

Manually run a deduplication rule¶

To manually run a specific deduplication rule at any time, navigate to Data Cleaning app ‣ Configuration ‣ Rules: Deduplication, and select the rule to run.

Then, on the rule form, select the Deduplicate button on the top-left. Upon doing so, the Duplicates smart button displays the number of duplicates captured.

Click on the Duplicates smart button to manage these records.

Recycle records¶

Use the Recycle Records feature to rid the database of old and outdated records.

항목 레코드 재활용 현황판 (데이터 정리 앱 ‣ 레코드 재사용)에서 Odoo는 레코드 재사용 규칙 에 의해 설정한 레코드에 조건을 적용하여 보관 혹은 삭제할 수 있는 레코드를 감지합니다.

The RECYCLE RULES sidebar lists each of the active recycle record rules, and displays the total number of records detected beside each rule.

By default, the All option is selected. Records are displayed in the list view, with the following columns:

• Record ID: the ID of the original record.

• Record Name: the name or title of the original record.

Select a specific rule in the RECYCLE RULES sidebar to filter the duplicate records.

To recycle records, click the Validate button on the row of the record.

Upon doing so, the record is recycled, depending on how the rule is configured, to be either archived or deleted from the database.

Recycle record rules¶

The Recycle Records Rules page (Data Cleaning app ‣ Configuration ‣ Rules: Recycle Records) is where the conditions for records to be recycled can be set.

These rules can be configured for each model in the database, and with varying levels of specificity.

By default, no recycle record rules exist. Click the New button to create a new rule.

On the recycle record rule form, first choose a Model for this rule to target. Selecting a model updates the rule title to the chosen model.

Optionally, configure a Filter to specify the records eligible for this rule. The number of eligible records is shown in the # record(s) link.

Next, configure the field and time range for how the rule detects the records to recycle:

• Time Field: select a field from the model to base the time (Delta).

• Delta: type the length of time, which must be a whole number (e.g. 7).

• Delta Unit: select the unit of time (Days, Weeks, Months, or Years).

Then, select a Recycle Mode:

• Manual: requires each detected record to be manually recycled, and enables the Notify Users field.

• Automatic: automatically merges recycled groupings, without notifying users.

Lastly, select a Recycle Action to either Archive or Delete records. If Delete is selected, choose whether or not to Include Archived records in the rule.

With the rule’s configuration complete, either close the rule form, or run the rule manually to instantly capture records to recycle.

Example

A recycle rule can be configured to delete archived leads and opportunities that were last updated a year ago, and with a specific lost reason, by using the following configuration:

• Model: Lead/Opportunity

• 필터:

  • Active is not set

  • Lost Reason is in Too expensive

• Time Field: Last Updated on (Lead/Opportunity)

• Delta: 1

• Delta Unit: Years

• Recycle Mode: Automatic

• Recycle Action: Delete

• Include Archived:

Manually run a recycle rule¶

To manually run a specific recycle rule at any time, navigate to Data Cleaning app ‣ Configuration ‣ Rules: Recycle Records, and select the rule to run.

Then, on the rule form, click the Run Now button on the top-left. Upon doing so, the Records smart button displays the number of records captured.

Click the Records smart button to manage these records.

Field cleaning¶

항목 레코드 정리 현황판 (데이터 정리 앱 ‣ 항목 정리)에서 Odoo는 항목 정리 규칙에 설정되어 있는 규칙을 따르도록 레코드 항목의 데이터 서식 변경을 제안합니다.

Merge action manager¶

The Merge Action Manager (Data Cleaning app ‣ Configuration ‣ Merge Action Manager) enables or disables the Merge action available in the Actions menu for models in the database.