Skip ke Konten
Pertanyaan ini telah diberikan tanda
exportchartaccountof
2 Replies
9818 Tampilan
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
Buang
Avatar
Ray Carnes
Jawaban Terbai

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
Buang
Michael
Penulis

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
Penulis Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Does anyone know if there is an Egyptian Chart Of Accounts templates for Odoo? Diselesaikan
accounts chart of
Avatar
Avatar
Avatar
2
Apr 20
8465
What is the correct configuration of ALE module from HEONIUM to export to EBP ?
export account ebp
Avatar
0
Mar 15
4098
Is there any way to change chart of accounts?
accounts chart change of
Avatar
Avatar
Avatar
3
Agu 17
13857
My Chart of Account is Broken. Please help
accounts chart broken of
Avatar
0
Mar 15
4159
Chart of taxes, wrong calculation
accounting chart tax taxes of
Avatar
Avatar
1
Mar 15
8129