Changeset 34876
- Timestamp:
- 2021-02-16T01:04:49+13:00 (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/voting-excel/xlsx-to-jsonmetadata.py
r34863 r34876 12 12 13 13 import xlsxutil 14 15 jury_from_countries = {} 16 tele_from_countries = {} 14 17 15 18 def eprint(*args, **kwargs): … … 119 122 points = to_country_year_vote.get('Points') 120 123 121 voting_rec = { "name": from_country+"-"+vote_type, "content": points } 124 id_from_country = re.sub(r'\s+', '', from_country) 125 126 voting_rec = { "name": id_from_country+"-"+vote_type, "content": points } 122 127 123 128 metadata_array.append(voting_rec) 124 129 125 130 if (vote_type == "J"): 126 jury_metadata_vals.append(from_country+"-J") 131 jury_metadata_vals.append(id_from_country+"-J") 132 jury_from_countries[id_from_country] = 1 133 127 134 elif (vote_type == "T"): 128 tele_metadata_vals.append(from_country+"-T") 135 tele_metadata_vals.append(id_from_country+"-T") 136 tele_from_countries[id_from_country] = 1 129 137 else: 130 138 eprint("Warning: Unrecognized voting type: " + vote_type) … … 216 224 print(" " + filename_id.ljust(28) + ": " + str(num_countries_voting_data) + " votes") 217 225 226 227 print("") 228 for from_country in sorted(jury_from_countries.keys()): 229 print("<gsf:metadata name=\""+from_country+"-J\" />") 230 231 print("") 232 for from_country in sorted(tele_from_countries.keys()): 233 print("<gsf:metadata name=\""+from_country+"-T\" />") 234 218 235 greenstone_metadata_json = { "DirectoryMetadata": directory_metadata } 219 220 236 221 237 with open(json_output_filename, 'w') as outfile:
Note:
See TracChangeset
for help on using the changeset viewer.