Cleaning up test data

ERPNext
1

Hi,


I am trying to clean up test data using lib/wnf.py --cleanup_data.
Cleaning up take no effects.
Following error occurs:
Are you sure you want to delete the data from the system (N/Y)?y

What type of cleanup you want ot perform?
        1. Only Transactions
        2. Both Masters and Transactions

        Please enter your choice (1/2):
                2
Deleting transactions…
Deleted Timesheet
Deleted Task
Deleted Support Ticket
Deleted Stock Reconciliation
Deleted Stock Ledger Entry
Deleted Stock Entry
Deleted Sales Order
Deleted Salary Slip
Deleted Sales Invoice
Deleted Quotation
Deleted Quality Inspection
Deleted Purchase Receipt
Deleted Purchase Order
Deleted Production Order
Deleted POS Setting
Deleted Period Closing Voucher
Deleted Purchase Invoice
Deleted Maintenance Visit
Deleted Maintenance Schedule
Deleted Leave Application
Deleted Leave Allocation
Deleted Lead
Deleted Journal Voucher
Deleted Installation Note
Deleted Material Request
Deleted GL Entry
Deleted Expense Claim
Deleted Opportunity
Deleted Delivery Note
Deleted Customer Issue
Deleted Bin
Deleted Authorization Rule
Deleted Attendance
Deleted C-Form
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 415, in run
    cleanup_data.run()
  File “app/utilities/cleanup_data.py”, line 184, in run
    delete_transactions()
  File “app/utilities/cleanup_data.py”, line 36, in delete_transactions
    webnotes.conn.sql(“delete from tab%s” % (d))
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.ProgrammingError: (1146, “Table ‘erpnext.tabForm 16A’ doesn’t exist”)

Pls. advice.

Thank You,
Ferenc

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/lw6DPAvd0jMJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

2
Fixed. Thanks for reporting.


On 09-Mar-2013, at 6:22 PM, Ferenc <fe...@gmail.com> wrote:

Hi,

I am trying to clean up test data using lib/wnf.py --cleanup_data.
Cleaning up take no effects.
Following error occurs:
Are you sure you want to delete the data from the system (N/Y)?y

What type of cleanup you want ot perform?
        1. Only Transactions
        2. Both Masters and Transactions

        Please enter your choice (1/2):
                2
Deleting transactions...
Deleted Timesheet
Deleted Task
Deleted Support Ticket
Deleted Stock Reconciliation
Deleted Stock Ledger Entry
Deleted Stock Entry
Deleted Sales Order
Deleted Salary Slip
Deleted Sales Invoice
Deleted Quotation
Deleted Quality Inspection
Deleted Purchase Receipt
Deleted Purchase Order
Deleted Production Order
Deleted POS Setting
Deleted Period Closing Voucher
Deleted Purchase Invoice
Deleted Maintenance Visit
Deleted Maintenance Schedule
Deleted Leave Application
Deleted Leave Allocation
Deleted Lead
Deleted Journal Voucher
Deleted Installation Note
Deleted Material Request
Deleted GL Entry
Deleted Expense Claim
Deleted Opportunity
Deleted Delivery Note
Deleted Customer Issue
Deleted Bin
Deleted Authorization Rule
Deleted Attendance
Deleted C-Form
Traceback (most recent call last):
  File "lib/wnf.py", line 494, in <module>
    run()
  File "lib/wnf.py", line 415, in run
    cleanup_data.run()
  File "app/utilities/cleanup_data.py", line 184, in run
    delete_transactions()
  File "app/utilities/cleanup_data.py", line 36, in delete_transactions
    webnotes.conn.sql("delete from `tab%s`" % (d))
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.ProgrammingError: (1146, "Table 'erpnext.tabForm 16A' doesn't exist")

Pls. advice.

Thank You,
Ferenc

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/lw6DPAvd0jMJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 


–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

3

Hello,

I am trying to clear the test data but I am not really familiar with linux command lines. When I enter the lib/wnf.py --cleanup_data command in the vm screen (starting with erpnext@erpnextvm:), I end up with the following error:

-bash: lib/wnf.py: no such file or directory

I am running erpnext on a virtualbox vm. What am I doing wrong?

Thank for your help

4

lib/wnf.py is deprecated in version 4. Also cleanup_data is not available now.

You can reinstall using bench frappe --reinstall <your_site_name>, it will reinstall all existing apps automatically.

5

Ok but I want to keep the master data (customers, items, etc), not do a complete fresh install.
Or if there is a way to delete submitted records that should be ok.

6

No, you have to cancel the transactions first to delete those.

Better way will be export all the master date in csv file and then reinstall. Later you import those csv files after reinstalling.

7

Hi, I am entreprener with limited knowlege on coding however, I am liking very userfriendly UX of ErpNext. i was following documentation for deleting test transections however same link “deletion tool” is not present in current version. can anybody help ?