Home

Statbus Load: Frequent Challenges & Questions:

2. Regions:

Failed to upload file: Column 'FullPath' of relation 'region_upload' does not exist
Column Name 'Full Path' is not expected, this column must be removed. Or be put at the end, with no column name.
Failed to upload file: Column 'FullPath' of relation 'region_upload' does not exist
Column Name 'Full Path' is not expected, this column must be removed. Or be put at the end, with no column name.
Failed to upload file: Column 'path' of relation 'region_upload' does not exist
Make sure that your file is true UTF-8. If not UTF-8 reload the file in ie. Visual Code and re-save as UTF-8, Notepad++ select all text, change format to UTF8 and resave.
Failed to upload file: invalid positions
Missing 'path' in one of the rows... a complete blank line is not a problem
Failed to upload file: All lines must have same number of fields
One of the lines are missing the ',' separator. Cannot be the character ';'
Fail to load the entire name of region
Make sure to quote names, if containing the character ',' such as 1.3320,"Capital, greater city"
Failed to upload file: new row for relation "region" violates check constraint "parent_id is required for child"
Make sure that the files contains parents, before children
Duplicates - but no error message
When duplicate path, the last rows loaded will overwrite the previous rows.

Failed to upload file: Column 'path' of relation 'legal_form_custom_only' does not exist
Legal form file consist of 2 columns : code,name. There is no hierarchy for this classification

Failed to upload file: failed to upload in view activity_category_available_custom
Failed to upload file: Column 'path' of relation '_upload' does not exist
Make sure that your file is true UTF-8. If not UTF-8 reload the file in ie. Visual Code and re-save as UTF-8, or Cut & Paste into plain Notepad. Flipping to UTF8 in Notepad++ works only if highligting all text before changing to UTF8 and resave.
Failed to upload file: ltree syntax error
Make sure code not ending with . : Q.,SANTE HUMAINE ET ACTION SOCIALE, should be: Q,SANTE HUMAINE ET ACTION SOCIALE
Failed to upload file: Could not find parent for path Q.999.99
Make sure to have parents already defined higher up in the file
Failed to upload file: All lines must have same number of fields
One of the lines are missing one field (an extra fiels is not a problem it will be ignored)

Failed to upload file: Could not find the 'tax_ident' column of 'import_legal_unit_current'
Verify file is in the UTF-8 format

Failed to upload file: Could not find the 'stat_ident' column of 'import_legal_unit_current' in the schema cache
Make sure Stat_ident / Tax_ident is enabled in the external_ident_type table. Archieved should be FALSE

Failed to upload file: null value in column "country_id" of relation "location" violates not-null constraint
Invalid value in country, make sure to use a 2 letter iso country such as NO or MA in Upper case, -that is already defined in statbus. Ups TCC --need to fix!

Failed to upload file: Invalid birth_date for row {"valid_from":"2024-04-17", "valid_to":"infinity", "tax_ident":"1066118", "name":"LA MAROCAINE DE JEUX ET DES SPORTS (MDJS)", "birth_date":"01.janua.14", "death_date":null, "physical_address_part1":"33 BOULEVARD RACHIDI", "physical_address_part2":null, "physical_address_part3":null, "physical_postal_code":null, "physical_postal_place":"CASABLANCA", "physical_region_code":"1227", "physical_country_iso_2":"MA", "postal_address_part1":null, "postal_address_part2":null, "postal_address_part3":null, "postal_postal_code":null, "postal_postal_place":null, "postal_region_code":null, "postal_country_iso_2":null, "primary_activity_category_code":"41.1", "secondary_activity_category_code":null, "sector_code":"6500", "legal_form_code":"2", "tag_path":null}
Check your date format for this row, search based on id or name to find the problem row. Common date formats such as 01.jan.14 or 2020-04-17 or 2020.04.17 are all ok.

Failed to upload file: Could not find legal_unit_tax_ident for row {"valid_from":"2024-04-18", "valid_to":"infinity", "tax_ident":"1066118", "legal_unit_tax_ident":"1066118999", "name":"LA MAROCAINE DE JEUX ET DES SPORTS..
Make sure a legal matching legal unit id already is loaded.
Failed to upload file: Invalid turnover integer for row {"valid__from":"2024-04-18", "valid_to":"infinity",, "tax_ident":"1066118", "legal_unit_tax_ident":"1066118999", "name":"LA MAROCAINE DE JEUX ET DES SPORTS..
Make sure turnover is a number without decimals
Missing Establishment (no error message)
Make sure the id of the establishment is uniq, else it will owerwrite an already defined establishment