Discussion Forums  >  Maps, Device Location, Tracking

Replies: 25    Views: 242

Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
04/25/12 04:08 PM (13 years ago)

CSV to JSON Tool now available for map data generation from spreadsheet

Hello Fellow BT-ers! After seeing many requests for a simple solution to convert a spreadsheet to a map data file, I decided to create one from scratch. With this tool you can take a simple spreadsheet, export it to a CSV file, and create a mad data file that can be included in your build, or hosted remotely. If you have projects with a lot of map points, this can potentially save you a ton of time. I'm offering it as "donationware", meaning if you think it will work for you, pay what you think is fair. If you don't think you can pay for it, just PM me and explain your concerns. I'm a fair person, and I'm not trying to leech off my fellow developers. Just trying to account for my time spent away from app creation (my real passion). You can read all about the tool, and see screenshots at the following address: http://idevdepot.com/?p=121 Let me know what you think. If you find any bugs, let me know and I'll work them out as soon as possible. Thanks for looking! Hope it helps some folks around here! -Stobe
 
GoNorthWest
buzztouch Evangelist
Profile
Posts: 8197
Reg: Jun 24, 2011
Oro Valley, AZ
1,000,000
like
04/25/12 04:34 PM (13 years ago)
Wow! That looks amazing, incredibly useful, and just plain cool! I know there are a number of people in the forum who will jump all over this. Thanks for taking the time to create it...I see myself using it in the very near future! Way to go, @Stobe! Mark
 
Fred@mySkylla com
Android Fan
Profile
Posts: 5259
Reg: Oct 03, 2011
location unknow...
62,560
like
04/25/12 04:37 PM (13 years ago)
Nice tool. Question, are you using a public folder for the file in Dropbox? Fred
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 04:39 PM (13 years ago)
The map file? Or the program itself?
 
Fred@mySkylla com
Android Fan
Profile
Posts: 5259
Reg: Oct 03, 2011
location unknow...
62,560
like
04/25/12 04:40 PM (13 years ago)
The map file
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 04:42 PM (13 years ago)
I have used several methods. Public dropbox, copy/paste into BT_Config, and remote host on a webserver.
 
Fred@mySkylla com
Android Fan
Profile
Posts: 5259
Reg: Oct 03, 2011
location unknow...
62,560
like
04/25/12 04:58 PM (13 years ago)
Thanks, I was primarly interested in Dropbox thought you were using a non-public folder. Thanks for the info. I'll post a link to your tool in my Buzztouch & Google maps guide. Fred
 
David @ buzztouch
buzztouch Evangelist
Profile
Posts: 6866
Reg: Jan 01, 2010
Monterey, CA
78,840
like
04/25/12 05:00 PM (13 years ago)
Applause!!!!
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 05:20 PM (13 years ago)
David's Applause makes it all worth while!
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 05:23 PM (13 years ago)
Also for anyone willing to try this tool, I've had success creating CSV files (without spreadsheet program) with zeemaps.com You have to signup for a free account, then you can export any map you create in CSV format. I used the address field (after creating the map markers, click on the title to see the address field) to save my "subtitle" entries. With a few seconds of column manipulation in excel, the file was ready for my tool.
 
Moto110
Aspiring developer
Profile
Posts: 205
Reg: Jul 26, 2011
Orlando, FL
8,700
like
04/25/12 06:07 PM (13 years ago)
This utility looks very interesting. Is there anyway to set the pin color on the map using this utility? I have an app with a lot of map locations and I used a green pin where you should start and a red pin where you stop.
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 06:12 PM (13 years ago)
I can add that in the next revision. I left it out initially since BT only has 3 preset colors, and wasn't sure how many people used them. I can add a 5th column that if present will add the needed JSON for the pin color. Of course, lifetime updates will be available to anyone who "purchases" the tool.
 
Moto110
Aspiring developer
Profile
Posts: 205
Reg: Jul 26, 2011
Orlando, FL
8,700
like
04/25/12 06:32 PM (13 years ago)
Maybe this utility could help with this SORRY if it is off topic, but do you know if there is a way using map data to "draw" a line between to points and have it follow the roads? Kind of like what you get when selecting driving directions except that the path on the map is always visible.
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 06:36 PM (13 years ago)
Sorry, I have no idea about that.
 
hacerapps
buzztouch Evangelist
Profile
Posts: 542
Reg: Jan 30, 2011
usa
11,170
like
04/25/12 07:06 PM (13 years ago)
wow that is so cool this is only for windows?
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/25/12 07:08 PM (13 years ago)
Yes, but I tested it in Parallels and it works fine. If you don't have windows, you can send me the CSV and I'll send you back the config.
 
hacerapps
buzztouch Evangelist
Profile
Posts: 542
Reg: Jan 30, 2011
usa
11,170
like
04/25/12 07:17 PM (13 years ago)
ok
 
Kristian_N
Code is Art
Profile
Posts: 91
Reg: Oct 27, 2011
Copenhagen
2,610
like
04/26/12 05:20 AM (13 years ago)
Excellent work, Stobe! Just what I needed! THANKS! A couple of questions though: 1. How do one get the program? I'd be pleased to donate for your effort! Will you send it to those who donate? 2. Is it possible to add a field for a URL ? I could use that option to allow the user to tap on a location point and be directed to a website for more info. GREAT WORK! Kind regards, Kristian, Copenhagen, Denmark
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/26/12 05:50 AM (13 years ago)
http://idevdepot.com/?p=121 At the bottom of the above page is a donation link. You get a download URL after donation. As far as adding URLs, I believe that would require the itemID from your BuzzTouch project (that's associated with your custom URL). If someone can correct me on this, and if someone knows a way to add a direct URL to the JSON, then I can certainly add it in.
 
mysps
Code is Art
Profile
Posts: 2082
Reg: May 14, 2011
Palma
33,320
like
04/26/12 10:37 AM (13 years ago)
@stobe & kristian_n try adding another field with another nested json: "loadScreenObject": { "itemNickname": "Your Nickname", "itemId": "93203", "itemType": "BT_screen_webView", "navBarTitleText": "My Bar Title", "listRowSeparatorColor": "#000000", "listDescriptionFontColor": "#777777", "dataURL": "http://www.mydomain.com" }
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/26/12 10:52 AM (13 years ago)
hmmmm.... interesting. I suppose with another 6 variables (columns) in a spreadsheet could fully feed that information to my program. We could probably "spoof" the nickname, and autogenerate the itemID as before. And I'm not sure if we'd need the two colors defined? So I could probably generate the code needed from just a URL and navBarTitle. Might have to test this out to see if the nesting works. Thanks mysps
 
mysps
Code is Art
Profile
Posts: 2082
Reg: May 14, 2011
Palma
33,320
like
04/26/12 11:14 AM (13 years ago)
sorry.. that was my project lol.. no colors necessary, however i needed it :) good luck with it
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/26/12 12:30 PM (13 years ago)
Just tested it, and it works great! I found a couple of small bugs in my first build, so I'm fixing those and I'll have this new option in today! The tool will now have a page for creating configs without any URLs (with the driving direction option), and a page for creating configs with URLs (with no driving directions, since you can only have one or the other). Thanks again!
 
mysps
Code is Art
Profile
Posts: 2082
Reg: May 14, 2011
Palma
33,320
like
04/26/12 12:38 PM (13 years ago)
Awesome!! btw, I'm located south of Richmond, VA :) however, at the moment in located in Spain. also, why limit your project? you can do more than maps i think right?! i'll be grabbing your tool soon! great work
 
David @ buzztouch
buzztouch Evangelist
Profile
Posts: 6866
Reg: Jan 01, 2010
Monterey, CA
78,840
like
04/26/12 12:40 PM (13 years ago)
@Stobe: We'll get a link to this added to the How To's screen. If you object to this, let us know and we'll remove it. I'm thinking it's OK to publicize your very cool tool ;-) It won't be too long before our control panels allow us to list plugins we've worked out so we can all begin sharing screen creations. Stoked for this because it should help us all create more compelling apps with less effort.
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/26/12 12:55 PM (13 years ago)
@David : By all means, list it anywhere you want :) @mysps: I've got another tool on the way! Similar concept, but completely different type of screen. Should help a lot of people.
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.