makecopies.py
View Options

			import csv
			import os

			# HOWTO: get students names from ISA (Exam tab) as Excel file
			# export names + SCIPER from Excel as CSV
			# Convert CSV to UTF8 format using Notepad++
			# run this tool

			with open('final.tex', 'r') as exam_text:
			exam = exam_text.read()

			with open('students.csv', 'r') as csvfile:
			r = csv.reader(csvfile, delimiter=',', quotechar='"')
			count = 0
			for row in r:
			count += 1
			try:
			name = row[0]
			sciper = row[1]
			except:
			print("error for row %d (%s)" % (count, row))
			exit

			print("compiling for %s" % name)
			e = exam.replace("STUDENT-NAME", name)
			e = e.replace("SCIPER", sciper)
			with open('pf.tex', 'w') as exam_text:
			exam_text.write(e)
			os.system("latex.exe pf.tex")
			os.system("dvips.exe pf.dvi")
			os.system("ps2pdf.exe pf.ps pf%d.pdf" % count)

R2653/teaching/COM303/2019/exams/makecopies.py02f25ba49010master