Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
4 Trả lời
7772 Lượt xem

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?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

  1. open PgAdmin

  2. select the Database

  3. select the res.partner

  4. right click on res.partner - select view data-view all rows

  5. select administrator row and copy the row into clipboard

  6. again select the res.partner

  7. right click on res.partner - select truncate cascaded(it will delete all customers and their related informations)

  8. 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

Ảnh đại diện
Huỷ bỏ
Tác giả

I cannot find res.partner. how do i get it, please?

Are you using windows? Then you can find PgAdmin.

Tác giả

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.

Tác giả

Easy for you, not me. The help doesn't even say. Please, tell me how? Thanks

Tác giả

res.partner does not appear again.

Tác giả

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.

Tác giả

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.

Câu trả lời hay nhất

If there is no sales entry for those customers then

  1. Go to Sales>Customers
    1. Select List view.
    2. Select the customers you want to delete by selecting their checkboxes.
    3. Click the More button and delete.
Ảnh đại diện
Huỷ bỏ
Tác giả

not possible. validation error from system.

Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ

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.

Tác giả Câu trả lời hay nhất

acting on it ASAP

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 3 15
3829
2
thg 8 25
225
2
thg 8 25
180
0
thg 8 25
86
1
thg 8 25
414