draft of the gradebook converter to BlackBoard roster

1 files changed, 28 insertions, 0 deletions

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)