topic Re: Imap preview eml in Alfresco Archive

Imap preview eml

dranakan — Thu, 16 Jun 2011 12:45:47 GMT

Hello,I would like to show preview in Share from mails coming from Outlook. I get problem with the accents : If a mail contain this "é" it will show this "?%". It's ok with mail UTF-8, but how can I change to preview all kind of mails ?I have done this to be able to get a preview of eml files :Trans

Re: Imap preview eml

mrogers — Fri, 17 Jun 2011 14:12:57 GMT

There are a few issues with EML preview - which is why the issue you refer to is still open. :?
Before you start, check your database and connection string are UTF-8.

There are some fixes to the code since 3.4d to get accented characters working, you may need to patch. In particular we replaced the old RFC822 transformer. I suggest you look at JIRA for further details.

From memory, I'm fairly sure we have unit tests for French accented characters now.

My colleagues are investigating fixing PDFBox at the moment to get it to work with Japaneese. And then we need to get share to preview plain text files better.

Re: Imap preview eml

dranakan — Mon, 20 Jun 2011 06:12:05 GMT

Thank you mrogers,

check your database and connection string are UTF-8

It's ok, /opt/Alfresco/tomcat/shared/classes/alfresco-global.properties :

db.url=jdbc:mysql://localhost:3309/${db.name}?useUnicode=yes&characterEncoding=UTF-8‍

/opt/Alfresco/mysql/my.cnf

default-character-set=utf8
‍‍

There are some fixes to the code since 3.4d to get accented characters working, you may need to patch. In particular we replaced the old RFC822 transformer. I suggest you look at JIRA for further details

I have not found something like a new update of the transformer in Jira 😞 Do I replace the org.alfresco.repo.content.transform.EMLTransformer (bean id="transformer.RFC822") with the last in the SVN ?

Thank you

Re: Imap preview eml

dranakan — Tue, 28 Jun 2011 14:25:42 GMT

I think I have this problem : http://issues.alfresco.com/jira/browse/ALF-3757 (problems with characters encoding).

Someone purpose to process to a Tika upgrade. I have tried to use last Tika (tika-app-0.9.jar in tomcat/webapps/alfresco/WEB-INF/lib/, removing tika-core-0.8-SNAPSHOT.jar and tika-parsers-0.8-SNAPSHOT.jar, restart server) but there no change… The accents are still bad.

Someone has done a Tika upgrade ? Do I forget something ?

Thank you.

Re: Imap preview eml

mrogers — Tue, 28 Jun 2011 15:02:46 GMT

I think that particular change is unlikely to help.

Its far more likely to be this… ALF-5495 or one of the related issues.

Re: Imap preview eml

dranakan — Wed, 29 Jun 2011 06:52:55 GMT

Thank you mroger,

I see there is a patch (greenmail-1.3-patched.diff) changing severals java files (in http://issues.alfresco.com/jira/browse/ALF-5495). I am using 3.4D and I don't think it's a good idea to change manually the java file and create a new alfresco.war

I need to use a new version of Alfresco… (trying the 34e or waiting on the 4.0a)…

Re: Imap preview eml

mrogers — Wed, 29 Jun 2011 08:11:11 GMT

3.4.e is unlikely to help. :cry:

Re: Imap preview eml

dranakan — Wed, 29 Jun 2011 08:26:29 GMT

With Alfresco Entreprise, I could have a patch and my problem should be solved. Our firm is in discussions with Alfresco to be partners… I hope it's be done quickly…

I have done a lot of search and test with this problem. With an Alfresco Entreprise licence : For this problem the support searches for me or I need to add in JIRA and wait a response ?

Thank you

Re: Imap preview eml

mrogers — Wed, 29 Jun 2011 08:52:10 GMT

I'm not sure what you are asking, but with an Enterprise subscription Alfresco Support will investigate, and raise and track any issues if necessary.

Re: Imap preview eml

nlaselva — Wed, 29 Jun 2011 15:18:54 GMT

Hi dranakan,

I had the same issue with IMAP and accented (or non-ASCII) characters. I tested everything, without any chance of getting this fixed.

Then I installed Alfresco Entreprise Trial (3.4.2-30 days) and it works perfectly. Looking in JIIRA they fixed it already for build 3.3.x. This means they didn't bring the fix in the 3.4 community edition and, IMHO, this has been done on purpose. Business is business and Alfresco is not a charity

Re: Imap preview eml

mrogers — Wed, 29 Jun 2011 15:28:34 GMT

Ho hum. :roll: Thats not how it works.

Re: Imap preview eml

nlaselva — Thu, 30 Jun 2011 07:40:27 GMT

Sorry, maybe it doesn't work the way I stated. Nevertheless a bug is a bug. In Community Edition the bug is still there. In Enterprise edition it has been fixed. I didn't want to be unfair, but only to notify to dranakan that if he is looking for a QUICK fix for this bug, the Enterprise edition is the quickest solution (maybe not the cheapest).

Re: Imap preview eml

mrogers — Thu, 30 Jun 2011 08:41:09 GMT

I expect that it is fixed on HEAD now. And is probably fixed in Community 3.5.a. However I don't have details of that release to confirm or test.

Re: Imap preview eml

dranakan — Fri, 04 Nov 2011 08:09:09 GMT

Hello,

The accented characters are ok with Alfresco 4.0b 🙂

Just need to add in tomcat/webapps/alfresco/WEB-INF/classes/alfresco/swf-transform-context.xml to enable the EML preview :


 <!– This transformer allows for the webpreviewing of outlook msg files. –>
   <bean id="transformer.complex.Mail.rfc82swff"
        class="org.alfresco.repo.content.transform.ComplexContentTransformer"
        parent="baseContentTransformer" >
      <property name="transformers">
         <list>
            <ref bean="transformer.RFC822" />
            <ref bean="transformer.PdfBox.TextToPdf" />
            <ref bean="transformer.Pdf2swf" />
         </list>
      </property>
      <property name="intermediateMimetypes">
         <list>
            <value>text/plain</value>
            <value>application/pdf</value>
         </list>
      </property>
   </bean>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I see that the pictures are not visible in the preview (it replaces the picture by the URL of the picture). The picture can be displayed ?

Re: Imap preview eml

mrogers — Fri, 04 Nov 2011 09:00:33 GMT

We need a different transformer stack for preview to see the compound types like Mime messages. I'm not happy with the text based swf based preview like below which is why its not configured out of the box, however I agree that its better than nothing!

Contributions or suggestions anyone?