Re: GENERATE_SPREADSHEET - Resolved!

Hi Alan,

as you also had your problems with using SNDSMTPEMM directly - maybe you should try SYSTOOLS.SEND_EMAIL

https://www.ibm.com/docs/en/i/7.5?topic=services-send-email-scalar-function

This makes it somehow easier, and you can "extract" the source code of the function and use it as a starting point for something of your own.

HTH
Daniel

Am 03.04.2025 um 00:42 schrieb Infodorado InfoDorado via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

Thanks to all of you for the helpful points.
The issue was actually with the SNDSMTPEMM command and parameters, and be warned, it's quirky like it does not like punctuation in the email subject, and the waY it handles the xls suffix is quirky. But now that I know the gotchas, it's a great thing to have and simplifies sending email attachments.

--Alan

On 04/02/2025 6:18 PM EDT Vern Hamberg via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:


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.

--
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
at https://archive.midrange.com/midrange-l.

Please contact support@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
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.