Ir al contenido
Se marcó esta pregunta
exportchartaccountof
2 Respuestas
10294 Vistas
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
Descartar
Avatar
Ray Carnes
Mejor respuesta

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
Descartar
Michael
Autor

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
Autor Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
Does anyone know if there is an Egyptian Chart Of Accounts templates for Odoo? Resuelto
accounts chart of
Avatar
Avatar
Avatar
2
abr 20
9255
What is the correct configuration of ALE module from HEONIUM to export to EBP ?
export account ebp
Avatar
0
mar 15
4634
Is there any way to change chart of accounts?
accounts chart change of
Avatar
Avatar
Avatar
3
ago 17
14857
My Chart of Account is Broken. Please help
accounts chart broken of
Avatar
0
mar 15
4876
Chart of taxes, wrong calculation
accounting chart tax taxes of
Avatar
Avatar
1
mar 15
8757