Odoo Help


4 Answers



| 8 8 10
Thiruvananthapuram, India

Working as an Senior ODOO developer. http://in.linkedin.com/pub/remya-r/69/a23/298

7/17/13, 3:51 AM

First the better option is you have to create a fresh database with no demonstration data


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

odimegwu david
7/17/13, 1:30 PM

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

7/18/13, 2:10 AM

Are you using windows? Then you can find PgAdmin.

odimegwu david
7/18/13, 5:59 AM

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

7/18/13, 6:19 AM

Ok. Are you sure to copy the rows to clipboard? You can surely paste it.

7/18/13, 6:23 AM

See the updated answer. Dont be panic. You have to create a user in Pgadmin. It is very easy.

odimegwu david
7/18/13, 10:34 AM

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

odimegwu david
7/18/13, 10:39 AM

res.partner does not appear again.

odimegwu david
7/18/13, 11:10 AM

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/

7/19/13, 1:53 AM

Hi David, i cant reply you yesterday. Did you mean your whole table deleted or only its data?

7/19/13, 1:54 AM

I will help you create a new table or to add data.

odimegwu david
7/19/13, 6:19 AM

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

7/19/13, 6:24 AM

if you are a developer, you have to know about how to create table,field through PgAdmin interface.


Grover Hernando Menacho Quisbert

--Grover Hernando Menacho Quisbert--
WebVision Enterprise Systems
| 7 8 10
La Paz, Bolivia
--Grover Hernando Menacho Quisbert--

Odoo Developer

Grover Hernando Menacho Quisbert
7/16/13, 1:43 PM

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.

7/17/13, 5:08 AM

You are right. It is the best solution.

Ray Carnes
7/18/13, 2:00 AM

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.

7/16/13, 1:31 PM

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.
1 Comment
odimegwu david
7/17/13, 1:31 PM

not possible. validation error from system.

odimegwu david
7/17/13, 6:27 AM

acting on it ASAP

Ask a Question
Keep Informed
0 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Odoo Training Center

Access to our eLearning platform and experience all Odoo Apps through learning videos, use cases and quizzes.

Test it now