Attachment File Name Change

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   Hello.

We are seeing file attachment names changed when sending email through Email2DB. There ends up being a random four-character alpha-numeric string appended to the file name. For example, FirstAttachment.pdf might become FirstAttachment_A3FT.pdf. The appended string is different for each attachment. I guess it's actually a five-character string including the underscore.

It doesn't seem to happen to all email that comes through Email2DB. But sending email around Email2DB (which users should not be doing) does not result in file name changes, which is why we think it's Email2DB doing it.

Has anyone else seen this from Email2DB?

I tried looking at processed messages, but they do not show any information about attachments. Is there some way to view what attachments were received by Email2DB and what attachments were sent by Email2DB?

Thanks!

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
hzmud Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 20 Jul 2011 Posts: 17	Post Options Post Reply Quote hzmud Report Post Quote Reply Topic: Attachment File Name Change Posted: 17 Nov 2011 at 6:04pm
	Hello. We are seeing file attachment names changed when sending email through Email2DB. There ends up being a random four-character alpha-numeric string appended to the file name. For example, FirstAttachment.pdf might become FirstAttachment_A3FT.pdf. The appended string is different for each attachment. I guess it's actually a five-character string including the underscore. It doesn't seem to happen to all email that comes through Email2DB. But sending email around Email2DB (which users should not be doing) does not result in file name changes, which is why we think it's Email2DB doing it. Has anyone else seen this from Email2DB? I tried looking at processed messages, but they do not show any information about attachments. Is there some way to view what attachments were received by Email2DB and what attachments were sent by Email2DB? Thanks!

James Horton Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Technical Support Joined: 01 Jun 2009 Location: Stoke-on-Trent Posts: 277	Post Options Post Reply Quote James Horton Report Post Quote Reply Posted: 18 Nov 2011 at 10:14am
	What account type are you reading mail in from? If this is Outlook then it may not show the attachment files within the View Processed Message area as it is not able to store a copy within the database here. For the IMAP and POP3 connectivity types for your account you would see the attachments that were held within the message when viewing the Processed Messages. In relation to the file names. I believe the only reason for Email2DB to append additional characters as part of the processing would be if files were contained within the folder with the same name, or within the message itself with the same name. Do you know whether the message itself contained multiple copies of the same message? If that is the case then Email2DB would need to stamp on individual IDs else the messages would be overwritten. I assume my last point is the most likely of the reasons.
	Best Regards, James Horton Technical Analyst Parker Software

hzmud Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 20 Jul 2011 Posts: 17	Post Options Post Reply Quote hzmud Report Post Quote Reply Posted: 18 Nov 2011 at 4:25pm
	Thanks for your post! I'm reading mail from a POP3 account type. The messages that included the renamed file attachments did not contain multiple copies of the attachments. I can't be sure that Email2DB did not get duplicate emails with duplicate attachments at the same time; but if the recipients had gotten two emails, one with good attachment names and one with bad attachment names, I assume they would have just ignored the one with the bad attachment names as a technical glitch and not complained about it to us.

James Horton Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Technical Support Joined: 01 Jun 2009 Location: Stoke-on-Trent Posts: 277	Post Options Post Reply Quote James Horton Report Post Quote Reply Posted: 21 Nov 2011 at 10:14am
	The only reason I am aware of Email2DB appending a 4 character string to the attachment name is when attachments of the save name are contained within a message. If you wish us to look into this further then please let us know.
	Best Regards, James Horton Technical Analyst Parker Software

miken700 Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 04 May 2011 Posts: 5	Post Options Post Reply Quote miken700 Report Post Quote Reply Posted: 20 Apr 2012 at 3:25pm
	I'm seeing the same thing here. Seems to happen when you send an email with an attachment with the same name as an attachment on a previously processed email. For example sending an attachment with the name of "fileName.png", becomes "fileName_IT6N.png" when you re-forward it in a second email. I see this happen in our prod and QA environments, although I haven't been able repro this on my dev server. Is there a setting that controls the use of a temp folder or something that I'm missing that could be set differently on the servers that could cause this? But it's very possible that my dev server is not setup in the same way. I also just remembered that I haven't updated my Email2DB dev server in a long while. I think it's ver 2.2. So maybe this is an issue just on newer versions? Edited by miken700 - 20 Apr 2012 at 3:56pm

ksnyder Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 26 Jul 2012 Posts: 1	Post Options Post Reply Quote ksnyder Report Post Quote Reply Posted: 26 Jul 2012 at 11:26pm
	I'm having the same issue with file attachment names being appended by a random 5 character string in only certain email messages. Situation: I have three email messages, with the same subject line, that contain attachments of PDF and HTML report files. I’m attempting to save the attachments from all three of these messages to a corresponding folder on the local system. Two of the email messages attachments save with no issues. The third, all of the attachments have the original file name along with a random 5 character suffix (_3GLS as an example). The three email messages are being processed by the same ‘account’ and ‘trigger’ so I’m unsure why the two email message attachments work correctly where the third seems to append the character string. My preference is to have all of the original file names in place. In addition, the attachments in the original ‘failed’ message do not have the character string appended and the appended characters only appear when processed by Email2DB and then only for the one email message. I've removed the processed email messages and when running the trigger again, I have the same issue where two of the email messages having attachments save correctly where the third one has the 5 characters appended.

Liam Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 29 Jun 2011 Location: Stoke-on-Trent Posts: 144	Post Options Post Reply Quote Liam Report Post Quote Reply Posted: 27 Sep 2012 at 6:59am
	Hello miken700 and ksnyder, miken700 - I would definitely reocmmend updating your Email2DB, if the problem continues after this then please let us know. ksnyder - What version of Email2DB are you currently running?