Email .msg file import corruption

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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
chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Email .msg file import corruption

Post by chrwei » Fri May 24, 2019 2:41 pm

I have several msg files exported from outlook that the message body is corrupted when added to 6.3.7. opening the msg file in outlook shows a plain text email with a few attachments. when I save the added file out of openkm it's an eml file, and that opens as an html email. the readable text from the msg file gets turned into non-printable characters in the openkm preview and the eml file.

additionally, if I use OKMRest 1.2.2 .net SDK's importMsg method the files added corrupt as with the interface, but I get an exception too: $exception {"MailImpl (importMsg)\n'\u0003', hexadecimal value 0x03, is an invalid character. Line 1, position 410.\n\ncom.openkm.sdk4csharp.exception.UnknowException: '\u0003', hexadecimal value 0x03, is an invalid character. Line 1, position 410.\r\n at com.openkm.sdk4csharp.impl.MailImpl.importMsg(String dstId, String title, FileStream fileStream)"} com.openkm.sdk4csharp.exception.OKMRestException

search results on this error lead to a possible XML conversion issue, like that 0x03 needs to be escaped but isn't

I was able to find the original raw SMTP message in my mail archives, headers mark it as:

Code: Select all

Content-Transfer-Encoding: 7bit
Content-Type: multipart/mixed;
        boundary="Apple-Mail-E819C806-3C10-4266-AB6B-491067E0E843"
text body part is

Code: Select all

--Apple-Mail-E819C806-3C10-4266-AB6B-491067E0E843
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Adjunto fotos como evidencia del rechazo

followed by a base64 image part, another plain text 7bit part that's just a couple newlines (what the hell apple), then another base64 image, and another plain text 7bit part that's a signature

Code: Select all

--Apple-Mail-E819C806-3C10-4266-AB6B-491067E0E843
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit



Enviado desde mi iPhone
all the msg files that I'm seeing issues with are spanish language, but so far I'm not seeing accented characters or anything in the original files that would explain a 0x03 character. any ideas how to go about making this work?

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

Re: Email .msg file import corruption

Post by jllort » Sat May 25, 2019 8:24 am

You are exporting msg from outlook and then you upload to OpenKM?
Before talking to export, the email from OpenKM is shown right?

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Tue May 28, 2019 1:05 pm

yes, export from outlook via drag and drop email to a windows explorer folder. it shows right in outlook, and shows right in the .msg file, but once uploaded into openkm it no longer shows correctly.

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

Re: Email .msg file import corruption

Post by jllort » Fri May 31, 2019 5:29 pm

can you share with us the msg file to check what happens.

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Fri May 31, 2019 9:26 pm

i'll have to dig one up that isn't confidential, or see if I can reproduce from scratch, might take a bit

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

Re: Email .msg file import corruption

Post by jllort » Fri Jun 07, 2019 6:42 pm

When you have someone please send us from here. If it is confidential contact us from https://www.openkm.com/en/contact.html indicating the URL of the forum and I will share direct contact with us.

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Mon Jun 10, 2019 9:33 pm

contact form sent, but it doens't allow URLs, so I put "OpenKM English Users-> Usage-> Email .msg file import corruption"

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Thu Jun 13, 2019 1:07 pm

Will you have a conversation with Mario Zules? he seems a little confused as to why i emailed.

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Thu Jun 13, 2019 5:14 pm

it would seem they are aware of the cause of the issue and have it fixed in the Pro version already.

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

Re: Email .msg file import corruption

Post by jllort » Sat Jun 15, 2019 6:47 pm

Sorry, but at the end of the day I talk with a lot of persons and here I think we have had some miss understanding. I had not received the file, usually when somebody contact with something about the forum I ask him to share the URL of the forum post to do not lose the focus ( seems I forget to explain it ). I will send my private email address from a private message in the forum. Contact me directly and share the URL of this post. Apologies.

When I have all the data I will sure know if it is a problem with community, your mail, or some extra feature what we have in professional edition an is not currently present in the community. Mario Contacted me, but I do not being able to link the questions with this previous forum post, it is not his fault, apologies.

chrwei
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: Mon Apr 15, 2019 2:54 pm

Re: Email .msg file import corruption

Post by chrwei » Mon Jun 17, 2019 1:01 pm

the contact form does not allow URLs. I got your email and will reply.

Post Reply