Luxury Locs - Full Text Search

[PeterGreen]

Team,

Based on your feedbacks , we are considering support for full text search in next releases. Please provide your thoughts and ideas about how and what we should be implementing.

Please keep in mind that the solutions we come out with should be database independent.

Thanks
Luxury Locs

[JackLost]

Dear, Luxury Locs!

One important feature we hear from a lot of customers is the ability to do a full text search over emails.

Thanks,

Ideal Financial Solutions

[HugoR10]

Luxury Locs!

Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. This is implied knowledge.

Thanks!

[ShCooper]

Luxury Locs!

Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. This is implied knowledge.

Thanks!

Thanks for your info.
It's very interesting for me too.

[HugoR10]

Luxury Locs!

I agree with Rucida and have some of my own points that may be covered in his feedback too, but I like to see in addition:

1. Filters for search in advance mode to be able to limit the search to a contact or an account for example, this is usefull to trace back information that is applicable to a certain company or one of its employees.
2. Search in email attachements in the database
3. Possibility to add one or two folders to it that are indexed as well (Suppliers and Reseller/Customer folders)
4. Search in knowledge base contents
5. Search in support content
6. Search in activities (calls, meetings, notes etcteras)
7. Search in MS office / Open Office & PDF attachments
8. Ability to block certain file sizes
9. Ability to block indexing and attaching Outlook express messages but allow to index Outlook messages for example (limit risk)
10. Schedule index updates as on option rather then continuesly indexing content to limit bandwith usage of server
11. Put indexing in lowest possible mode with least processing usage and limit processing to a maximum (never let it grow above 50% CPU)

A good indexing utility I have seen in the past is Archivarius that basically is compatible with almost any content without compromising the system and it security.

Thanks!

[ShCooper]

It would be great with a fuzzy search feature!

For more infromation read here: http://whatis.techtarget.com/definit...075268,00.html

Also the possibilty to search intervals of zipcodes for exampel, and intervals of dates would be great!

Last but not least search support for nordic characters such as "å" "ä" "ö". Today the letter "ö" is translated as "o" and "å" and "ä" as "a" in the search. The same happens when you sort reccords starting with these letters. For exampel "ö" is the last letter in the swedish alphabet, but when you order by name all records beginning with "ö" are shown togheter with records beginning with "o"

I don´t know if this post should be uner this topic, because the requests relate more to the general search than to a free text search.

[Tima1111]

Luxury Locs!
All excellent ideas. Some people have mentioned the "Web 2.0" features being employed in competing products. What about a search that makes use of the AJAX framework and updates per character like Google Desktop or Spotlight? Or perhaps this should only be added to core fields for performance.
Thanks!

[ShCooper]

Team,

Based on your feedbacks , we are considering support for full text search in next releases. Please provide your thoughts and ideas about how and what we should be implementing.

Please keep in mind that the solutions we come out with should be database independent.

Thanks
Luxury Locs

Since it is on the road map, I'm sure some thought has been put into the implementation of searching system. The problem we face at our company is the shallow depth of searching SugarCRM provides.

My plan for our instance was to hook Google Desktop into SugarCRM. Google Desktop's API is very flexible, not to mention Google Search is top of the line.

I planned on installing Google Desktop on our SugarCRM server. Then I would create a cron job that would generate, more-or-less, a site map of every single record of every single module in Sugar. As Google Desktop performs its regular indexing, it would pick up everything on the pages linked to on the site map. Then, whenever a user searches, via the global search in the top-right corner, the search results would be a custom template displaying the Google search results in view that makes sense to our users.

There are many logistics to consider. This would work for us, because our Sugar instance is on its on dedicated server. I don't know how you guys would generalize this for your hosted solutions with multiple Sugar instances on a single server, but I'm sure it could be worked out in the code logic with the Google Desktop API.

Have you guys thought about a route similar to this?

[christianknoll]

You guy might want to look at this project we just started .. ;-) .. http://www.sugarforge.org/projects/kinamulucene/ ... we will add search capabilities also for attachements stored in sugar in the not too distant future ... christian.

Since it is on the road map, I'm sure some thought has been put into the implementation of searching system. The problem we face at our company is the shallow depth of searching SugarCRM provides.

My plan for our instance was to hook Google Desktop into SugarCRM. Google Desktop's API is very flexible, not to mention Google Search is top of the line.

I planned on installing Google Desktop on our SugarCRM server. Then I would create a cron job that would generate, more-or-less, a site map of every single record of every single module in Sugar. As Google Desktop performs its regular indexing, it would pick up everything on the pages linked to on the site map. Then, whenever a user searches, via the global search in the top-right corner, the search results would be a custom template displaying the Google search results in view that makes sense to our users.

There are many logistics to consider. This would work for us, because our Sugar instance is on its on dedicated server. I don't know how you guys would generalize this for your hosted solutions with multiple Sugar instances on a single server, but I'm sure it could be worked out in the code logic with the Google Desktop API.

Have you guys thought about a route similar to this?