-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathimportations.example.py
executable file
·157 lines (133 loc) · 6.87 KB
/
importations.example.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
from datetime import datetime
from django.contrib.auth.models import User
from django.forms.models import model_to_dict
import django_data_import as importer
from coms.core.consumer import *
from your_django_app.models import Address
from your_django_app.models import UserProfile
from your_django_app.models import PhoneType
from your_django_app.models import Relationship
from your_django_app.dummy import models as dummymodels
blank_date = datetime(2007,1,20,01,01,01) # It is very important to use a static date to fill in gaps
old_date = datetime(1900,11,20,01,01,01) # Dynamic dates will create duplicate records since get_or_create will always 'create'
class UserImport(importer.Import):
username = importer.Field('username')
email = importer.Field('email')
first_name = importer.Field('firstname')
last_name = importer.Field('lastname')
is_active = importer.Field('emptype')
password = importer.Field(None,value='tmp')
is_staff = importer.Field(None,value=False)
is_superuser = importer.Field(None,value=False)
last_login = importer.Field(None,value=blank_date)
date_joined = importer.Field(None,value=blank_date)
def clean_email(self,slave_record,cleaned_data):
return '%s%s@old_site.com' % (slave_record.firstname.lower(),slave_record.lastname.lower())
def clean_username(self,slave_record,cleaned_data):
return slave_record.username.lower()
def clean_is_active(self,slave_record,cleaned_data):
if slave_record.emptype != "UNEMP":
return True
return False
class Meta:
master = User
slave = dummymodels.OldUsers.objects.all()
class UserProfileImport(importer.Import):
user = importer.Field('username',uses_import=UserImport,verify_by=('username',))
title = importer.Field('title')
location = importer.Field('office')
supervisor = importer.Field('supervisorid',uses_import=UserImport)
exempt = importer.Field(None,value=False)
annual_pto = importer.Field(None,value=0)
def clean_supervisor(self,slave_record,cleaned_data):
if User.objects.filter(username=slave_record.username.lower()).count():
return User.objects.get(username=slave_record.username.lower())
return User.objects.get(username='dmoore')
def clean_user(self,slave_record,cleaned_data):
return User.objects.get(username=slave_record.username.lower)
class Meta:
master = UserProfile
slave = dummymodels.OldUsers.objects.all()
class AddressImport(importer.Import):
line_1 = importer.Field('address1',if_null='Unknown')
line_2 = importer.Field('address2')
city = importer.Field('city',if_null='Unknown')
state = importer.Field('state',if_null='FL',max_length=2)
zip = importer.Field('zip',if_null='00000')
mail_opt_out = importer.Field('mailoptout',if_null=False)
newsletter = importer.Field('mailinglist',if_null=False)
phone_primary = importer.Field('phoneprimary',if_null='000-000-0000',max_length=20)
phone_primary_type = importer.Field('phoneprimarytype')
phone_secondary = importer.Field('phonesecondary',max_length=20)
phone_secondary_type = importer.Field('phonesecondarytype')
email = importer.Field('email')
preferred = importer.Field('preferred')
bad_address = importer.Field(None,if_null=False)
def clean_line_2(self,slave_record,cleaned_data):
if 'line_2' in cleaned_data and cleaned_data['line_2'] == 'None':
return None
return cleaned_data['line_2']
class CustomerImport(importer.Import):
staff = importer.Field('addedby',uses_import=UserImport,verify_by=('username',))
date_added = importer.Field('timestamp',if_null=old_date)
file = importer.Field('consumerid')
first_name = importer.Field('firstname',if_null='Unknown')
last_name = importer.Field('lastname',if_null='Unknown')
address = importer.Field('addressid',uses_import=CAddressImport)
middle_initial = importer.Field('mi')
birth_date = importer.Field('birthdate',if_null=blank_date)
entry_date = importer.Field('entrydate',if_null=blank_date)
closure_date = importer.Field('closuredate')
ssn = importer.Field('ssn',if_null='0000')
status = importer.Field('status')
waive_ilp = importer.Field('createilp',if_null=False)
emergency_contact_primary = importer.Field(None,uses_import=EmergencyContactPrimaryImport)
emergency_contact_secondary = importer.Field(None,uses_import=EmergencyContactSecondaryImport)
disability_primary = importer.Field('disabprimary')
disability_secondary = importer.Field('disabsecondary')
language_primary = importer.Field('langprimary')
language_secondary = importer.Field('langsecondary')
ethnicity = importer.Field('ethnicity')
race = importer.Field('race')
gender = importer.Field('gender')
employment_status = importer.Field('empstatus')
household_type = importer.Field('householdtype')
household_annual_income = importer.Field('householdannual')
crime_victim = importer.Field('crimevictim',if_null=False)
is_veteran = importer.Field('isvet',if_null=False)
def clean_staff(self,slave_record,cleaned_data):
if OldUsers.objects.filter(id=slave_record.addedby).count():
return User.objects.get(username=OldUsers.objects.get(id=slave_record.addedby).username.lower())
return User.objects.get(username='coms')
def post_save(self,slave_record,master_record):
if slave_record.householdtype == 'Female head of household':
CustomerTag.objects.get_or_create(consumer=master_record,type=Tag.objects.get_or_create(name="Female head of household")[0])
class Meta:
master = Customer
slave = dummymodels.OldCustomers.objects.all()
class CustomerContactImport(importer.Import):
date = importer.Field('contactdate',if_null=old_date)
notes = importer.Field('comments',if_null='')
consumer = importer.Field('consumerid',uses_import=CustomerImport,verify_by=('file','consumerid'))
program = importer.Field('program')
hours = importer.Field('hours',if_null=0)
staff = importer.Field('addedby',uses_import=UserImport,verify_by=('username',))
group = importer.Field('groupname')
date_added = importer.Field('timestamp')
def clean_staff(self,slave_record,cleaned_data):
if not cleaned_data['staff'] or not OldUsers.objects.filter(pk=slave_record.addedby).count():
return User.objects.get(username='DefaultUser')
return cleaned_data['staff']
def clean(self,slave_record,cleaned_data):
consumer = Customer.objects.get(file=OldCustomers.objects.get(id=slave_record.consumerid).consumerid)
cleaned_data['consumer'] = consumer
return cleaned_data
def post_save(self,slave,master):
if master.group:
for i in CustomerGroups.objects.filter(consumerid=slave.consumerid,group=slave.groupname):
master.group.consumers.add(master.consumer)
master.service.group = master.group
master.service.save()
class Meta:
master = Contact
slave = dummymodels.CustomerContacts.objects.all()