Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Create product using XMLRPC - PHP, issue with public_categ_ids

php xmlrpc many2many

2 Antwoorden

11926 Weergaven

Fred Cruypenninck

Hi there,

I'm coding a small interface synchronisation between Odoo V9 and other ERP. Everything is working fine except for the public category ids.

Here's my field:

$fields = array( 'name' => 'test', 'default_code' => '1111', 'public_categ_ids' => array( 81 ) );
$odoo->create_product('product.product', $fields);
public function create_product($model, $fields){
$create = $this->ripcord_models->execute_kw($this->db, $this->uid, $this->password, $model, 'create', array( $fields )) ;
}

And here's the result (using xmlrpc debug):

DEBUG? openerp.http.rpc.request: 'name': 'test',

DEBUG? openerp.http.rpc.request: 'default_code': '1111',

DEBUG? openerp.http.rpc.request: 'public_categ_ids': [81],

All other fields are correctly set (name, default_code, etc.) but not the public_categ_ids and i don't have any error....

Do someone has any clue for me?

Thank you

Jérémy Kersten (jke)

Take a look here: https://www.odoo.com/documentation/8.0/reference/orm.html#openerp.models.Model.write

Have you try something like 'public_categ_ids' => array(array(6,0, array( 81 ))) that should generate the equivalent of ( 'public_categ_ids' = [(6, 0, [81])] )


    $url = "http://127.0.0.1:8069";
    $db = "8.0-debug";
    $username = "admin";
    $password = "admin";
    require_once('ripcord.php');
    $common = ripcord::client("$url/xmlrpc/2/common");
    $uid = $common->authenticate($db, $username, $password, array());
    $models = ripcord::client("$url/xmlrpc/2/object");
    $vals = array(
                array( 
                    'name' => 'test', 
                    'default_code' => '1111', 
                    'public_categ_ids' =>  array(
                        array(6,0, array(1))
                    )
                )
            );
    $create = $models->execute_kw($db, $uid, $password,
        'product.product', 'create', $vals
    );
    echo $create;

Fred Cruypenninck

Auteur

Jérémy... I tried... it works!!! it seems exactly similar to my code... anyway... THANK YOU! If you participate to the 2016 odoo days, i'll offer you a good beer :)

Jérémy Kersten (jke)

Sure, I will be there :) thank you

Fred Cruypenninck

Auteur

Hi Jérémy,

Thx for your reply.

I tried with...

'public_categ_ids' => array( array( 0,0, array( 81 ) ) ), error => cannot convert dictionary update sequence element #0 to a sequence

'public_categ_ids' => array( 0,0, array( 81 ) ), no error, not working

'public_categ_ids' => array( 6,0, array( 81 ) ), no error, not working

ps. i'm trying to create, not to update products

Jérémy Kersten (jke)

can you provide simplified php code to regenerate the issue in local ... that will be faster... And what is 81 ? the id of an existing product category ? so it should be 6 ...

Jérémy Kersten (jke)

Take a look in my previous answer, I have updated with a example which works !

Fred Cruypenninck

Auteur

Here you can browse my code: https://bitbucket.org/sp4tz/odoo-sync/src I simplyfied it a bit, so you wont have the ERP source part...

Jérémy Kersten (jke)

Have you try me code from previous answer ?
'public_categ_ids' => array(array(6,0, array( 81 ))) should works !

'cannot convert dictionary update sequence element' was because you try 0 instead of 6 ! 0 take a dict and not a list of id :)

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
XMLRPC WITH PHP php xmlrpc	0 mrt. 18	4949
Openerp xmlrpc PHP insert into re.users with company_id php xmlrpc	2 mrt. 15	11311
How to identify record is created from xmlrpc script(php) when create method overrite php xmlrpc	1 mrt. 15	8545
PHP Ripcord UnicodeEncodeError on Read php xmlrpc utf8	1 jan. 23	5744
How to find out the table name for a many2many relation (Where is the many2many table name stored?) Opgelost orm xmlrpc many2many	4 okt. 21	25201

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!