MODULE: SearchDoc

[aymeric]

I developed a new module to index attachements. With this module, you can search in attachement content (Word, PDF, PowerPoint, Excell and Text file).

Screenshots:


Download:
Module SearchDoc version alpha

Thanks to post your feed back.

[aymeric]

SearchDoc is new module by SII Compagny. This module add a new tab "Search" who permit to search in the content of notes, emails and their attachements (Word, Excell, PowerPoint, RTF, PDF).

SearchDoc v1.0 :
- index Word, Excell, PowerPoint, RTF and PDF,
- search in content and title of Emails,
- search in content of Emails attachements,
- search in content and title of Notes,
- search in content of Notes attachements,
- results are sorted more relevant at least relevant,
- view, by default, first results, you can view all,
- when you return on the tab "Search", you have your last research result (words searched are stored)
- correct file with accents


This module install automatically in the file module the open source sofwares for windows :
- Catdoc/Catppt program which converts Word/Powerpoint files to ASCII text
- Xls2csv program which converts Excel spreadsheet into comma-separated value file
- wvWare is a library which allows access to Microsoft Word files. It can load and parse Word 2000, 97, 95 and 6 file formats. (These are the file formats known internally as Word 9, 8, 7 and 6.) There is some support for reading earlier formats as well: Word 2 docs are converted to plaintext.
- xPDF is an open source viewer for Portable Document Format (PDF) files.

Screenshots:

Download SearchDoc v1.0

[ssch]

Ok i try it and it's ok for me sugar 421b OS rhel 4

Good tools

Bon travail l'ami

[aymeric]

SearchDoc v1.1 fo download:
Changements : add image to result list if it's an attachement

[aymeric]

SearchDoc v1.2:
- search in description and name of Calls,
- search in description and name of Meetings,
- search in Contacts's description,
- secure correction (Entry Point),
- a new version for Linux by Pontus Bergendahl.

This module for Windows install automatically in the file module the open source sofwares for windows :
- Catdoc/Catppt/Xls2csv (http://www.45.free.net/~vitus/software/catdoc/)
- wvWare (http://wvware.sourceforge.net/)
- xPDF (http://www.foolabs.com/xpdf/)

On Linux, you must install this softwares before install SearchDoc Module

Download avaible on http://www.sugarforge.org/projects/searchdoc/ :

• patch SearchDo v1.x to v1.2 Windows
• module SearchDoc v1.2 Windows
• module SearchDoc v1.2 Linux

[miles932]

This is a great idea. Thanks for your efforts.

[aymeric]

New improvements on SearchDoc Module. You have an screenshot in attachement of this post.

SearchDoc v1.2.1:
- corrections of bugs for linux version by Pontus Bergendahl.
SearchDoc v1.2.2:
- add German language - thanks to Marcel Schoene.
SearchDoc v1.3:
- modification SQL query "CONVERT" to improve the compatibility,
- add choice beetween search "All words" or "One of the words",
- modification for compatibility with Candidates module.

Download : SearchDoc module v1.3

[malcolmh]

Great module, something that a lot of our customers have been wanting.

One question, have you done any tests to see if this module works with version 4.5?

[aymeric]

Great module, something that a lot of our customers have been wanting.

One question, have you done any tests to see if this module works with version 4.5?

For the moment, there is a problem with version 4.5. My table document_index is not create as version 4.2

Medata file :
$dictionary['document_index'] =
array ( 'table' => 'document_index',
'fields' => array (
array('name' =>'id',
'type' =>'id',
'required'=>true,
'default'=>''),
array('name' =>'document_text',
'type' =>'text')
)
);

Version 4.2.
table document_index
id - char(36) | document_index - longtext

Version 4.5.
table document_index
id - char(36) | document_index - text

field 'text' is too short therefore, documents are not indexed.

I will add an ALTER TABLE commande

[malcolmh]

Hi,

found a strange thing, that seems to be caused by the SearchDoc module.

When the module is installed and I go and look at the dashboard as a normal user, I get the following error message:

Query Failed:SELECT notes.id,notes.filename FROM notes INNER JOIN team_memberships team_memberships ON .team_id = team_memberships.team_id AND team_memberships.user_id = 'be07f229-e4d7-6d41-a7f2-44ede6a28656' AND team_memberships.deleted=0 LEFT JOIN teams ON notes.team_id=teams.id LEFT JOIN contacts ON notes.contact_id=contacts.id where filename IS NOT NULL AND notes.id NOT IN (SELECT id FROM `document_index`) AND (contacts.deleted IS NULL OR contacts.deleted=0) AND notes.deleted=0 ORDER BY notes.name::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= team_memberships.team_id AND team_memberships.user_id = 'be07f229-e4d7-6d' at line 2

When I deinstall the SearchDoc module, everything works OK.

Working with Sugar Professional 4.2.1b. Been replicated in two systems, both Linux server