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

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

ValueError: Expected singleton

models valueerror odoo9

3 ตอบกลับ

23748 มุมมอง

Dominic

Hello,

This is my function:

@api.depends('xidentification')
    def _concat_nit(self):

        # Executing only for Document Type 31 (NIT)
        if self.doctype is 31: # <--------------- THIS IS LINE 147
            # First check if entered value is valid
            self._check_ident()
            self._check_ident_num()
            # Instead of showing "False" we put en empty string
            if self.xidentification is False:
                self.xidentification = ''
            self.formatedNit = ''
            # Formatting the NIT: xx.xxx.xxx-x
            s = str(self.xidentification)[::-1]
            newnit = '.'.join(s[i:i+3] for i in range(0, len(s), 3))
            newnit = newnit[::-1]
            nitList = [
                newnit,
                # Calling the NIT Function which creates the Verification Code:
                self._check_dv(str(self.xidentification))
            ]
            formatedNitList = []
            for item in nitList:
                if item is not '':
                    formatedNitList.append(item)
                    self.formatedNit = '-' .join(formatedNitList)
            # Saving Verification digit in a proper field
            self.dv = nitList[1]

But I get the following error:

File "/home/travis/build/OCA/l10n-colombia/l10n_co_res_partner/models/l10n_co_res_partner.py", line 147, in _concat_nit
if self.doctype is 31:
File "/home/travis/odoo-9.0/openerp/fields.py", line 819, in __get__
record.ensure_one()
File "/home/travis/odoo-9.0/openerp/models.py", line 5403, in ensure_one
raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: res.partner(3, 7, 17, 32, 22, 21, 6, 18, 16, 14, 19, 20, 13, 11, 29, 35, 28, 8, 23, 24, 34, 25, 9, 26, 27, 39, 38, 15, 33, 37, 43, 5, 4, 42, 10, 30, 31, 12, 36, 1, 40, 41)

I have no clue why I get this error? Actually the function works in the interface, but Travis is complaining: https://travis-ci.org/OCA/l10n-colombia/jobs/139356438#L645

Any Ideas on how to fix this issue?

Baiju KS

คำตอบที่ดีที่สุด

Hi,

Try giving @api.one decorator for the method.

@api.depends('xidentification')   
@api.one    
     def _concat_nit(self):

This decorator loops automatically on Records of RecordSet for you. Self is redefined as current record:

try iterating with for loop

     for record in self:

        if record.doctype is 31: # <--------------- THIS IS LINE 147 
             # First check if entered value is valid            
            record._check_ident()

Hopes this solves the problem.

Dominic

ผู้เขียน

Thanks for your answer. Yes, with api.one it works, BUT api.one is deprecated in Odoo9, so I don't want to use it. Any other ideas?

Checking other resources I see that it might be an issue with a loop?

Pawan

Dominiac,

here in _concat_init you are getting list of res.partner object and when you are trying to access doctype off it, its not able to perform that as it is "list of objects".

So what you can do is,

1) As suggested by Baiju,

2) loop through self and check for each record as:

@api.depends('xidentification')    
    def _concat_nit(self):
         for record in self:
             if record.doctype is 31:
                 # Further code goes here, use record instead of self......

Hope this will help you...

Dominic

ผู้เขียน

This was it! Thank you :-) fixed the problem

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
ValueError("Expected singleton: %s" % self) แก้ไขแล้ว models valueerror odoo8.0	3 พ.ย. 23	36317
'NoneType' object has no attribute '_fields' views fields models odoo9	3 ม.ค. 17	16184
Meaning of Type of constraint : u and f (Odoo9) แก้ไขแล้ว database models constraint odoo9	2 เม.ย. 16	5033
Reuse field from a different Model models	1 พ.ย. 25	426
How can I use two models in an API (foreign key - relations)? models	0 ธ.ค. 24	2333

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!