Re: Info Template
"Rahkonen Jukka (MML)" <[email protected]> Wed, 20 Nov 2019 13:29:15 +0000
| Newsgroups | gmane.comp.gis.mapserver.user |
|---|---|
| Message-ID | <[email protected]> |
--===============3172098767825281084==
Content-Language: fi-FI
Content-Type: multipart/alternative;
boundary="_000_e1008e90003748e2bac996ee66f785adC119S212VM042msvyvivaha_"
--_000_e1008e90003748e2bac996ee66f785adC119S212VM042msvyvivaha_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Markus,
I am not sure if you'd prefer me to answer in Finnish but English is easier=
for the majority of readers.
Certainly it is possible to use data from a database with templates yes but=
you did not tell the details about for what purpose you are trying to use =
the templates. The DATA (perhaps with CONNECTION) that is used in LAYER htt=
ps://mapserver.org/mapfile/layer.html can also be used as a data source for=
templates.
An example from an old mail http://osgeo-org.1560.x6.nabble.com/html-tags-i=
n-GetFeatureInfo-td5224781.html contains a template that defines the html f=
ormat of GetFeatureInfo. Each "item name" is a name of the attribute in the=
source data. If vector data for the LAYER comes from MYSQL then the attrib=
utes are read from MYSQL as well.
<body>
<h3>NIMI</h3>
[item name=3DNIMI format=3D"$value" escape=3Dnone]
<h3>LIS=C4TIEDOT</h3>
[item name=3DKIELLONLISATIETO format=3D"$value" escape=3Dnone]
<h3>VOIMASSAOLO</h3>
[item name=3DVOIMASSAOLO format=3D"$value" escape=3Dnone]
<h3>YHTEYSTIEDOT</h3>
[item name=3DYHTEYSTIEDOT format=3D"$value" escape=3Dnone]
</body>
-Jukka Rahkonen-
L=E4hett=E4j=E4: mapserver-users <[email protected]> =
Puolesta Markus L=FCtke Brintrup
L=E4hetetty: keskiviikko 20. marraskuuta 2019 14.53
Vastaanottaja: [email protected]
Aihe: [mapserver-users] Info Template
Hallo Liste,
besteht die M=F6glichkeit in der Template.html eines Map-Projektes eine Dat=
enbankanbindung an zu steuern?
Beispiel:
<tr>
<td><b>Projektname:</b></td>
<td>[Werte aus MYSQL-DB]</td>
</tr>
Freundliche Gr=FC=DFe
Markus L=FCtke Brintrup
WipflerPLAN
Niederlassung Donauries
Telefon: 09081 27509-44
Telefax: 09081 27509-50
[email protected]<mailto:[email protected]>
www.wipflerplan.de<http://www.wipflerplan.de/>
WipflerPLAN Planungsgesellschaft mbH
Standort N=F6rdlingen
An der Lach 11a
86720 N=F6rdlingen
Amtsgericht Ingolstadt HRB 190595
Gesch=E4ftsf=FChrer:
Wilhelm Wipfler
Ursula Burkart
Adelheid Buchard
--_000_e1008e90003748e2bac996ee66f785adC119S212VM042msvyvivaha_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.Shkpostityyli18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Shkpostityyli19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"FI" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi Markus,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I am not sure if you’d pr=
efer me to answer in Finnish but English is easier for the majority of read=
ers.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Certainly it is possible to use=
data from a database with templates yes but you did not tell the details a=
bout for what purpose you are trying to use the templates. The DATA (perhap=
s with CONNECTION) that is used in LAYER
<a href=3D"https://mapserver.org/mapfile/layer.html">https://mapserver.org/=
mapfile/layer.html</a> can also be used as a data source for templates.<o:p=
></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">An example from an old mail <a =
href=3D"http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5=
224781.html">
http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.h=
tml</a> contains a template that defines the html format of GetFeatureInfo.=
Each “item name” is a name of the attribute in the source data=
. If vector data for the LAYER comes from MYSQL
then the attributes are read from MYSQL as well. <o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><body> <br>
<h3>NIMI</h3> <br>
[item name=3DNIMI format=3D"$value" escape=3D=
none] <br>
<h3>LIS=C4TIEDOT</h3> <br>
[item name=3DKIELLONLISATIETO format=3D"$value&quo=
t; escape=3Dnone] <br>
<h3>VOIMASSAOLO</h3> <br>
[item name=3DVOIMASSAOLO format=3D"$value" es=
cape=3Dnone] <br>
<h3>YHTEYSTIEDOT</h3> <br>
[item name=3DYHTEYSTIEDOT format=3D"$value" e=
scape=3Dnone] <br>
</body><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">-Jukka Rahkonen-</span><span la=
ng=3D"EN-US"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p>
<div>
<div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm =
0cm 0cm">
<p class=3D"MsoNormal"><b><span style=3D"mso-fareast-language:FI">L=E4hett=
=E4j=E4:</span></b><span style=3D"mso-fareast-language:FI"> mapserver-users=
<[email protected]>
<b>Puolesta </b>Markus L=FCtke Brintrup<br>
<b>L=E4hetetty:</b> keskiviikko 20. marraskuuta 2019 14.53<br>
<b>Vastaanottaja:</b> [email protected]<br>
<b>Aihe:</b> [mapserver-users] Info Template<o:p></o:p></span></p>
</div>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><span lang=3D"DE">Hallo Liste,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE">besteht die M=F6glichkeit in der T=
emplate.html eines Map-Projektes eine Datenbankanbindung an zu steuern?<o:p=
></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE">Beispiel:<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"><tr><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"> <td><b=
>Projektname:</b></td><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"> <td>[Wert=
e aus MYSQL-DB]</td> <o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"></tr><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
Freundliche Gr=FC=DFe<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
<o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
Markus L=FCtke Brintrup<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
<o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
WipflerPLAN<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
Niederlassung Donauries<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
<o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
Telefon: 09081 27509-44<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
Telefax: 09081 27509-50<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"color:blue;mso-fareast-la=
nguage:DE"><a href=3D"mailto:[email protected]"><span style=3D"color:blue"=
>[email protected]</span></a><o:p></o:p></span></p>
<p class=3D"MsoNormal"><u><span lang=3D"DE" style=3D"color:blue;mso-fareast=
-language:DE"><a href=3D"http://www.wipflerplan.de/"><span style=3D"color:b=
lue">www.wipflerplan.de</span></a></span></u><span lang=3D"DE" style=3D"col=
or:blue;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:DE">=
<o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">WipflerPLAN Planungsgesellschaft mbH<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Standort N=F6rdlingen<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">An der Lach 11a<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">86720 N=F6rdlingen<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Amtsgericht Ingolstadt HRB 190595<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Gesch=E4ftsf=FChrer:<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Wilhelm Wipfler<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Ursula Burkart<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9.0pt;mso-farea=
st-language:DE">Adelheid Buchard
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"><o:p> </o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"DE"><o:p> </o:p></span></p>
</div>
</body>
</html>
--_000_e1008e90003748e2bac996ee66f785adC119S212VM042msvyvivaha_--
--===============3172098767825281084==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KbWFwc2VydmVy
LXVzZXJzIG1haWxpbmcgbGlzdAptYXBzZXJ2ZXItdXNlcnNAbGlzdHMub3NnZW8ub3JnCmh0dHBz
Oi8vbGlzdHMub3NnZW8ub3JnL21haWxtYW4vbGlzdGluZm8vbWFwc2VydmVyLXVzZXJz
--===============3172098767825281084==--