Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
productxmlrpcattributes
3 Vastaukset
3396 Näkymät
Avatar
Bart Friederichs

I am working on a product importing tool, that imports data through XMLRPC into my Odoo 18 database. I am well on the way, except getting the Attribute lines has some mysteries for me.


I have created an product.attribute​and product.attribute.value​, which are are all OK. Now, to connect this to a product, I have to create a product.template.attribute.line​which has an attribute_id​ and an array of value_ids​. So far so good, however, to prevent creating too many items, I first want to check if such a line already exists. To do so, I have now this:


​existing_line_ids = self.models.execute_kw(self.database, self.uid, self.apikey, 'product.template.attribute.line', 'search', [[["value_ids","any",[value_id]],["attribute_id", "=", attribute_id]]])​


But this gives me an error: 

​ValueError: not enough values to unpack (expected 3, got 1)​


How can I search for a line that has a specific attribute_id​ and value_id​ set?


PS

This is the complete backtrace of the error:


xmlrpc.client.Fault: <Fault 1: 'Traceback (most recent call last):\n  File "/home/odoo/src/odoo/odoo/addons/base/controllers/rpc.py", line 161, in xmlrpc_2\n    response = self._xmlrpc(service)\n               ^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/addons/base/controllers/rpc.py", line 139, in _xmlrpc\n    result = dispatch_rpc(service, method, params)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/http.py", line 398, in dispatch_rpc\n    return dispatch(method, params)\n           ^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/service/model.py", line 39, in dispatch\n    res = execute_kw(db, uid, *params[3:])\n          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/service/model.py", line 61, in execute_kw\n    return execute(db, uid, obj, method, *args, **kw or {})\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/service/model.py", line 68, in execute\n    res = execute_cr(cr, uid, obj, method, *args, **kw)\n          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/service/model.py", line 52, in execute_cr\n    result = retrying(partial(odoo.api.call_kw, recs, method, args, kw), env)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/service/model.py", line 137, in retrying\n    result = func()\n             ^^^^^^\n  File "/home/odoo/src/odoo/odoo/api.py", line 517, in call_kw\n    result = getattr(recs, name)(*args, **kwargs)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/models.py", line 1717, in search\n    return self.search_fetch(domain, [], offset=offset, limit=limit, order=order)\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/models.py", line 1741, in search_fetch\n    query = self._search(domain, offset=offset, limit=limit, order=order or self._order)\n            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/models.py", line 5754, in _search\n    query = self._where_calc(domain)\n            ^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/models.py", line 5505, in _where_calc\n    return expression.expression(domain, self).query\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/osv/expression.py", line 781, in __init__\n    self.expression = domain_combine_anies(domain, model)\n                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/osv/expression.py", line 599, in domain_combine_anies\n    domain_any = _anyfy_leaves(domain, model)\n                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/osv/expression.py", line 381, in _anyfy_leaves\n    result.append((left, operator, _anyfy_leaves(right, comodel)))\n                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File "/home/odoo/src/odoo/odoo/osv/expression.py", line 366, in _anyfy_leaves\n    left, operator, right = item = tuple(item)\n    ^^^^^^^^^^^^^^^^^^^^^\nValueError: not enough values to unpack (expected 3, got 1)\n'>


Avatar
Hylkää
Avatar
D Enterprise
Paras vastaus

Hii,

Problem in Your Current Domain

This part:


[[ "value_ids" , "any" ,[value_id]],[ "attribute_id" , "=" , attribute_id]]

is incorrect because:

  • The any operator does not exist in Odoo's domain language.
  • Every condition in the domain must be a 3-element tuple/list : [field, operator, value]
Correct Way to Search for attribute_id and value_ids

To search for lines that have a specific attribute_id and one value in value_ids :

[
    [ "attribute_id" , "=" , attribute_id],
    [ "value_ids" , "in" , [value_id]],
]
  • "in" is the valid operator to check whether a value is in a many2many/one2many field.

Full Example

Here's how your XML-RPC call from Java/Python should look:

existing_line_ids = models.execute_kw(
    db, uid, password,
    'product.template.attribute.line' , 'search' ,
    [[
        [ 'attribute_id' , '=' , attribute_id],
        [ 'value_ids' , 'in' , [value_id]]
    ]]
)

This will return all product.template.attribute.line IDs that have:

  • The given attribute_id
  • At least one value_id equal to the one you're checking

i hope it is use fulll

Avatar
Hylkää
Avatar
Adil Akbar
Paras vastaus

Hi, please check this: https://youtu.be/Cmbo2iGuTBY 
Hope it helps.

Avatar
Hylkää
Avatar
Paresh Wagh
Paras vastaus

Hi Bart:

There are 2 issues that need to be fixed in the domain - remove the extra [] on the outside and add a condition for product template (I'm assuming you have a variable called product_template_id in your code). Try changing the domain expression in your code to the following:

[["value_ids.id", "=", value_id], ["attribute_id", "=", attribute_id], ["product_tmpl_id", "=", product_template_id]]


Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How to add an attribute to a product using XMLRPC?
product xmlrpc attributes
Avatar
Avatar
Avatar
Avatar
3
heinäk. 25
3008
Generating Product Data Sheet (pdf) possible?
product attributes
Avatar
Avatar
1
elok. 25
3880
Product Attributes Not Working
product attributes
Avatar
Avatar
2
lokak. 23
2896
Import Products with Attributes in Excel File
product import attributes
Avatar
Avatar
Avatar
Avatar
Avatar
5
toukok. 24
18251
How To Stop Product Images Vanishing When Selecting Attributes?
product images attributes
Avatar
Avatar
Avatar
2
maalisk. 24
3059