TOPIC: Import hotspots csv

Hi, im carlos, i need import my list of hotspots for example: 900 Hospitals and i have the list.. but how can import all? please dont tellme 1 by 1..sniff..

Hey Carlos,
Right now there is no importer for this. I would advise you to import the data trou phpmyadmin... A little bit harder, but better so, than adding everything per hand!
Daniel

Hi Daniel,

I am trying to create a tutorial of how to import data from excel to hotspots through phpmyadmin.

This is the head of my csv file:

All the data is in the database, but i can not make it grab the category, and the 'yes' to the published option.

In this case: category is Foods, and the id number for this category is 11

Ok. I figured it out.

The problem now is that all hotspots are located at the same spot, because i didn't setup any lat and/or long coordinates.

Do I have to go one by one to move them to the right position?

In 2.0.5 there is a geolocation feature. Go to the marker page in the backend, select max 100 hotspots click on geolocate, read the instructions and click geolocate in the popup After few seconds, or minutes most of your hotspots will get some coordinates.
Daniel

Hi Eliecer,

When you have it all worked out, please let us know what to do - I am sure there are many users who would appreciate an import function.

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)

- Once you finish to populate the table just go to File/Save As/
and select:
- Save as type: Text CSV (.csv) (*.csv)
- Character set: Western Europe (Windows-1252/WinLatin 1)
- Field delimiter: ; <

---

it's originally a ,
- Text delimiter: "
- Check: Save cell content as shown
- Uncheck: Fixed column width
- Click Ok
(I only filled the first 7 fields, and the last one, I left the rest empty)



- Let's go back to PHPmyadmin

- Select jos_hotspots_marker

- Select Import
- Choose the CSV File


- Check CSV using LOAD DATA
- Check the options and leave them in the way I am showing


- Click on Go

- The database has been populated with the new information.

and don't forget to do what Daniel said:

In 2.0.5 there is a geolocation feature. Go to the marker page in the backend, select max 100 hotspots click on geolocate, read the instructions and click geolocate in the popup After few seconds, or minutes most of your hotspots will get some coordinates.

I could really do with an import function without having to use Myphpadmin

This method is becoming a real pain...

Keith