<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space"
bgColor=#ffffff>
<DIV>I am also looking for the same function for an international site. I
am not a coder and have no idea about how to go about creating these dependent
drop-downs. In the meantime, i would like to make due with a simple
drop-down list of the global state/province list that is in civicrm.</DIV>
<DIV> </DIV>
<DIV>I have created a custom (project) profile form in Drupal and would like to
know the simplest way to export the global state/province list that is in
civicrm into a cck custom field list.</DIV>
<DIV>does anyone know how i can do this?</DIV>
<DIV> </DIV>
<DIV>thanks,</DIV>
<DIV>grace</DIV>
<DIV><BR><FONT face=Arial size=2>*********** REPLY SEPARATOR
***********<BR><BR>On 3/7/2007 at 11:40 PM Neil: esl-lounge.com
wrote:</FONT></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid">
<DIV><FONT face=Arial size=2>Laura, </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have already looked at the Location module and
it isn't quite what I want, although I may revisit it. This is going to be a
global site and the txt files available are not complete. Once I have a basic
Profile/Register page set up with autocomplete working to gather users' towns,
I may look to Location as a additional tool but it isn't complete enough (yet)
to do what I want. Maybe I didn't spend enough time on it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My original idea was to use dependent dropdowns
as a way of avoiding free text boxes and cut down on misspellings, etc. It
seems nye on impossible to get effective dependent dropdowns set up on Drupal
and we have been pulling our hair out over the DependantDropdown module which
is buggy and with zero documentation. So now our attention has turned to this
autocomplete idea as long as we can pre-populate and if possible, add other
info (such as state) to the dropdown itself once a user starts typing.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks for your response.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Neil</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=laura@pingv.com href="mailto:laura@pingv.com">Laura Scott</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=support@drupal.org
href="mailto:support@drupal.org">support@drupal.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 07, 2007 5:47
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [support] More effective
use of auto-complete in Profile</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>On Mar 7, 2007, at 4:58 AM, Neil: esl-lounge.com wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<P style="MARGIN: 0px"><FONT style="FONT: 10px Monaco" face=Monaco
size=2>Unfortunately, I have a selection of 23,000 towns so that is not
practical.<SPAN class=Apple-converted-space> </SPAN></FONT></P>
<P style="MARGIN: 0px"><FONT style="FONT: 10px Monaco" face=Monaco
size=2>Isn't there a way of getting the autocomplete to "look" in a
different table<SPAN class=Apple-converted-space> </SPAN></FONT></P>
<P style="MARGIN: 0px"><FONT style="FONT: 10px Monaco" face=Monaco
size=2>for values?</FONT></P></BLOCKQUOTE></DIV><BR>
<DIV>I wonder if it might be more direct to build off of the location module
as it already works with user profiles and has this info in the us zipcodes
table (albeit with some cities listed multiple times, listed once for each
zip code contained within). Then the issue is doing the autocomplete ajaxy
interface with otherwise existing functionality. Or am I missing
something?</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>Laura</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<P>
<HR>
<P></P>-- <BR>[ Drupal support list | http://lists.drupal.org/
]</BLOCKQUOTE><FONT size=2 Arial></BLOCKQUOTE></FONT></BODY></HTML>