I'm want to create an app to show the locations of over 400 restaurants that participate in a diners club. Because there are so many locations, I'm wondering if there is/will be a way to upload all locations from a spreadsheet.

Subscribe

In my two seconds of research on Google, I think you could do this with PHP. However, it would require you to be able to make a call to a server that's running PHP in order to make it happen, I think. http://code.google.com/p/php-excel-reader/ The other way would be to create a mySQL database and query the locations that way. Either way, the basic here is to extract the data you want and create a JSON file that you feed to the app. Mark

In a test I was just able to add over 1000 locations to a location map, but via a different method. I have a members map on our online forum where members can add themselves. It is only accessible by members. Anyhow, this map feature also provides a download link of the current data in a .kml file that you can open with Google Earth. Well, low and behold, if you upload that file to an accessible webserver, and then take the address of the file to google maps and put it in the search, it will open up all of your locations on a google map. At that point, google maps creates a URL link, or an embed link that you can use. You can also choose the option to have it create a short link for you. Once you do that, you have the ability to take the link and use it in your app. I've tried it with custom url, as well as the customhtml on 1.4 as well as 1.5 and it works good! I think you can create a .kml file using google earth that you can save and use, so, putting those 400 restaurants in a file and into the app should be a snap. ;o)

Nice! If you get the chance, and wouldn't mind documenting how you did that, could you write something up? Step-by-steps are much appreciated here on the forum! Mark

Sure, tomorrow I'll try and make a video tutorial starting with google earth, and the process to get it on to your app.

jeffb: that is very cool, looking forward to seeing more...

Here is a short awkward video I put together this morning as promised showing how to easily add a multiple location google map to your app. I used the app I have on 1.4 for the demo. Hope this is of some use. ;o) http://www.youtube.com/watch?v=1g8nuXChUjs

@jeffb Awesome! Thank you very much! That is exactly what I was looking for.

I just found this website: http://batchgeo.com/. It will create a multiple location map if you have all the locations in a Tab-delimited spreadsheet. From there you can get the custom URL to the map and use that in BuzzTouch app editor.

Is it possible to link to a screen on the android app when clicking on a location? When using the short URL the page doesn't stop loading. With the long URL it's OK? Any suggestion.

@MEJohnsonJr I have tested Batchgeo and it works well except for a couple of problems. I used Batchgeo map as Custom HTML in BT and it works fine. Have You had the opportunity to test Butchgeo in Buzztouch and what is your experience on this?

@Lars1 I have not had a chance to test Batchgeo in Buzztouch yet, but I plan to late next week. I'll let you know how things work out.