Ajax AutoComplete Support Product Page

This topic was archived

First use, request and Jquery

Shared 24 Sep 2007 00:56:45
1
likes this idea
24 Sep 2007 00:56:45 David Chamberlain posted:
I used this extension in anger for the first time today with a bit if trepidation as I thought I was being ambitious in it's use.

The autocomplete widget selects from a database of about 51000 items which are all the place names in the UK Gazateer. I thought there would be performance problems but that is not the case - it is well within the bounds of acceptability.

Also in the database I created is a number of other fields for each place such as administrative district, EU region, police authority, county, datum84 latitudes and longitudes and the 6character OS reference.

So now to the requests -

A way of making this a template.

I think I saw some of the functionality using the jquery library. Does this mean we can expect some more goodies from the JqueryUI widgets and Jquery itself. I would love to have the whole lot implemented where possible as DW extensions.

On the autocomplete. The UK has a database designers nigthmare of a system for listing where you live. For example my 'village' is Southfields which is in Surrey which is in the London EU region. Not all of Surrey is in the London Region. My admin district is Wandsworth, which is all in the London region but does not come under the Surrey county council or the Surrey Police but under the Metropolitan Police area. I do not come under any unitary council. If you ask me where I live I say Wandsworth, if you ask my neighbour they will say Southfields and technically we are both correct. So what I did was call a field "rationalised" and made a rule to select which of the various options was used as a second level - so I had first level = place, 2nd level = rationalised and third level EU region and concatenated these into one string so that in the autocomplete you have 'place' followed by a description which is this concatenated string. The thing I would like to do is be able to search for matches in that second level of the description or the third level so that in the case of Southfields

select = "Southfields" description = "Southfields, Wandsworth, London" if I typed in "Wan" it would also list the Southfields select.

Also I have found that if you have too may matches the list of options is not scrollable. Type more letters and you reduce the number but it might get to the stage where you have completed a whole "select" value and still have too many entries.

Finally if anybody want the data (excel format) that I used then let me know and I will make it available.

If a cannibal uses a knife and fork is that progress?

Replies

Replied 24 Sep 2007 11:18:40
24 Sep 2007 11:18:40 George Petrov replied:
Hi David,

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I used this extension in anger for the first time today with a bit if trepidation as I thought I was being ambitious in it's use.

The autocomplete widget selects from a database of about 51000 items which are all the place names in the UK Gazateer. I thought there would be performance problems but that is not the case - it is well within the bounds of acceptability.

Also in the database I created is a number of other fields for each place such as administrative district, EU region, police authority, county, datum84 latitudes and longitudes and the 6character OS reference.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Yes you have indeed a complicated case - but it should be manageable.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
So now to the requests -

A way of making this a template.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Could you explain what do you mean under "template" ?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I think I saw some of the functionality using the jquery library. Does this mean we can expect some more goodies from the JqueryUI widgets and Jquery itself. I would love to have the whole lot implemented where possible as DW extensions.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Yes we are going very much in the direction of using jquery as our primary ajax/dhtml library. So you will see in the future more and more jquery based extensions from us. It is a great framework with small footprint but very powerfull and javascript unobstrisive. So that is the way to go!

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
On the autocomplete. The UK has a database designers nigthmare of a system for listing where you live. For example my 'village' is Southfields which is in Surrey which is in the London EU region. Not all of Surrey is in the London Region. My admin district is Wandsworth, which is all in the London region but does not come under the Surrey county council or the Surrey Police but under the Metropolitan Police area. I do not come under any unitary council. If you ask me where I live I say Wandsworth, if you ask my neighbour they will say Southfields and technically we are both correct. So what I did was call a field "rationalised" and made a rule to select which of the various options was used as a second level - so I had first level = place, 2nd level = rationalised and third level EU region and concatenated these into one string so that in the autocomplete you have 'place' followed by a description which is this concatenated string. The thing I would like to do is be able to search for matches in that second level of the description or the third level so that in the case of Southfields

select = "Southfields" description = "Southfields, Wandsworth, London" if I typed in "Wan" it would also list the Southfields select.

Also I have found that if you have too may matches the list of options is not scrollable. Type more letters and you reduce the number but it might get to the stage where you have completed a whole "select" value and still have too many entries.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Wow! - Ok to summarize - we will add support for also searching in the secondary fields - that should help you <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Finally if anybody want the data (excel format) that I used then let me know and I will make it available.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Yes sure send it over so we can test.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------
Replied 25 Sep 2007 12:22:28
25 Sep 2007 12:22:28 David Chamberlain replied:
Appreciate the new 101 release - thanks.

If you are building more on Jquery can I petition for a decent slider.

the features I would like are
* specify min and max value and per pixel increments
* snap to values
* user specifiable back ground image for slider including some templates
* various types of pointer
* more than one pointer per slider with each pointer bound to a different form value
features to take it into the stratosphere
* I don't know the best way to describe this but a slider that increments in (say) 1000 per pixel below 100000, 5000 per pixel from 100000-500000, 10,000 per pixel after that.
* nudge a single pixel either way buttons
* slider that follows a path rather than a straight line

Reply to this topic