Re: GENERATE_SPREADSHEET

Hello Alan

A couple things - in your first email you used xls as the extension  - that would give you the old Excel 97 format, while xlsx is the Excel 2003 format. When you look at it in WRKLNK, it will probably have PK as the first 2 characters - so it is a PKZIP archive.

It sounds like GENERATE_SPREADSHEET is working fine. So I suggest you change the *spreadsheet_type* parameter to *txt* or *csv* and look at the result with WRKLNK, to verify further that GENERATE_SPREADSHEET is working correctly.

Then I suggest that you use the ACS IFS tool to download the file to your PC and verify, again, that it is correct. This is a process of elimination.

If that is working, then I would email the text file as you are doing and see if the file is readable. Or that it has the correct content.

I've never used SNDSMTPEMM, so I cannot speak to that, but see if everything else is working.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.qx9pKEG9.GOvlpcEK@centurylink.net> CAAC (COMMON Americas Advisory Council) IBM Influencer 2023

On 4/2/2025 3:38 PM, Infodorado InfoDorado via MIDRANGE-L wrote:

Can't view the file using green-screen WRKLNK because XLSX looks like garbage there. Same for using the IFS link from ACS Actions pull-down menu.

Strange? This is blocking me and I'm second day past due. The last snag to finish a request.

--Alan

On 04/02/2025 4:27 PM EDT Daniel Gross<daniel@xxxxxxxx> wrote:

Hi,

I can't say so much without looking into the files.

But it may be a typical CCSID conversion - how did you make the FTP transfer? Binary? Maybe look it up, whether both files really look the same - and try to work your way through.

HTH
Daniel

Am 02.04.2025 um 22:23 schrieb Infodorado InfoDorado via MIDRANGE-L<midrange-l@xxxxxxxxxxxxxxxxxx>:

Greetings

I'm using this SYSTOOLS tool for the first time.
I have a program that runs to generate an XLSX spreadsheet file kind of like pgm-isodate-hmstime, dot xls.

Then, it sets up and runs the following command:
SNDSMTPEMM RCP(email)
+ SUBJECT(%trim(subject))
+ NOTE(%trim(note))
+ ATTACH((%trim(path))
and runs that.

That all runs okay, and sends the email.

But Outlook refuses to open the attachment, and refuses to download it. The explanation is "cannot open". Right. Thanks a lot, Microsoft (NOT)

BUT the kicker is that we can download the attached IFS file using FTP and it opens just like it's supposed to, and the data is good, good, good.
:(

Anybodey got a solution here?

--Alan Cassidy
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:https://lists.midrange.com/mailman/listinfo/midrange-l
or email:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:https://lists.midrange.com/mailman/listinfo/midrange-l
or email:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.