Hi,

In reference to this previous post (https://answers.laserfiche.com/questions/81890/Removing-Electronic-Doc-Extensions-from-Search-Options) we have another client who has nearly 1600 file extensions in their list of file extensions when searching. This is a pain point for the users who are faced with a very long list of extensions. We appreciate you can type the first few letters but it is still a little unwieldy. 

This list seems to come from the "extension_cache" table and results from the way Laserfiche seems to incorrectly parse the file extension when importing documents. For example, if a file is named "Letter to Client.final.pdf" then it assumes the extension to be ".final" - the exact mechanism may be slightly different but it's along those lines.

We'd like to purge this table and include only "proper" extensions - .pdf, .msg etc. Will cleaning this table have any undesired effects? I appreciate direct SQL updates aren't generally supported but this seems to result from a bug and there is no other front end for managing this.

Thanks,

Nigel.