Command to clear data in address DB?

14 views
Skip to first unread message

CJ

unread,
May 21, 2014, 9:43:08 PM5/21/14
to erpnext-dev...@googlegroups.com
Hi, is there a command I can execute in console to clear the address DB?
Is there a list of command available somewhere out there?

Rushabh Mehta

unread,
May 21, 2014, 10:47:35 PM5/21/14
to erpnext-dev...@googlegroups.com
Hi, is there a command I can execute in console to clear the address DB?

I assume you mean address table?

do 

frappe --mysql
delete from tabAddress;
update tabCustomer set default_address=NULL; (example manually remove all Address links)

Is there a list of command available somewhere out there?

frappe --help


--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/29c85914-d83e-43fb-81ec-70a78bf26387%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages