Re: Info Template
Steve Lime <[email protected]> Wed, 20 Nov 2019 10:59:17 -0600
| Newsgroups | gmane.comp.gis.mapserver.user |
|---|---|
| Message-ID | <CAMrKZ99ytgLukaOK4RL4jA9kxfB++UpQ+sPkxCbGReSiVJbNKg@mail.gmail.com> |
--===============4804242061118388423== Content-Type: multipart/alternative; boundary="0000000000009992dc0597ca1a58" --0000000000009992dc0597ca1a58 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable For the sake of completeness, "$value" is the default format and doesn't need to be explicitly set. --Steve On Wed, Nov 20, 2019 at 7:29 AM Rahkonen Jukka (MML) < [email protected]> wrote: > Hi Markus, > > > > I am not sure if you=E2=80=99d 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 LAY= ER > https://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-in-GetFeatureInfo-td5224781= .html > contains a template that defines the html format of GetFeatureInfo. Each > =E2=80=9Citem name=E2=80=9D 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. > > > > <body> > <h3>NIMI</h3> > [item name=3DNIMI format=3D"$value" escape=3Dnone] > <h3>LIS=C3=84TIEDOT</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=C3=A4hett=C3=A4j=C3=A4:* mapserver-users <mapserver-users-bounces@list= s.osgeo.org> *Puolesta > *Markus L=C3=BCtke Brintrup > *L=C3=A4hetetty:* keskiviikko 20. marraskuuta 2019 14.53 > *Vastaanottaja:* [email protected] > *Aihe:* [mapserver-users] Info Template > > > > Hallo Liste, > > > > besteht die M=C3=B6glichkeit in der Template.html eines Map-Projektes ein= e > Datenbankanbindung an zu steuern? > > Beispiel: > > <tr> > > <td><b>Projektname:</b></td> > > <td>[Werte aus MYSQL-DB]</td> > > </tr> > > > > Freundliche Gr=C3=BC=C3=9Fe > > > > Markus L=C3=BCtke Brintrup > > > > WipflerPLAN > > Niederlassung Donauries > > > > Telefon: 09081 27509-44 > > Telefax: 09081 27509-50 > > [email protected] > > *www.wipflerplan.de <http://www.wipflerplan.de/>* > > > > WipflerPLAN Planungsgesellschaft mbH > > Standort N=C3=B6rdlingen > > An der Lach 11a > > 86720 N=C3=B6rdlingen > > Amtsgericht Ingolstadt HRB 190595 > > Gesch=C3=A4ftsf=C3=BChrer: > > Wilhelm Wipfler > > Ursula Burkart > > Adelheid Buchard > > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/mapserver-users --0000000000009992dc0597ca1a58 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">For the sake of completeness, "$value" is the de= fault format and doesn't need to be explicitly set. --Steve</div><br><d= iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Nov = 20, 2019 at 7:29 AM Rahkonen Jukka (MML) <<a href=3D"mailto:jukka.rahkon= [email protected]">[email protected]</a>> wrote:= <br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8= ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div lang=3D"FI"> <div class=3D"gmail-m_757538910375480729WordSection1"> <p class=3D"MsoNormal">Hi Markus,<u></u><u></u></p> <p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">I am not sure if you=E2=80=99d = prefer me to answer in Finnish but English is easier for the majority of re= aders.<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></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" target=3D"_blank">http= s://mapserver.org/mapfile/layer.html</a> can also be used as a data source = for templates.<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></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" target=3D"_blank"> 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 =E2=80=9Citem name=E2=80=9D 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. <u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><body> <br> <h3>NIMI</h3> <br> =C2=A0 =C2=A0 =C2=A0[item name=3DNIMI format=3D"$value" escape=3D= none] <br> <h3>LIS=C3=84TIEDOT</h3> <br> =C2=A0 =C2=A0 =C2=A0[item name=3DKIELLONLISATIETO format=3D"$value&quo= t; escape=3Dnone] <br> <h3>VOIMASSAOLO</h3> <br> =C2=A0 =C2=A0 =C2=A0[item name=3DVOIMASSAOLO format=3D"$value" es= cape=3Dnone] <br> <h3>YHTEYSTIEDOT</h3> <br> =C2=A0 =C2=A0 =C2=A0[item name=3DYHTEYSTIEDOT format=3D"$value" e= scape=3Dnone] <br> =C2=A0</body><u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">-Jukka Rahkonen-</span><span la= ng=3D"EN-US"><u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p> <div> <div style=3D"border-right:none;border-bottom:none;border-left:none;border-= top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm"> <p class=3D"MsoNormal"><b><span>L=C3=A4hett=C3=A4j=C3=A4:</span></b><span> = mapserver-users <<a href=3D"mailto:[email protected]= rg" target=3D"_blank">[email protected]</a>> <b>Puolesta </b>Markus L=C3=BCtke Brintrup<br> <b>L=C3=A4hetetty:</b> keskiviikko 20. marraskuuta 2019 14.53<br> <b>Vastaanottaja:</b> <a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a><br> <b>Aihe:</b> [mapserver-users] Info Template<u></u><u></u></span></p> </div> </div> <p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p> <p class=3D"MsoNormal"><span lang=3D"DE">Hallo Liste,<u></u><u></u></span><= /p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">besteht die M=C3=B6glichkeit in de= r Template.html eines Map-Projektes eine Datenbankanbindung an zu steuern?<= u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">Beispiel:<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><tr><u></u><u></u></span></p= > <p class=3D"MsoNormal"><span lang=3D"DE">=C2=A0=C2=A0=C2=A0 <td><b= >Projektname:</b></td><u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">=C2=A0=C2=A0=C2=A0 <td>[Wert= e aus MYSQL-DB]</td>=C2=A0=C2=A0 <u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"></tr><u></u><u></u></span></= p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">Freundliche Gr=C3=BC=C3=9Fe<u></u>= <u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">Markus L=C3=BCtke Brintrup<u></u><= u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">WipflerPLAN<u></u><u></u></span></= p> <p class=3D"MsoNormal"><span lang=3D"DE">Niederlassung Donauries<u></u><u><= /u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">Telefon: 09081 27509-44<u></u><u><= /u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE">Telefax: 09081 27509-50<u></u><u><= /u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"color:blue"><a href=3D"ma= ilto:[email protected]" target=3D"_blank"><span style=3D"color:blue">mlb@w= ipflerplan.de</span></a><u></u><u></u></span></p> <p class=3D"MsoNormal"><u><span lang=3D"DE" style=3D"color:blue"><a href=3D= "http://www.wipflerplan.de/" target=3D"_blank"><span style=3D"color:blue">w= ww.wipflerplan.de</span></a></span></u><span lang=3D"DE" style=3D"color:blu= e"><u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">WipflerPLA= N Planungsgesellschaft mbH<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Standort N= =C3=B6rdlingen<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">An der Lac= h 11a<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">86720 N=C3= =B6rdlingen<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Amtsgerich= t Ingolstadt HRB 190595<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Gesch=C3= =A4ftsf=C3=BChrer:<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Wilhelm Wi= pfler<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Ursula Bur= kart<u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-size:9pt">Adelheid B= uchard <u></u><u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> <p class=3D"MsoNormal"><span lang=3D"DE"><u></u>=C2=A0<u></u></span></p> </div> </div> _______________________________________________<br> mapserver-users mailing list<br> <a href=3D"mailto:[email protected]" target=3D"_blank">mapser= [email protected]</a><br> <a href=3D"https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel=3D= "noreferrer" target=3D"_blank">https://lists.osgeo.org/mailman/listinfo/map= server-users</a></blockquote></div> --0000000000009992dc0597ca1a58-- --===============4804242061118388423== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KbWFwc2VydmVy LXVzZXJzIG1haWxpbmcgbGlzdAptYXBzZXJ2ZXItdXNlcnNAbGlzdHMub3NnZW8ub3JnCmh0dHBz Oi8vbGlzdHMub3NnZW8ub3JnL21haWxtYW4vbGlzdGluZm8vbWFwc2VydmVyLXVzZXJz --===============4804242061118388423==--