How to get Exact file instead of encrypted in ir.attachemts [Odoo][CE][12.0]

Question

I uploaded a file as attachment through *ir.attachments*  model.
I am able to locate that file locally location which is
/.local/share/Odoo/filestore/mydb/0c/0c45faf5b09ce9b7c9fbb6bd1a7787f24d24ab8
How to get the exact file in exact format which i uploaded which is *my_file.shp *instead of this encrypted file because i wanted to do some manipulation/processing on this file through *python* code.
I wanted to decrypt this file back to original format and extension with a path associated with it.
T

Tony Prime · Accepted Answer

You can retrieve the name of the encrypted file in the filestore using the Odoo database.
In the table *ir.attachments*, there are columns named *checksum *​and *name *that allow you to establish the connection between those.
Based on your example, you could have done this:
SELECT name
FROM ir_attachment
WHERE checksum='0c45faf5b09ce9b7c9fbb6bd1a7787f24d24ab8'
The field  *name * would have been: my_file.shp.

Auxi · Answer

Hi! I've the same problem, have you managed to solve the problem? I need to manipulate it in PHP for a script.
Thanks

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to upload a .doc/.pdf file through a button click from form view filestore attachments	1 elok. 20	7982
changing the directory for attachments attachments ir.attachment	0 helmik. 19	3177
Creating Attachments For account.invoice in odoo 12? Ratkaistu attachments ir.attachment odoo12	1 tammik. 23	9194
ir_attachment_force_storage then files not found database filestore attachments	0 elok. 18	3673
Can i let user to attach files to only specific models ? attachments ir.attachment access_rules	1 elok. 15	5644

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!