import os import sys import csv import datetime os.environ['DJANGO_SETTINGS_MODULE'] = 'clubmanager.settings' os.environ.setdefault("DJANGO_SETTINGS_MODULE", "clubmanager.settings") from manager.models import Aircraft, Organisation reader = csv.DictReader(open('powered.csv'), delimiter = ',') reader.fieldnames = [field.strip().lower() for field in reader.fieldnames] organisation = Organisation.objects.filter(name='Aeroklub Celje')[0] for aircraft in reader: a = Aircraft() a.type = 'powered' a.make = 'Neznan' a.model = unicode(aircraft['tip'].strip(), 'utf-8') a.serial_number = 'Neznana' a.registration = unicode(aircraft['oznaka'].strip(), 'utf-8') a.competition_number = unicode(aircraft['kratica'].strip().upper(), 'utf-8') a.external_id = aircraft['num'].strip() a.ownership = 'club' a.organisation = organisation a.save() print u'Imported powered aircraft %s %s' % (a.model, a.registration)
import os import sys import csv import datetime os.environ['DJANGO_SETTINGS_MODULE'] = 'clubmanager.settings' os.environ.setdefault("DJANGO_SETTINGS_MODULE", "clubmanager.settings") from manager.models import Aircraft, Organisation reader = csv.DictReader(open('sailplanes.csv'), delimiter = ',') reader.fieldnames = [field.strip().lower() for field in reader.fieldnames] organisation = Organisation.objects.filter(name='Aeroklub Celje')[0] for aircraft in reader: a = Aircraft() a.type = 'sailplane' a.make = 'Neznan' a.model = unicode(aircraft['tip'].strip(), 'utf-8') a.serial_number = 'Neznana' a.registration = unicode(aircraft['oznaka'].strip(), 'utf-8') a.competition_number = unicode(aircraft['kratica'].strip().upper(), 'utf-8') a.external_id = aircraft['num'].strip() a.ownership = 'club' a.organisation = organisation a.save() print u'Imported sailplane %s %s' % (a.model, a.registration)