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!
Erik.