Discussion Forums  >  Maps, Device Location, Tracking

Replies: 19    Views: 145

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

CSV to JSON Tool updated with URL support

As requested by some of the members here, I added another option in my CSV2JSON tool to allow URLs and NavBar Titles to be imported to be added to the created map data file. Read about it here: http://idevdepot.com/?p=286
 
Paddy
Lost but trying
Profile
Posts: 240
Reg: Oct 08, 2011
Hands Up !
12,500
like
04/29/12 07:17 AM (13 years ago)
Looks a real handy tool. Little question, are the URLs opened by a web view in the app or with safari ? Thanks,
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/29/12 07:34 AM (13 years ago)
They open up the same way that buzztouch opens a Custom URL screen. The only difference (and this is a bonus!), it doesn't count against your # of pages in your project. Normally, you would have to create a URL Screen with the website you want them to be forwarded to. Then create a map item that points to that screen using a loadScreenWithItemId or loadScreenWithNickName With this tool, it creates a screen dynamically based upon the URL you give it, thus saving you a step (or in some cases, hundreds of steps!)
 
Paddy
Lost but trying
Profile
Posts: 240
Reg: Oct 08, 2011
Hands Up !
12,500
like
04/29/12 08:07 AM (13 years ago)
Thanks Stobe, pizza on it's way. I read about the problem with screen id's, but you think it's possible to link to bt screens in the future ?
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/29/12 08:22 AM (13 years ago)
Link from a map to a BT screen? Or from HTML to BT screen?
 
Paddy
Lost but trying
Profile
Posts: 240
Reg: Oct 08, 2011
Hands Up !
12,500
like
04/29/12 08:38 AM (13 years ago)
Map to bt screen. You got html to bt screen to work ?
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/29/12 08:41 AM (13 years ago)
I've seen several discussions about html to BT screen. Maybe for my next project :) But I can probably get map to BT working in the next update of my tool. It would require a column in the spreadsheet with either the nickname of the screen, or the itemID.
 
Paddy
Lost but trying
Profile
Posts: 240
Reg: Oct 08, 2011
Hands Up !
12,500
like
04/29/12 08:59 AM (13 years ago)
Pizza ordered...all went fine thanks. Having an extra column would be great for screen ids. I think we would only have to look in the bt config.txt to find the id generated. Not sure though.
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
04/29/12 09:07 AM (13 years ago)
Yep, finding the ID is easy. Putting them all in a spreadsheet is the tedious part :) Thanks! Show us your results when you've got a map page powered by Stobe!
 
Kristian_N
Code is Art
Profile
Posts: 91
Reg: Oct 27, 2011
Copenhagen
2,610
like
04/29/12 01:15 PM (13 years ago)
Great, Stobe.. Pizza is sent!
 
Kristian_N
Code is Art
Profile
Posts: 91
Reg: Oct 27, 2011
Copenhagen
2,610
like
05/07/12 06:44 AM (13 years ago)
Hi again, Been busy for some time so I hadn't had a chance to try out this tool in earnest and this is just a short line to express my sincere kudos'!! Great tool! Works just like i wanted it to! Thanks, Stobe! Regards, Kristian, Copenhagen
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
05/07/12 11:12 AM (13 years ago)
Thanks for the kind words Kristian! I'm finishing up some needed added features for the Quiz Maker tool, then I'll be back to work adding some new stuff to the Map tool next.
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/14/14 09:34 PM (12 years ago)
Stobe, Now I am ready to use the tool. Had got it a couple of months ago, and did a quick test. Looks like you have updated it to include option to include loadscreen object using screen nickname - which will be awesome! I created a sample with 3 points following docs online. When running the project (Simulator IOS7) when the map tries to display the points- I get a "There was a problem parsing some JSON data. Please make sure it is well-formed". (Same result whether the file is in App or from URL (DropBox). CSV File: https://www.dropbox.com/s/7kqobl0svo73w7y/Test_3_MapLocations.csv JSON File: https://www.dropbox.com/s/gxl98qpkn97fszv/MapData_Test_Scratch.txt Can you see what is wrong??? - Thanks! Question: Once I get it working... A question is what if you did not want to include either a screen or url with one of the points- what would you change? (Any way easier than including dummy data in csv and deleting from txt) Thanks, Kevin
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
01/14/14 09:58 PM (12 years ago)
Try copying and pasting the below into a test text file and link to it. If it works, I can tell you how to fix the problem. And I'm not sure what your other question is about. Do you mean you want map pins, but no links or info assigned to them? -Chris {"childItems":[{"itemId":"11111111", "itemType":"BT_mapLocation","latitude":"36.085651", "longitude":"-79.830852", "title":"Greeensboro", "subTitle":"February 18, 2014","loadScreenObject": {"itemNickname": "Scratch Off", "itemId": "21111111", "itemType": "BT_screen_webView", "navBarTitleText": "Greeensboro", "dataURL": "http://google.com"}},{"itemId":"11111112", "itemType":"BT_mapLocation","latitude":"35.824852", "longitude":"-78.649776", "title":"Raleigh", "subTitle":"April 7, 2014","loadScreenObject": {"itemNickname": "Scratch Off", "itemId": "21111112", "itemType": "BT_screen_webView", "navBarTitleText": "Raleigh", "dataURL": "http://yahoo.com"}},{"itemId":"11111113", "itemType":"BT_mapLocation","latitude":"35.07024", "longitude":"-78.958146", "title":"Fayetteville", "subTitle":"June 7, 2014","loadScreenObject": {"itemNickname": "Scratch Off", "itemId": "21111113", "itemType": "BT_screen_webView", "navBarTitleText": "Fayetteville", "dataURL": "http://usatoday.com"}}]}
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/15/14 05:26 AM (12 years ago)
Thanks for the quick reply. I did not compare the JSON to see what was different, but the replacement JSON not work- same error. (BT v3 project Hosted by BuzzTouch)
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/15/14 10:47 AM (12 years ago)
So I looked a little closer at what you sent. Ran a JSON validation on the original, and it said the same thing about the two missing commas. Validates the new file identical to what you posted, but still same error?
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/15/14 11:34 AM (12 years ago)
Wondering since the JSON for childitems is ok, if the problem is actually in the BT_config.txt after it is referenced. Is the last "childItems": [] that BT adds correct since we are already including in the Screen Data URL? Here is the section from the BT_config.txt: { "itemId": "myItemId", "itemType": "BT_screen_map", "itemNickname": "Map", "navBarTitleText": "Map", "showUserLocation": "0", "showUserLocationButton": "1", "defaultMapType": "standard", "showMapTypeButtons": "1", "showRefreshButton": "0", "singleLocationDefaultZoom": "15", "dataURL": "https://www.dropbox.com/s/u7qe6nri31487oq/MapData_Chris.txt", "childItems": [] }
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/15/14 01:21 PM (12 years ago)
Well after filling up your mailbox, I am wondering if after the initial missing "," format error the rest of the problems are on V3. Stobe can you update the CSVto JSON tool to add the colon, and let me know if I should swing this over to the V3 bug fix section... https://www.dropbox.com/s/5kk21zhiuvs62zu/Map%20locations%20thru%20Control%20Panel.pdf Thanks, Kevin I will add one more post regarding features ;)
 
NCbuzz
Code is Art
Profile
Posts: 575
Reg: Sep 11, 2013
Lillington, NC
11,100
like
01/15/14 01:29 PM (12 years ago)
Enhancements (how is that for positive thinking ;) 1) Can you add PinColor as a valid value in the CSV that will be converted for each item. 2) When working now it looks like every item would have a screen and URL. Would it be possible by leaving xls-csv value for URL blank or some designation that no URL info would be generated? Thanks
 
Stobe
buzztouch Evangelist
Profile
Posts: 1528
Reg: Mar 04, 2011
Fredericksburg,...
24,680
like
01/15/14 03:38 PM (12 years ago)
Ok. Lots to investigate, lol. Let me find some time to dig into these questions and I'll get back to you as soon as I can. If you don't hear back in a reasonable time, feel free to bump this thread, or PM me with a link to this thread to remind me. -Chris
 

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.