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()