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

Timestamp:

2019-06-22T10:44:47+12:00 (5 years ago)

Author:

davidb

Message:

More carefully control where the sanitized CSV file is generated

File:

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

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

@@ -2 +2 @@
 import csv
 import os
+import sys
 
 import xlsutil
 
-def excel_to_sanitized_csv(excel_filename):
+def excel_to_sanitized_csv(excel_filename,sanitized_csv_filename):
     workbook = xlrd.open_workbook(excel_filename)
 
@@ -11 +12 @@
     ## worksheet = workbook.sheet_by_name(xlsutil.worksheet_name)
 
-    excel_filename_split = os.path.split(excel_filename)
-    excel_dirname = excel_filename_split[0]
-    excel_file = excel_filename_split[1]
-    excel_file_splitext = os.path.splitext(excel_file)
-    excel_file_root = excel_file_splitext[0];
+    # excel_filename_split = os.path.split(excel_filename)
+    # excel_dirname = excel_filename_split[0]
+    # excel_file = excel_filename_split[1]
+    # excel_file_splitext = os.path.splitext(excel_file)
+    # excel_file_root = excel_file_splitext[0];
 
-    sanitized_csv_filename  = os.path.join(excel_dirname,excel_file_root+".csv")
+    # sanitized_csv_filename  = os.path.join("for-download",excel_file_root+".csv")
 
     sanitized_csv_ofile = open(sanitized_csv_filename, 'wb')
@@ -63 +64 @@
 
 if __name__ == "__main__":
-    excel_to_sanitized_csv(os.sys.argv[1])
+    if len(os.sys.argv) != 3:
+        print >> sys.stderr, "Usage: " + os.sys.argv[0] + "input.xsl|input.xslx output.csv"
+        exit(1)
 
+    excel_to_sanitized_csv(os.sys.argv[1],os.sys.argv[2])
+