Changeset 38488 for other-projects

Timestamp:

2023-12-12T15:54:19+13:00 (5 months ago)

Author:

jc550

Message:

add part of convertFile function

File:

• other-projects/metadata-encoding/py/xRefToMongo.py (modified) (2 diffs)

other-projects/metadata-encoding/py/xRefToMongo.py

@@ -1 +1 @@
 #program to convert xref metadata files into compatible files for mongo database
 
-import pymongo, gzip, argparse
+import pymongo, gzip, argparse, json
 
+numFile = 0
+
+#convert std xref metadata file
 def convertFile(path):
-    pass
+    jsonItems = ""
+    with gzip.open(path, "r", encoding="utf-8") as gzippedFile:
+        jsonDictionary = json.load(gzippedFile)
+        for item in jsonDictionary["items"]:
+            dictToDump = {"_id":numFile,}
+            if "DOI" in item.keys():
+                dictToDump.update({"DOI":item["DOI"]})
+            if "title" in item.keys():
+                dictToDump.update({"title":item["title"][0]})
+            if "subtitle" in item.keys():
+                dictToDump.update({"subtitle":item["subtitle"][0]})
+
+
 
 def convertFileVerbose(path):
@@ -33 +48 @@
         processDir(parsedArgs.verbose, parsedArgs.filePath, parsedArgs.count)
 
+
     #print(parsedArgs.count)