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

Timestamp:

2019-06-23T22:49:47+12:00 (5 years ago)

Author:

davidb

Message:

Regularization of SiteNo through sprintf %03d type formatting so things sort more nicely when browsing by this metadata; Extra field added in to sanitized CSV output; fixed typo in TLA name

File:

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

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

@@ -2 +2 @@
 import csv
 import os
+import re
 
 import xlsutil
@@ -139 +140 @@
                     header_name = "dc.Title"
 
-                if header_name == "RelevantTLA's":
+                if header_name == "Relevant TLA's":
                     header_name = "TLA"
 
@@ -146 +147 @@
 
                 entry_utf8_row.append(metadata_name_utf8)
+
+                if header_name == "Site No":
+                    entry_utf8_row.append("SiteNoOrdering")
 
 ##            else:
@@ -211 +215 @@
 
                     formatted_utf8_row.append(formatted_cell_value_utf8)
+
+                    if header_name == "Site No":
+                        site_no = formatted_cell_value_utf8
+                        site_no_ordering = None
+
+                        if site_no and site_no.strip():
+                            # Non-empty entry
+                            pattern = re.compile('^([A-Z])(\d+)')
+                            site_no_match = pattern.match(site_no)
+                            
+                            if site_no_match:
+                                site_no_primary_letter = site_no_match.group(1)
+                                site_no_primary_num = int(site_no_match.group(2))
+                                
+                                site_no_ordering = "%s%03d" % (site_no_primary_letter, site_no_primary_num)
+                            else:
+                                if site_no != "various":
+                                    print "Warning: Site No '"+site_no+"' did not form Capital Letter followed by Digits"
+                                    print "Leaving value unchanged for column 'Site No Ordering'"
+
+                                site_no_ordering = site_no
+                        else:
+                            site_no_ordering = ""
+
+                        formatted_utf8_row.append(site_no_ordering)
+
 ##                else:
 ##                    print "Warning: No column number mapping for header name \""+header_name+"\" => skipping"