looking for some advice on the above plugin, smug has been great and given me loads of help, but im still having problem wuth the external csv file and what sections to include in the file for the plugin to work, has anyone had success with it and could i use someones csv file to create my own. cheers sean

Think Smug is very clear in his explanation video. Are you having problems importing your csv file in your MySQL database? What exactly?

ive manged to get everything set up, including the mysql database, just cant seam to figure out what to name the sections in the csv file, even when i use the wb addons for the map on my self hosted, all i need is an example csv file that works, then i can adapt for myself.

Watch Smugs Video again! Every header in your database has to be a row header in your csv in exactly the same order. Will send you a csv later today as soon as I am at my computer again

thanks dude, that will help loads, just need full file that i can compare and play with, against my own file. cheers sean

here you go: http://appkingz.de/downloads/demo.csv

Nice help, LeonG ! Thank you. -- Niraj

thats great dude thanks, yeah ive followed smug to a t, got all the headers set up, but it wouldnt work,will start again from scratch, least i have csv file that works, and i can see wether its my file, or i havnt loaded all the other stuff wrong, thanks again dude cheers sean

ps heres mine, same headings as yours, but yours is all on 1 line with comas separating it, which is the correct way, https://www.dropbox.com/s/kahct3kxp8x2zdf/knightresidence.csv?dl=0

right heres where im at, if anyone can help, ive set up the wb add ons and the mysql database, ive imported the csv file into the databass, no errors, i create a screen in the app with smugs location map called test,under maps in wb add ons in my self hosting, i copy the url in Smug Location Menu with Categories, which is http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=yourCategoryHere which i then paste into the data url in the screen test, when i open the screen on device, i get the screen layout , but nothing is showing in screen, what am i doing wrong guys

ps when i change the end of the url (yourCategoryHere ) to a category, ie city centre, the app crashes, http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=City_Centre when i copy the csv file and convert it with smugs jason converter, and save it as text file,(checked the json is fine) and use this as a url in the screen, still nothing

Change the guid to a way longer one like mine. Do not know why but I had the same problem until I changed those to longer ones.

changed the guid to this, https://www.dropbox.com/s/kahct3kxp8x2zdf/knightresidence.csv?dl=0 then reinserted url http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=yourCategoryHere into screen, and still the same

and http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=City_Centre app crashes

I will have a closer look later but please take this URL for now: http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=

tried that, app crashes when i open the map screen

right managed to get somewhere, as in its showing the items on the screen, when i open maps on self hosting, i get 3 options when it comes to the data url, Display All Records on Map (Location Map): <a href="http://www.webmonkeys.co/BT-server/wb_addons/maps/map_locations.php?appGuid=EA39624E8643A6A44131736BE" target="_blank" rel="nofollow">http://www.webmonkeys.co/BT-server/wb_addons/maps/map_locations.php?appGuid=EA39624E8643A6A44131736BE</a> Simple Menu list of Categories: <a href="http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catMenu.php?appGuid=EA39624E8643A6A44131736BE" target="_blank" rel="nofollow">http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catMenu.php?appGuid=EA39624E8643A6A44131736BE</a> Smug Location Menu with Categories: <a href="http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=yourCategoryHere" target="_blank" rel="nofollow">http://www.webmonkeys.co/BT-server/wb_addons/maps/lm_catDisp.php?appGuid=EA39624E8643A6A44131736BE&category=yourCategoryHere</a> im using smugs location menu, so i used the url for that, no matter what i did with the url, it wouldnt show anything, then i tried the simple menu list url(bearing in mind im using a smug location map screen) and it worked, everthing was showing <a href="https://www.dropbox.com/s/fc331rw2i6hft8o/2014-12-09%2014.17.18.png?dl=0" target="_blank" rel="nofollow">https://www.dropbox.com/s/fc331rw2i6hft8o/2014-12-09%2014.17.18.png?dl=0</a> how do i get it to show catagories rather than the whole list, also when pressing the items it takes you 2 next screen <a href="https://www.dropbox.com/s/n00glq8miclanym/2014-12-09%2014.17.13.png?dl=0" target="_blank" rel="nofollow">https://www.dropbox.com/s/n00glq8miclanym/2014-12-09%2014.17.13.png?dl=0</a> but isnt showing driving directions and also where do i put the image files for the icons. cheers sean

It is not made to show the categories, so that would be a whole different approach, would need new coding. If it is not showing the driving directions the address is somehow not pulled from the database. I solved that with the new GUID length as mentioned before. The whole plugin is not really easy to handle and I can't remember all my steps I made, but had a lot of trial and error myself. I got to understand most of it as I looked into the JSON that the links show. Not sure if you use timestamps in the csv file? I deleted those as well.

i didnt use the timestamps, do you know where the icons go,ie where do i store them, will just keep fiddling with it, thanks for your help dude. cheers sean ps further testing, is only the first data url works Display All Records on Map (Location Map)

I actually only use the "Display All Records on Map (Location Map)" URL for the location menu. Works fine. Icons don't seem to work as they are connected with linkImage somehow. Will figure that out later.

Watch Smugs Video again! Every header in your database has to be a row header in your csv in exactly the same order. Will send you a csv later today as soon as I am at my computer again

ive actually watched it about 6 times, plus got loads of pointers from smug, the file works when you use the ordinary location map url, but not on the other 2 urls, heres mine, which is how smug wants it i think, tell me if you can see any mistakes. https://www.dropbox.com/s/kahct3kxp8x2zdf/knightresidence.csv?dl=0 cheers dude sean