MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap

Hello again, Today i want ask if is possible to import Lots of Adress and ZIpcode Data into ZHgooglemaps.

The Task is.

If have a Excel form with many many Adressdata and i must import it to ZHgooglemaps
The Problem is, it would take many many time to write all the adressdata manuel.

If is there a importfunktion to import the Adressdata with a mark on the map? If Yes do i need a special format?

Wich formatation must have my Excelform. I saw that one can somethink edit in the databse.

A PHP script to insert all th Adressdata ware very nice.

I hope you can understand my Request and find a way to help me.

By the way i cantranform the Excelform to word, csv ect.

Regards

Hi.
I think you can do that
wiki.zhuk.cc/index.php/Zh_GoogleMap_LoadPlacemarks
But you have to know about placemarks, defined by text addresses:
1 - wiki.zhuk.cc/index.php/Zh_GoogleMap_Trou..._when_displaying_map
2 - I do not load that placemarks by AJAX (ie if you want to use dynamic loading map objects JQuery/Mootools)

Thank you for the quick answer, i will check it now.
I Create a map and the map id is 1.
Then i go to mysql database and find the zhgooglemaps_markers table. When i go to SQL
the a window pops up. On the rigth hand i find SELECT * FROM `jzaxr_zhgooglemaps_markers` WHERE 1
and on the left hand i find a table with
Id
catid
latitute
longtitute
adrestext

To insert Data into SQL Database how the Excel ort csv dokument should look like
i understand that i do it this way



title latitude longitude addresstext mapid icontype description
Pioner Cinema 37.564088 55.751575) Kutuzovsky Ave, 21 Moscow, 13 car.bmp Cinema in Moskau
Romanov Cinema 37.608079 55.752523 per. Romanov, 4, Moskau 13 car.bmp Cinema in Moskau
Mirage Cinema 30.316247 60.042344 prospekt Engelsa, 124 st Peter 13 car.bmp Cinema in st Petersb
Mirage Cinema 30.317743 60.041306 Planernaya ul., 59 st Petersbu 13 car.bmp Cinema in st Petersb

Im not shure if i do it right, i hope you can support me a little bit with that.

I want show you somethink what i found in the www.

This is not commercion for other products or other aplication. You can delete this post after you read it if you want.
I want to show you only exatly what i want to have.
Look here.
de.batchgeo.com/features/store-locator/

There is a exaple what exactly i mean. There is a Excelform with Adressdata. This guy copy and paste only the Data and import it in a uncoplicatet. I mean is this possible to do ist with zhgooglemap ??

Pleas dont missunderstand me.

In my docs I wrote simple SQL which you can prepare

INSERT INTO `jos_j16zhgooglemaps_markers`(`title`, `latitude`, `longitude`, `addresstext`, `published`, `baloon`, `icontype`, `mapid`)
VALUES
('Placemark #1', 59.91854831914932, 30.39719313507078, '', 1, 1, 'default#', 13),
('Placemark #2', 59.9185483191492, 30.3971931350778, '', 1, 1, 'default#', 13),
('Placemark #3', 59.91854831913492, 30.39719313250778, '', 1, 1, 'default#', 13)
;

As for your link to example - you can do it by my extensions (check my demo site)
search - find feature in placemark list
groups - placemarks management by group list
reset map - home map button feature
find my location - geolocation button
ans so on

as for prepare by Excel
Put your data into sheet.
After that add between it column
fill this column by , or ','
put column before first column
fill by ( or ('
after last put ), or '),
at the last row remove last ,
add ;
before first row add INSERT INTO and your column list

Copy-paste into MySQL window and execute
You'll insert your data into my table. It is very easy.

I wrote ') or ) - it's depend on what your excel give your data after copy-paste (with or without quotes)