def bulk_upload_activities(request):
path = 'bulk_upload/activities.csv'
with open(path, encoding="latin-1") as f:
reader = csv.reader(f)
for row in reader:
activity = Activity()
activity.name = row[0]
activity.activity_type = row[1]
activity.term = row[2]
activity.location = row[3]
activity.suburb = row[4]
activity.postcode = row[5]
activity.organiser = row[6]
activity.contact_number = row[7]
activity.description = row[8]
activity.activity_date = row[9]
activity.start_date = row[10]
activity.end_date = row[11]
activity.start_time = row[13]
activity.end_time = row[14]
activity.created_by = User.objects.get(username=row[15])
# Image Upload
if row[16] != '':
file_dir = 'bulk_upload/images/' + row[16]
image = open(file_dir, 'rb')
image_file = File(image)
activity.activity_img.save(row[16], image_file)
# Flyer Upload
if row[17] != '':
file_dir = 'bulk_upload/flyers/' + row[17]
flyer = open(file_dir, 'rb')
flyer_file = File(flyer)
activity.flyer.save(row[17], flyer_file)
activity.min_age = row[18]
activity.max_age = row[19]
activity.background = row[20]
activity.living_duration = row[21]
activity.gender = row[22]
if row[23] != '':
activity.cost = row[23]
if row[24] != '':
activity.space = row[24]
activity.cost_choice = row[25]
activity.space_choice = row[26]
activity.save()
f.close()
return HttpResponse("Success uploading activities.")
def createActivity(self):
activity = Activity()
activity.name = 'test from function'
activity.user = User.objects.get_by_natural_key('testingUser')
activity.save()
return activity
