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.
You mean file names are encoded, like 68bb912c1711dade5df906449f0d5dd3 ?
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.)
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.
Il n'y à pas de quoi
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.
try to add one more parameter (for csv file):
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.
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
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.
have you listed "document" module as dependency in __openerp__.py for your module? using 'depends' property?
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.Temur, ... you rock ! It works fine now. Thank you for your precious help.
You're welcome