<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello Steve</p>
<p>Thanks for your feedback so far. It is slowly painting a picture
for me.</p>
<p>Before we start the CRM DB, we need ot determine if a mapping
software can with with the CRM DB. You seem to say this.</p>
<p>We do not want to start the DB in a software, only have to export
it once done, to a new DB software. The Ma[pserver part wil be
done once the DB part is done. Why, the budget is ready for the
DB part, but not yet for the mapserver part.<br>
</p>
<p>So, a simple scenario would be:</p>
<p><br>
</p>
<p>-My CRM database is populated with various data concerning
projects that we want to map out in Map server, including
longitude and latitude. This coudl include: year, budget,
different project paramaters, etc...<br>
</p>
<p>-Mapserver is configured to be able to read the CRM DB. There
will be various fields that will be searchable by definable fields
in Mapserver.<br>
</p>
<p>-Mapserver is able to peruse through the CRM DB and grab the data
that it needs to display on the map, according to defined choices
in our search.</p>
<p>-Mapserver displays the files that meet the given criteria.</p>
<p>This sound right?</p>
<p><br>
</p>
<p>Those points that are displayed, are they clickable?</p>
<p>IF so (for my project they need to be clickable, or the people
doing the search will not be able to see details on the files that
meet the criteria), how to we determine what is displayed? If it
is displayed, we will want to display additional information that
what query criteria.<br>
</p>
<p><br>
</p>
<p>Last question before I sign off.</p>
<p>Like I state, we are looking at CRM to do this system. It seems
to be much easier than building a new interface and database. The
CRM is well advanced, very flexible, modifiable and a great price
that fits our budget. By removing a few modules, it seems to suit
the project well.</p>
<p>When we have a project in the CRM, there are hard data typed
right into the profile: name, year, budget, etc...</p>
<p>But, we also have data that is "linked" to the project, like:
Companies and individuals. This is different from the hard
data. Hard data has a field, and whether you enter something in
the field or note, the full or empty field is displayed. For the
"linked" style, there is a heading, but if there are no "linked"
files, nothing is displayed. But, if there are things to display,
the page adjusts downward to accommodate the entries.<br>
</p>
<p>Can we have Mapserver grab the names of these "linked" files?<br>
</p>
<p>Thanks!<br>
</p>
<p>Joseph<br>
</p>
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 02/22/2017 09:32 AM,
<a class="moz-txt-link-abbreviated" href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a> wrote:<br>
</div>
<blockquote
cite="mid:OF1A7707EC.4DB780AD-ON852580CF.004F662C-852580CF.004FD639@isn.rtss.qc.ca"
type="cite"><font face="sans-serif" size="2">WMS and WFS are ogc
standards to share
maps over the web, intranet ...</font>
<br>
<a moz-do-not-send="true"
href="https://en.wikipedia.org/wiki/Web_Map_Service"><font
face="sans-serif" color="blue" size="2">https://en.wikipedia.org/wiki/Web_Map_Service</font></a>
<br>
<br>
<font face="sans-serif" size="2">You will not export data from the
database.
Mapserver will be connected to your mysql DB and render maps as
a service.</font>
<br>
<font face="sans-serif" size="2">Those services can be viewed by
gis
softwares or web applications</font>
<br>
<font face="sans-serif" size="2">steve</font>
<br>
<font face="sans-serif" size="2"> </font>
<br>
<br>
<br>
<br>
<font face="sans-serif" color="#5f5f5f" size="1">De :
</font><font face="sans-serif" size="1">Joe Hogan
<a class="moz-txt-link-rfc2396E" href="mailto:joehogan@gmx.com"><joehogan@gmx.com></a></font>
<br>
<font face="sans-serif" color="#5f5f5f" size="1">A :
</font><font face="sans-serif" size="1"><a class="moz-txt-link-abbreviated" href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a></font>
<br>
<font face="sans-serif" color="#5f5f5f" size="1">Cc :
</font><font face="sans-serif" size="1"><a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></font>
<br>
<font face="sans-serif" color="#5f5f5f" size="1">Date :
</font><font face="sans-serif" size="1">2017-02-21 11:14</font>
<br>
<font face="sans-serif" color="#5f5f5f" size="1">Objet :
</font><font face="sans-serif" size="1">Re: [mapserver-users]
Possible application questions</font>
<br>
<hr noshade="noshade">
<br>
<br>
<br>
<font size="3">Hello Steve,</font>
<p><font size="3">Thanks for the reassuring news. We have found
our
possible solution.</font>
</p>
<p><font size="3">The CRM software has not yet been modified, but
it will
have the two fields for the Longitude and Latitude.</font>
</p>
<p><font size="3">Other fields will be used as well, and we will
have to
add more for those.</font>
</p>
<p><font size="3">When you say it has to provide wms/wfs services,
what does
that mean? I found the 9nitials, but what does it mean?</font>
</p>
<p><font size="3">Is it a special format? Like I need to export
the
data from the data base into a certain format?</font>
</p>
<p><font size="3">Sorry for the newbie questions, but I am
learning:)</font>
</p>
<p><font size="3">Thanks</font>
</p>
<p>
</p>
<p><font size="3">Joseph</font>
</p>
<p>
<br>
<font size="3">On 02/21/2017 08:48 AM, </font><a
moz-do-not-send="true" href="mailto:Steve.Toutant@inspq.qc.ca"><font
color="blue" size="3"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font
size="3">
wrote:</font>
<br>
<font face="Arial" size="2"><br>
hi Joseph<br>
Yes mapserver can be used for your application by providing
wms/wfs services<br>
Here are some links that can help<br>
#connect to mysql</font><font face="Arial" color="blue"
size="2"><u><br>
</u></font><a moz-do-not-send="true"
href="http://mapserver.org/input/vector/mysql.html"><font
face="Arial" color="blue" size="2"><u>http://mapserver.org/input/vector/mysql.html</u></font></a><font
face="Arial" size="2"><br>
<br>
#filters...Runtime substitution</font><font face="Arial"
color="blue" size="2"><u><br>
</u></font><a moz-do-not-send="true"
href="http://mapserver.org/cgi/runsub.html"><font face="Arial"
color="blue" size="2"><u>http://mapserver.org/cgi/runsub.html</u></font></a><font
face="Arial" size="2"><br>
<br>
Do you have latitude/longitude data in your database, or any
other georeference
that can be used to render on a map?<br>
Steve<br>
<br>
</font><font face="Arial" color="#a1009f" size="2"><br>
-----"mapserver-users" </font><a moz-do-not-send="true"
href="mailto:mapserver-users-bounces@lists.osgeo.org"><font
face="Arial" color="blue" size="2"><u><mapserver-users-bounces@lists.osgeo.org></u></font></a><font
face="Arial" color="#a1009f" size="2">
a écrit : -----</font><font face="Arial" size="2"> </font>
<br>
<font face="Arial" size="2">A : </font><a
moz-do-not-send="true"
href="mailto:mapserver-users@lists.osgeo.org"><font
face="Arial" color="blue" size="2"><u>mapserver-users@lists.osgeo.org</u></font></a><font
face="Arial" size="2"><br>
De : Joe Hogan <br>
Envoyé par : "mapserver-users" <br>
Date : 20/02/2017 11:12<br>
Objet : [mapserver-users] Possible application questions<br>
</font>
<br>
<tt><font size="2">Hello,<br>
<br>
I am writing to ask if MapServer will work for our
application.<br>
<br>
We are working on a project that will allow us to place on a
map of our
<br>
country various projects. We want to be able to filter them
based
on <br>
various pieces of information, including, for example:<br>
<br>
year of project<br>
population<br>
project budget<br>
etc...<br>
<br>
We are compiling the data in a CRM(MySQL database), and want
to use the
<br>
data from the CRM to feed the mapping software.<br>
<br>
1 - can I map the type fo information that I need?<br>
2 - can we use the data directly from the CRM database if we
tell the <br>
mapping software what data to use(so t can be read on the
fly, live from
<br>
the database?), or does it need to be exported before using
in the <br>
mapping software?<br>
3 - It it needs to be in its own exported format, how to I
get it from
<br>
MtSQL to the correct format?<br>
<br>
<br>
Thanks for any and all help.<br>
<br>
Joseph<br>
<br>
_______________________________________________<br>
mapserver-users mailing list</font></tt><tt><font
color="blue" size="2"><u><br>
</u></font></tt><a moz-do-not-send="true"
href="mailto:mapserver-users@lists.osgeo.org"><tt><font
color="blue" size="2"><u>mapserver-users@lists.osgeo.org</u></font></tt></a><tt><font
color="blue" size="2"><u><br>
</u></font></tt><a moz-do-not-send="true"
href="https://lists.osgeo.org/mailman/listinfo/mapserver-users"><tt><font
color="blue" size="2"><u>https://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></tt></a>
<br>
<font face="Arial" size="2"><br>
Si vous n'êtes pas le destinataire de ce message, veuillez le
détruire
près avoir informé l'expéditeur de son erreur. Par ailleurs,
il est interdit
de copier ou de modifier ce courriel sans l'autorisation de
l'auteur.<br>
<br>
L'Institut national de santé publique du Québec n'assume
aucune responsabilité
à l'égard du contenu des messages personnels envoyés par ses
employés.</font>
<br>
<br>
</p>
</blockquote>
<br>
</body>
</html>