Skip to Content
Odoo Menu
  • Prisijungti
  • Išbandykite nemokamai
  • Programėlės
    Finansai
    • Apskaita
    • Pateikimas apmokėjimui
    • Sąnaudos
    • Skaičiuoklė (BI)
    • Dokumentai
    • Pasirašymas
    Pardavimai
    • CRM
    • Pardavimai
    • Kasų sistema - Parduotuvė
    • Kasų sistema - Restoranas
    • Prenumeratos
    • Nuoma
    Svetainės
    • Svetainių kūrėjimo įrankis
    • El. Prekyba
    • Internetinis Tinklaraštis
    • Forumas
    • Tiesioginis pokalbis
    • eMokymasis
    Tiekimo grandinė
    • Atsarga
    • Gamyba
    • PLM
    • Įsigijimai
    • Priežiūra
    • Kokybė
    Žmogaus ištekliai
    • Darbuotojai
    • Įdarbinimas
    • Atostogos
    • Įvertinimai
    • Rekomendacijos
    • Transporto priemonės
    Rinkodara
    • Socialinė rinkodara
    • Rinkodara el. paštu
    • SMS rinkodara
    • Renginiai
    • Rinkodaros automatizavimas
    • Apklausos
    Paslaugos
    • Projektas
    • Darbo laiko žiniaraščiai
    • Priežiūros tarnyba
    • Pagalbos tarnyba
    • Planavimas
    • Rezervacijos
    Produktyvumas
    • Diskucija
    • Patvirtinimai
    • IoT
    • VoIP
    • Žinių biblioteka
    • WhatsApp
    Trečiųjų šalių programos Odoo Studija Odoo debesijos platforma
  • Pramonės šakos
    Mažmeninė prekyba
    • Knygynas
    • Drabužių parduotuvė
    • Baldų parduotuvė
    • Maisto prekių parduotuvė
    • Techninės įrangos parduotuvė
    • Žaislų parduotuvė
    Food & Hospitality
    • Barai ir pub'ai
    • Restoranas
    • Greitasis maistas
    • Guest House
    • Gėrimų platintojas
    • Hotel
    Nekilnojamasis turtas
    • Real Estate Agency
    • Architektūros įmonė
    • Konstrukcija
    • Estate Managament
    • Sodininkauti
    • Turto savininkų asociacija
    Konsultavimas
    • Accounting Firm
    • Odoo Partneris
    • Marketing Agency
    • Teisinė firma
    • Talentų paieška
    • Auditai & sertifikavimas
    Gamyba
    • Textile
    • Metal
    • Furnitures
    • Maistas
    • Brewery
    • Įmonių dovanos
    Sveikata & Fitnesas
    • Sporto klubas
    • Akinių parduotuvė
    • Fitneso Centras
    • Sveikatos praktikai
    • Vaistinė
    • Kirpėjas
    Trades
    • Handyman
    • IT įranga ir palaikymas
    • Saulės energijos sistemos
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Kiti
    • Nonprofit Organization
    • Aplinkos agentūra
    • Reklaminių stendų nuoma
    • Fotografavimas
    • Dviračių nuoma
    • Programinės įrangos perpardavėjas
    Browse all Industries
  • Bendrija
    Mokykitės
    • Mokomosios medžiagos
    • Dokumentacija
    • Sertifikatai
    • Mokymai
    • Internetinis Tinklaraštis
    • Tinklalaidės
    Skatinkite švietinimą
    • Švietimo programa
    • Scale Up! Verslo žaidimas
    • Aplankykite Odoo
    Gaukite programinę įrangą
    • Atsisiųsti
    • Palyginkite versijas
    • Leidimai
    Bendradarbiauti
    • Github
    • Forumas
    • Renginiai
    • Vertimai
    • Tapkite partneriu
    • Services for Partners
    • Registruokite jūsų apskaitos įmonę
    Gaukite paslaugas
    • Susiraskite partnerį
    • Susirask buhalterį
    • Susitikti su konsultantu
    • Diegimo paslaugos
    • Klientų rekomendavimas
    • Palaikymas
    • Atnaujinimai
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Gaukite demo
  • Kainodara
  • Pagalba

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

  • CRM
  • e-Commerce
  • Apskaita
  • Atsarga
  • PoS
  • Projektas
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
Pagalba

Upload a file by code thanks to ir.attachment

Prenumeruoti

Get notified when there's activity on this post

This question has been flagged
filestorecreateir_attachment
6 Replies
32090 Rodiniai
Portretas
Fabien REMY

Hi all,

I try to upload a file generated on the server by an OpenERP (v 7.0) cron task via the ir.attachment object.

 When I set the parameters passed to the ir.attachment create method, I don't know what kind of object I need for the datas parameter ?

Do I need an absolute path to my file ? An instance of my opened file ? something else ?

The error I have is : "Cannot determine mime type... I guess I don't give the right type of object.


Example :


document_vals = {'name': name_file_export_final,                        -> filename.csv

                             'datas': fname,                                                  -> path to my file (under Windows)

                             'datas_fname': name_file_export_final,            -> filename.csv

                             'res_model': self._name,                                   -> My object_model

                             'res_id': gm_record_id,                                     -> the id linked to the attachment.

                             'type': 'binary' }

ir_id = ir_attachement_obj.create(cr, uid, document_vals, context)


The record is created within the table ir_attachment, I can see the attached file on my object on the web application, but when I download the file it is stangely encoded.

My developments are done under windows, but the server is under Unix (if it could be usefull for my problem)

Thank you for your answers.

Fabien.

2
Portretas
Atmesti
Temur

You mean file names are encoded, like 68bb912c1711dade5df906449f0d5dd3 ?

Temur

that's filename as it stored in the odoo filestore. it avoids duplicated files in filestore. the real filenames are stored in the database, for download these files with correct filename, you've to manage to have all parameters set correctly ('datas_fname' should set to real filename, etc.)

Fabien REMY
Autorius

Hi Temur !! Thank you very much for your reactivity and your great answer. Now it works. Once the file read in a local variable and encoded in base64, the file is stored with its data. Thanks again. Fabien.

Temur

Il n'y à pas de quoi

Fabien REMY
Autorius

Temur, One more question, regarding the mime type of my file. The module openerp.addons.document.content_index send an exception saying that it "Cannot determine mime type." Any idea ? Cheers.

Temur

try to add one more parameter (for csv file):

'mimetype': 'text/csv',
Fabien REMY
Autorius

You mean add that parameter when I create the ir.attachment object within the params dictionnary ? I've already try that, but it replies me that mimetype is not an attribute of that object.

Fabien REMY
Autorius

Here is the full stacktrace : 2015-05-11 13:48:13,480 5076 ERROR db_name openerp.addons.document.content_index: Cannot determine mime type. Traceback (most recent call last): File "D:\workspace_luna\openerp_server\openerp-7\openerp\addons\document\content_index.py", line 167, in doIndex pop = Popen(['file','-b','--mime',fname], shell=False, stdout=PIPE) File "D:\Python27\lib\subprocess.py", line 679, in __init__ errread, errwrite) File "D:\Python27\lib\subprocess.py", line 896, in _execute_child startupinfo) File "D:\Program Files\eclipse_luna\plugins\org.python.pydev_3.7.0.201408261926\pysrc\pydev_monkey.py", line 289, in new_CreateProcess return getattr(_subprocess, original_name)(appName, patch_arg_str_win(commandLine), *args) And a final error from Windows : WindowsError: [Error 2] Le fichier spécifié est introuvable = The specified file is not found

Temur

yes I meant to add this parameter when you create ir.attachment. agree, in v7 there is no mimetype field. I'm sorry, I actually work on v8 and in v8 there is mimetype field in ir.attachment model added somewhere. have not checked it back in v7. so 'mimetype' parameter is not a solution.

Temur

have you listed "document" module as dependency in __openerp__.py for your module? using 'depends' property?

Temur

custom indexer for csv fiels:

from document.content_index import indexer, cntIndex
....
class CsvIndex(indexer):
    def _getMimeTypes(self):
        return ['text/csv','application/csv','text/*']

    def _getExtensions(self):
        return ['.csv']

    def _doIndexContent(self, content):
        return content

cntIndex.register(CsvIndex())
your error comes from contentIndex.doIndex() function. it seems there is not support for indexing of csv files. you'll have to add support for it or install some module (if any) that adds such support. for the start you can try to add above custom indexer in your code. hope this'll work, if not, then you'll have to add support for indexing of csv files somehow if you want to disappear this error.
Fabien REMY
Autorius

Temur, ... you rock ! It works fine now. Thank you for your precious help.

Temur

You're welcome

Portretas
Temur
Best Answer

For datas parameter you'll need file content (encoded with base64).

Read the whole file content into the some varialbe, lets say _content, and then use as:

'datas': _content.encode('base64'),

 

3
Portretas
Atmesti
Temur

updated with .encode('base64'), as you read file content locally at the server side, it's normal content, whereas while sending over network content is encoded with base64 encoding. so after reading normal file content into the '_content' variable, you'll need to encode it witn .encode('base64') to get base64 encoded content string instead of normal file content string.

Portretas
Fabien REMY
Autorius Best Answer

Hi Temur,

No, the filename is encoded in a good way, just the file content (a "stupid" CSV file).

The fields "datas_fname" and "res_name" are OK. But the field file_size is not right (21 instead of 652 when I push it thanks to the graphical interface)

My question is, do I set the good type of object in the parameter "datas" ?

1
Portretas
Atmesti
Portretas
Fabien REMY
Autorius Best Answer

Hi Temur,

No, the filename is encoded in a good way, just the file content (a "stupid" CSV file).

The fields "datas_fname" and "res_name" are OK. But the field file_size is not right (21 instead of 652 when I push it thanks to the graphical interface)

My question is, do I set the good type of object in the parameter "datas" ?

1
Portretas
Atmesti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija
Related Posts Replies Rodiniai Veikla
Why does the filestore directory not appear after setting ir_attachment.location? Solved
filestore location ir_attachment
Portretas
Portretas
Portretas
Portretas
Portretas
14
spal. 24
48836
Upload Large File Store to Odoo.sh Solved
filestore
Portretas
Portretas
1
liep. 25
7814
where is the filestore folder located on odoo 18
filestore
Portretas
Portretas
1
vas. 25
5646
Clean up filestore
filestore
Portretas
Portretas
Portretas
Portretas
Portretas
5
spal. 24
14143
Create new bug
create
Portretas
0
bal. 24
2923
Bendrija
  • Mokomosios medžiagos
  • Dokumentacija
  • Forumas
Atvirasis kodas
  • Atsisiųsti
  • Github
  • Runbot
  • Vertimai
Paslaugos
  • Odoo.sh talpinimas
  • Palaikymas
  • Atnaujinti
  • Pritaikytas programavimo kūrimas
  • Švietimas
  • Susirask buhalterį
  • Susiraskite partnerį
  • Tapkite partneriu
Apie mus
  • Mūsų įmonė
  • Prekės ženklo turtas
  • Susisiekite su mumis
  • Darbo pasiūlymai
  • Renginiai
  • Tinklalaidės
  • Internetinis Tinklaraštis
  • Klientai
  • Teisinis • Privatumas
  • Saugumas
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo yra atvirojo kodo verslo programų rinkinys, kuris apima visas įmonės poreikius: CRM, El. Prekybą, Apskaitą, Atsargų, Kasų sistemą, Projektų valdymą ir kt.

Unikali Odoo vertės pasiūla – būti tuo pačiu metu labai lengvai naudojama ir visiškai integruota sistema.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now