From 240c7eff100cbcfa5e4d777fe4f823a777b7d4a4 Mon Sep 17 00:00:00 2001 From: Rad Date: Thu, 28 Feb 2019 18:07:50 +0000 Subject: survex parser added --- parsers/peopleM.py | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 parsers/peopleM.py (limited to 'parsers/peopleM.py') diff --git a/parsers/peopleM.py b/parsers/peopleM.py new file mode 100644 index 0000000..62c7ce0 --- /dev/null +++ b/parsers/peopleM.py @@ -0,0 +1,27 @@ +from django.conf import settings +import troggle.core.models as models + +def load(): + folkfile = open(settings.EXPOWEB+"noinfo/folk.csv") + personlines = folkfile.read().splitlines() + persontable = [x.split(',') for x in personlines] + years = [persontable[0][i] for i in range(5,len(persontable[0]))] + for year in years: + newexpedition = models.ExpeditionM( date = year ) + newexpedition.save() + for row in persontable[1:]: #skip header + attendedid = [i for i, x in enumerate(row) if '1' in x] + attendedyears = [persontable[0][i] for i in attendedid if i >= 5] + name = row[0] + print(name+' has attended: '+', '.join(attendedyears)) + newperson = models.PersonM( + name = name) + newperson.save() + for year in attendedyears: + target = models.ExpeditionM.objects.get(date=year) + newperson.expos_attended.add( target ) + print('Person -> Expo table created!') + + + + -- cgit v1.2.3