def import_course(filename): with open(filename, 'rt', encoding='utf-8') as csvfile: reader = csv.reader(csvfile, delimiter=',') course_list = list(reader) for i in course_list[1:]: try: c = Course(code=i[0], title=i[1], topic=i[2], type=i[3], opening=i[4], duration=i[5], venue=i[6], fee=i[7], grant=i[8], wsa=i[9], remark=i[10], overview=i[11], outline=i[12], testimonial=i[13], upcoming=i[14], hyperlink=i[15]) c.save() print('Added: {}'.format(i[0])) except IntegrityError as e: if 'UNIQUE constraint failed: core_course.code' in e.args: c = Course.objects.get(code=i[0]) c.title = i[1] c.topic = i[2] c.type = i[3] c.opening = i[4] c.duration = i[5] c.venue = i[6] c.fee = i[7] c.grant = i[8] c.wsa = i[9] c.remark = i[10] c.overview = i[11] c.outline = i[12] c.testimonial = i[13] c.upcoming = i[14] c.hyperlink = i[15] c.save() print('Updated: {}'.format(i[0]))