<div>Tara,</div>
<div> </div>
<div>For SQL Server,</div>
<div> </div>
<div>Take a look at this article...<font size="2"><a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882</a></font></div>
<div>
<p><font size="2"> OR</font></p>
<p><font size="2">You can set up an ODBC link and connect to that link via Excel to produce a spreadsheet from which you could produce a text file.</font></p><font size="2">Linda Rawson</font><br> </div><br><br>
<div><span class="gmail_quote">On 10/9/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 did finally run across the documentation on the textfile format 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 ;-) )- it<br>is actually possible to create the text file in notepad but you 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>Robert J Becraft wrote:<br>> See my example at <a href="http://www.metaphaze.com/Avalon/AMII_world_map.htm">
http://www.metaphaze.com/Avalon/AMII_world_map.htm</a><br>><br>> You will need to use Excell to create the txt file. Type each column<br>> in the spreadsheet, then export as a .txt file. It puts tabs between<br>
> the columns, and makes it readable to OpenLayers. Using notepad won't<br>> work. The column headers are keywords that specify what type of data<br>> is in that column. I don't have the link to the help page I found
<br>> this on, it is on the OpenLayer's site though.<br>><br>> I positioned the icon's over the first letter of the layer with the<br>> country names on it. You can see this when zooming in. I did this by
<br>> hand with the spreadsheet open and adjusted the LAT/LON values,<br>> exporting and reloading the web-page until they were close.<br>> The icon's themselves are 25x25 pels, I don't adjust the size. It
<br>> seemed simpler to have them the actual size I wanted them to appear on<br>> the map. They are transparent gifs.<br>><br>> Eventually the text detail will come in from a dynamic piece of code I<br>> haven't finished writing. One idea I'm toying with is to build a menu
<br>> in the popup that zooms to a variety of features for each of the<br>> countries. The final product will depend on my time and how well it<br>> works when I get to it.<br>><br>> Erik Uzureau wrote:<br>
>> Here is example/textfile.txt<br>>><br>>> point title description icon<br>>> 10,20 my orange title my orange description<br>>> 2,4 my aqua title my aqua description<br>
>> 42,-71 my purple title my purple description<br/>is<br>>> great. <a href="http://www.openlayers.org/api/img/zoom-world-mini.png">http://www.openlayers.org/api/img/zoom-world-mini.png</a><br>>>
<br>>><br>>> You need to add new columns for iconSize and iconOffset, so something<br>>> like this:<br>>><br>>> point title description icon iconSize iconOffset<br>>> 10,20 my orange title my orange
<br>>> description <a href="http://example.com/icon.jpg">http://example.com/icon.jpg</a> 50,50 20,20<br>>><br>>><br>>> On 10/8/07, Tara Athan <<a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com
</a>> wrote:<br>>><br>>>> Erik- sounds good but how do I do that- is there an example<br>>>> somewhere to<br>>>> follow?<br>>>><br>>>> Tara<br>>>><br>>>>
<br>>>> Erik Uzureau wrote:<br>>>> Hi Tara,<br>>>><br>>>> What you want to do is to specyify iconOffset and iconSize columns in<br>>>> your text file.<br>>>><br>>>> Erik
<br>>>><br>>>><br>>>> On 10/8/07, Tara Athan <<a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com</a>> wrote:<br>>>><br>>>><br>>>> I am trying to add nondefault icons for markers using
Layer.Text<br>>>> (because I plan to have a large, dynamic set of markers)<br>>>> I want the marker to be smaller than the default marker.<br>>>> Passing a rescaled version of a larger marker caused it to be enlarged
<br>>>> and stretched and look really bad.<br>>>> I sort of got it working by placing a marker into a larger canvas, but<br>>>> the tip of the marker doesn't seem to be in quite the right place.
<br>>>> Is there some documentation on this, or another way to handle it?<br>>>> Also, is there a way to specifiy the image file for all the markers<br>>>> in a<br>>>> text file without repeating the path in every line?
<br>>>><br>>>> Sample script at<br>>>> <a href="http://alt2is.com/pages_html/openlayers/marker.html">alt2is.com/pages_html/openlayers/marker.html</a><br>>>><br>>>> Thanks, Tara
<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>>>><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>> --<br>>>> My e-mail delivery has been unreliable lately, so I am asking for
<br>>>> return receipts from all my email messages.<br>>>> OK'ing the return receipt lets me know that my message was delivered.<br>>>> Thank you.<br>>>><br>>>> Tara Athan<br>
>>> Principal, Alternatives to Invasive Species<br>>>> <a href="mailto:tara_athan@alt2is.com">tara_athan@alt2is.com</a><br>>>> 707-485-1198<br>>>> PO Box 415<br>>>> Redwood Valley, CA 95470
<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>>>><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>>><br>>><br>><br>><br>><br><br><br>--<br>My e-mail delivery has been unreliable lately, so I am asking for
<br>return receipts from all my email messages.<br>OK'ing the return receipt lets me know that my message was delivered.<br>Thank you.<br><br>Tara Athan<br>Principal, Alternatives to Invasive Species<br><a href="mailto:tara_athan@alt2is.com">
tara_athan@alt2is.com</a><br>707-485-1198<br>PO Box 415<br>Redwood Valley, CA 95470<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>