From 5d48c9d1a42ff2021beb556c25496fe8496b4c2c Mon Sep 17 00:00:00 2001 From: Guillaume Pellerin Date: Tue, 16 Mar 2021 22:03:36 +0100 Subject: [PATCH] add command --- .../teleforma-import-students-from-xls.py | 23 +++++++++++++++++++ teleforma/views/crfpa.py | 3 +++ 2 files changed, 26 insertions(+) create mode 100644 teleforma/management/commands/teleforma-import-students-from-xls.py diff --git a/teleforma/management/commands/teleforma-import-students-from-xls.py b/teleforma/management/commands/teleforma-import-students-from-xls.py new file mode 100644 index 00000000..30e1d7f5 --- /dev/null +++ b/teleforma/management/commands/teleforma-import-students-from-xls.py @@ -0,0 +1,23 @@ +from optparse import make_option +from django.conf import settings +from django.core.management.base import BaseCommand, CommandError +from django.contrib.auth.models import User +from django.template.defaultfilters import slugify +from telemeta.util.unaccent import unaccent +from teleforma.views import * +import logging +import json + + +class Command(BaseCommand): + help = "Import Students from XLS file" + args = "path" + admin_email = 'webmaster@parisson.com' + + def handle(self, *args, **options): + file = args[0] + xls = UserXLSBook() + xls.read(file) + + + diff --git a/teleforma/views/crfpa.py b/teleforma/views/crfpa.py index 30025976..4a221c2f 100644 --- a/teleforma/views/crfpa.py +++ b/teleforma/views/crfpa.py @@ -51,6 +51,9 @@ from django.forms.formsets import all_valid from django.core.exceptions import ValidationError from django.contrib.sites.models import Site +import xlrd + + ORAL_OPTION_PRICE = 250 def get_course_code(obj): -- 2.39.5