Page Menu
Home
DevCentral
Search
Configure Global Search
Log In
Files
F56405102
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Flag For Later
Award Token
Size
1 KB
Referenced Files
None
Subscribers
None
View Options
diff --git a/tools/spreadsheet2json b/tools/spreadsheet2json
index ff122b7..af2db2a 100755
--- a/tools/spreadsheet2json
+++ b/tools/spreadsheet2json
@@ -1,36 +1,36 @@
#!/usr/bin/env python3
#
# Converts key/value lines from a spreadsheet to a JSON object:
# 1. create a spreadsheet with two columns, one for keys, one for values
# 2. copy paste into a text file (or save as a file delimited with tabs)
# 3. `spreadsheet2json neko.dat > neko.json`
import collections
import json
import sys
import os.path
# Parses arguments
if len(sys.argv) < 2:
print("Usage: spreadsheet2json <some-copy-paste-of-a-spreadsheet.dat>")
sys.exit(1)
source = sys.argv[1]
if not os.path.exists(source):
print("File not found:", source)
sys.exit(2)
# Reads tabular data file and produce JSON
-with open(source, "r") as file:
+with open(source, "r") as translations_file:
translations = {}
- for line in file:
+ for line in translations_file:
record = line.rstrip().split('\t')
translations[record[0]] = record[1]
# Sorted JSON output
sorted_translations = collections.OrderedDict(sorted(translations.items()))
json = json.dumps(sorted_translations, indent=4)
print(json)
File Metadata
Details
Attached
Mime Type
text/x-diff
Expires
Sat, Nov 7, 20:58 (1 w, 3 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4249846
Default Alt Text
(1 KB)
Attached To
Mode
rDWD Dæghrefn Wikidata access layer
Attached
Detach File
Event Timeline
Log In to Comment