Hi Alex,

Thanks. A few more questions:

I would like the Telephone field to accept 8-digit numbers, which is common in 
Norway. At the moment I have to prefix with +47, otherwise I get "Bad phone 
number format".

How difficult would it be to create export and import functions, e.g. to and 
from tab-separated files? This could be separate utilities, i.e. not a part of 
the GUI.

How about sorting the names case-insensitive? Now "Willy" comes before "von". 
For a Norwegian, it would also be nice if Å came after Ø, at least in a more 
serious application than this. I’m just curious. ;-)


On 13. Jan, 2015, at 13:42, Alexander Burger <a...@software-lab.de> wrote:

> Hi Jon,
>> When I’m typing in one of the search fields (Name or Address), a box
>> with possible matches pops up, but quite often there are names/addresses
>> missing in this box, and I haven’t been able to find a pattern in this.
>> If I type a (single) j, k, l, e, i or s, then my name comes up, but not
>> if I type just o, n or r. Do you know why?
> Yes. The 'nm' relation in the DB model
>   (rel nm (+Sn +IdxFold +String))
> uses two index prefixes:
>   1. +Sn for the soundex algorithm. It stores a condensed and unified
>      pattern in the DB index tree. In case of e.g. "Jon Kleiser" this
>      is "JNSLSR". This pattern is used for tolerant searches.
>   2. +IdxFold applies the 'fold' function the whole name, and stores it
>      (i.e. "jonkleiser") in the index. Then it splits the name on
>      blanks, 'fold's the fragments, and stores substrings of these
>      fragments.
> But: The substrings are generated only up to a maximal length of three.
> This is to avoid storing lots of single- or double-letter tokens - which
> are not meaningful to search - in the index.
> Thus, "jon" is stored, but not "on" or "n".
> If you dump the index, you'll see what's there:
>   : (scan '(nm . +Prs))
>   ("JNSLSR" {2} . T) {2}
>   ("eiser" {2}) {2}
>   ("iser" {2}) {2}
>   ("jonkleiser" . {2}) {2}
>   ("kleiser" {2}) {2}
>   ("leiser" {2}) {2}
>   ("ser" {2}) {2}
> Thus, when you type in the search field, this index is accessed. Typing
> "iser" or only "ser" will find something, but "o", "n" or "r" won't.
> ♪♫ Alex

PԔ � &j)m����X�����zV�u�.n7�

Reply via email to