diff scripts/search/tab2json-dvs @ 10:a50cf11e5178

Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/search/tab2json-dvs	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,34 @@
+#!/usr/bin/env python
+import sys
+from optparse import OptionParser
+import csv
+try:
+    import json
+except ImportError:
+    import simplejson as json
+
+parser = OptionParser()
+options, args = parser.parse_args()
+
+if args:
+    csv_file = open(args[0])
+else:
+    csv_file = sys.stdin
+
+reader = csv.DictReader(csv_file, delimiter="\t")
+rows = [row for row in reader]
+for row in rows:
+    if "contactEmail" in row:
+        contactArray = []
+        contactHash = {}
+        contactHash["contactEmail"] = row["contactEmail"]
+        contactArray.append(contactHash)
+        row["dataverseContacts"] = contactArray
+        del row["contactEmail"]
+    if "subject" in row:
+        subjectsArray = []
+        subjectsArray.append(row["subject"])
+        row["dataverseSubjects"] = subjectsArray
+        del row["subject"]
+    print json.dumps(row)
+csv_file.close()