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 highlighting 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 field 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. Archived should be FALSE
Failed to upload file: All lines must have same number of fields
Missing some columns, should get a line number here...TBC
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.
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", ...}
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 matching legal unit id is already 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 unique, else it will overwrite an already defined establishment