Skip to Content
This question has been flagged
exportchartaccountof
2 Replies
9836 Views
Avatar
Michael

Hello, I am using openerp v7.0 For my accounting, I use the default chart of accounts of the finance module. For my country (France), it contains 975 lines. I have two questions : 1- Is there a clean manner to export it entirely to a csv? Indeed, when I try to export it, I can do that page by page, as it is displayed on several pages, each one containing 80 lines.

2- Even when I manage to export it, I obtain much more lines than displayed. Here are for example the first 7 lines, where some are almost empty (line 1 is header, line 2 is the root of chart of account, line 3 is almost empty and I cannot explain why it is there. Line 4 is an account, while the subsequent one are almost empty). These almost empty lines appear for many other kinds of export that I do (partners, products and so on..) Can you help by explaining why are there these almost empty lines? :

Thanks a lot for help

"id","user_type/id","active","reconcile","child_parent_ids/id","code","company_id/id","child_consol_ids/id","credit","debit","tax_ids/id","exchange_rate","financial_report_ids/id","note","type","name","currency_mode","parent_id/id","parent_left","parent_right","currency_id/id","shortcut"
"__export__.account_account_33","account.data_account_type_view","True","False","__export__.account_account_34","0","base.main_company","","","","","","","","View","MY COMPANY","At Date","","","1943","",""
"","","","","__export__.account_account_617","","","","","","","","","","","","","","","","",""
"__export__.account_account_34","account.data_account_type_view","True","False","__export__.account_account_35","Classes 1 à 5","base.main_company","","","","","","","","View","Comptes de bilan","At Date","__export__.account_account_33","1","1170","",""
"","","","","__export__.account_account_168","","","","","","","","","","","","","","","","",""
"","","","","__export__.account_account_326","","","","","","","","","","","","","","","","",""
"","","","","__export__.account_account_396","","","","","","","","","","","","","","","","",""
"","","","","__export__.account_account_564","","","","","","","","","","","","","","","","",""
Avatar
Discard
Avatar
Ray Carnes
Best Answer

On any list view, click Import and select a file.

At the bottom of the screen you will see comprehensive help explaining why you have blank lines - they are related records from a 1 to many relationship.

For another example, see https://accounts.openerp.com/forum/Help-1/question/28203

Avatar
Discard
Michael
Author

Thanks a lot Ray. It seems in fact that in my example of chart of accounts, the empty lines correspond to children of a given account. Do you see any solution for my first question, ie. downloading a list view spanning several pages?

Avatar
Michael
Author Best Answer

Hello, I found a manner to export a list view spanning several pages. I post it here in case someone reads the post. When a list viw spans several pages, you find at the top right of the pages "1-80 of 1089" for example, if the list view contains a total of 1089 lines. That string is in fact clickable. So click it, a dropdown will appear to change the number of lines to be viewed. Just select unlimited, and do the select all, and then export in the usual way.

Avatar
Discard
Related Posts Replies Views Activity
Does anyone know if there is an Egyptian Chart Of Accounts templates for Odoo? Solved
accounts chart of
Avatar
Avatar
Avatar
2
Apr 20
8502
What is the correct configuration of ALE module from HEONIUM to export to EBP ?
export account ebp
Avatar
0
Mar 15
4149
Is there any way to change chart of accounts?
accounts chart change of
Avatar
Avatar
Avatar
3
Aug 17
13901
My Chart of Account is Broken. Please help
accounts chart broken of
Avatar
0
Mar 15
4177
Chart of taxes, wrong calculation
accounting chart tax taxes of
Avatar
Avatar
1
Mar 15
8152