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

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

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

2 Replies

3897 Views

filestore attachments path ir.attachment

Muhammad Awais

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.

Thanks

Tony Prime

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

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

Thanks

This question has been flagged