Changeset 34876

Timestamp:

2021-02-16T01:04:49+13:00 (3 years ago)

Author:

davidb

Message:

Code updated to generate list of GS3 metadata tags needed for voting country metadata to appear in document view

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsx-to-jsonmetadata.py (modified) (3 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsx-to-jsonmetadata.py

@@ -12 +12 @@
 
 import xlsxutil
+
+jury_from_countries = {}
+tele_from_countries = {}
 
 def eprint(*args, **kwargs):
@@ -119 +122 @@
         points       = to_country_year_vote.get('Points')
 
-        voting_rec = { "name": from_country+"-"+vote_type, "content": points }
+        id_from_country = re.sub(r'\s+', '', from_country)
+            
+        voting_rec = { "name": id_from_country+"-"+vote_type, "content": points }
 
         metadata_array.append(voting_rec)
 
         if (vote_type == "J"):
-            jury_metadata_vals.append(from_country+"-J")
+            jury_metadata_vals.append(id_from_country+"-J")
+            jury_from_countries[id_from_country] = 1
+            
         elif (vote_type == "T"):
-            tele_metadata_vals.append(from_country+"-T")
+            tele_metadata_vals.append(id_from_country+"-T")
+            tele_from_countries[id_from_country] = 1
         else:            
             eprint("Warning: Unrecognized voting type: " + vote_type)
@@ -216 +224 @@
         print("  " + filename_id.ljust(28) + ": " + str(num_countries_voting_data) + " votes")
 
+
+    print("")
+    for from_country in sorted(jury_from_countries.keys()):
+        print("<gsf:metadata name=\""+from_country+"-J\" />")
+
+    print("")
+    for from_country in sorted(tele_from_countries.keys()):
+        print("<gsf:metadata name=\""+from_country+"-T\" />")
+
     greenstone_metadata_json = { "DirectoryMetadata": directory_metadata }
-
 
     with open(json_output_filename, 'w') as outfile: