view 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 source

#!/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()