Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: MODULE: SearchDoc

  1. #1
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Arrow MODULE: SearchDoc

    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.
    Last edited by aymeric; 2006-08-10 at 03:35 PM.
    Aymeric

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  2. #2
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Smile Re: MODULE: SearchDoc

    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:


    Last edited by aymeric; 2006-08-10 at 03:36 PM.
    Aymeric

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  3. #3
    ssch is offline Sugar Community Member
    Join Date
    Aug 2005
    Posts
    34

    Default Re: MODULE: SearchDoc

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

    Good tools

    Bon travail l'ami

  4. #4
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Default Re: MODULE: SearchDoc

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

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  5. #5
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Smile Re: MODULE: SearchDoc

    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
    Aymeric

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  6. #6
    miles932 is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    20

    Default Re: MODULE: SearchDoc

    This is a great idea. Thanks for your efforts.

  7. #7
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Smile Re: MODULE: SearchDoc

    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
    Attached Images Attached Images  
    Aymeric

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  8. #8
    malcolmh's Avatar
    malcolmh is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Aug 2004
    Posts
    1,712

    Default Re: MODULE: SearchDoc

    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?
    Cheers Malcolm

    Genius4U Limited - Ingenious simple IT solutions for you / Genial einfache IT Lösungen für Sie
    http://www.genius4u.com or http://www.genius4u.de

  9. #9
    aymeric is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    32

    Exclamation Re: MODULE: SearchDoc

    Quote Originally Posted by 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?
    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
    Aymeric

    SII Compagny created SearchDoc module, SearchCandidates module, and SharedCalendarByMonth patch.

  10. #10
    malcolmh's Avatar
    malcolmh is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Aug 2004
    Posts
    1,712

    Default Re: MODULE: SearchDoc

    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
    Cheers Malcolm

    Genius4U Limited - Ingenious simple IT solutions for you / Genial einfache IT Lösungen für Sie
    http://www.genius4u.com or http://www.genius4u.de

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •