comparison python/commentquestion_parser.py @ 2745:44a6a61de7fc

Potential fix for #206

 elif not os.access(os.path.dirname(folder_name), os.W_OK):
     #the file does exist but write privileges are not given
     print("No write privileges in folder '"+folder_name+"'.")
 
 # create folder 'ratings' if not yet created
-if not os.path.exists(folder_name + '/ratings'):
-    os.makedirs(folder_name + '/ratings')
+if not os.path.exists(folder_name + '/comments'):
+    os.makedirs(folder_name + '/comments')
     
 pagestore = {}
 
 for filename in os.listdir(folder_name):
     if (filename.endswith(".xml")):
-        tree = ET.parse(folder_name + '/' + file_name)
+        tree = ET.parse(folder_name + '/' + filename)
         root = tree.getroot()
         
         subject_id = root.get('key');
         
         # get the list of pages

             if page.get('state') != "complete":
                 print("WARNING: " + filename + " contains incomplete page " +pagename+ ". (commentquestion_parser.py)")
                 break
             try:
                 questionStore = pagestore[pagename]
-            except KeyValue:
+            except KeyError:
                 questionStore = {}
                 pagestore[pagename] = questionStore
             
             for cq in page.findall("./comment"):
                 cqid = cq.get("id");
                 response = cq.find("./response").text
                 try:
                     commentStore = questionStore[cqid]
-                except KeyValue:
+                except KeyError:
                     commentStore = [];
                     questionStore[cqid] = commentStore
                 commentStore.append({"subject": subject_id, "value": response})
-print pagestore
+
+for page in pagestore.keys():
+	print page
+	pagedir = folder_name + '/comments/'+page
+	if not os.path.exists(pagedir):
+	    os.makedirs(pagedir)
+	for comment in pagestore[page].keys():
+		with open(pagedir+"/"+comment+".csv", "w") as csvfile:
+			filewriter = csv.writer(csvfile, delimiter=',')
+			filewriter.writerow(("save_id", "value"))
+			for entry in pagestore[page][comment]:
+				filewriter.writerow((entry["subject"], entry["value"]))