1 | #-*- mode: python; mode: fold -*- |
---|
2 | from Globals import InitializeClass |
---|
3 | from AccessControl import ClassSecurityInfo |
---|
4 | |
---|
5 | from Products.CMFCore.utils import UniqueObject, getToolByName |
---|
6 | from Products.CMFCore.permissions import View |
---|
7 | from Products.CMFCore.permissions import ModifyPortalContent |
---|
8 | from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder |
---|
9 | #from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument |
---|
10 | from Products.CPSDocument.CPSDocument import CPSDocument |
---|
11 | #from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder |
---|
12 | #from Products.CPSCore.CPSBase import CPSBaseBTreeDocument as BaseBTreeDocument |
---|
13 | #from Products.CMFCore.DirectoryView import registerDirectory |
---|
14 | |
---|
15 | #registerDirectory('skins', globals()) |
---|
16 | #registerDirectory('skins/waeup_default', globals()) |
---|
17 | #registerDirectory('skins/waeup_faculty', globals()) |
---|
18 | |
---|
19 | import DateTime |
---|
20 | import csv,re |
---|
21 | import logging |
---|
22 | import Globals |
---|
23 | p_home = Globals.package_home(globals()) |
---|
24 | i_home = Globals.INSTANCE_HOME |
---|
25 | |
---|
26 | def makeCertificateCode(code): |
---|
27 | code = code.replace('.','') |
---|
28 | code = code.replace('(','') |
---|
29 | code = code.replace(')','') |
---|
30 | code = code.replace('/','') |
---|
31 | code = code.replace(' ','') |
---|
32 | code = code.replace('_','') |
---|
33 | return code |
---|
34 | |
---|
35 | class AcademicsFolder(CPSDocument): ###( |
---|
36 | """ |
---|
37 | WAeUP AcademicsFolder containing StudyCourses |
---|
38 | """ |
---|
39 | meta_type = 'AcademicsFolder' |
---|
40 | portal_type = meta_type |
---|
41 | security = ClassSecurityInfo() |
---|
42 | use_catalog_for_folder_contents = True |
---|
43 | |
---|
44 | security.declareProtected(View,"Title") |
---|
45 | def Title(self): |
---|
46 | """compose title""" |
---|
47 | return "Academic Section" |
---|
48 | |
---|
49 | security.declareProtected(ModifyPortalContent,"loadFacultiesFromCSV")###( |
---|
50 | def loadFacultiesFromCSV(self): |
---|
51 | """install Universityspecific Faculies from CSV values""" |
---|
52 | #return |
---|
53 | name = 'Faculties' |
---|
54 | no_import = False |
---|
55 | logger = logging.getLogger('%s_csv_import' % name) |
---|
56 | logger.info('Start loading from %s.csv' % name) |
---|
57 | academics = self.portal_catalog({'meta_type': 'AcademicsFolder'})[-1].getObject() |
---|
58 | try: |
---|
59 | faculties = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
60 | except: |
---|
61 | logger.error('Error reading %s.csv' % name) |
---|
62 | return |
---|
63 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
64 | facs = {} |
---|
65 | for f in l: |
---|
66 | facs[f.id] = f.getObject() |
---|
67 | fields = ("code", |
---|
68 | "review_state", |
---|
69 | "title", |
---|
70 | "title_prefix", |
---|
71 | "college_code", |
---|
72 | "degree_grade", |
---|
73 | "bank_code", |
---|
74 | ) |
---|
75 | format = ' '.join(['%%(%s)s ' % fn for fn in fields]) |
---|
76 | for faculty in faculties: |
---|
77 | processing = "processing %s" % format |
---|
78 | logger.info(processing % faculty) |
---|
79 | fid = faculty.get('code') |
---|
80 | f = facs.get(fid,None) |
---|
81 | if f is None: |
---|
82 | #self.log('Creating Faculty %(id)s = %(Title)s' % faculty) |
---|
83 | logger.info('Creating Faculty with ID %(code)s %(title)s' % faculty) |
---|
84 | academics.invokeFactory('Faculty', fid) |
---|
85 | f = getattr(self,fid) |
---|
86 | d = {'Title': faculty.get('title')} |
---|
87 | else: |
---|
88 | d = {} |
---|
89 | f.getContent().edit(mapping=faculty) |
---|
90 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
91 | ###) |
---|
92 | |
---|
93 | security.declareProtected(ModifyPortalContent,"loadDepartmentsFromCSV")###( |
---|
94 | def loadDepartmentsFromCSV(self): |
---|
95 | """install Universityspecific Faculies from CSV values""" |
---|
96 | #return |
---|
97 | name = 'Departments' |
---|
98 | no_import = False |
---|
99 | logger = logging.getLogger('loaddepartments') |
---|
100 | fields = ("code", |
---|
101 | "review_state", |
---|
102 | "title", |
---|
103 | "title_prefix", |
---|
104 | "faculty_code", |
---|
105 | ) |
---|
106 | format = ' '.join(['%%(%s)s ' % fn for fn in fields]) |
---|
107 | try: |
---|
108 | deps = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
109 | except: |
---|
110 | logger.error('Error reading %s.csv' % name) |
---|
111 | return |
---|
112 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
113 | heading = ' '.join(['"%s"' % fn for fn in fields]) |
---|
114 | no_import.write('%s\n' % heading) |
---|
115 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
116 | facs = {} |
---|
117 | for f in l: |
---|
118 | facs[f.id] = f.getObject() |
---|
119 | for dep in deps: |
---|
120 | processing = "processing %s" % format |
---|
121 | logger.info(processing % dep) |
---|
122 | fid = dep['faculty_code'] |
---|
123 | f = facs.get(fid,None) |
---|
124 | if f is None: |
---|
125 | logger.info( "No Faculty with ID: %s" % fid) |
---|
126 | no_import.write( "No Faculty with ID: %s\n" % fid) |
---|
127 | no_import.write(format % dep + "\n") |
---|
128 | else: |
---|
129 | did = dep.get('code') |
---|
130 | d = getattr(f,did,None) |
---|
131 | if d is None or d.portal_type == "Faculty": |
---|
132 | logger.info('Creating Department %(code)s = %(title)s' % dep) |
---|
133 | f.invokeFactory('Department', did) |
---|
134 | d = getattr(f,did) |
---|
135 | d.invokeFactory('CoursesFolder','courses') |
---|
136 | courses = getattr(d,'courses') |
---|
137 | dict = {'Title': 'Courses'} |
---|
138 | courses.getContent().edit(mapping=dict) |
---|
139 | d.invokeFactory('CertificatesFolder','certificates') |
---|
140 | certificates = getattr(d,'certificates') |
---|
141 | dict = {'Title': 'Certificates'} |
---|
142 | certificates.getContent().edit(mapping=dict) |
---|
143 | d.getContent().edit(mapping=dep) |
---|
144 | |
---|
145 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
146 | ###) |
---|
147 | |
---|
148 | security.declareProtected(ModifyPortalContent,"loadCoursesFromCSV")###( |
---|
149 | def loadCoursesFromCSV(self): |
---|
150 | """install Universityspecific Courses from CSV values""" |
---|
151 | #return |
---|
152 | wf = self.portal_workflow |
---|
153 | name = 'Courses' |
---|
154 | no_import = False |
---|
155 | logger = logging.getLogger('loadcourses') |
---|
156 | fields = ("code", |
---|
157 | "review_state", |
---|
158 | "title", |
---|
159 | "faculty_code", |
---|
160 | "department_code", |
---|
161 | "credits", |
---|
162 | "org_code", |
---|
163 | "passmark", |
---|
164 | "semester", |
---|
165 | "session", |
---|
166 | ) |
---|
167 | format = ' '.join(['%%(%s)s ' % fn for fn in fields]) |
---|
168 | try: |
---|
169 | courses = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
170 | except: |
---|
171 | logger.error('Error reading %s.csv' % name) |
---|
172 | return |
---|
173 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
174 | heading = ' '.join(['"%s"' % fn for fn in fields]) |
---|
175 | no_import.write('%s\n' % heading) |
---|
176 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
177 | facs = {} |
---|
178 | for f in l: |
---|
179 | facs[f.id] = f.getObject() |
---|
180 | dl = self.portal_catalog({'meta_type': "Department"}) |
---|
181 | deps = {} |
---|
182 | for d in dl: |
---|
183 | deps[d.id] = d.getObject() |
---|
184 | cl = self.portal_catalog({'meta_type': "Course"}) |
---|
185 | course_list = [ c.id for c in cl] |
---|
186 | for course in courses: |
---|
187 | processing = "processing %s" % format |
---|
188 | logger.info(processing % course) |
---|
189 | depid = course.get('department_code').upper() |
---|
190 | if depid in deps.keys(): |
---|
191 | dept= deps.get(depid) |
---|
192 | else: |
---|
193 | msg = "Department %(department_code)s for Course %(code)s not found" % course |
---|
194 | logger.info(msg) |
---|
195 | no_import.write(msg) |
---|
196 | no_import.write(format % course + "\n") |
---|
197 | continue |
---|
198 | course_id = course.get('code') |
---|
199 | cf = dept.courses |
---|
200 | c = getattr(cf,course_id,None) |
---|
201 | if c is None: |
---|
202 | logger.info('Creating Course %(code)s %(title)s in Department %(department_code)s' % course) |
---|
203 | cf.invokeFactory('Course', course_id) |
---|
204 | c = getattr(cf,course_id) |
---|
205 | c.getContent().edit(mapping=course) |
---|
206 | review_state = course.get('review_state') |
---|
207 | if review_state == "checked" and wf.getInfoFor(c,'review_state',None) != 'checked': |
---|
208 | self.portal_workflow.doActionFor(c,'approve') |
---|
209 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
210 | ###) |
---|
211 | |
---|
212 | security.declareProtected(ModifyPortalContent,"loadCertificatesFromCSV")###( |
---|
213 | |
---|
214 | def loadCertificatesFromCSV(self): |
---|
215 | """install Universityspecific Certificates from CSV values""" |
---|
216 | #return |
---|
217 | name = 'Certificates' |
---|
218 | wf = self.portal_workflow |
---|
219 | no_import_list = [] |
---|
220 | logger = logging.getLogger('loadcertificates') |
---|
221 | fields = ("code", |
---|
222 | "review_state", |
---|
223 | "title", |
---|
224 | "faculty_code", |
---|
225 | "department_code", |
---|
226 | "category", |
---|
227 | "end_level", |
---|
228 | "m_prefix", |
---|
229 | "max_elect", |
---|
230 | "max_pass", |
---|
231 | "n_core", |
---|
232 | "nr_years", |
---|
233 | "original_code", |
---|
234 | "probation_credits", |
---|
235 | "promotion_credits", |
---|
236 | "start_level", |
---|
237 | "admin_status", |
---|
238 | ) |
---|
239 | format = ' '.join(['%%(%s)s ' % fn for fn in fields]) |
---|
240 | try: |
---|
241 | courses = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
242 | except: |
---|
243 | logger.error('Error reading %s.csv' % name) |
---|
244 | return |
---|
245 | try: |
---|
246 | certificates = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
247 | except: |
---|
248 | logger.error('Error reading %s.csv' % name) |
---|
249 | return |
---|
250 | f_ids = [f.id for f in self.portal_catalog({'meta_type': "Faculty"})] |
---|
251 | dl = self.portal_catalog({'meta_type': "Department"}) |
---|
252 | deps = {} |
---|
253 | for d in dl: |
---|
254 | deps[d.id] = d.getObject() |
---|
255 | for certificate in certificates: |
---|
256 | processing = "processing %s" % format |
---|
257 | logger.info(processing % certificate) |
---|
258 | depid = certificate.get('department_code') |
---|
259 | facid = certificate.get('faculty_code') |
---|
260 | if facid not in f_ids: |
---|
261 | msg = 'Faculty %(faculty_code)s for %(code)s %(title)s not found' % certificate |
---|
262 | logger.info(msg) |
---|
263 | no_import_list.append(msg) |
---|
264 | no_import_list.append(format % certificate + "\n") |
---|
265 | continue |
---|
266 | if not deps.has_key(depid): |
---|
267 | msg = 'Department %(department_code)s for %(code)s %(title)s not found' % certificate |
---|
268 | logger.info(msg) |
---|
269 | no_import_list.append(msg) |
---|
270 | no_import_list.append(format % certificate + "\n") |
---|
271 | continue |
---|
272 | dep = deps[depid] |
---|
273 | cf= dep.certificates |
---|
274 | code = certificate.get('code') |
---|
275 | certificate_id = code |
---|
276 | c = getattr(cf,certificate_id,None) |
---|
277 | if c is None: |
---|
278 | logger.info('Creating certificate %(code)s %(title)s in Department %(department_code)s' % certificate) |
---|
279 | cf.invokeFactory('Certificate', certificate_id) |
---|
280 | c = getattr(cf,certificate_id) |
---|
281 | c.getContent().edit(mapping=certificate) |
---|
282 | review_state = c.get('review_state') |
---|
283 | if review_state == "checked" and wf.getInfoFor(c,'review_state',None) != 'checked': |
---|
284 | self.portal_workflow.doActionFor(c,'approve') |
---|
285 | if no_import_list: |
---|
286 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
287 | heading = ' '.join(['"%s"' % fn for fn in fields]) |
---|
288 | no_import.write('%s\n' % heading) |
---|
289 | for line in no_import_list: |
---|
290 | no_import.write(line) |
---|
291 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
292 | ###) |
---|
293 | |
---|
294 | security.declareProtected(ModifyPortalContent,"loadCertificateCoursesFromCSV")###( |
---|
295 | def loadCertificateCoursesFromCSV(self): |
---|
296 | """install Certificate Courses from CSV values""" |
---|
297 | #return |
---|
298 | logger = logging.getLogger('loadcertificatecourses') |
---|
299 | name = 'CertificateCourses' |
---|
300 | wf = self.portal_workflow |
---|
301 | no_import_list = [] |
---|
302 | logger = logging.getLogger('loadcertificates') |
---|
303 | fields = ("code", |
---|
304 | "review_state", |
---|
305 | "faculty_code", |
---|
306 | "department_code", |
---|
307 | "certificate_code", |
---|
308 | "level", |
---|
309 | "semester", |
---|
310 | "core_or_elective", |
---|
311 | ) |
---|
312 | format = ' '.join(['%%(%s)s ' % fn for fn in fields]) |
---|
313 | try: |
---|
314 | cert_courses = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
315 | except: |
---|
316 | logger.error('Error reading %s.csv' % name) |
---|
317 | return |
---|
318 | d_ids = [d.id for d in self.portal_catalog({'meta_type': "Department"})] |
---|
319 | c_ids = [c.id for c in self.portal_catalog({'meta_type': "Course"})] |
---|
320 | l = self.portal_catalog({'meta_type': "Certificate"}) |
---|
321 | certs = {} |
---|
322 | for f in l: |
---|
323 | certs[f.id] = f.getObject() |
---|
324 | for cert_course in cert_courses: |
---|
325 | processing = "processing %s" % format |
---|
326 | logger.info(processing % cert_course) |
---|
327 | depid = cert_course.get('department_code') |
---|
328 | course_code = cert_course.get('code') |
---|
329 | code = cert_course.get('certificate_code') |
---|
330 | if not code in certs.keys(): |
---|
331 | em = 'CertCode %(certificate_code)s for %(code)s not found\n' % cert_course |
---|
332 | logger.info(em) |
---|
333 | no_import_list.append(em) |
---|
334 | no_import_list.append(format % cert_course + "\n") |
---|
335 | continue |
---|
336 | certificate = certs[code] |
---|
337 | certificate_code = certificate.getId() |
---|
338 | if course_code not in c_ids: |
---|
339 | em = 'Course %(code)s for %(certificate_code)s Level %(level)s not found in Courses\n' % cert_course |
---|
340 | logger.info(em) |
---|
341 | no_import_list.append(em) |
---|
342 | no_import_list.append(format % cert_course + "\n") |
---|
343 | continue |
---|
344 | if depid not in d_ids: |
---|
345 | em = 'Department %(department_code)s for %(certificate_code)s not found\n' % cert_course |
---|
346 | logger.info(em) |
---|
347 | no_import_list.append(em) |
---|
348 | no_import_list.append(format % cert_course + "\n") |
---|
349 | continue |
---|
350 | level = cert_course.get('level') |
---|
351 | l = getattr(certificate,level,None) |
---|
352 | if l is None: |
---|
353 | logger.info('Creating Level %(level)s in certificate %(certificate_code)s' % cert_course) |
---|
354 | certificate.invokeFactory('StudyLevel', level) |
---|
355 | l = getattr(certificate, level) |
---|
356 | l.getContent().edit(mapping={'Title': "Level %s" % level}) |
---|
357 | certificate.orderObjects('id') |
---|
358 | if hasattr(l,course_code): |
---|
359 | msg = 'Duplicate %(code)s in Level %(level)s' % cert_course |
---|
360 | logger.info(msg) |
---|
361 | no_import_list.append(msg + "\n") |
---|
362 | no_import_list.append(format % cert_course + "\n") |
---|
363 | continue |
---|
364 | l.invokeFactory('CertificateCourse',course_code) |
---|
365 | logger.info('Creating CertificateCourse %(code)s in certificate %(certificate_code)s Level %(level)s' % cert_course) |
---|
366 | cc = getattr(l,course_code) |
---|
367 | semester = 'first' |
---|
368 | try: |
---|
369 | sem = int(cert_course.get('semester')) |
---|
370 | cert_course['semester'] = ('first','second')[sem - 1] |
---|
371 | except: |
---|
372 | pass |
---|
373 | cert_course['core_or_elective'] = eval(cert_course['core_or_elective']) |
---|
374 | cc.getContent().edit(mapping=cert_course) |
---|
375 | review_state = cc.get('review_state') |
---|
376 | if review_state == "checked" and wf.getInfoFor(cc,'review_state',None) != 'checked': |
---|
377 | self.portal_workflow.doActionFor(cc,'approve') |
---|
378 | if no_import_list: |
---|
379 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
380 | heading = ' '.join(['"%s"' % fn for fn in fields]) |
---|
381 | no_import.write('%s\n' % heading) |
---|
382 | for line in no_import_list: |
---|
383 | no_import.write(line) |
---|
384 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
385 | ###) |
---|
386 | |
---|
387 | security.declareProtected(ModifyPortalContent,"loadFacultiesFromOrgCSV")###( |
---|
388 | def loadFacultiesFromOrgCSV(self): |
---|
389 | """install Universityspecific Faculies from CSV values""" |
---|
390 | #return |
---|
391 | name = 'Faculties' |
---|
392 | no_import = False |
---|
393 | logger = logging.getLogger('%s_import' % name) |
---|
394 | logger.info('Start loading from %s.csv' % name) |
---|
395 | academics = self.portal_catalog({'meta_type': 'AcademicsFolder'})[-1].getObject() |
---|
396 | try: |
---|
397 | faculties = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
398 | except: |
---|
399 | logger.error('Error reading %s.csv' % name) |
---|
400 | return |
---|
401 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
402 | facs = {} |
---|
403 | for f in l: |
---|
404 | facs[f.id] = f.getObject() |
---|
405 | for faculty in faculties: |
---|
406 | logger.info('processing %(Session)s %(FacultyCode)s %(Description)s %(CollegeCode)s %(FacultyKey)s %(Status)s %(degree_grade)s %(Bankcode)s' % faculty) |
---|
407 | fid = faculty['FacultyCode'] |
---|
408 | f = facs.get(fid,None) |
---|
409 | if f is None: |
---|
410 | #self.log('Creating Faculty %(id)s = %(Title)s' % faculty) |
---|
411 | logger.info('Creating Faculty with ID %(FacultyCode)s %(Description)s' % faculty) |
---|
412 | academics.invokeFactory('Faculty', fid) |
---|
413 | f = getattr(self,fid) |
---|
414 | d = {'Title': faculty['Description']} |
---|
415 | else: |
---|
416 | d = {} |
---|
417 | d['bank_code'] = faculty.get("Bankcode") |
---|
418 | d["degree_grade"] = faculty.get("degree_grade") |
---|
419 | d['institution_type'] = 'faculty' |
---|
420 | d['Description'] = '' |
---|
421 | d['college_code'] = faculty.get('CollegeCode') |
---|
422 | f.getContent().edit(mapping=d) |
---|
423 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
424 | ###) |
---|
425 | |
---|
426 | security.declareProtected(ModifyPortalContent,"yamlDumpFaculties")###( |
---|
427 | def yamlDumpFaculties(self): |
---|
428 | """dump Faculies to Yaml""" |
---|
429 | #return |
---|
430 | import yaml |
---|
431 | logger = logging.getLogger('dumpfaculties') |
---|
432 | logger.info('Start dumping Faculties') |
---|
433 | academics = self.portal_catalog({'meta_type': 'AcademicsFolder'})[-1].getObject() |
---|
434 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
435 | facs = {} |
---|
436 | for f in l: |
---|
437 | facs[f.id] = f.getObject() |
---|
438 | for fid in facs.keys(): |
---|
439 | faculty = facs.get(fid).aq_self |
---|
440 | logger.info('dumping %s %s ' % (faculty.id, faculty.title)) |
---|
441 | print yaml.dump(faculty) |
---|
442 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
443 | |
---|
444 | ###) |
---|
445 | |
---|
446 | security.declareProtected(ModifyPortalContent,"loadDepartmentsFromOrgCSV")###( |
---|
447 | def loadDepartmentsFromOrgCSV(self): |
---|
448 | """install Universityspecific Faculies from CSV values""" |
---|
449 | #return |
---|
450 | name = 'Departments' |
---|
451 | no_import = False |
---|
452 | logger = logging.getLogger('loaddepartments') |
---|
453 | try: |
---|
454 | deps = csv.DictReader(open("%s/import/departments.csv" % i_home,"rb")) |
---|
455 | except: |
---|
456 | logger.error('Error reading departments.csv') |
---|
457 | return |
---|
458 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
459 | facs = {} |
---|
460 | for f in l: |
---|
461 | facs[f.id] = f.getObject() |
---|
462 | for dep in deps: |
---|
463 | logger.info('Processing %(Session)s %(DeptCode)s %(Description)s %(FacultyCode)s' % dep) |
---|
464 | fid = dep['FacultyCode'] |
---|
465 | f = facs.get(fid,None) |
---|
466 | if f is None: |
---|
467 | logger.info( "No Faculty with ID: %s" % fid) |
---|
468 | if not no_import: |
---|
469 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
470 | no_import.write('"Session","DeptCode","Description","FacultyCode"\n') |
---|
471 | no_import.write( "No Faculty with ID: %s\n" % fid) |
---|
472 | no_import.write('"%(Session)s","%(DeptCode)s","%(Description)s","%(FacultyCode)s"\n' % dep) |
---|
473 | else: |
---|
474 | did = dep.get('DeptCode') |
---|
475 | d = getattr(f,did,None) |
---|
476 | if d is None or d.portal_type == "Faculty": |
---|
477 | logger.info('Creating Department %(DeptCode)s = %(Description)s' % dep) |
---|
478 | f.invokeFactory('Department', did) |
---|
479 | d = getattr(f,did) |
---|
480 | dict = {'Title': dep['Description']} |
---|
481 | d.getContent().edit(mapping=dict) |
---|
482 | d.invokeFactory('CoursesFolder','courses') |
---|
483 | courses = getattr(d,'courses') |
---|
484 | dict = {'Title': 'Courses'} |
---|
485 | courses.getContent().edit(mapping=dict) |
---|
486 | d.invokeFactory('CertificatesFolder','certificates') |
---|
487 | certificates = getattr(d,'certificates') |
---|
488 | dict = {'Title': 'Certificates'} |
---|
489 | certificates.getContent().edit(mapping=dict) |
---|
490 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
491 | ###) |
---|
492 | |
---|
493 | security.declareProtected(ModifyPortalContent,"loadCoursesFromOrgCSV")###( |
---|
494 | def loadCoursesFromOrgCSV(self): |
---|
495 | """install Universityspecific Courses from CSV values""" |
---|
496 | #return |
---|
497 | name = 'Courses' |
---|
498 | no_import = False |
---|
499 | logger = logging.getLogger('loadcourses') |
---|
500 | try: |
---|
501 | courses = csv.DictReader(open("%s/import/courses.csv" % i_home,"rb")) |
---|
502 | except: |
---|
503 | logger.error('Error reading courses.csv') |
---|
504 | return |
---|
505 | l = self.portal_catalog({'meta_type': "Faculty"}) |
---|
506 | facs = {} |
---|
507 | for f in l: |
---|
508 | facs[f.id] = f.getObject() |
---|
509 | dl = self.portal_catalog({'meta_type': "Department"}) |
---|
510 | deps = {} |
---|
511 | for d in dl: |
---|
512 | deps[d.id] = d.getObject() |
---|
513 | cl = self.portal_catalog({'meta_type': "Course"}) |
---|
514 | course_list = [ c.id for c in cl] |
---|
515 | for course in courses: |
---|
516 | logger.info('Processing %(CourseCode)s %(Description)s %(Credits)s %(Dept)s %(Semester)s %(Session)s %(PassMark)s %(Category)s %(AdmStatus)s' % course) |
---|
517 | ## if course.get("FORMERCODE").endswith('BITS'): |
---|
518 | ## continue |
---|
519 | depid = course.get('Dept').upper() |
---|
520 | if depid in deps.keys(): |
---|
521 | dept= deps.get(depid) |
---|
522 | ## elif depid in facs.keys(): |
---|
523 | ## dept= facs.get(depid) |
---|
524 | else: |
---|
525 | logger.info("Dep %(Dept)s for Course %(CourseCode)s not found" % course) |
---|
526 | if not no_import: |
---|
527 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
528 | no_import.write('"CourseCode","Description","Credits","Dept","Semester","Session","PassMark","Category","AdmStatus"\n') |
---|
529 | no_import.write("Dep %(Dept)s for Course %(CourseCode)s not found\n" % course) |
---|
530 | no_import.write('"%(CourseCode)s","%(Description)s","%(Credits)s","%(Dept)s","%(Semester)s","%(Session)s","%(PassMark)s","%(Category)s","%(AdmStatus)s"\n' % course) |
---|
531 | continue |
---|
532 | course_id = ''.join(re.split('\W+',course.get('CourseCode'))) |
---|
533 | if len(course_id) == 3: |
---|
534 | course_id = "%s000" % course_id |
---|
535 | elif len(course_id) > 10: |
---|
536 | logger.info("invalid course_code %(CourseCode)s" % course) |
---|
537 | if not no_import: |
---|
538 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
539 | no_import.write('"CourseCode","Description","Credits","Dept","Semester","Session","PassMark","Category","AdmStatus"\n') |
---|
540 | no_import.write("invalid course_code %(CourseCode)s\n" % course) |
---|
541 | no_import.write('"%(CourseCode)s","%(Description)s","%(Credits)s","%(Dept)s","%(Semester)s","%(Session)s","%(PassMark)s","%(Category)s","%(AdmStatus)s"\n' % course) |
---|
542 | continue |
---|
543 | courses = dept.courses |
---|
544 | c = getattr(courses,course_id,None) |
---|
545 | if c is None: |
---|
546 | logger.info('Creating Course %(CourseCode)s %(Description)s in Department %(Dept)s' % course) |
---|
547 | courses.invokeFactory('Course', course_id) |
---|
548 | c = getattr(courses,course_id) |
---|
549 | dict = {'Title': course['Description']} |
---|
550 | dict['code'] = course_id |
---|
551 | dict['org_code'] = course.get('CourseCode') |
---|
552 | dict['credits'] = course.get('Credits') |
---|
553 | dict['semester'] = course.get('Semester') |
---|
554 | dict['session'] = course.get('Session') |
---|
555 | dict['category'] = course.get('Category') |
---|
556 | dict['adm_status'] = course.get('AdmStatus') |
---|
557 | dict['former_code'] = course.get('FORMERCODE') |
---|
558 | pm = course.get('PassMark') |
---|
559 | if pm.find(',') > -1: |
---|
560 | pm.replace(',','.') |
---|
561 | elif pm == "": |
---|
562 | pm = "0.0" |
---|
563 | try: |
---|
564 | dict['passmark'] = int(float(pm)) |
---|
565 | except: |
---|
566 | dict['passmark'] = 0 |
---|
567 | c.getContent().edit(mapping=dict) |
---|
568 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
569 | ###) |
---|
570 | |
---|
571 | security.declareProtected(ModifyPortalContent,"loadCertificatesFromOrgCSV")###( |
---|
572 | |
---|
573 | def loadCertificatesFromOrgCSV(self): |
---|
574 | """install Universityspecific Certificates from CSV values""" |
---|
575 | #return |
---|
576 | name = 'Certificates' |
---|
577 | no_import = False |
---|
578 | logger = logging.getLogger('loadcertificates') |
---|
579 | try: |
---|
580 | certificates = csv.DictReader(open("%s/import/certificates.csv" % i_home,"rb")) |
---|
581 | except: |
---|
582 | logger.error('Error reading certificates.csv') |
---|
583 | return |
---|
584 | f_ids = [f.id for f in self.portal_catalog({'meta_type': "Faculty"})] |
---|
585 | #d_ids = [d.id for d in self.portal_catalog({'meta_type': "Department"})] |
---|
586 | dl = self.portal_catalog({'meta_type': "Department"}) |
---|
587 | deps = {} |
---|
588 | for d in dl: |
---|
589 | deps[d.id] = d.getObject() |
---|
590 | for certificate in certificates: |
---|
591 | logger.info('Processing %(CertCode)s %(Description)s %(Faculty)s %(MaxPass)s %(MaxLoad)s %(session)s %(PromotionCredits)s %(Probationcredits)s %(StartLevel)s %(endLevel)s %(Nyears)s %(Ncore)s %(MaxElect)s %(MPREFIX)s %(Dept)s %(Admstatus)s %(category)s' % certificate) |
---|
592 | depid = certificate.get('Dept') |
---|
593 | facid = certificate.get('Faculty') |
---|
594 | if facid not in f_ids: |
---|
595 | logger.info('Faculty %(Faculty)s for %(CertCode)s %(Description)s not found' % certificate) |
---|
596 | if not no_import: |
---|
597 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
598 | no_import.write('"CertCode","Description","Faculty","MaxPass","MaxLoad","session","PromotionCredits","Probationcredits","StartLevel","endLevel","Nyears","Ncore","MaxElect","MPREFIX","Dept","Admstatus","category"\n') |
---|
599 | no_import.write('Faculty %(Faculty)s for %(CertCode)s %(Description)s not found\n' % certificate) |
---|
600 | no_import.write('"%(CertCode)s","%(Description)s","%(Faculty)s","%(MaxPass)s","%(MaxLoad)s","%(session)s","%(PromotionCredits)s","%(Probationcredits)s","%(StartLevel)s","%(endLevel)s","%(Nyears)s","%(Ncore)s","%(MaxElect)s","%(MPREFIX)s","%(Dept)s","%(Admstatus)s","%(category)s"\n' % certificate) |
---|
601 | continue |
---|
602 | if not deps.has_key(depid): |
---|
603 | logger.info('Department %(Dept)s for %(CertCode)s %(Description)s not found' % certificate) |
---|
604 | if not no_import: |
---|
605 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
606 | no_import.write('"CertCode","Description","Faculty","MaxPass","MaxLoad","session","PromotionCredits","Probationcredits","StartLevel","endLevel","Nyears","Ncore","MaxElect","MPREFIX","Dept","Admstatus","category"\n') |
---|
607 | no_import.write('Department %(Dept)s for %(CertCode)s %(Description)s not found\n' % certificate) |
---|
608 | no_import.write('"%(CertCode)s","%(Description)s","%(Faculty)s","%(MaxPass)s","%(MaxLoad)s","%(session)s","%(PromotionCredits)s","%(Probationcredits)s","%(StartLevel)s","%(endLevel)s","%(Nyears)s","%(Ncore)s","%(MaxElect)s","%(MPREFIX)s","%(Dept)s","%(Admstatus)s","%(category)s"\n' % certificate) |
---|
609 | continue |
---|
610 | #certificate_id = "%(category)s_%(Admstatus)s_%(Dept)s" % certificate |
---|
611 | dep = deps[depid] |
---|
612 | certificates = dep.certificates |
---|
613 | code = makeCertificateCode(certificate.get('CertCode')) |
---|
614 | certificate_id = code |
---|
615 | c = getattr(certificates,certificate_id,None) |
---|
616 | if c is None: |
---|
617 | #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep) |
---|
618 | logger.info('Creating certificate %(CertCode)s %(Description)s in Department %(Dept)s' % certificate) |
---|
619 | certificates.invokeFactory('Certificate', certificate_id) |
---|
620 | c = getattr(certificates,certificate_id) |
---|
621 | dict = {'Title': certificate['Description']} |
---|
622 | dict['code'] = code |
---|
623 | dict['faculty'] = certificate.get('Faculty') |
---|
624 | dict['department'] = certificate.get('Dept') |
---|
625 | dict['max_pass'] = certificate.get('MaxPass') |
---|
626 | dict['max_load'] = certificate.get('MaxLoad') |
---|
627 | dict['admin_status'] = certificate.get('Admstatus') |
---|
628 | dict['category'] = certificate.get('category') |
---|
629 | dict['m_prefix'] = certificate.get('MPREFIX') |
---|
630 | dict['nr_years'] = int(certificate.get('Nyears')) |
---|
631 | nc = certificate.get('Ncore','1') |
---|
632 | try: |
---|
633 | dict['n_core'] = int(nc) |
---|
634 | except: |
---|
635 | dict['n_core'] = 1 |
---|
636 | dict['start_level'] = certificate.get('StartLevel') |
---|
637 | dict['end_level'] = certificate.get('endLevel') |
---|
638 | dict['promotion_credits'] = certificate.get('PromotionCredits') |
---|
639 | dict['probation_credits'] = certificate.get('ProbationCredits') |
---|
640 | else: |
---|
641 | dict = {} |
---|
642 | dict['original_code'] = certificate.get('CertCode') |
---|
643 | print |
---|
644 | c.getContent().edit(mapping=dict) |
---|
645 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
646 | ###) |
---|
647 | |
---|
648 | security.declareProtected(ModifyPortalContent,"loadCertificateCoursesFromOrgCSV")###( |
---|
649 | def loadCertificateCoursesFromOrgCSV(self): |
---|
650 | """install Certificate Courses from CSV values""" |
---|
651 | #return |
---|
652 | logger = logging.getLogger('loadcertificatecourses') |
---|
653 | name = 'Certificate_courses' |
---|
654 | no_import = False |
---|
655 | try: |
---|
656 | cert_courses = csv.DictReader(open("%s/import/course_level_courses.csv" % i_home,"rb")) |
---|
657 | except: |
---|
658 | logger.error('Error reading course_level_courses.csv') |
---|
659 | return |
---|
660 | d_ids = [d.id for d in self.portal_catalog({'meta_type': "Department"})] |
---|
661 | c_ids = [c.id for c in self.portal_catalog({'meta_type': "Course"})] |
---|
662 | l = self.portal_catalog({'meta_type': "Certificate"}) |
---|
663 | certs = {} |
---|
664 | for f in l: |
---|
665 | certs[f.id] = f.getObject() |
---|
666 | for cert_course in cert_courses: |
---|
667 | logger.info('Processing %(CosCode)s %(CertCode)s %(Session)s %(Level)s %(Core)s %(Elective)s %(Mandatory)s %(AdmStatus)s %(Dept)s %(Semester)s' % cert_course) |
---|
668 | depid = cert_course.get('Dept') |
---|
669 | course_code = cert_course.get('CosCode') |
---|
670 | code = cert_course.get('CertCode') |
---|
671 | code = code.replace('.','') |
---|
672 | code = code.replace('(','') |
---|
673 | code = code.replace(')','') |
---|
674 | code = code.replace('/','') |
---|
675 | code = code.replace(' ','') |
---|
676 | code = code.replace('_','') |
---|
677 | ## if cert_course.get('Session') != '2002/2003': |
---|
678 | ## continue |
---|
679 | ## certificate = self.portal_catalog({'meta_type': "Certificate", |
---|
680 | ## 'SearchableText': code}) |
---|
681 | ## if not certificate: |
---|
682 | if not code in certs.keys(): |
---|
683 | #print code |
---|
684 | em = 'CertCode %(CertCode)s for %(CosCode)s not found\n' % cert_course |
---|
685 | logger.info(em) |
---|
686 | if not no_import: |
---|
687 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
688 | no_import.write('"CosCode","CertCode","Session","Level","Core","Elective","Mandatory","AdmStatus","Dept","Semester"\n') |
---|
689 | no_import.write(em) |
---|
690 | no_import.write('"%(CosCode)s","%(CertCode)s","%(Session)s","%(Level)s","%(Core)s","%(Elective)s","%(Mandatory)s","%(AdmStatus)s","%(Dept)s","%(Semester)s"\n' % cert_course) |
---|
691 | continue |
---|
692 | certificate = certs[code] |
---|
693 | certificate_code = certificate.getId() |
---|
694 | if course_code not in c_ids: |
---|
695 | em = 'CorseCode %(CosCode)s for %(CertCode)s not found in Courses\n' % cert_course |
---|
696 | logger.info(em) |
---|
697 | if not no_import: |
---|
698 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
699 | no_import.write('"CosCode","CertCode","Session","Level","Core","Elective","Mandatory","AdmStatus","Dept","Semester"\n') |
---|
700 | no_import.write(em) |
---|
701 | no_import.write('"%(CosCode)s","%(CertCode)s","%(Session)s","%(Level)s","%(Core)s","%(Elective)s","%(Mandatory)s","%(AdmStatus)s","%(Dept)s","%(Semester)s"\n' % cert_course) |
---|
702 | continue |
---|
703 | if depid not in d_ids: |
---|
704 | em = 'Department %(Dept)s for %(CertCode)s not found\n' % cert_course |
---|
705 | logger.info(em) |
---|
706 | if not no_import: |
---|
707 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
708 | no_import.write('"CosCode","CertCode","Session","Level","Core","Elective","Mandatory","AdmStatus","Dept","Semester"\n') |
---|
709 | no_import.write(em) |
---|
710 | no_import.write('"%(CosCode)s","%(CertCode)s","%(Session)s","%(Level)s","%(Core)s","%(Elective)s","%(Mandatory)s","%(AdmStatus)s","%(Dept)s","%(Semester)s"\n' % cert_course) |
---|
711 | continue |
---|
712 | level = cert_course.get('Level') |
---|
713 | l = getattr(certificate,level,None) |
---|
714 | if l is None: |
---|
715 | #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep) |
---|
716 | logger.info('Creating Level %(Level)s in certificate %(CertCode)s' % cert_course) |
---|
717 | certificate.invokeFactory('StudyLevel', level) |
---|
718 | l = getattr(certificate, level) |
---|
719 | l.getContent().edit(mapping={'Title': "Level %s" % level}) |
---|
720 | l.invokeFactory('Semester','first') |
---|
721 | l.invokeFactory('Semester','second') |
---|
722 | certificate.orderObjects('id') |
---|
723 | first_s = getattr(l,'first') |
---|
724 | first_s.getContent().edit(mapping={'Title': 'First Semester'}) |
---|
725 | second_s = getattr(l,'second') |
---|
726 | second_s.getContent().edit(mapping={'Title': 'Second Semester'}) |
---|
727 | if cert_course.get('Semester') == '1': |
---|
728 | semester = first_s |
---|
729 | else: |
---|
730 | semester = second_s |
---|
731 | if hasattr(semester,course_code): |
---|
732 | logger.info('Duplicate %(CosCode)s in Level %(Level)s' % cert_course) |
---|
733 | if not no_import: |
---|
734 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
735 | no_import.write('"CosCode","CertCode","Session","Level","Core","Elective","Mandatory","AdmStatus","Dept","Semester"\n') |
---|
736 | ## no_import.write('Duplicate %(CosCode)s in Level %(Level)s' % cert_course) |
---|
737 | ## no_import.write('"%(CosCode)s","%(CertCode)s","%(Session)s","%(Level)s","%(Core)s","%(Elective)s","%(Mandatory)s","%(AdmStatus)s","%(Dept)s","%(Semester)s"\n' % cert_course) |
---|
738 | continue |
---|
739 | semester.invokeFactory('CertificateCourse',course_code) |
---|
740 | cc = getattr(semester,course_code) |
---|
741 | dict = {} |
---|
742 | dict['code'] = cert_course.get('CosCode') |
---|
743 | dict['certificate_code'] = code |
---|
744 | dict['certificate_code_org'] = cert_course.get('CertCode') |
---|
745 | dict['department'] = cert_course.get('Dept') |
---|
746 | dict['admin_status'] = cert_course.get('Admstatus') |
---|
747 | dict['session'] = cert_course.get('Session') |
---|
748 | if cert_course.get('Core') != '': |
---|
749 | dict['core_or_elective'] = True |
---|
750 | else: |
---|
751 | dict['core_or_elective'] = False |
---|
752 | dict['level'] = cert_course.get('Level') |
---|
753 | cc.getContent().edit(mapping=dict) |
---|
754 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
755 | ###) |
---|
756 | |
---|
757 | security.declareProtected(ModifyPortalContent,"exportFacultiesToCSV")###( |
---|
758 | def exportFacultiesToCSV(self): |
---|
759 | """export Faculies to CSV""" |
---|
760 | #return |
---|
761 | name = 'Faculties' |
---|
762 | no_import = False |
---|
763 | logger = logging.getLogger('%s_export' % name) |
---|
764 | current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S") |
---|
765 | logger.info('Start exporting %(name)s to %(name)s_%(current)s.csv' % vars()) |
---|
766 | objects = [f.getObject() for f in self.portal_catalog({'meta_type': 'Faculty'})] |
---|
767 | export = [] |
---|
768 | export.append('"code","review_state","title","title_prefix","college_code","degree_grade","bank_code"') |
---|
769 | for obj in objects: |
---|
770 | logger.info('exporting %s %s ' % (obj.id, obj.title)) |
---|
771 | obj_d = obj.getContent() |
---|
772 | di = {} |
---|
773 | di['code'] = obj_d.code |
---|
774 | di['title'] = obj_d.title |
---|
775 | di['title_prefix'] = obj_d.title_prefix |
---|
776 | di['college_code'] = obj_d.college_code |
---|
777 | di['degree_grade'] = obj_d.degree_grade |
---|
778 | di['bank_code'] = obj_d.bank_code |
---|
779 | di['code'] = di['code'] or obj.id |
---|
780 | di['review_state'] = self.portal_workflow.getInfoFor(obj,'review_state','no_state') |
---|
781 | export.append('"%(code)s","%(review_state)s","%(title)s","%(title_prefix)s","%(college_code)s","%(degree_grade)s","%(bank_code)s"' % di) |
---|
782 | open("%s/import/%s-%s.csv" % (i_home,name,current),"w+").write('\n'.join(export)) |
---|
783 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
784 | |
---|
785 | ###) |
---|
786 | |
---|
787 | security.declareProtected(ModifyPortalContent,"exportDepartmentsToCSV")###( |
---|
788 | def exportDepartmentsToCSV(self): |
---|
789 | """export Faculies to CSV""" |
---|
790 | #return |
---|
791 | import copy |
---|
792 | name = 'Departments' |
---|
793 | no_import = False |
---|
794 | logger = logging.getLogger('%s_export' % name) |
---|
795 | current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S") |
---|
796 | logger.info('Start exporting %(name)s to %(name)s_%(current)s.csv' % vars()) |
---|
797 | faculties = [f.getObject() for f in self.portal_catalog({'meta_type': 'Faculty'})] |
---|
798 | export = [] |
---|
799 | export.append('"code","review_state","title","title_prefix","faculty_code"') |
---|
800 | #import pdb;pdb.set_trace() |
---|
801 | for faculty in faculties: |
---|
802 | di = {} |
---|
803 | di['faculty_code'] = faculty.id |
---|
804 | for department in faculty.objectValues(): |
---|
805 | department_d = department.getContent() |
---|
806 | try: |
---|
807 | di['code'] = department.getId() |
---|
808 | di['title'] = department_d.title |
---|
809 | di['title_prefix'] = department_d.title_prefix |
---|
810 | di['review_state'] = self.portal_workflow.getInfoFor(department,'review_state','no_state') |
---|
811 | export.append('"%(code)s","%(review_state)s","%(title)s","%(title_prefix)s","%(faculty_code)s"' % di) |
---|
812 | logger.info('exporting %s %s ' % (department.id, department.title)) |
---|
813 | except: |
---|
814 | logger.info('could not export %s %s ' % (department.id, department.title)) |
---|
815 | continue |
---|
816 | open("%s/import/%s-%s.csv" % (i_home,name,current),"w+").write('\n'.join(export)) |
---|
817 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
818 | ###) |
---|
819 | |
---|
820 | security.declareProtected(ModifyPortalContent,"exportCoursesToCSV")###( |
---|
821 | def exportCoursesToCSV(self): |
---|
822 | """export Courses to CSV""" |
---|
823 | #return |
---|
824 | name = 'Courses' |
---|
825 | no_import = False |
---|
826 | logger = logging.getLogger('%s_export' % name) |
---|
827 | current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S") |
---|
828 | logger.info('Start exporting %(name)s to %(name)s_%(current)s.csv' % vars()) |
---|
829 | faculties = [f.getObject() for f in self.portal_catalog({'meta_type': 'Faculty'})] |
---|
830 | export = [] |
---|
831 | heading = '"code","review_state","title","faculty_code","department_code",' |
---|
832 | heading += '"credits","org_code","passmark","semester","session"' |
---|
833 | dataline = '"%(code)s","%(review_state)s","%(title)s","%(faculty_code)s","%(department_code)s",' |
---|
834 | dataline += '"%(credits)s","%(org_code)s","%(passmark)s","%(semester)s","%(session)s"' |
---|
835 | export.append(heading) |
---|
836 | #import pdb;pdb.set_trace() |
---|
837 | fields = ("title", |
---|
838 | "credits", |
---|
839 | "org_code", |
---|
840 | "passmark", |
---|
841 | "semester", |
---|
842 | "session", |
---|
843 | ) |
---|
844 | for faculty in faculties: |
---|
845 | di = {} |
---|
846 | di['faculty_code'] = faculty.id |
---|
847 | for department in faculty.objectValues(): |
---|
848 | di['department_code'] = department.id |
---|
849 | for course in department.courses.objectValues(): |
---|
850 | di['code'] = course.getId() |
---|
851 | course_d = course.getContent() |
---|
852 | for f in fields: |
---|
853 | di[f] = getattr(course_d,f,None) |
---|
854 | di['review_state'] = self.portal_workflow.getInfoFor(course,'review_state','no_state') |
---|
855 | export.append(dataline % di) |
---|
856 | logger.info('exporting %s %s ' % (course.id, course.title)) |
---|
857 | continue |
---|
858 | open("%s/import/%s-%s.csv" % (i_home,name,current),"w+").write('\n'.join(export)) |
---|
859 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
860 | ###) |
---|
861 | |
---|
862 | security.declareProtected(ModifyPortalContent,"exportCertificatesToCSV")###( |
---|
863 | def exportCertificatesToCSV(self): |
---|
864 | """export Certificates to CSV""" |
---|
865 | #return |
---|
866 | name = 'Certificates' |
---|
867 | no_import = False |
---|
868 | logger = logging.getLogger('%s_export' % name) |
---|
869 | current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S") |
---|
870 | logger.info('Start exporting %(name)s to %(name)s_%(current)s.csv' % vars()) |
---|
871 | faculties = [f.getObject() for f in self.portal_catalog({'meta_type': 'Faculty'})] |
---|
872 | export = [] |
---|
873 | heading = '"code","review_state","title","faculty_code","department_code",' |
---|
874 | heading += '"category","end_level","m_prefix","max_elect","max_pass",' |
---|
875 | heading += '"n_core","nr_years","original_code","probation_credits",' |
---|
876 | heading += '"promotion_credits","start_level","admin_status"' |
---|
877 | dataline = '"%(code)s","%(review_state)s","%(title)s","%(faculty_code)s","%(department_code)s",' |
---|
878 | dataline += '"%(category)s","%(end_level)s","%(m_prefix)s","%(max_elect)s","%(max_pass)s",' |
---|
879 | dataline += '"%(n_core)s","%(nr_years)s","%(original_code)s","%(probation_credits)s",' |
---|
880 | dataline += '"%(promotion_credits)s","%(start_level)s","%(admin_status)s"' |
---|
881 | export.append(heading) |
---|
882 | #import pdb;pdb.set_trace() |
---|
883 | for faculty in faculties: |
---|
884 | di = {} |
---|
885 | di['faculty_code'] = faculty.id |
---|
886 | for department in faculty.objectValues(): |
---|
887 | di['department_code'] = department.id |
---|
888 | for certificate in department.certificates.objectValues(): |
---|
889 | certificate_d = certificate.getContent() |
---|
890 | di['code'] = certificate.id |
---|
891 | #di['code'] = getattr(certificate_d,'code',None) |
---|
892 | di['title'] = getattr(certificate_d,'title',None) |
---|
893 | di['category'] = getattr(certificate_d,'category',None) |
---|
894 | di['admin_status'] = getattr(certificate_d,'admin_status',None) |
---|
895 | di['end_level'] = getattr(certificate_d,'end_level',None) |
---|
896 | di['m_prefix'] = getattr(certificate_d,'m_prefix',None) |
---|
897 | di['max_elect'] = getattr(certificate_d,'max_elect',None) |
---|
898 | di['max_load'] = getattr(certificate_d,'max_load',None) |
---|
899 | di['max_pass'] = getattr(certificate_d,'max_pass',None) |
---|
900 | di['n_core'] = getattr(certificate_d,'n_core',None) |
---|
901 | di['nr_years'] = getattr(certificate_d,'nr_years',None) |
---|
902 | di['original_code'] = getattr(certificate_d,'original_code',None) |
---|
903 | di['probation_credits'] = getattr(certificate_d,'probation_credits',None) |
---|
904 | di['promotion_credits'] = getattr(certificate_d,'promotion_credits',None) |
---|
905 | di['start_level'] = getattr(certificate_d,'start_level',None) |
---|
906 | di['code'] = di['code'] or certificate.id |
---|
907 | di['review_state'] = self.portal_workflow.getInfoFor(certificate,'review_state','no_state') |
---|
908 | try: |
---|
909 | export.append(dataline % di) |
---|
910 | logger.info('exporting %s %s ' % (certificate.id, certificate.title)) |
---|
911 | except: |
---|
912 | logger.info('could not export %s %s ' % (certificate.id, certificate.title)) |
---|
913 | continue |
---|
914 | open("%s/import/%s-%s.csv" % (i_home,name,current),"w+").write('\n'.join(export)) |
---|
915 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
916 | ###) |
---|
917 | |
---|
918 | security.declareProtected(ModifyPortalContent,"exportCertificateCoursesToCSV")###( |
---|
919 | def exportCertificateCoursesToCSV(self): |
---|
920 | """export CertificateCourses to CSV""" |
---|
921 | #return |
---|
922 | name = 'CertificateCourses' |
---|
923 | no_import = False |
---|
924 | logger = logging.getLogger('%s_export' % name) |
---|
925 | current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S") |
---|
926 | logger.info('Start exporting %(name)s to %(name)s_%(current)s.csv' % vars()) |
---|
927 | faculties = [f.getObject() for f in self.portal_catalog({'meta_type': 'Faculty'})] |
---|
928 | export = [] |
---|
929 | heading = '"code","review_state","faculty_code","department_code",' |
---|
930 | heading += '"certificate_code","level","semester","core_or_elective"' |
---|
931 | dataline = '"%(code)s","%(review_state)s","%(faculty_code)s","%(department_code)s",' |
---|
932 | dataline += '"%(certificate_code)s","%(level)s","%(semester)s","%(core_or_elective)s"' |
---|
933 | export.append(heading) |
---|
934 | #import pdb;pdb.set_trace() |
---|
935 | semesters = ['first','second'] |
---|
936 | for faculty in faculties: |
---|
937 | di = {} |
---|
938 | di['faculty_code'] = faculty.id |
---|
939 | for department in faculty.objectValues(): |
---|
940 | di['department_code'] = department.id |
---|
941 | for certificate in department.certificates.objectValues(): |
---|
942 | di['certificate_code'] = certificate.id |
---|
943 | for level in certificate.objectValues(): |
---|
944 | di['level'] = level.id |
---|
945 | for sem in semesters: |
---|
946 | semester = getattr(level,sem,None) |
---|
947 | if semester is not None: |
---|
948 | di['semester'] = semesters.index(sem) + 1 |
---|
949 | for course in semester.objectValues(): |
---|
950 | di['code'] = course.getId() |
---|
951 | course_d = course.getContent() |
---|
952 | di['core_or_elective'] = getattr(course_d,'core_or_elective',None) |
---|
953 | di['review_state'] = self.portal_workflow.getInfoFor(course,'review_state','no_state') |
---|
954 | try: |
---|
955 | export.append(dataline % di) |
---|
956 | logger.info('exporting %s %s ' % (certificate.id, certificate.title)) |
---|
957 | except: |
---|
958 | logger.info('could not export %s %s ' % (certificate.id, certificate.title)) |
---|
959 | continue |
---|
960 | open("%s/import/%s-%s.csv" % (i_home,name,current),"w+").write('\n'.join(export)) |
---|
961 | return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1')) |
---|
962 | ###) |
---|
963 | |
---|
964 | |
---|
965 | InitializeClass(AcademicsFolder) |
---|
966 | |
---|
967 | def addAcademicsFolder(container, id, REQUEST=None, **kw): |
---|
968 | """Add a AcademicsFolder.""" |
---|
969 | ob = AcademicsFolder(id, **kw) |
---|
970 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
971 | |
---|
972 | ###) |
---|
973 | |
---|
974 | class Certificate(CPSDocument): ###( |
---|
975 | """ |
---|
976 | WAeUP Certificate |
---|
977 | """ |
---|
978 | meta_type = 'Certificate' |
---|
979 | portal_type = meta_type |
---|
980 | security = ClassSecurityInfo() |
---|
981 | |
---|
982 | def __init__(self, id, **kw): |
---|
983 | CPSDocument.__init__(self, id, **kw) |
---|
984 | |
---|
985 | ## security.declareProtected(View,"Title") |
---|
986 | ## def Title(self): |
---|
987 | ## """compose title""" |
---|
988 | ## return "Certificate of %s" % (self.title) |
---|
989 | |
---|
990 | InitializeClass(Certificate) |
---|
991 | |
---|
992 | def addCertificate(container, id, REQUEST=None, **kw): |
---|
993 | """Add a Certificate.""" |
---|
994 | ob = Certificate(id, **kw) |
---|
995 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
996 | |
---|
997 | ###) |
---|
998 | |
---|
999 | class StudyLevel(CPSDocument): ###( |
---|
1000 | """ |
---|
1001 | WAeUP StudyLevel containing the courses and students |
---|
1002 | """ |
---|
1003 | meta_type = 'StudyLevel' |
---|
1004 | portal_type = meta_type |
---|
1005 | security = ClassSecurityInfo() |
---|
1006 | |
---|
1007 | security.declareProtected(View,"Title") |
---|
1008 | def Title(self): |
---|
1009 | """compose title""" |
---|
1010 | try: |
---|
1011 | return "Level %s" % self.aq_parent.getId() |
---|
1012 | except: |
---|
1013 | return "no Title for %s" % self.getId() |
---|
1014 | |
---|
1015 | |
---|
1016 | InitializeClass(StudyLevel) |
---|
1017 | |
---|
1018 | def addStudyLevel(container, id, REQUEST=None, **kw): |
---|
1019 | """Add a StudyLevel.""" |
---|
1020 | ob = StudyLevel(id, **kw) |
---|
1021 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
1022 | |
---|
1023 | ###) |
---|
1024 | |
---|
1025 | class CertificateCourse(CPSDocument): ###( |
---|
1026 | """ |
---|
1027 | WAeUP CertificateCourse |
---|
1028 | """ |
---|
1029 | meta_type = 'CertificateCourse' |
---|
1030 | portal_type = meta_type |
---|
1031 | security = ClassSecurityInfo() |
---|
1032 | |
---|
1033 | def getCourseEntry(self,cid): |
---|
1034 | res = self.portal_catalog({'meta_type': "Course", |
---|
1035 | 'id': cid}) |
---|
1036 | if res: |
---|
1037 | return res[-1] |
---|
1038 | else: |
---|
1039 | return None |
---|
1040 | |
---|
1041 | security.declareProtected(View,"Title") |
---|
1042 | def Title(self): |
---|
1043 | """compose title""" |
---|
1044 | #import pdb;pdb.set_trace() |
---|
1045 | ce = self.getCourseEntry(self.aq_parent.getId()) |
---|
1046 | #print self.id, self.aq_parent.id |
---|
1047 | if ce: |
---|
1048 | return "%s" % ce.Title |
---|
1049 | return "No such course" |
---|
1050 | |
---|
1051 | security.declareProtected(View,"credits") |
---|
1052 | def credits(self): |
---|
1053 | """credits from course""" |
---|
1054 | ce = self.getCourseEntry(self.id) |
---|
1055 | if ce: |
---|
1056 | return "%s" % ce.credits |
---|
1057 | return "0" |
---|
1058 | |
---|
1059 | security.declareProtected(View,"passmark") |
---|
1060 | def passmark(self): |
---|
1061 | """passmark from course""" |
---|
1062 | ce = self.getCourseEntry(self.id) |
---|
1063 | if ce is not None and hasattr(ce,"passmark"): |
---|
1064 | return ce.passmark |
---|
1065 | |
---|
1066 | |
---|
1067 | security.declareProtected(View,"coursepath") |
---|
1068 | def coursepath(self): |
---|
1069 | """coursepath from course""" |
---|
1070 | ce = self.getCourseEntry(self.id) |
---|
1071 | if ce: |
---|
1072 | return ce.getPath() |
---|
1073 | return "?" |
---|
1074 | |
---|
1075 | |
---|
1076 | InitializeClass(CertificateCourse) |
---|
1077 | |
---|
1078 | def addCertificateCourse(container, id, REQUEST=None, **kw): |
---|
1079 | """Add a CertificateCourse.""" |
---|
1080 | ob = CertificateCourse(id, **kw) |
---|
1081 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
1082 | ###) |
---|
1083 | |
---|
1084 | class Faculty(CPSDocument): ###( |
---|
1085 | """ |
---|
1086 | WAeUP Faculty containing Departments |
---|
1087 | """ |
---|
1088 | meta_type = 'Faculty' |
---|
1089 | portal_type = meta_type |
---|
1090 | security = ClassSecurityInfo() |
---|
1091 | |
---|
1092 | ## def __init__(self, id, **kw): |
---|
1093 | ## CPSDocument.__init__(self, id, **kw) |
---|
1094 | |
---|
1095 | security.declareProtected(View,"Title") |
---|
1096 | def Title(self): |
---|
1097 | """compose title""" |
---|
1098 | return "%s" % (self.title) |
---|
1099 | |
---|
1100 | |
---|
1101 | security.declareProtected(View,"LongTitle") |
---|
1102 | def LongTitle(self): |
---|
1103 | """compose long_title""" |
---|
1104 | prefix = getattr(self,'title_prefix',None) |
---|
1105 | if prefix is None: |
---|
1106 | prefix = getattr(self,'institution_type','faculty') |
---|
1107 | self.getContent().edit(mapping = {'title_prefix': prefix}) |
---|
1108 | itype = self.portal_vocabularies.institution_types_voc.get(prefix,default="Faculty of") |
---|
1109 | return "%s %s" % (itype,self.title) |
---|
1110 | |
---|
1111 | InitializeClass(Faculty) |
---|
1112 | |
---|
1113 | def addFaculty(container, id, REQUEST=None, **kw): |
---|
1114 | """Add a Faculty.""" |
---|
1115 | ob = Faculty(id, **kw) |
---|
1116 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
1117 | |
---|
1118 | ###) |
---|
1119 | |
---|
1120 | class Department(CPSDocument): ###( |
---|
1121 | """ |
---|
1122 | WAeUP Department containing the courses and students |
---|
1123 | """ |
---|
1124 | meta_type = 'Department' |
---|
1125 | portal_type = meta_type |
---|
1126 | security = ClassSecurityInfo() |
---|
1127 | |
---|
1128 | security.declareProtected(View,"LongTitle") |
---|
1129 | def LongTitle(self): |
---|
1130 | """compose long_title""" |
---|
1131 | prefix = getattr(self,'title_prefix',None) |
---|
1132 | if prefix is None: |
---|
1133 | prefix = getattr(self,'institution_type','department') |
---|
1134 | self.getContent().edit(mapping = {'title_prefix': prefix}) |
---|
1135 | itype = self.portal_vocabularies.institution_types_voc.get(prefix,default="Department of") |
---|
1136 | return "%s %s" % (itype,self.title) |
---|
1137 | |
---|
1138 | InitializeClass(Department) |
---|
1139 | |
---|
1140 | def addDepartment(container, id, REQUEST=None, **kw): |
---|
1141 | """Add a Department.""" |
---|
1142 | object = Department(id, **kw) |
---|
1143 | id = object.getId() |
---|
1144 | container._setObject(id, object) |
---|
1145 | ## dep = getattr(container,id).getEditableContent() #getContent() |
---|
1146 | ## dep.invokeFactory('CoursesFolder','Courses') |
---|
1147 | ## o = getattr(dep,'Courses') |
---|
1148 | ## dict = {'Title': 'Courses'} |
---|
1149 | ## o.getContent().edit(mapping=dict) |
---|
1150 | ## dep.invokeFactory('CertificatesFolder','Certificates') |
---|
1151 | ## o = getattr(dep,'Certificates') |
---|
1152 | ## dict = {'Title': 'Certificates'} |
---|
1153 | ## o.geetContent().edit(mapping=dict) |
---|
1154 | if REQUEST is not None: |
---|
1155 | url = container.absolute_url() |
---|
1156 | REQUEST.RESPONSE.redirect('%s/manage_main' % url) |
---|
1157 | |
---|
1158 | ###) |
---|
1159 | |
---|
1160 | class Course(CPSDocument): ###( |
---|
1161 | """ |
---|
1162 | WAeUP Course |
---|
1163 | """ |
---|
1164 | meta_type = 'Course' |
---|
1165 | portal_type = meta_type |
---|
1166 | security = ClassSecurityInfo() |
---|
1167 | |
---|
1168 | security.declareProtected(View,"Title") |
---|
1169 | def Title(self): |
---|
1170 | """compose title""" |
---|
1171 | return self.title |
---|
1172 | |
---|
1173 | InitializeClass(Course) |
---|
1174 | |
---|
1175 | def addCourse(container, id, REQUEST=None, **kw): |
---|
1176 | """Add a Course.""" |
---|
1177 | ob = Course(id, **kw) |
---|
1178 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
1179 | ###) |
---|
1180 | |
---|
1181 | |
---|