Skip to main content

Odoo: Upload binary images from backend using API




If you want to upload a binary image to Odoo using API..here are the steps:

controllers/main.py

# -*- coding: utf-8 -*-
from odoo.tools.translate import _
from odoo import http
from odoo.http import request
from odoo.addons import web
from time import strftime
import functools
import datetime
import json
import base64
import sys
import copy
from dateutil import parser
import logging
from operator import itemgetter
logger = logging.getLogger(__name__)


def serialize_exception(f):
    @functools.wraps(f)
    def wrap(*args, **kwargs):
        try:
            return f(*args, **kwargs)
        except Exception, e:
            logger.debug("An exception occured during an http request")
            #se = _serialize_exception(e)
            error = {
                'code': 200,
                'message': "Odoo Server Error",
                'data': str(e)
            }
            return json.dumps(error)
    return wrap


class Binary(web.controllers.main.Binary):
    @http.route('/api/upload_images', type='http', auth="public", csrf=False)
    @serialize_exception
    def upload_attachment(self, uid, ufile, ufile_name):
        user_model = request.env['res.users']
        user_ids = user_model.sudo().browse([('id', '=', uid)])
        if user_ids:
            user_obj = user_ids[0]
            try:
                user_obj.write({
                    'uploaded_files': base64.encodestring(ufile.read()),
                    'uploaded_files_filename': ufile_name,
                })
            except Exception:
                args = {'status': 0, 'error': "Something horrible happened."}
                return json.dumps(args)
            return json.dumps({'status': 1, 'message': 'File uploaded successfully'})
        else:
            return json.dumps({'status': 0, 'message': 'User does not exist.'})



Where fields are:

uploaded_files = fields.Binary(string=_('Files'), attachment=True, store=True)
uploaded_files_filename = fields.Char("Filename")

and JS code is:

<script>
    // grab your file object from a file input
    // Where fileInput is
    // <input id="fileInput" type="file" />
    $('#fileInput').change(function () {
        sendFile(this.files[0]);
    });

    function sendFile(file) {
        var querydata = new FormData();
        querydata.append('ufile',file);
        querydata.append('ufile_name',file.name);
        querydata.append('uid', 10);
        //querydata.append('multi', 'true');
        $.ajax({
            url: "http://xxxxx:8069/api/upload_images",
            data: querydata,
            type: "POST",
            cache: false,
            processData: false, 
            contentType: false,
            dataType: "json",
            beforeSend: function (xhr) {

            },
            success: function (result) {
                console.log(result);
                console.log(result.status);   
            },
            error: function (err) {
                console.log(err);
            }
        });
    }
</script>


References:

https://www.odoo.com/forum/help-1/question/openerp-multiple-file-upload-54736 
https://code.tutsplus.com/tutorials/base64-encoding-and-decoding-using-python--cms-25588
https://www.odoo.com/forum/help-1/question/change-filename-on-field-binary-52235

Thanks!!!!!!!!!! Enjoy Programming!!! :) 

Comments

Post a Comment

Thanks for your valuable comments.

Popular posts from this blog

Odoo/OpenERP: one2one relational field example

one2one relational field is deprecated in OpenERP version>5 but you can achieve the same using many2one relational field. You can achieve it in following two ways : 1) using many2one field in both the objects ( http://tutorialopenerp.wordpress.com/2014/04/23/one2one/ ) 2)  using inheritance by deligation You can easily find the first solution with little search over internet so let's start with 2nd solution. Scenario :  I want to create a one2one relation between two objects of openerp hr.employee and hr.employee.medical.details What I should do  i. Add _inherits section in hr_employee class ii. Add field medical_detail_id in hr_employee class class hr_employee(osv.osv):     _name = 'hr.employee'     _inherits = {' hr.employee.medical.details ': "medical_detail_id"}     _inherit = 'hr.employee'         _columns = {              'emp_code':fields.char('Employee Code', si

How to draw Dynamic Line or Timeseries Chart in Java using jfreechart library?

Today we are going to write a code to draw a dynamic timeseries-cum-line chart in java.   The only difference between simple and dynamic chart is that a dynamic event is used to create a new series and update the graph. In out example we are using timer which automatically calls a funtion after every 1/4 th second and graph is updated with random data. Let's try with the code : Note : I had tried my best to provide complete documentation along with code. If at any time anyone have any doubt or question please post in comments section. DynamicLineAndTimeSeriesChart.java import java.awt.BorderLayout; import java.awt.Color; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.Timer; import javax.swing.JPanel; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.ValueAxis; import org.jfree.chart.plot.XYPlot; import

pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]

Recently, I faced this error in our Docker-Container environment. All the necessary packages were already installed but still, I was facing this clueless error. I search a bit and after an hour and so I found the exact reason and solution for this error. To know more about this error in detail. Please follow this Github thread. https://github.com/mkleehammer/pyodbc/issues/610 https://github.com/mkleehammer/pyodbc/issues/610#issuecomment-587523802 Solution: It's because the   server's certificate has too weak a key. In case you are using Linux env directly/not the Docker one.  Just edited /etc/ssl/openssl.cnf and change these 2 lines. MinProtocol = TLSv1.0 CipherString = DEFAULT@SECLEVEL=1 In case you are also using a container, please add these three lines to your Docker file. RUN chmod +rwx /etc/ssl/openssl.cnf RUN sed -i ' s/TLSv1.2/TLSv1/g ' /etc/ssl/openssl.cnf RUN sed -i ' s/SECLEVEL=2/SECLEVEL=1/g ' /etc/ssl/openssl.cnf Thanks!! Enjoy Programming! Refer