Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
string indices must be integers , many2one
Hi everybody, I want to ask you a question. I have an error :TypeError: string indices must be integers
code .py
class danh_sach_nv(osv.Model):
_name = 'danh.sach.nv'
_rec_name = 'ma_nv'
_columns = {
'ma_nv':fields.char('Mã NV',size=30),
'luong_dc':fields.related('ma_nv', 'luong_dc', type='many2one', relation='dieu.chinh', store=True, string='Lương điều chỉnh', readonly = 'True'),
}
class dieu_chinh(osv.Model):
_name = 'dieu.chinh'
_columns = {
'state': fields.selection([('draft', 'Draft'),('cancel', 'Cancel'),('done', 'Confirmed') ], 'Status',readonly=True,track_visibility='onchange'),
'image_nv':fields.related('ma_nv', 'image_nv',readonly = 'True', type ='binary', string = 'Ảnh đại diện'),
'ma_nv':fields.many2one('danh.sach.nv', 'Mã NV'),
'luong_dc':fields.integer('Lương điều chỉnh'),
}
Can you help me?I dont understan I have why I have an error?
Thank all
deep
Techno-Functional Associate with 6+ years of experience in Odoo (formerly known as OpenERP).
Before creating a related fields, one should have many2one field ... only then a related relation can be establised..
For example:
'partner_id': fields.many2one('res.partner', 'Partner')
'partner_email': fields.related('partner_id', 'email', ....)
As you can see, I have establised a relation to partner object first, then i can establish related for the same....
and also data type/property for the related field should be of target objects' column's data type...
Sudhir Arya (SA)
Working as an OpenERP/Odoo developer and a Team Leader
In short you should define related field like this:
'luong_dc':fields.related('ma_nv', 'luong_dc', type='integer, store=True, string='Lương điều chỉnh', readonly=True),
One more thing, readonly value should not be in string form (readonly='True'). It should be readonly=True.
You can get more idea about Related field.
Anil R. Kesariya
ERP Consultant
Key Skill
- Technical & Functional Expert
Here you go!
You have used related field luong_dc from dieu.chinh model which is defined as integer inside, but in danh.sach.nv model as you have use as relational field you have given many2one. but field type must be same. if you are realting each other.
Hope this will helps you.
Anil.
Emipro Technologies Pvt. Ltd.
Being an emerging leader in IT market since 2011, Emipro
Technologies Pvt. Ltd. has been providing a wide range of business
solutions in Odoo & Magento. We are pleased to have a large
pool of contented customers with our meticulous work in the domain
of ERP & e-Commerce. A ray of relief & satisfaction to
our customers heart by our successful deployment in their
organization, purely represents our success in Odoo platform.
Hence, we take pride for being an Odoo partner with a vision of
expanding our strategic alliances with our customers to offer them
high value-added, trustworthy & cost effective solutions.
Since establishment, our business has span across 11 countries of
the world. Our customers are companies of all sizes ranging from
start-ups to large enterprises, who realize that they need a
professional business solutions to generate revenue streams,
establish proper communication channels or streamline business
operations. Standing with strong determination of customer
satisfaction, observing each minute detail of their business
processes, providing proper guidance and moving forth to develop
product accordingly adds our value and reliability among our
customers.
We are blessed with efficient, passionate & eclectic young
developers who have come across almost all kinds of business
profiles, working with full dedication, applying creativity &
new features in existing modules and completing customer's
projects successfully on predefined target. Our in-depth knowledge
while giving business solutions in Odoo allows us to offer
following services to our customers :
- Consulting
- Installation, Configuration & Customization
- Training & Support
- Maintenance
- Upgradation
- Documentation
- Crafting community modules
- Drafting videos on demand
- Smart Apps development
We will be :) to welcome you @ www.emiprotechnologies.com to solve any kind of your business needs around Odoo. However we are just an inch away from you by email info@emiprotechnologies.com or a tweet to @EmiproTech
Hi,
There is wrong defination of the fields.related.
_columns = {
'ma_nv':fields.char('Mã NV',size=30),
'luong_dc':fields.related('ma_nv', 'luong_dc', type='many2one', relation='dieu.chinh', store=True, string='Lương điều chỉnh', readonly = 'True'),
}
In the above columns you have define 'ma_nv' is 'fields.char' and then you have define 'luong_dc' as 'fields.relate' to the relation with 'ma_nv'. This is wrong, you can only relate any field with 'many2one' field. So, you have to take 'ma_nv' of 'may2one' type or you have to remove 'luong_dc' from 'fields.related' and make it 'fields.many2one'.
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.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 9/4/14, 11:32 PM |
| Seen: 1521 times |
| Last updated: 3/16/15, 8:10 AM |
Hi huongcute you must change this line: 'luong_dc':fields.related('ma_nv', 'luong_dc', type='many2one', relation='dieu.chinh', store=True, string='Lương điều chỉnh', readonly = 'True'), instead of ma_nv you must give the class name(many2one).Thats why the error occured...Thank u
Sorry other class's(dieu_chinh) field name