Skip ke Konten
Pertanyaan ini telah diberikan tanda
v8databaseproductspicturesodoo
1 Balas
7293 Tampilan
Avatar
Bart Criel

When attaching pictures to products and/or variants, the pictures are AFAIK stored in the database. The database size can get huge if there are a lot of products, or when the products change every year and the old ones need to be preserved for legacy reasons. Is there a way to tell Odoo that it should save the pictures as files on the file system (exact location is a configuration), and not in the database? It would also be nice that, when the same picture is used for multiple products, the picture is only stored once.

 

 

Avatar
Buang
Avatar
Bole
Jawaban Terbai

If you are talking about V7 , yes it is in database... and here is a topic with more info, and solutions for your problem.

If you are using V8, then attachments are stored on fs by default.. .location of stored data is ~/.local/share/Odoo/dbname....
or you can set custom location by adding data_dir = /path/to/locatin in your config file.. 

Hope it helps.. 

Avatar
Buang
Jeff Beidler

Attachments are different than product images added through the product edit form, correct? Aren't the images stored as base64 strings in the product_template table?

Bart Criel
Penulis

That's what I'm thinking as well: attachments (documents) are stored on the file system with module Document Management or something similar. Product pictures seem to be stored in the database as base64 without alternative. Which makes my point: when you work with 4000+ products and a collection that changes every year, the database size gets enormous without much added value.

Post Terkait Replies Tampilan Aktivitas
What is the best way to migrate database from Odoo 8 to 9? Diselesaikan
v8 database migration odoo v9
Avatar
Avatar
Avatar
Avatar
Avatar
7
Des 22
12106
Could Not Restore Database Error. Odoo V8
v8 error database restore odoo
Avatar
Avatar
Avatar
6
Apr 16
13054
clean purchase history
database odoo
Avatar
Avatar
1
Mar 24
1833
How can I recover ownership? Diselesaikan
database odoo
Avatar
Avatar
1
Feb 23
2130
Odoo database failed Diselesaikan
database odoo
Avatar
Avatar
1
Des 22
11748