Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Empty excel attachment in mail received from SMTP on Outlook

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
gs185008

New User


Joined: 12 May 2009
Posts: 3
Location: delhi

PostPosted: Mon Jul 13, 2015 7:45 pm    Post subject: Empty excel attachment in mail received from SMTP on Outlook
Reply with quote

Hi,
Our client recently migrated from Lotus Notes to Microsoft Outlook. Till then, they were able to receive and open/ view all attachments sent thru SMTP in Lotus Notes but after migration, same attachment is opening as empty or blank (even though there is data in file) in Outlook while it is opening correctly in Lotus Notes.
The only difference I could find in SMTP instructions is CONTENT-TYPE is TEXT/PLAIN while attachment extension is .XLS. Could this be an issue for Outlook and not for Notes?

Need help urgently.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7226

PostPosted: Mon Jul 13, 2015 8:06 pm    Post subject: Reply to: Empty excel attachment in mail received from SMTP on Outlook
Reply with quote

For "urgently", pay someone to do it.

Is there even a Mainframe involved in this? If the same data in Lotus Notes works and doesn't in Microsoft Outlook, you have to find out why before you can decide if anything needs to change (even if you are using a Mainframe at all).
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Jul 13, 2015 8:11 pm    Post subject: Reply to: Empty excel attachment in mail received from SMTP on Outlook
Reply with quote

Quote:
Need help urgently.


unfortunately we do not do urgently

You should always remember that on a forum people reply
on their own time
free of charge


if Your organisation has time constraints a paid consultant will be happy ( for a proper fee )
to adjust his schedule to Your needs icon_cool.gif
Back to top
View user's profile Send private message
gs185008

New User


Joined: 12 May 2009
Posts: 3
Location: delhi

PostPosted: Mon Jul 13, 2015 8:13 pm    Post subject:
Reply with quote

Hi Bill,
Yes, we are using Mainframe since long icon_smile.gif

We have digged into COBOL code to find any difference but there is not any. So, am not sure whether it is due to the issue I outlined in my previous query but could be Outlook configuration issue as well. Not sure though.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7908
Location: Bellevue, IA

PostPosted: Mon Jul 13, 2015 10:53 pm    Post subject:
Reply with quote

It sounds like an OUTLOOK issue to me, with no bearing on the mainframe at all. Are you truly sending .XLS data (which must be transferred as binary), or are you sending a CSV file being opened by Excel (which can be transferred as text instead of binary)? If the latter, you might try changing the attachment extension to TXT instead of XLS as OUTLOOK might be assuming the XLS really is an Excel work sheet.
Back to top
View user's profile Send private message
gs185008

New User


Joined: 12 May 2009
Posts: 3
Location: delhi

PostPosted: Tue Jul 14, 2015 10:39 am    Post subject:
Reply with quote

Hi Bob,
We are sending data delimited by X'05' (tab) and file extension as .XLS. This file is getting received correctly in Lotus Notes and opening correctly but same file is opening as blank in Outlook.
To us it seems issue during exchange migration from Lotus Notes to Outlook.
Also, we noticed once mail with attachment is received on Outlook, the excel attachment is corrupt by then. Even if I send the same mail (received on Outlook from Mainframe) with attachment on Lotus Notes to verify, by then the damage was done and file does not even open up on Lotus.
Back to top
View user's profile Send private message
steve-myers

Active User


Joined: 30 Nov 2013
Posts: 461
Location: The Universe

PostPosted: Tue Jul 14, 2015 10:57 am    Post subject:
Reply with quote

gs185008 wrote:
...We are sending data delimited by X'05' (tab) and file extension as .XLS.
You appear to be sending a CSV file, not a true XLS file

FWIW, X'05' is the EBCDIC "tab" character, not the "ASCII" tab character. The ASCII "tab" character appears to be X'09', though I do not completely trust the reference I'm using, though it does agree with http://www.asciitable.com/. (ESA/390 Reference Summary)
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7908
Location: Bellevue, IA

PostPosted: Tue Jul 14, 2015 5:57 pm    Post subject:
Reply with quote

It is definitely NOT a mainframe issue since the same file going to Lotus Notes can be opened while the file going to Outlook cannot be opened. You should open a problem with Microsoft.
Back to top
View user's profile Send private message
David Maher

New User


Joined: 17 Aug 2015
Posts: 3
Location: Australia

PostPosted: Tue Aug 18, 2015 4:48 am    Post subject: Reply to: Empty excel attachment in mail received from SMTP on Outlook
Reply with quote

OK, here's the deal.
There is a slight variation between Lotus Notes and OUTLOOK when emailing a .CSV File as an attachment.
Using Lotus Notes you would have the SMTP Header information concatenated ahead of a .CSV Data file, and this works fine.
With OUTLOOK there needs to be a blank line inserted between the SMTP Header and the CSV Data for OUTLOOK to recognize the data.
If there is not a blank line OUTLOOK will attach an EMPTY Xcel Spreadsheet.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. how to find if file is empty or not. abdulrafi DFSORT/ICETOOL 5 Tue May 17, 2016 4:39 pm
No new posts Issue in sending zip file as mail att... ajithajt JCL & VSAM 8 Thu Apr 07, 2016 9:11 am
No new posts How to read a excel sheet and load it... Radhika Nambiar Java & MQSeries 10 Wed Mar 30, 2016 4:49 pm
No new posts Formatting data from Excel to mainframe kishpra JCL & VSAM 5 Fri Feb 19, 2016 7:12 pm
No new posts Trigger a mainframe job by mail Praveen Thenraj IBM Tools 8 Wed Jan 13, 2016 12:05 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us