Need help for putting together the sql data for updating the Austrian Chart of Accounts (from excel raw data to dolibarr sql format)

Developing for Dolibarr
1

Hello everyone,

I’ve taken a look at the chart of accounts for Austria and it’s kind of a bad base for adjusting it to fit ones company’s needs.

I’ve modified the base to a better one but i have no idea how to properly format it to the sql format without having to tediously do it manually, so if anyone here has a proper tool/has the knowledge on how to put the data together I’d appreciate it if you do so any open up a pull request with the new chart.

here’s the excel chart of accounts formated in:
entity rowid fk_pcg_version pcg_type account_number account_parent label active

AT-BASE.zip (17.8 KB)

Here’s the link to the Austrian Chart of Accounts in the Dolibarr repo.

Thanks.

2

Hello,

@aspangaro can you help on this ?

1 Like
3

Did it myself using excel’s concat function.