[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



- Select the database you are using with hotspots


- These are the elements related with hotspots


- Click on Browse


-These are the fields to use with the OpenOffice.org Calc,



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



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)