Rule Library
24 rules
Cleaning
Trim Whitespace
Leading and trailing
Remove Duplicates
All models
Null Fill
Default values
Empty Field Check
Required fields
Case Normalize
Title / Lower / Upper
Transformation
Date Format
ISO 8601 → Local
Field Merge
Concat fields
Value Mapping
Old → New map
Computed Fields
Derived values
Validation
Email Validator
RFC 5321
Phone Format
E.164 standard
Range Check
Min/Max bounds
Deduplication
Fuzzy Match
Levenshtein 85%
Exact Duplicate
Hash comparison
Data Cleaning and Transformation
// res.partner · product.product · account.move · 3 more models
Last run: 2 min ago
Next: in 58 min
Next: in 58 min
Total Records
48,291
↑ 1.2k this week
Issues Found
1,847
3.8% of total
Auto-Fixed
1,203
65.1% resolution
Pending Review
644
Needs action
Rules Active
18/24
75% coverage
Processing Pipeline
📥
INGEST
48,291 rows
→
🧹
CLEAN
−843 fixed
→
✓
VALIDATE
−360 flagged
→
⟿
TRANSFORM
in progress...
→
⋈
DEDUPE
pending
→
📤
OUTPUT
pending
Data Preview — res.partner
| ID | Name | Phone | Country | Issue | Action | |
|---|---|---|---|---|---|---|
| 1024 | Alice Fontaine | alice@ | +33 6 12 34 56 78 | FR | Invalid Email | Flag |
| 1025 | bob smith | bob.smith@corp.io | 0612345 | US | Phone Format | Auto-fix |
| 1026 | MARIA GARCIA | maria.g@empresa.es | +34 612 345 678 | Missing Country | Review | |
| 1027 | Jean-Pierre Dupont | jp.dupont@mail.fr | +33 1 40 20 30 40 | FR | Clean | Pass |
| 1028 | Alice Fontaine | alice.fontaine@mail.fr | +33 6 12 34 56 78 | FR | Duplicate | Merge |
| 1029 | Hiro Tanaka | hiro@@tanaka.jp | +81 90 1234 5678 | JP | Invalid Email | Flag |
| 1030 | Emma Wilson | e.wilson@studio.co | +44 7911 123456 | GB | Whitespace | Auto-fix |
Issue Breakdown by Model
| Model | Records | Issues | Coverage | Quality Score |
|---|---|---|---|---|
| res.partner | 18,402 | 923 | 74.2% | |
| product.product | 12,841 | 412 | 88.1% | |
| account.move | 9,103 | 287 | 68.4% | |
| sale.order | 5,229 | 118 | 93.5% | |
| mrp.production | 2,716 | 107 | 82.0% |
Config
Quality
Log
Overall Quality Score
81.3%
QUALITY
Clean 81.3%
Warn 9.0%
Error 9.7%
Issues by Type
✦ Trim Whitespace
Model
Fields
Auto-Fix
⟿ Date Format
Timezone
⋈ Fuzzy Match
Strategy
On Match
Recent Activity
14:02
FIX
Trimmed 843 whitespace fields in res.partner
14:01
WARN
412 records flagged: phone format mismatch
14:00
ERR
923 invalid emails detected in res.partner
13:58
INFO
Pipeline started — 48,291 records
13:55
SCHED
Cron job triggered by ir.cron #14