Share
ReportWe have a Dynamics GP 2018 installation with Workflow. When sending out email attachments through Workflow the filename has a bunch of whitespace after the file extension and then an underscore.(e.g., Filename.pdf _) When the attachment is received it can't be opened with most email programs. The user has to save the attachment stripping off the excess beyond the file extension. Looking at the SQL 2014 database the Table dbo.coAttachmentItems has a column named fileName which is a char(255). My understanding of char is that it requires in this case a 255 character file name and will fill the unused characters with white/blank spaces to reach the 255 character setting. I may be way off, I am not a database guy. Some email clients will handle the attachment just fine. For instance the IOS version of Outlook recognizes the attachment as a pdf and allows me to open it. The desktop version of Outlook as well as G-suite(gmail) doesn't strip off the blank spaces and the underscore so it doesn't recognize the file type. Is this an isolated incident or has anyone seen this before? I tried deleting the dbo.coAttachmentItems table and recreating it with the fileName column as a varchar with no success. Is there something in the Workflow settings I can change to fix this or is this an SQL issue? Any assistance with this would be greatly appreciated. Thank you
You’re offline. This is a read only version of the page.
All responses (
Answers (
5
