OpenKM 6.2 Mail Import

OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
Post Reply
Rudolf21
Junior Boarder
Junior Boarder
Posts: 34
Joined: Fri Aug 19, 2011 6:43 am

OpenKM 6.2 Mail Import

Post by Rudolf21 »

I've added a mail account to a user and configured the SMTP server in server.xml.
OpenKM successfully imports every mail but it also creates additional folders named by the date.

Example structure:
-User Mail Folder
--2012
---11
----18
-----Mails

Is there a way to deactivate this behavior?

Thanks in advance.

pavila
Moderator
Moderator
Posts: 3077
Joined: Tue Dec 11, 2007 6:02 pm
Location: Alicante, Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by pavila »

You can configure mail filters. Take a look at http://wiki.openkm.com/index.php/Administring_users.

jllort
Moderator
Moderator
Posts: 11204
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by jllort »

As indicate pavila this allow you to create this kind of folder structure or not ( there's a checkbox for it).

Rudolf21
Junior Boarder
Junior Boarder
Posts: 34
Joined: Fri Aug 19, 2011 6:43 am

Re: OpenKM 6.2 Mail Import

Post by Rudolf21 »

Looks like editing and deleting mail filters doesn't work:

Code: Select all

Class: 	  com.openkm.core.DatabaseException
Message: 	Provided id of the wrong type for class com.openkm.dao.bean.MailFilter. Expected: class java.lang.Long, got class java.lang.Integer

jllort
Moderator
Moderator
Posts: 11204
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by jllort »

It's a bug. Can see more stack trace log ?

pavila
Moderator
Moderator
Posts: 3077
Joined: Tue Dec 11, 2007 6:02 pm
Location: Alicante, Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by pavila »

I have created an issue for this: http://issues.openkm.com/view.php?id=2497

Rudolf21
Junior Boarder
Junior Boarder
Posts: 34
Joined: Fri Aug 19, 2011 6:43 am

Re: OpenKM 6.2 Mail Import

Post by Rudolf21 »

Looks like a datatype issue..

Catalina.log:

Code: Select all

ERROR com.openkm.servlet.admin.MailAccountServlet - Provided id of the wrong type for class com.openkm.dao.bean.MailFilter. Expected: class java.lang.Lo
ng, got class java.lang.Integer
com.openkm.core.DatabaseException: Provided id of the wrong type for class com.openkm.dao.bean.MailFilter. Expected: class java.lang.Long, got class java.lang.Integer
        at com.openkm.dao.MailAccountDAO.findFilterByPk(MailAccountDAO.java:340)
        at com.openkm.servlet.admin.MailAccountServlet.filterEdit(MailAccountServlet.java:384)
        at com.openkm.servlet.admin.MailAccountServlet.doGet(MailAccountServlet.java:82)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
        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.runWorker(ThreadPoolExecutor.java:1121)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614)
        at java.lang.Thread.run(Thread.java:777)
Caused by: org.hibernate.TypeMismatchException: Provided id of the wrong type for class com.openkm.dao.bean.MailFilter. Expected: class java.lang.Long, got class java.lang.Integer
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:135)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
        at org.hibernate.impl.SessionImpl.load(SessionImpl.java:985)
        at org.hibernate.impl.SessionImpl.load(SessionImpl.java:978)
        at com.openkm.dao.MailAccountDAO.findFilterByPk(MailAccountDAO.java:323)
        ... 43 more

jllort
Moderator
Moderator
Posts: 11204
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by jllort »

We converted some integer to long and there's some error on this method that is still receiving a integer when spected should be long. In source compilation is right but when hibernate found long the error is shown. We will solve as soon as possible ( if you want subscribe to the ticket has been published by pavila to be notified when will be solved ).

pavila
Moderator
Moderator
Posts: 3077
Joined: Tue Dec 11, 2007 6:02 pm
Location: Alicante, Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by pavila »

This bug is marked as solved, please try the last nightbuild from http://integration.openkm.com/6.2/

stiebs
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Fri Jun 15, 2012 12:26 pm

Re: OpenKM 6.2 Mail Import

Post by stiebs »

I've just started considering importing mail into OpenKM, and although I like the way it categorises into a date structure, it does not order properly when the month or day number is less than 10.

Eg, in the screenshot below, the emails on the 4th of Feb come after those on the 10th, 11th and 26th.
Image

The day and month numbers should be padded out with a leading zero like this:
Image
Attachments
okm_mail_proposed.jpg
okm_mail_proposed.jpg (23.56 KiB) Viewed 2280 times
okm_mail_current.jpg
okm_mail_current.jpg (22.9 KiB) Viewed 2280 times

jllort
Moderator
Moderator
Posts: 11204
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: OpenKM 6.2 Mail Import

Post by jllort »

It's ordering correctly, because it's based on first letter. The problem is we should create folders like 01,02 etc... and then the order will be what you spected. We will try to introduce on next release.

Post Reply