Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
9841 Widoki

Hello there!

I have a Binary field, but it has been used too much and now the database is overloaded and it takes so long some queries. I want to fix it and I added "attachment=True" to the field, but the previous data are still on the database.

Is there any function to export all that data and import the data to the ir.attachment??

If it is not, any clues to do it myself, please? I suppose the point would be creating an ad-hoc function but I have no idea about how to get those files from the function, how to transform them into files, and how to save those files in the filestore according to ir.attachment rules.


Sorry for mistakes, I try my best with English.

Thank you all!

Awatar
Odrzuć
Najlepsza odpowiedź

 

Hello as far as I know in version 10 odoo files are stored on the file system, and not in the default database. For version 8 there is a free module for transfer from the database to the file system. 

The logic is written in python therefore to transfer on 10 version I think there are no problems.Link:



https://www.odoo.com/apps/modules/8.0/attachments_to_filesystem/

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
6
gru 23
19997
3
mar 17
3901
0
lut 23
1843
1
kwi 18
12967
2
sty 18
3374