MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap

  • Rambo
  • Rambo's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 7 months ago #10356 by Rambo
Rambo created the topic: 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

"Live for nothing, or die for something"

Please Log in or Create an account to join the conversation.

More
1 year 7 months ago #10360 by Dima
Dima replied the topic: MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap
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)

Don't forget support my developments: post review in JED, donate ;)

Post your sites as examples into my directory
Zh GoogleMap: forum.zhuk.cc/index.php/forum/gm-user-s-sites
Zh YandexMap: forum.zhuk.cc/index.php/forum/ym-user-s-sites

Please Log in or Create an account to join the conversation.

  • Rambo
  • Rambo's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 7 months ago - 1 year 7 months ago #10363 by Rambo
Rambo replied the topic: MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap
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.

"Live for nothing, or die for something"
Last Edit: 1 year 7 months ago by Rambo.

Please Log in or Create an account to join the conversation.

More
1 year 7 months ago #10365 by Dima
Dima replied the topic: MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap
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)
;

Don't forget support my developments: post review in JED, donate ;)

Post your sites as examples into my directory
Zh GoogleMap: forum.zhuk.cc/index.php/forum/gm-user-s-sites
Zh YandexMap: forum.zhuk.cc/index.php/forum/ym-user-s-sites

Please Log in or Create an account to join the conversation.

More
1 year 7 months ago #10366 by Dima
Dima replied the topic: MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap
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

Don't forget support my developments: post review in JED, donate ;)

Post your sites as examples into my directory
Zh GoogleMap: forum.zhuk.cc/index.php/forum/gm-user-s-sites
Zh YandexMap: forum.zhuk.cc/index.php/forum/ym-user-s-sites

Please Log in or Create an account to join the conversation.

More
1 year 7 months ago - 1 year 7 months ago #10367 by Dima
Dima replied the topic: MANY ADRESSES IMPORT from EXCEL FORM in ZHgooglmap
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)

Don't forget support my developments: post review in JED, donate ;)

Post your sites as examples into my directory
Zh GoogleMap: forum.zhuk.cc/index.php/forum/gm-user-s-sites
Zh YandexMap: forum.zhuk.cc/index.php/forum/ym-user-s-sites
Last Edit: 1 year 7 months ago by Dima.

Please Log in or Create an account to join the conversation.

Time to create page: 0.079 seconds

Donate


Go to top