Changeset 33752

Timestamp:

2019-12-04T21:14:53+13:00 (4 years ago)

Author:

davidb

Message:

Followed Dr Bainbridge's suggestion to correct hnz.Identifiers that contain spaces to containing hyphens

File:

• main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-csv.py (modified) (1 diff)

main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-csv.py

@@ -183 +183 @@
                         # Check to see if companion PDF file present
                         # pdf_filename = os.path.join(excel_dirname,"pdfs",formatted_cell_value+".pdf")
-                        id = formatted_cell_value.replace(" ","-")
+
+                        # ANU EDIT: for header_name Report Identifier, we want to ensure
+                        # spaces are replaced by hypens. A trim() (strip()) first to not replace
+                        # spaces at start and end/outside the bookending quotes.
+                        #id = formatted_cell_value.replace(" ","-")
+                        # Not just the id in memory, but the hnz.Identifier value that ends
+                        # up in the PDF (UN)BOUND files needs to have spaces replaced with hyphens
+                        formatted_cell_value = formatted_cell_value.strip().replace(" ","-")
+                        id = formatted_cell_value
                         
                         pdf_file = id_to_relative_pdf_file(id)