[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Unloadable CoA files




With the upcoming beta4 release, I thought I'd load all CoA files one by one in a fresh company. Unfortunately, the result isn't all that good:

psql:sql/coa/at/chart/General.sql:36: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/au/chart/General-0000.sql:2: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/au/chart/General-00000.sql:78: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/be/chart/General.sql:7: ERROR:  function account_save(unknown, unknown, unknown, unknown, unknown, unknown, unknown, text[]) does not exist
psql:sql/coa/br/chart/General.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/ca/chart/English_General.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/ca/chart/French-Quebec_General.sql:12: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/ch/chart/German.sql:160: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/cn/chart/General.sql:3: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/co/chart/PUC.sql:650: ERROR:  insert or update on table "account_link" violates foreign key constraint "account_link_description_fkey"
psql:sql/coa/cz/chart/General.sql:14: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/de/chart/DATEV-SKR03.sql:223: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/de/chart/General.sql:61: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/de/chart/SKR03.sql:14: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/dk/chart/General.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/eg/chart/General.sql:3: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/es/chart/General.sql:95: ERROR:  insert or update on table "account_link" violates foreign key constraint "account_link_description_fkey"
psql:sql/coa/es/chart/ISO.sql:95: ERROR:  insert or update on table "account_link" violates foreign key constraint "account_link_description_fkey"
psql:sql/coa/fr/chart/General.sql:952: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/hu/chart/Complete.sql:317: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/hu/chart/Minimal.sql:50: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/hu/chart/Old-general.sql:50: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/id/chart/General.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/it/chart/General.sql:179: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/it/chart/cc2424.sql:264: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/lv/chart/General.sql:15: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/nl/chart/General.sql:63: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/nl/chart/Simple.sql:6: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/no/chart/General.sql:12: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/pl/chart/General.sql:106: ERROR:  insert or update on table "account_link" violates foreign key constraint "account_link_description_fkey"
psql:sql/coa/py/chart/General.sql:254: ERROR:  duplicate key value violates unique constraint "defaults_pkey"
psql:sql/coa/se/chart/Agriculture.sql:29: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/se/chart/Church_Society.sql:9: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/se/chart/General.sql:19: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/tw/chart/General.sql:3: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/uk/chart/General.sql:21: ERROR:  duplicate key value violates unique constraint "account_pkey"
psql:sql/coa/us/chart/General.sql:5: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/us/chart/Manufacturing.sql:5: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/us/chart/Service.sql:5: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/us/chart/UCOA-Form990.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/us/chart/UCOA-Form990EZ.sql:4: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"
psql:sql/coa/ve/chart/General.sql:7: ERROR:  duplicate key value violates unique constraint "account_heading_pkey"


It would be great if people could help fix up the issues in these files (especially those who have knowledge of the languages in these files); it'd be a great service to a successful 1.3 and very helpful to for our prospective new users!


Thanks in advance for your help!


Bye,


Erik.