Account Export CSV

account_export_csv · OCA/account-financial-reporting

    Repository
    OCA/account-financial-reporting · module folder · Try on Runboat
    Module version
    1.2.1
    Category
    Uncategorized
    Folder size
    0.1 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/account-financial-reporting
    Last tracking update
    2026-08-07 07:31:49
    Authors
    Camptocamp, Odoo Community Association (OCA)
    Maintainers
    Camptocamp, Odoo Community Association (OCA)
    Committers
    Pedro M. Baeza, David Beal, sergiocorato, Weblate, OCA Transbot, OCA-git-bot, oca-travis
    Odoo dependencies
    OCA/server-ux:
    - date_range
    odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - http_routing
    - digest
    Python dependencies
    None
    System dependencies
    None
    Required by
    None
    Description
    
    
    

    


    

    Code Analysis ⓘ
    

    Views touched (1)
    


    

    
    
    XML IDNameModelTypeStatus
    
    
        
        
    
            account_csv_export_view
            Accounting Entries CSV Export
            account.csv.export
            form
            
                
                New
                
            
        
    
        
        

    

    



    HTTP endpoints (0)
    


    No HTTP endpoints found for this module.
    



    Models touched (1)
    


    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (7)
                
                
      
                    
                    
    • 
                        company_id
                        Many2one → res.company
                        
                        
      
                            
                            comodel_name='res.company'
                            
                            default=<expr>
                            
                            invisible=True
                            
                            string='Company'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        data
                        Binary
                        
                        
      
                            
                            
                            
                            readonly=True
                            
                            args: 'CSV'
                        
      
                        
                    
      • 
                    
                    
    • 
                        date_end
                        Date
                        
                        
      
                            
                            required=True
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        date_range_id
                        Many2one → date.range
                        
                        
      
                            
                            comodel_name='date.range'
                            
                            string='Date range'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        date_start
                        Date
                        
                        
      
                            
                            required=True
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        export_filename
                        Char
                        
                        
      
                            
                            default='account_export.csv'
                            
                            size=128
                            
                            string='Export CSV Filename'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        journal_ids
                        Many2many → account.journal
                        
                        
      
                            
                            comodel_name='account.journal'
                            
                            default=<expr>
                            
                            help='If empty, use all journals, only used for journal entries'
                            
                            string='Journals'
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (3)
                
                
      
                    
                    
    • 
                        action_manual_export_account(self)
                        
                        
                    
      • 
                    
                    
    • 
                        action_manual_export_analytic(self)
                        
                        
                    
      • 
                    
                    
    • 
                        action_manual_export_journal_entries(self)
                        
                        
      Here we use TemporaryFile to avoid full filling the Odoo worker
Memory
We also write the data to the wizard with SQL query as write seems
to use too much memory as well.

Those improvements permitted to improve the export from a 100k line to
200k lines
with default `limit_memory_hard = 805306368` (768MB) with more lines,
you might encounter a MemoryError when trying to download the file even
if it has been generated.

To be able to export bigger volume of data, it is advised to set
limit_memory_hard to 2097152000 (2 GB) to generate the file and let
Odoo load it in the wizard when trying to download it.

Tested with up to a generation of 700k entry lines
      
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    

    


    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…