Zh GoogleMap LoadPlacemarks - Revision history

Admin: /* Prepare and Load Placemark Data */

2012-07-19T11:12:16Z

Prepare and Load Placemark Data

← Older revision		Revision as of 11:12, 19 July 2012
Line 66:		Line 66:

	If you wish to load addition data into the other table fields, you should add it name into ''insert into column clause'' and values into '''values''' section in your order.		If you wish to load addition data into the other table fields, you should add it name into ''insert into column clause'' and values into '''values''' section in your order.


	After that copy your code, go to phpMyAdmin, select your database, click SQL tab, paste your code and press '''Go'''		After that copy your code, go to phpMyAdmin, select your database, click SQL tab, paste your code and press '''Go'''

			And wait for loading end.

			That's All.

2012-07-19T11:10:51Z

Prepare and Load Placemark Data

← Older revision		Revision as of 11:10, 19 July 2012
Line 3:		Line 3:
	For example, you have a lot of placemarks, and want to load it into '''Zh GoogleMap''' extension.		For example, you have a lot of placemarks, and want to load it into '''Zh GoogleMap''' extension.

	In this case we will use ~~PHPAdmin~~ (or others interface to connect to your database for loading data)		In this case we will use phpMyAdmin (or others interface to connect to your database for loading data)

	Lets prepare data for loading.		Lets prepare data for loading.
Line 14:		Line 14:
	* '''longitude''' - ''optional''		* '''longitude''' - ''optional''
	* '''addresstext''' - ''optional'' - Address, defined by text		* '''addresstext''' - ''optional'' - Address, defined by text
	* '''mapid'''		* '''mapid''' - Map ID
	* '''icontype'''		* '''icontype'''

Line 65:		Line 65:
	As you can see, you can easy create data block in any editor, and it is very simple.		As you can see, you can easy create data block in any editor, and it is very simple.

	If you wish to load addition data into the other table fields, you should add it name into ''insert into column clause''		If you wish to load addition data into the other table fields, you should add it name into ''insert into column clause'' and values into '''values''' section in your order.

			After that copy your code, go to phpMyAdmin, select your database, click SQL tab, paste your code and press '''Go'''

2012-07-19T11:05:55Z

@@ Line 18: / Line 18: @@
 And special values for placemark attributes
-* published
+* '''published'''
-* baloon - field '''Marker''', values
+* '''baloon''' - field '''Marker''', values
 ** 1 - Drop
 ** 2 - Bounce
 ** 3 - Simple
-* markercontent  - field '''InfoWin Content''', values
+* '''markercontent'''  - field '''InfoWin Content''', values
-** 0 - Title and Description
+** 0 - Title and Description (''default'')
 ** 1 - Title
 ** 2 - Description
@@ Line 30: / Line 31: @@
 If you wish
-* description - Placemark Description
+* '''description''' - Placemark Description
-* descriptionhtml - Addition HTML text
+* '''descriptionhtml''' - Addition HTML text

2012-07-19T10:53:10Z

← Older revision		Revision as of 10:53, 19 July 2012
Line 1:		Line 1:
	== Prepare and Load Placemark Data ==		== Prepare and Load Placemark Data ==

			For example, you have a lot of placemarks, and want to load it into '''Zh GoogleMap''' extension.

			In this case we will use PHPAdmin (or others interface to connect to your database for loading data)

			Lets prepare data for loading.

			You can use any text editor, or prepare it in MS Excel (like csv format).

			For loading data today you have to load this minimum data
			* '''title''' - Placemark title
			* '''latitude''' - ''optional''
			* '''longitude''' - ''optional''
			* '''addresstext''' - ''optional'' - Address, defined by text
			* '''mapid'''
			* '''icontype'''

			And special values for placemark attributes
			* published
			* baloon - field '''Marker''', values
			** 1 - Drop
			** 2 - Bounce
			** 3 - Simple
			* markercontent - field '''InfoWin Content''', values
			** 0 - Title and Description
			** 1 - Title
			** 2 - Description
			** 100 - None

			If you wish
			* description - Placemark Description
			* descriptionhtml - Addition HTML text

2012-07-19T10:36:55Z

Created page with "== Prepare and Load Placemark Data =="

New page

== Prepare and Load Placemark Data ==