Delete through .csv

cpurbaugh · November 10, 2015, 2:04pm

Hey guys,

I think it would be pretty cool if it were possible to delete a file (such as item or BOM) using the .csv, perhaps by adding a column for delete? Not sure how it would work, but it’s just a thought.

-Chris

rmehta · November 12, 2015, 5:19am

@cpurbaugh, just run a simple python script to do this.

Tropicalrambler · February 5, 2016, 6:50pm

@rmehta I was looking for something similar, I assume the script must be run server side? How would such a script be run? I am thinking with our end users in mind, for them to be able to do it from within ERPNext. As @cpurbaugh states, adding a column with a 0 or 1 for “flag for deletion” would be great. For that import type, perhaps a final confirmation would be interesting to setup!

rmehta · February 6, 2016, 5:25am

Bulk delete is usually a dangerous action, what is the use case?

Tropicalrambler · February 12, 2016, 12:38am

I agree that bulk delete is a dangerous action, someone could certainly sabotage your data. Seems like deleting records straight from MariaDB would be a better option?

rmehta · February 12, 2016, 4:02am

Not that is worse, you will lose data integrity, just use a script and call frappe.delete_doc(doctype, name)

Tropicalrambler · February 19, 2016, 6:21am

Server side script is more elegant for sure. The bench environment simplifies many functions by way of easy scripts. Data integrity is preserved by not allowing users to delete multiple records at once.

Ben_Cornwell_Mott · February 19, 2016, 6:24am

I have used the REST API to mass delete files - doesn’t require a server_side script and is pretty easy to do. I did an excel macro for mass Submit, Cancel and Delete.