Changes to treat all columns as strings

Pa04rth · northdpole · commit 9da39fe284aa · 2025-03-30T19:04:16.000+01:00
diff --git a/application/utils/spreadsheet.py b/application/utils/spreadsheet.py
@@ -59,19 +59,13 @@ def read_spreadsheet(
                     " will be processed by convention)" % wsh.title
                 )
                 records = wsh.get_all_records(
-                    head=1,
-                    numericise_ignore=[
-                        "ISO Number"
-                    ],  # Added numericise_ignore parameter
+                    head=1, numericise_ignore="all"  # Added numericise_ignore parameter
                 )  # workaround because of https://github.com/burnash/gspread/issues/1007 # this will break if the column names are in any other line
                 toyaml = yaml.safe_load(yaml.safe_dump(records))
                 result[wsh.title] = toyaml
             elif not parse_numbered_only:
                 records = wsh.get_all_records(
-                    head=1,
-                    numericise_ignore=[
-                        "ISO Number"
-                    ],  # Added numericise_ignore parameter
+                    head=1, numericise_ignore="all"  # Added numericise_ignore parameter
                 )  # workaround because of https://github.com/burnash/gspread/issues/1007 # this will break if the column names are in any other line
                 toyaml = yaml.safe_load(yaml.safe_dump(records))
                 result[wsh.title] = toyaml
