Thanks Ikai, but the problem is to obtain the city and the country from the coordinates.
Max 2011/4/7 Ikai Lan (Google) <[email protected]> > Python has a CSV reader that does things like escape characters: > > http://docs.python.org/library/csv.html > > > Ikai Lan > Developer Programs Engineer, Google App Engine > Blog: http://googleappengine.blogspot.com > Twitter: http://twitter.com/app_engine > Reddit: http://www.reddit.com/r/appengine > > > > On Thu, Apr 7, 2011 at 9:58 AM, Phil Young <[email protected]> wrote: > >> I think he's already got the data he want, just needs to extract the >> individual fields from the CSV data. >> >> The split function will be a simple way to achieve this. >> e.g. >> >> strArray = strInputLine.split(',') >> strPlace = strArray[0] >> strXcoord = strArray[1] >> >> etc. >> >> HTH >> >> Phil >> >> On 6 April 2011 18:13, Barry Hunter <[email protected]> wrote: >> >>> You need to use a geocoder (well technically a reverse geocoder). That >>> will most probably be connecting to an external webservice, such as >>> geonames, or the one in the Google Maps API. >>> >>> (note if you use the Google Maps API one, you must use teh data to shown >>> a Google Map on your site) >>> >>> It could be a geocoder you have locally in your application, I dont know >>> any coded in python off hand, but you would also need to source the data to >>> power it. >>> >>> >>> >>> >>> On 6 April 2011 15:51, Massimiliano <[email protected]>wrote: >>> >>>> I'm not afraid how to import the CSV. I don't know how to manage the >>>> data to obtain the city and country with the coordinates! >>>> >>>> >>>> 2011/4/6 JH <[email protected]> >>>> >>>>> Max, >>>>> >>>>> There is a nice python library called xlwt, I'm sure you can find it >>>>> via Google. It lets you read and write Microsoft Excel files. >>>>> >>>>> Cheers >>>>> >>>>> On Apr 6, 9:07 am, Massimiliano <[email protected]> >>>>> wrote: >>>>> > Hi, >>>>> > can someone help me? A big problem for me, I hope easy for you. I >>>>> have a >>>>> > file xls (I can convert it in CSV) like this: >>>>> > >>>>> > Place Coordinates >>>>> > Place1 1,2 >>>>> > Place2 3,4 >>>>> > Place3 5,6 >>>>> > Place4 7,8 >>>>> > and so on... >>>>> > >>>>> > and I want to store it in appengine like this: >>>>> > >>>>> > Place Country City Coordinates >>>>> > ....... >>>>> > >>>>> > How can I do it? Can someone share a python code to do this? >>>>> > >>>>> > Thanks >>>>> > >>>>> > Max >>>>> > >>>>> > --www.themaxbuddies.com >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Google App Engine" group. >>>>> To post to this group, send email to [email protected] >>>>> . >>>>> To unsubscribe from this group, send email to >>>>> [email protected]. >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/google-appengine?hl=en. >>>>> >>>>> >>>> >>>> >>>> -- >>>> www.themaxbuddies.com >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Google App Engine" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/google-appengine?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Google App Engine" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/google-appengine?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/google-appengine?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- www.themaxbuddies.com -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
