cancel
Showing results for 
Search instead for 
Did you mean: 

Excel not indexed in Alfresco 2.9B and 3.0B

gfeguiguren
Champ in-the-making
Champ in-the-making
Hi everybody!

First of all I would like to congratulate this excellent community and product  Smiley Very Happy , is the only one open source ECM project  that offers a complete set of features: Office plugins,  WebDav, CIFS, Web scripts….  at no cost and quality documentation.

I´m integrating some small application in PHP using phpIntegration.amp library with Alfresco2.9b , right now is working, but I realized in testing that the content of the Excel files (most of them Excel 2003 format) are not indexed or not appearing in search results.

Then I thought it could be related with some mistake in the code. So I started to upload excel files directly in the Alfresco Web Interface, and still the problem persist. When I search for a phrase or a word (that is inside the excel file ) using standard and advanced mode of the web interface, I didn´t get any result. I have tried with various excel files (2003 format) and I´m not getting them as result of the search in the alfresco web interface results.

Then I tried with the new version 3.0B and is the same.  Actually I realized that the search of phrases inside some pdf files are also not working.
In fact I think that just word files are being corrected indexed and appear in the search results when you look for a phrase inside them.

My testing environment  is : Windows XP SP2, MySql 5.0.45-community-nt,  Apache 2.2.4  and I’m using the tomcat bundles of Alfresco 2.9B and 3.0B 

I will appreciate any help and suggestions around this.

Thanks in advance for your kind and valuable help

Regards,

Gabriel
2 REPLIES 2

spotlight2001
Champ in-the-making
Champ in-the-making
do you have any errors in your log ?

if you have POI (… hssf or similar) errors, upgrading the library might help.
in Alfresco 2.9B you would have to recompile OfficeMetadataExtracter.java against the upgraded lib

gfeguiguren
Champ in-the-making
Champ in-the-making
Hi, thanks for your help.

Regarding to your question: I actually review the log files in tomcat and also Alfresco.log and Ididn't find any error or warning. when I upload an excel file (create content in a space)  or when I try to search for some text phrase contained in this excel file.

Could you please explain me wich library do I have to upgrade?.

Thanks in advance,

Gabriel