view scripts/search/tab2json-dvs @ 14:be7787c36e58 default tip

new: nofity LGSercies for deleted files
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Mon, 02 Nov 2015 16:41:23 +0100
parents a50cf11e5178
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()