1. Eliecer Marchante
  2. Tricks
  3. Tuesday, 26 June 2012
  4.  Subscribe via email
[color=#000088][b]FIRST PART[/color][/b]

To follow this tutorial you will need:
- OpenOffice.org 3.3.0 Calc
- Notepad ++
- Access to your website's PHPmyadmin


- Go to your PHPadmin and Select Databases
http://www.virtualbc.ca/images/11.jpg


- Select the database you are using with hotspots
http://www.virtualbc.ca/images/12.jpg

- These are the elements related with hotspots
http://www.virtualbc.ca/images/13.jpg

- Click on Browse
http://www.virtualbc.ca/images/14.jpg

-These are the fields to use with the OpenOffice.org Calc,
http://www.virtualbc.ca/images/15.jpg


but they must be in these order:
id - catid - name - street - plz - town - country - gmlat - gmlng - description - description_small - picture - picture_thumb - autor - autorip - autoruserid - postdate - vote - votenum - published
http://www.virtualbc.ca/images/16.jpg


The id and the catid, will match the category id number.
plz corresponds to the postal code
published - value 1 (the hotspot will be published), and value 0 (the hotspot won't be published)
Responses (6)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Slow web page loading
Hi I have a question about HotSpot - Mapview. I've uploaded several 36 differen...
4 Replies
Posted on Saturday, 28 October 2017
  • #Hotspots
  • #mapview
Page Navigation!
The admin bar is currently on top before site visitors see the comments. How can...
0 Replies
Posted on Wednesday, 25 May 2022
  • New
  • Exporting Markers and Importing via PHPMyAdmin
    This is not a question, unless someone reading this knows a better way to do thi...
    3 Replies
    Posted on Monday, 22 July 2019
    • #Export
    • #import
    • #phpmyadmin
    • #markers
    Show all markers (and keep paginated list)?
    For my particular use case it makes more sense to do marker clusters than tiles....
    1 Replies
    Posted on Thursday, 19 May 2022
    Two message dialogs when submitting hotspot
    Hi! I noticed that there are two Joomla messages shown when a hotspot is subm...
    1 Replies
    Posted on Thursday, 05 May 2022