Mass Clean Data (Clear Data)

by
Odoo

7.44

v 14.0 Third Party 194
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 198
Technical Name clean_data
LicenseOPL-1
Websitehttp://www.aktivsoftware.com
Versions 15.0 16.0 12.0 13.0 14.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 198
Technical Name clean_data
LicenseOPL-1
Websitehttp://www.aktivsoftware.com
Versions 15.0 16.0 12.0 13.0 14.0

Mass Clear Data(Clean data)

Main Features:
This module helps the user clear unwanted testing data using wizard on single click of button.

How to Use:
User need to activate the developer mode to access the "Clean Data" Menu in the Settings
Steps to activate developer mode:
Navigate to: Settings > General Settings > Developer Tools.

Clean Data Menu

Once the Developer Mode is activated, a new menu named "Clean Data" will visible.
Navigate to: Settings > Clean Data > Clean Data.

Available Options for Data Cleaning

Easily clear following object / tables data using the checkboxes:
1.Sales & All Transfers
2.Purchase & All Transfers
3.Only Transfers
4.All Invoicing, Payments & Journal Entries
5.Only Journal Entries
6.Customers & Vendors
7.Chart Of Accounts & All Accounting Data
User can also clean all above object using single click by checking "All Data" boolean.

Data will be deleted only if the table exist in the database. For example, If Purchase module is not installed, Purchase checkbox will be visible on the popup but as the table doesn't exist it will have no effect.

Notes: Do not use this module in production environment.
Data is deleted via SQL query and you will not be able to restore it.
This module supports only core objects/tables of the odoo and not custom objects/tables.

TAGS: Clean, Clear, Delete, Clean Data, data clean, Clear data, data clear, Delete Data, Bulk, Bulk delete, bulk clear, clear bulk, delete bulk, multiple, multiple delete, multi, multi delete, multi clear, multi remove, multi clean, SQl, SQl delete, Delete records, remove records, remove accounting, delete accounting, journal entries, journal items, journal entry, Delete all, all delete, data cleaner, DB cleaner, cleaner, Database, Database cleaner, bulk cleaner, tool, Db tool, DB delete tool, Database delete tool, purchase, sales, transfers, invoice, invoices, customer, payments, vendor, data delete, delete data,
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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Awesome
by
Deepak Kamath
on 9/20/21, 3:42 PM

We had a situation where we went live with both Odoo and old system.  However, midway customer decided to push out the cut off date.  So Odoo had a lot of transactional data that needs to be cleaned leaving the master data and interface intact.  This app works like charm to delete transactional data selectivelly.  thank you.

Re: Awesome
by
Jainesh Shah
on 9/22/21, 12:33 AM Author

Hello Deepak,

Thanks for using our module.

Regards,

Aktiv Software


The expense module cannot be deleted
by
gavinguo
on 12/1/21, 3:38 AM

The operation cannot be completed: another model requires the record being deleted. If possible, archive it instead.


Model: Expense Report (hr.expense.sheet), Constraint: hr_expense_sheet_account_move_id_fkey

Re: The expense module cannot be deleted
by
Jainesh Shah
on 12/2/21, 1:16 AM Author

Hi Gavinguo, 

Thank you for raising your concern over here for the Expense module. Currently, this application is not supporting the expense module. 

We will consider your point and cover it in our next app upgrade. 

Regards,

Aktiv Software



Even better, clean up left over product images and attachments
by
gavinguo
on 11/30/21, 3:46 AM

Adding junk attachments to delete is even better, such as deleting products from a website, but the related product image records and attachments are not automatically cleaned up, resulting in large database files with many attachments. 
------------------------ table -------------------------
product image records--> ir_attachment,product_image
attachments--->firestore

Re: Even better, clean up left over product images and attachments
by
Jainesh Shah
on 11/30/21, 7:13 AM Author

Hi Gavinguo, 

Thank you for using our application.

We will consider your suggestion in our upgrade list and we will keep you posted once there is an upgrade for the same. 

If you require this solution upgrade, you can email us at odoo@aktivsoftware.com

Regards,

Aktiv Software 



by
Radovan Pualic
on 11/26/21, 9:57 AM

Hello,

we have uploaded the module to our Odoo 14 Enterprice on the test environment, but the menu item Data clean is not shown in the menu bar. how can we fix it?

Re:
by
Jainesh Shah
on 11/30/21, 7:06 AM Author

Hi , 

Please try to install the module on blank database. 

Let us know if you face the same issue or email us on odoo@aktivsoftware.com

Regards,