how do I remove the more than 50 customers that comes with the Sales app? And also the purchases app? And all other apps at once, so I can populate this view with only what I want to see?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
4
Replies
8487
Views
First the better option is you have to create a fresh database with no demonstration data
or
You have to delete the unwanted customers from PgAdmin.
open PgAdmin
select the Database
select the res.partner
right click on res.partner - select view data-view all rows
select administrator row and copy the row into clipboard
again select the res.partner
right click on res.partner - select truncate cascaded(it will delete all customers and their related informations)
then paste administrator row from clipboard
"Administrator" "en_US";1;1;"2013-07-02 09:13:13.845";"2013-07-02 09:13:27.178";1;"";"";0;"<binary data="">";FALSE;TRUE;"";FALSE;"";;"";;"";;;FALSE;"contact";"admin@example.com";"";"";"";"";"";;"";"";FALSE;"<binary data="">";"";"";"<binary data="">";"";FALSE;;"comment";FALSE;"";"";"";;;"";;"Administrator"
try to add this next to company
I cannot find res.partner. how do i get it, please?
Are you using windows? Then you can find PgAdmin.
Went to options and checked it. Now, I have an issue. Instead of copying only one row, the admin row, I copied two; the first row which is company data row and the second row, admin row. I then followed your instruction in removing customers which went fine. The problem: When I tried pasting the copied rows in the clipboard back into the res.partner table, only the first row, the company row was pasted, and the admin row is now lost. Result: I cannot log into the database as admin. There is no user, no admin - the database is just sleeping. Can you help me? thanks
Ok. Are you sure to copy the rows to clipboard? You can surely paste it.
See the updated answer. Dont be panic. You have to create a user in Pgadmin. It is very easy.
Easy for you, not me. The help doesn't even say. Please, tell me how? Thanks
res.partner does not appear again.
sorry, it still exists. nervous! decided to raise another ticket on this issue. I believe my issue should not bother you, remya. thanks for all the help. http://help.openerp.com/question/25093/respartner-tables-deleted-admin-all-users-lost-help-login/
Hi David, i cant reply you yesterday. Did you mean your whole table deleted or only its data?
I will help you create a new table or to add data.
Sorry, i tried but was not possible. some fields refuse to accept data input. will have to go with the suggestions from others in the forum. start with new database and reinstall everything. will never repeat the mistake though. thanks
if you are a developer, you have to know about how to create table,field through PgAdmin interface.
If there is no sales entry for those customers then
- Go to Sales>Customers
- Select List view.
- Select the customers you want to delete by selecting their checkboxes.
- Click the More button and delete.
not possible. validation error from system.
It seems that you installed the system with demonstration data. That's just to help you to understand how OpenERP works. If you want to have a system with only your data create a new database without checking load demonstration data.
You are right. It is the best solution.
Yes - there is SO MUCH demonstration data that you would probably spend more time deleting everything in the database than you would starting again with a new empty database.
acting on it ASAP
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Mar 15
|
4312 | ||
|
1
Nov 25
|
253 | ||
|
2
Nov 25
|
1066 | ||
|
2
Nov 25
|
466 | ||
|
2
Oct 25
|
514 |
