Skip to content

Instantly share code, notes, and snippets.

@SiddiqueAhmad

SiddiqueAhmad/accounts_data.csv Secret

Last active December 9, 2023 21:11
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SiddiqueAhmad/af081e71d5c4223bb7481be25b5f2ee0 to your computer and use it in GitHub Desktop.
Save SiddiqueAhmad/af081e71d5c4223bb7481be25b5f2ee0 to your computer and use it in GitHub Desktop.
Download ZIP
importing n level of chart of accounts in axelor under any company
Raw
accounts_data.csv
code parent_code name accountType.technicalTypeSelect reconcileOk company_code
0 Company Name view false company_code
BAL 0 Balance Sheet view false company_code
A000 BAL Fixed assets view false company_code
A010 A000 Intangible assets view false company_code
1000 A000 Software fixed_assets false company_code
1100 A000 Software Depreciation fixed_assets false company_code
2000 A000 Patents & Trademarks fixed_assets false company_code
2100 A000 Patents & Trademarks Depreciation fixed_assets false company_code
PNL 0 Profit and Loss view false company_code
F000 PNL Turnover view false company_code
400000 F000 Sales category 1 income false company_code
400100 F000 Sales category 2 income false company_code
400200 F000 Sales category 3 income false company_code
400300 F000 Sales category 4 income false company_code
G000 PNL Cost of sale view false company_code
500000 G000 Cost of sale 1 charge false company_code
500100 G000 Cost of sale 2 charge false company_code
500200 G000 Cost of sale 3 charge false company_code
Raw
import-coa.xml
<?xml version="1.0" encoding="UTF-8"?>
<csv-inputs xmlns="http://axelor.com/xml/ns/data-import"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://axelor.com/xml/ns/data-import http://axelor.com/xml/ns/data-import/data-import_5.4.xsd">
<input file="accounts_data.csv" separator="," type="com.axelor.apps.account.db.Account"
search="self.code = :code AND self.company.code = :company_code">
<bind to="parentAccount"
search="self.code = :parent_code AND self.company.code = :company_code" />
<bind to="company" search="self.code = :company_code" />
</input>
</csv-inputs>
@SiddiqueAhmad
Copy link
Author

code column for coa table is case sensitive.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment