def convert_local_person(person: Person) -> GraphUser:
"""Converts a local Django person to a Graph object."""
return GraphUser(
person.get_full_name(),
person.first_name or None, # Optional
person.username,
person.preferred_language or None,
person.last_name or None,
"{}@esmgquadrivium.nl".format(person.username),
extension={"tuttiId": person.id})
def create(self, row):
first_name = row['Nombre'].strip()
last_name = row['Apellido'].strip()
email = row['EMail'].strip()
patron = Patron(
name="{} {}".format(first_name, last_name),
email=email,
comments='Automatically loaded with PyCamp 2018 script',
)
patron.save()
category = Category.objects.get(name=row["Tipo socio"].strip())
member = Member(
category=category,
patron=patron,
has_student_certificate=row['C.Estud'].strip() == "✓",
has_subscription_letter=row['Firmó'].strip() == "✓"
)
member.save()
street_address, city, zip_code, province, country = split_address(row['Domicilio'].strip())
person = Person(
first_name=first_name,
last_name=last_name,
email=email,
document_number=row['DNI'].strip(),
nickname=row['Nick'].strip(),
nationality=row['Nacionalidad'].strip(),
marital_status=row['Estado Civil'].strip(),
occupation=row['Profesión'].strip(),
birth_date=get_date(row['Fecha Nacimiento'].strip()),
street_address=street_address,
city=city,
zip_code=zip_code,
province=province,
country=country,
membership=member,
comments='Automatically loaded with PyCamp 2018 script',
)
person.save()
return member
def handle(self, *args, **options):
if(len(args) != 1):
self.stdout.write('Invalid number of arguments')
exit()
try:
csvfile = open(args[0], 'r', encoding='utf-8')
except:
self.stdout.write('Unable to open file: ' + args[0])
exit()
dialect = csv.Sniffer().sniff(csvfile.read(1024))
csvfile.seek(0)
entries = csv.reader(csvfile, dialect)
columns = len(next(entries))
csvfile.seek(0)
entries = csv.reader(csvfile, dialect)
if(options['first_row_is_label']):
labels = next(entries)
else:
# make list of empty labels
labels = []
for col in range(columns):
if(col == options['date_column']):
labels.append('Opskrivnings dato')
elif (col == options['email_column']):
labels.append('e-mail')
elif (col == options['name_column']):
labels.append('Navn')
else:
labels.append('')
datetimeobject = datetime.datetime.today()
for entry in entries:
email = entry[options['email_column']].lower()
name = entry[options['name_column']].title().strip()
if(options['date_format'] == 0):
date_format = '%m/%d/%Y %H:%M:%S %z' # '3/20/2014 19:51:32'
date = datetimeobject.strptime(entry[options['date_column']].lstrip() + " +0001", date_format)
if(options['date_format'] == 1):
date_format = '%d. %m %Y, %H:%M %z' # '12. december 2014, 17:58'
months = [
('januar' , '1'),
('februar' , '2'),
('marts' , '3'),
('april' , '4'),
('maj' , '5'),
('juni' , '6'),
('juli' , '7'),
('august' , '8'),
('september' , '9'),
('oktober' , '10'),
('november' , '11'),
('december' , '12'),]
date_string = entry[options['date_column']].lstrip()
for month_name, month_number in months:
date_string = date_string.replace(month_name, month_number)
date = datetimeobject.strptime(date_string + " +0001", date_format)
# find or create the family
family, created = Family.objects.get_or_create(email = email)
#lookup person
try:
person = Person.objects.get(name=name, family=family)
# if current waiting list is older, replace timestamp
if(date < person.added):
person.added = date
person.save()
except ObjectDoesNotExist:
# create the person
person = Person(name=name, membertype=Person.CHILD, family = family, added = date)
person.save()
except Person.MultipleObjectsReturned:
print("family " + family.email + " has duplicate mebers named " + name + " - signup date : " + str(date) + " not recorded")
def handle(self, *args, **options):
if (len(args) != 1):
self.stdout.write('Invalid number of arguments')
exit()
try:
csvfile = open(args[0], 'r', encoding='utf-8')
except:
self.stdout.write('Unable to open file: ' + args[0])
exit()
dialect = csv.Sniffer().sniff(csvfile.read(1024))
csvfile.seek(0)
entries = csv.reader(csvfile, dialect)
columns = len(next(entries))
csvfile.seek(0)
entries = csv.reader(csvfile, dialect)
if (options['first_row_is_label']):
labels = next(entries)
else:
# make list of empty labels
labels = []
for col in range(columns):
if (col == options['date_column']):
labels.append('Opskrivnings dato')
elif (col == options['email_column']):
labels.append('e-mail')
elif (col == options['name_column']):
labels.append('Navn')
else:
labels.append('')
datetimeobject = datetime.datetime.today()
for entry in entries:
email = entry[options['email_column']].lower()
name = entry[options['name_column']].title().strip()
if (options['date_format'] == 0):
date_format = '%m/%d/%Y %H:%M:%S %z' # '3/20/2014 19:51:32'
date = datetimeobject.strptime(
entry[options['date_column']].lstrip() + " +0001",
date_format)
if (options['date_format'] == 1):
date_format = '%d. %m %Y, %H:%M %z' # '12. december 2014, 17:58'
months = [
('januar', '1'),
('februar', '2'),
('marts', '3'),
('april', '4'),
('maj', '5'),
('juni', '6'),
('juli', '7'),
('august', '8'),
('september', '9'),
('oktober', '10'),
('november', '11'),
('december', '12'),
]
date_string = entry[options['date_column']].lstrip()
for month_name, month_number in months:
date_string = date_string.replace(month_name, month_number)
date = datetimeobject.strptime(date_string + " +0001",
date_format)
# find or create the family
family, created = Family.objects.get_or_create(email=email)
#lookup person
try:
person = Person.objects.get(name=name, family=family)
# if current waiting list is older, replace timestamp
if (date < person.added):
person.added = date
person.save()
except ObjectDoesNotExist:
# create the person
person = Person(name=name,
membertype=Person.CHILD,
family=family,
added=date)
person.save()
except Person.MultipleObjectsReturned:
print("family " + family.email +
" has duplicate mebers named " + name +
" - signup date : " + str(date) + " not recorded")
def PersonCreate(request, unique, membertype):
family = get_object_or_404(Family, unique=unique)
if request.method == 'POST':
person = Person()
person.membertype = membertype
person.family = family
form = PersonForm(request.POST, instance=person)
if form.is_valid():
UpdatePersonFromForm(person,form)
return HttpResponseRedirect(reverse('family_detail', args=[family.unique]))
else:
person = Person()
person.membertype = membertype
if family.person_set.count() > 0 :
first_person = family.person_set.first()
person.family = family
person.zipcode = first_person.zipcode
person.city = first_person.city
person.streetname = first_person.streetname
person.housenumber = first_person.housenumber
person.floor = first_person.floor
person.door = first_person.door
person.placename = first_person.placename
person.dawa_id = first_person.dawa_id
form = PersonForm(instance=person)
return render(request, 'members/person_create_or_update.html', {'form': form, 'person' : person, 'family': family, 'membertype': membertype})
def PersonCreate(request, unique, membertype):
family = get_object_or_404(Family, unique=unique)
if request.method == 'POST':
person = Person()
person.membertype = membertype
person.family = family
form = PersonForm(request.POST, instance=person)
if form.is_valid():
UpdatePersonFromForm(person,form)
return HttpResponseRedirect(reverse('family_detail', args=[family.unique]))
else:
person = Person()
person.membertype = membertype
if family.person_set.count() > 0 :
first_person = family.person_set.first()
person.family = family
person.zipcode = first_person.zipcode
person.city = first_person.city
person.streetname = first_person.streetname
person.housenumber = first_person.housenumber
person.floor = first_person.floor
person.door = first_person.door
person.placename = first_person.placename
person.dawa_id = first_person.dawa_id
form = PersonForm(instance=person)
return render(request, 'members/person_create_or_update.html', {'form': form, 'person' : person, 'family': family, 'membertype': membertype})
