Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Previw

https://forum.openkm.com/viewtopic.php?t=10676

Page 1 of 1

Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Previw

PostPosted:Thu Aug 22, 2013 7:28 am
by Muhammad Imran
Hi,
I have installed OpenKM 6.2.2 on windows XP. I have configured it to replace HSQLDB with MySQL. Right now, in OpenKM .png .jpg .docx .txt .gif etc. preview is working well but the preview of files with extensions .tif, .ppt and .xls is not working.

when I want to preview .xls, I see the following error:
Conversion: Error in application/vnd.ms-excel to PDF conversion

when I want to preview .ppt, I see the following error:
Conversion: Error in application/vnd.ms-powerpint to PDF conversion

when I want to preview .tif,I see the following error:
Conversion: Error: May not be a PDF file (continuing anyway)
Error: PDF file is damaged - attempting to reconstruct xref table...
Error: Couldn't find trailer dictionary
Error: Couldn't read xref table
I have installed and configured the following softwares:
1. Imagemagic
2.swftools
3.tesseract
4.openoffice

I have also checked my configurations in the administration -> configuration -> configuration chek
My OpenKM configurations are also OK.

I also check on command line the imagemagick converts .tif to pdf successfully.
Code: Select all
convert *.tif imagenes.pdf
Please tell me where i am wrong...!
Thanks in anticipation,

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Sat Aug 24, 2013 3:58 pm
by jllort
i suggest take a look here:
http://wiki.openkm.com/index.php/Previsualization

To ensure soffice is correctly running, simply add text file into openkm and then try to download as pdf ( toolbar option ) if it's right then soffice service is correct otherside there's something wrong there.

Take in mind depending your ms office version can not be opened by openoffice, anyway openoffice ( or libreoffice ) service is first step manadatory to preview document.

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Mon Aug 26, 2013 8:35 am
by Muhammad Imran
Thanks for reply,
I can download the .txt file into .pdf file successfully. Now the .ppt and .xls preview is also working but the .tif preview is still not working.
I tested with scanned balck and white .tif image at 300 dpi, On uploading a new .tif image in OpneKM I can see the following error message:
Conversion: Document can not be opened
Please guide me to fix this problem.

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Tue Aug 27, 2013 10:06 pm
by jllort
is correctly configured the ImageMagick convert utility path ?

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Wed Sep 11, 2013 7:34 am
by Muhammad Imran
Yes the imagemagic is installed and configured correclty but the .tif image preview is not working.

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Thu Sep 12, 2013 5:48 am
by pavila
Can you see any error in $TOMCAT_HOME/logs/catalina.log ?

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Thu Sep 12, 2013 10:58 am
by Muhammad Imran
When I tried to preview the .tif image , I can found the following error messages loged in $TOMCAT_HOME/logs/catalina.log file.
Code: Select all
2013-09-12 15:50:11,655 [Thread-139] INFO  com.openkm.util.DocumentUtils - Using OpenOffice dictionary: C:\Program Files\gs\gs9.05\bin\en_US.oxt
2013-09-12 15:50:20,078 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - TEXT: PHP'sawHdy—Isedganai—plposcsa'pfingk|gIngelIm'sq)e<HysiedfmW& dcvdopInaimd<x1beuIbeddediioHTMT.. lfyouxencwIoPHPmdwaiIogd mmuaqmwawmmnymmoaummuamanmamammofig mom 1hep1aPdevaopma::a.n..umes:neh.md'mavauay(£p1aps419..dp1ap S S 3 1I.=uaasgsanbug;..:1.epad.£o. CVE—20l3—4Z4R ;..opa.ssL.md..e..d ¢xmp:eu..ewinzTsmbedhpH1>s4 AlPHPus»usxeanooIl3gedIo1pgndeIo e'IhaPHP553orPHP54 9 1I.ep1aPdevaopman:a.n...a.noes:1.ei..md'mavau;ay(£paPss2 About lo bung waefixed. blinding Rollie's Me s..opa.ssL.md..e (cv|~:,2o13r4z4x) sand ss'lonfixx'x>n;xoHun(CVE—20ll—47lR) Alisa Pm Ac anoollagedloipgnde ignoramus's 
2013-09-12 15:50:20,235 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - Rotate image 90 degrees
2013-09-12 15:50:39,160 [Thread-139] INFO  com.openkm.util.DocumentUtils - Using OpenOffice dictionary: C:\Program Files\gs\gs9.05\bin\en_US.oxt
2013-09-12 15:50:43,317 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - TEXT: —vEuvWNSr—l«AMbAnfl.fl1‘EiE8hmxugFmrfi—flmo_FIW%0«l«!IoAmcn§~% ._n<%ual!._.N:x8_eo&&loma:H —».<0=lo:nS_o—vEuvNK—¢«II_0nR 8an:fl&_5sms9E.5_?r:o&n3i9K>=n_.F&&.ea_?o1I tall arn_.mvmn<mauann.flBIu§Ivfl5nIaR_lon<lueE«&_.mv€. GuR:.E. M M W ._..nn.a_HRmuus=n_.._..nufl§mi o<m‘no5L§m rouflmmraofiklm 9.aurE§s:.§mnueEr..E.€. >:.E.a3non.8aum&.o€uu.r.o a.-..n_...=.mmw9_.E.:G ..x..E.._n<mauan..nau-§Ivn__.nm.aR_lou<unuerfne.:;mn >538 E misnomers E 39.5 Fey roaflmmraxrk fi<mE:f.§_c Ax mZ.§m.u.§1o:n=fi<m‘8_Z:5 3 3 In n.8.-#&.o€uir .o__.w.miK 
2013-09-12 15:50:43,317 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - Rotate image 180 degrees
2013-09-12 15:50:51,021 [Thread-139] INFO  com.openkm.util.DocumentUtils - Using OpenOffice dictionary: C:\Program Files\gs\gs9.05\bin\en_US.oxt
2013-09-12 15:50:54,647 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - TEXT: umuw.n..__o. u_En§o.1ouE..§u eon .E.=o 9 c::l.e.wm>ov§3olu9.neu9.fim 1 £§#me.wm>ov ieeaqmmamoi Si 358 mused Queens 3 S...3< umm.E..u;iai§uuu_eua£u.__uaauaa=E.E=§1.u_:_H....ufi a:m.E..5mmm._m..u._.B o.u_En§o:vouwE§uonwu!._m..-< em.=......:u.i.um.§._..:uu_.u.uuaaoo uiieeaqmmamoi m§#me.wm>o5uiumue1u3u£flmuw.uu..n M M M ._m..1i.:.Vm._mau;iau1.uuu_eua££_uaEuaua5.E=&a1.ue._maufi 1-E. I1o1_uo%afida_uu<15u.Eu€oi£_F«ioz.s£%E:ua3 uuo.Hz_xn.E..o.:!on.§= ,_Shmolue_%oaE3.EuiEaa%..us aoBs%o1n»1aoaflmua_uuEu£u1.i.nm8%:m‘1uEuvo!‘»1::um._ma 
2013-09-12 15:50:54,662 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - Rotate image 270 degrees
2013-09-12 15:51:02,648 [Thread-139] INFO  com.openkm.util.DocumentUtils - Using OpenOffice dictionary: C:\Program Files\gs\gs9.05\bin\en_US.oxt
2013-09-12 15:51:06,414 [Thread-139] INFO  com.openkm.extractor.Tesseract3TextExtractor - TEXT: anp.s_q.ou °I’=|3<iI0IW5“|W'” sen Mar armlets (8ILt7’II0‘£’EiA£))""M°l“‘”.¥"!l"°'.W5 W (xmz—sIoz—:~mo) Wl’°""JSS‘9d0"! 9 KI.-ms 5"!P'¥"'! 1>°r!I=m« sfinq ozlnoqv z§§¢|H¢[_pKQ1ppA:9n5)oullq:q1s<xlkxI2IIIDIIBui‘°P‘9PdHd°'Il 1 vsaualosssauavw °I=P=I3<iI°II>°5u-06-M-Esrvslax-Ialv VSJI-]d"!P°|‘F'°S.l.Z‘W“°l!“.|°l“"'°° P"”W!’°""JSS‘9d0"! 8vZv’SI0Z'3AI)1°J‘F>DdWl"!5"I“‘!l§’3”P”5‘|l. 5 S S dHdP"”6I vsmapwrsnwefiwuwwswnmma-umopwmam plume wmwmmvpwnwnwmmnwwwmvwmumwywnwm v=50IImoPI!¢|I-IJOIMBIHINIOKJI 1w.L(-1°I!ww°<l-=°°q‘=wI-Elm-i<=P«=P ¢PmmJP°!IsKrP°ds>swm=5m5|=I5!v!rvWs°d-fl—FH95wm—KPnMsa}1a 
2013-09-12 15:52:30,722 [http-bio-0.0.0.0-8080-exec-10] ERROR com.openkm.servlet.frontend.ConverterServlet - The document is not open.
java.lang.RuntimeException: The document is not open.
	at com.lowagie.text.pdf.PdfWriter.getDirectContent(Unknown Source)
	at com.lowagie.text.pdf.PdfDocument.newPage(Unknown Source)
	at com.lowagie.text.pdf.PdfDocument.close(Unknown Source)
	at com.lowagie.text.Document.close(Unknown Source)
	at com.openkm.util.DocConverter.tiff2pdf(DocConverter.java:605)
	at com.openkm.servlet.frontend.ConverterServlet.toPDF(ConverterServlet.java:198)
	at com.openkm.servlet.frontend.ConverterServlet.toSWF(ConverterServlet.java:259)
	at com.openkm.servlet.frontend.ConverterServlet.service(ConverterServlet.java:127)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
2013-09-12 15:52:30,957 [http-bio-0.0.0.0-8080-exec-10] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[ConverterServlet] - Servlet.service() for servlet [ConverterServlet] in context with path [/OpenKM] threw exception [com.openkm.frontend.client.OKMException: The document is not open.] with root cause
com.openkm.frontend.client.OKMException: The document is not open.
	at com.openkm.servlet.frontend.ConverterServlet.service(ConverterServlet.java:171)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Mon Sep 16, 2013 7:18 am
by pavila
I would recommend to try a recent night build.

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Fri Sep 20, 2013 6:48 am
by Muhammad Imran
Thank you for helping me.Now I have installed OpenKM 6.2.4. In this version of openKM the .tif preview is working well.

Re: Excel(.xls), Power Point (.ppt) and Tiff Image(.tif) Pre

PostPosted:Fri Sep 20, 2013 10:12 am
by pavila
Thanks for the feedback.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited