From 957b8f458d46ec331ac56f7f4a26c4ba8f76b97d Mon Sep 17 00:00:00 2001
From: "Eugeniy E. Mikhailov" <evgmik@gmail.com>
Date: Wed, 25 Oct 2023 14:58:11 -0400
Subject: draft of the gradebook converter to BlackBoard roster

---
 toBlackboardCSV.py | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 toBlackboardCSV.py

(limited to 'toBlackboardCSV.py')

diff --git a/toBlackboardCSV.py b/toBlackboardCSV.py
new file mode 100644
index 0000000..e248978
--- /dev/null
+++ b/toBlackboardCSV.py
@@ -0,0 +1,28 @@
+import sys
+import pandas as pd
+import numpy as np
+import os
+import sqlite3
+
+# infile = 'gb.db'
+infile = sys.argv[1]
+con = sqlite3.connect(infile)
+
+#dIn=pd.read_sql("Select * from 'GradesTable' where GroupName='student'", con)
+dIn=pd.read_sql("Select * from 'GradesTable'", con)
+
+
+dOut = dIn.copy()
+
+# replacing user names in accordance with BlackBoard
+dOut['UserName'] = dOut['UserName'].str.replace('@.*$', '', regex=True)
+dOut.rename(columns={'UserName':'Username'}, inplace=True)
+
+# exclude inforows
+dOut = dOut.loc[ dOut['GroupName'].isin(['student']) ]
+
+# remove unneeded info cols
+infoCol=['FirstName', 'LastName', 'GroupName', 'UserHiddenColums', 'UserHiddenGroups', 'UserHiddenGradeCategories', 'SectionNum', 'IdNum']
+dOut = dOut.drop(infoCol, axis=1)
+
+dOut.to_csv('BlackBoard.csv', index=False)
-- 
cgit v1.2.3