Insert record in odoo PostgreSQL database from c# and see record in Odoo

Question

I'm trying to insert a new client record in Odoo8 PostrgreSQL database using c#.

To connect with PostgreSQL database from c# , i use npgsql.

here is my Insert command

cmd.CommandText = "INSERT INTO res_partner (name,email,notify_email ,active) VALUES ('user name','[email protected]','[email protected]'," + true + ")";

I'm able to see the new insert record in res_partner table using pgAdmin, but using Odoo , i'm not able to see the new client.

Vinh VO · Accepted Answer · 2018-01-11 04:10:01Z

1

Odoo has a Web Service api which is better to use to interact with external application. With a little research, I found that interesting wrapper: OdooRpcWrapper . I used it in my application and everything works fine. I'm now able to see new added client from c# in Odoo8.

Code to add new client:

OdooConnectionCredentials creds = new OdooConnectionCredentials("http://localhost:8069", "your_bd", "admin", "admin");
OdooAPI api = new OdooAPI(creds);
//Define what model you want to use
OdooModel partnerModel = api.GetModel("res.partner");
//Create new objects by calling the model. New objects need to be saved.
OdooRecord record = partnerModel.CreateNew();
record.SetValue("name", "Abdelaziz test");
record.Save();

Step to use it in asp.net Webforms application:

Download OdooRpcWrapper from github
add it to your project: right click on solution => add => existing project and select the wrapper
add it as reference in your asp project: right click on reference => add reference => under solution tab, select OdooRpcWrapper project you added earlier
use the code to add new client

edited Jan 11, 2018 at 4:10

Vinh VO

7031 gold badge7 silver badges29 bronze badges

answered Mar 15, 2017 at 0:10

Oumar Diarra

3655 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CZoellner Over a year ago

Could you add your web api call code for this partner insertion here?

mahmoud alaa · Accepted Answer · 2018-01-10 15:28:41Z

0

Logically you can see changes in db in Odoo UI without using Odoo Web API

When you insert records in PostgreSQl db of odoo using webservice or manual from PgAdmin, you must insert values in all columns that not accept null to be reflected in odoo UI.

From pgadmin you can right click on a table, select properties to see which columns don't accept null.

answered Jan 10, 2018 at 15:28

mahmoud alaa

1111 silver badge7 bronze badges

Collectives™ on Stack Overflow

Insert record in odoo PostgreSQL database from c# and see record in Odoo

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related