def process_brazil(self,xml_path,country):
soup = BeautifulSoup(codecs.open(xml_path,'r',encoding='mac_roman'))
rows = soup.findAll('tr')
for row in rows:
a = row.contents[3]
td = row.contents[5]
code = td.contents[0]
name = a.find('a').contents[0]
print 'saving %s for country %s' % (name,country.name)
province = Province()
province.country_code = country
province.code = code
province.province = name
province.entity_active = True
province.created_dt = dt
province.updated_dt = dt
province.save()
def handle(self,excel_path,country_code,**options): usage = 'python manage.py provinces <excel-path> <country-code>' if not country_code: raise CommandError(usage) country = Country.objects.get(code=country_code) if country_code == 'BR': self.process_brazil(excel_path,country) return provinces = UnicodeReader(open(excel_path,"rU"),encoding='cp860') for p in provinces: print 'saving province %s for country %s' % (p[0],country.name) province = Province() province.country_code = country province.code = p[1] province.province = p[0] province.entity_active = True province.created_dt = dt province.updated_dt = dt province.save()
