for line in input_file: try: if re.search('^#', line): # next continue data = [d.strip() for d in line.split(';')] #print data lat = data[DATA['LAT']] if data[DATA['LAT']] != '-' else "0" lng = data[DATA['LNG']] if data[DATA['LNG']] != '-' else "0" lat = re.sub(',', '.', lat) lng = re.sub(',', '.', lng) name = smart_unicode(data[DATA['NAME']]) city = City(name=name, slug=str_slugify(name), zipcode=int(data[DATA['ZIPCODE']]), point=GEOSGeometry('POINT( %s %s )' % (lng, lat), srid=SRID_DEFAULT), insee_code=int(data[DATA['INSEECODE']]), population=0) print city, city.slug city.save() except Exception, e: print "!!!!!!!!!!!!!!!!!!!!!", line, e finally: input_file.close() print "OK\n"
try: if re.search("^#", line): # next continue data = [d.strip() for d in line.split(";")] # print data lat = data[DATA["LAT"]] if data[DATA["LAT"]] != "-" else "0" lng = data[DATA["LNG"]] if data[DATA["LNG"]] != "-" else "0" lat = re.sub(",", ".", lat) lng = re.sub(",", ".", lng) name = smart_unicode(data[DATA["NAME"]]) city = City( name=name, slug=str_slugify(name), zipcode=int(data[DATA["ZIPCODE"]]), point=GEOSGeometry("POINT( %s %s )" % (lng, lat), srid=SRID_DEFAULT), insee_code=int(data[DATA["INSEECODE"]]), population=0, ) print city, city.slug city.save() except Exception, e: print "!!!!!!!!!!!!!!!!!!!!!", line, e finally: input_file.close() print "OK\n"