<div>I will tell you one thing...the dropdown list of icons is hard to find. I used the control here -> <a href="http://www.scbr.com/docs/products/dhtmlxCombo/">http://www.scbr.com/docs/products/dhtmlxCombo/</a></div>
<div> </div>
<div>You probably want some kind of grid that is connected to the database. There are many out there including Rico. <a href="http://openrico.org/demos/livegrid">http://openrico.org/demos/livegrid</a></div>
<div> </div>
<div>Linda Rawson<br><br> </div>
<div><span class="gmail_quote">On 10/10/07, <b class="gmail_sendername">Tara Athan</b> <<a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I should have been more specific in my question.<br>I would like to create the textfile for the markers, titles and
<br>descriptions dynamically from a database so that users can enter new<br>markers and they appear on the map with minimal intervention from me.<br>I was planning to do this by the following steps<br>1. the user sees a map displaying the current markers from the text
<br>file, and an HTML form,<br>2. they click on the map to fill the lat lon fields in the form,<br>3.they type in the title, description and select characteristics from<br>dropdown menus that determine the icon<br>4. PHP commands are used to enter this into a database (MySQL or
<br>PostGRES) on the server, along with an e-mail alert to the database admin<br>5. at regular intervals (i.e. daily), the text file is automatically<br>updated from the database<br><br>I now know how to do steps 1, 3 and 4 but I'm not so sure about 2 and
<br>clueless about 5.<br>The example <a href="http://openlayers.org/dev/examples/google.html">http://openlayers.org/dev/examples/google.html</a> has controls<br>that suggest it should be possible for user to add a marker to the map,
<br>but this example does not function for me (in Firefox <a href="http://2.0.0.7">2.0.0.7</a>, Windows<br>XP SP2)<br>I am hoping that someone has already implemented an example like this,<br>or accomplished the same thing by a different method.
<br>I should mention that this would all be operating in a shared webhosting<br>environment without root access.<br><br>Thanks, Tara<br><br><br><br>Linda Rawson wrote:<br>> Tara,<br>><br>> For SQL Server,<br>>
<br>> Take a look at this<br>> article...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882<br>><br>> OR<br>><br>> You can set up an ODBC link and connect to that link via Excel to<br>> produce a spreadsheet from which you could produce a text file.
<br>><br>> Linda Rawson<br>><br>><br>><br>> On 10/9/07, *Tara Athan* <<a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com</a><br>> <mailto:<a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com
</a>>> wrote:<br>><br>> I did finally run across the documentation on the textfile format<br>> here:<br>> <a href="http://trac.openlayers.org/wiki/MapViewerService">http://trac.openlayers.org/wiki/MapViewerService
</a><br>> Thanks for your help- I have it working now.<br>> Also thanks for the tip about working in Excel (or OpenOffice ;-)<br>> )- it<br>> is actually possible to create the text file in notepad but you
<br>> have to<br>> put the tabs in the right place and then they look the same as spaces,<br>> so it is very inconvenient.<br>> Working in a spreadsheet allows me to fill down for all the duplicate
<br>> icons, sizes, etc. instead of typing them out.<br>><br>> Now if I can just figure out how to get the textfile from a database<br>> query... anyone have an example of that?<br>> Tara<br>
><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br><a href="http://openlayers.org/mailman/listinfo/users">http://openlayers.org/mailman/listinfo/users
</a><br></blockquote></div><br>