Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Schvalovania
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Estate Managament
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc

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

  • CRM
  • e-Commerce
  • Účtovníctvo
  • Sklady
  • PoS
  • Projektové riadenie
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

How to work with ir.attachment in Odoo 8?

Odoberať

Get notified when there's activity on this post

This question has been flagged
pdfdatabasefilestorefilenameir.attachment
1 Odpoveď
21529 Zobrazenia
Avatar
Pascal Tremblay

Hey guy,

Other questions here. 

Document module is well installed. We are on Odoo 8 nightly build.

When we go in Setting->Database Structure->Attachments, we many icons of our reports an attachments.


1) If we prefer to store our attachments in a external filestore, should they appear there too?

2) In this place, can we only see attachment stored in database?


3) And you guys, do you use this ir_attachment.location parameter in the setting of Odoo 8???



4) It is impossible to write any PDF report in the filestore (on disk). We can not see them in settings -> Database Structure -> Attachment, anymore... It worked before!!!??!!!  See image above.... We can see any PDF there... But now, it doesn't work.


5) I have made a search in all the directory of our odoo installations. No trace of any PDF there... It is magic.... Where are my report????? When it is written on the web that we can store our attachment on a disk filestore, does it include also the PDF REPORTS?????


Thanks to help or discuss any of my questions.

1
Avatar
Zrušiť
Avatar
Temur
Best Answer

We had some discussion about the topic here. It covers at least 4 and 5.

UPDATE:

1) Currently it's other way around: if we prefer to store files in database, then we have to configure it to be this way. by default files are stored in filestore, we do not have to configure anything. Files are stored in filestore and naturally they appear there. Thus, database records ("ir.attachment") are necessary as they are pointing to actual files in the filestore. 

2) In this place we see ir.attachment records, any of them may have actual file saved in filestore or in database. It does not matter where file is stored, in database or in filestore, here we can see all ir.attachment records.

3) this setting determine where files are actually stored. value 'file' is default and it means that files will be stored in the filestore. value 'db' means that files will be stored in the database, you can set it to 'db'. also possible use some path, I tried to use path in v7 but it become relative path under filestore... for path you can check how it works for v8. also you can implement support for other storage engines, refer to ir_attachment code. Note: if we change this setting, it'll affect only new records. i.e. if it was set to 'file' and we changed to 'db', then old files will stay where they are in filestore, but new files will be stored in database, and so on.

4) if you interested to do it yourself, then this is completely cowered in the thread that I've referred in the beginning. i.e. create file (csv) and save it using ir.attachment. only difference is that in your case file type is pdf, this difference does not make big deal. But if you just worry that now, it doesn't work... then I can assure you that it works like a charm.

5) Also cowered in the referred thread. files on the disk are NOT saved with it's original names, but using hash code of it's content (used sha1 of content, part of hash used for parent directory of actual file). that's why you can't find the file you search with it's name, but files are there. file names are stored in the database, in ir.attachment. if it's absolutely necessary you can find file on the disk if you know or can compute it's sha1 hash code. you'll find the file under filestore, under directory with a name matching the start (left part) of hashcode. as you find the correct one and you know it's original name, you can rename it (or just add .pdf extension) and open with some pdfreader.


3
Avatar
Zrušiť
Pascal Tremblay
Autor

Thanks. Someone else?

Temur

Updated. Added answers to 1, 2 and 3. Also added notes for 4 and 5.

Pascal Tremblay
Autor

Big big big thanks! We analyze each one of your words and we come back with our comments.

Temur

You're welcome.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrácia
Related Posts Replies Zobrazenia Aktivita
How to store programmatically created file in ir.attachment
pdf attachment filestore filename odoo
Avatar
Avatar
Avatar
2
sep 23
12790
database backup keep getting corrupted
database filestore odoo16
Avatar
Avatar
2
mar 25
2183
How to avoid storing pdf invoices in the filestore?
pdf invoice filestore
Avatar
Avatar
2
apr 24
2991
ir_attachment_force_storage then files not found
database filestore attachments
Avatar
0
aug 18
4518
Invoice number into the pdf file name Solved
pdf invoice filename
Avatar
Avatar
Avatar
Avatar
Avatar
27
aug 24
41714
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now