Odoo Help

Welcome!

This community 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.

0

Programming error

By
MALLE SOULEYMANE
on 7/8/14, 5:27 AM 952 views

Hi, I create a tree view based in the sql view, I don't know the source of this error:

Client Traceback (most recent call last): File "/home/openerp/workspace/sankofa/openerp/addons/web/http.py", line 203, in dispatch response["result"] = method(self, **self.params) File "/home/openerp/workspace/sankofa/openerp/addons/web/controllers/main.py", line 1055, in search_read return self.do_search_read(req, model, fields, offset, limit, domain, sort) File "/home/openerp/workspace/sankofa/openerp/addons/web/controllers/main.py", line 1078, in do_search_read req.context) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, *args) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info) Server Traceback (most recent call last): File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/home/openerp/workspace/sankofa/openerp/netsvc.py", line 293, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/home/openerp/workspace/sankofa/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, *args, **kwargs) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/openerp/workspace/sankofa/openerp/osv/orm.py", line 2354, in search return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count) File "/home/openerp/workspace/sankofa/openerp/osv/orm.py", line 4856, in _search cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params) File "/home/openerp/workspace/sankofa/openerp/sql_db.py", line 161, in wrapper return f(self, *args, **kwargs) File "/home/openerp/workspace/sankofa/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: relation "transfert_movement" does not exist LINE 1: SELECT "transfert_movement".id FROM "transfert_movement" ORDER BY "transfert_m... ^

My xml code is:

    <record id="view_transfert_movement_search" model="ir.ui.view">
        <field name="name">transfert.movement.search</field>
        <field name="model">transfert.movement</field>
        <field name="arch" type="xml">
            <search string="transfert movements">
                 <filter string="No.Transfert" domain="[]"  context="{'group_by':'name'}"/>
                 <filter string="Respo. Chargeur" domain="[]"  context="{'group_by':'partner_id'}"/>
                 <filter string="Chauffeur" domain="[]"  context="{'group_by':'material_driver_partner_id'}"/>
                 <filter string="Camion" domain="[]"  context="{'group_by':'material_license_plate'}"/>
                 <filter string="Date du transfert" domain="[]"  context="{'group_by':'date'}"/>
                 <filter string="Material" domain="[]"  context="{'group_by':'product_id'}"/>
                 <filter string="Source" domain="[]"  context="{'group_by':'sourcelocation'}"/>
                 <filter string="Destination" domain="[]"  context="{'group_by':'destinationlocation'}"/>
                 <filter string="Statut" domain="[]"  context="{'group_by':'state'}"/>
            </search>
        </field>
    </record>

    <record id="view_transfert_movement_report_tree_new" model="ir.ui.view">
        <field name="name">transfert.movement.tree</field>
        <field name="model">transfert.movement</field>
        <field name="arch" type="xml">
            <tree string="Out movements" create='false'>
                <field name="name"/>
                <field name="partner_id"/>
                <field name="material_driver_partner_id"/>
                <field name="material_license_plate"/>
                <field name="date"/>
                <field name="product_id"/>
                <field name="product_qty"/>
                <field name="sourcelocation"/>
                <field name="destinationlocation"/>
                <field name="state"/>
            </tree>
        </field>
    </record>
 
    <record id="action_transfert_movement_report_new" model="ir.actions.act_window">
        <field name="name">transfert movements</field>
        <field name="res_model">transfert.movement</field>
        <field name="view_type">form</field>
<!--         <field name="search_view_id" ref="view_transfert_movement_search"/> -->
        <field name="view_mode">tree</field>
    </record>
    <menuitem name="Mouvements" id="menu_transfert_mouvement_new" parent="menu_material_transfert" action="action_transfert_movement_report_new" sequence="20"/>

and my .py code is:

class transfert_movement(osv.osv):
    _name = "transfert.movement"
    _description = "transfert movement"
    _auto = False
    _columns = {
        'name': fields.char('No. Transfert', size=128),
        'partner_id': fields.many2one('res.partner', 'Respo Chargeur'),
        'material_driver_partner_id': fields.many2one('res.partner', 'Chauffeur'),
        'material_license_plate': fields.char('Camion', size=128),
        'date': fields.date('Date de transfert'),
        'product_id': fields.many2one('product.product', 'Material'),
        'product_qty': fields.integer('Quantity'),
        'sourcelocation': fields.char('Source', size=128),
        'destinationlocation': fields.char('Destination', size=128),
        'state': fields.selection(
            [('draft', 'Draft'),
            ('cancel', 'Cancelled'),
            ('auto', 'Waiting Another Operation'),
            ('confirmed', 'Waiting Availability'),
            ('assigned', 'Ready to Transfer'),
            ('done', 'Transferred'),
            ], 'Status'),
    }

    def init(self, cr):
        tools.drop_view_if_exists(cr, self._table)
        cr.execute("""CREATE or REPLACE VIEW %s as (select distinct sm.id as id, sp.name, sp.partner_id,
        sp.material_driver_partner_id, sp.material_license_plate, sp.date, sm.product_id,
        sm.product_qty, sl_source.name as sourcelocation, sl_dest.name as destinationlocation,
        sp.state
        from
        stock_picking sp, stock_move sm, stock_location sl_source, stock_location sl_dest  
        where
        sp.pickingmaterialtype='materialtransfert' and sp.id = sm.picking_id and
        sl_dest.id = sm.location_dest_id and sl_source.id = sm.location_id)
         """ % (self._table))

Help me please, Thanks...

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/8/14, 5:27 AM
Seen: 952 times
Last updated: 3/16/15, 8:10 AM