SNDDST with .csv or .xls attachment

0 pts.
Tags:
CLP
Can someone tell me how to send an attachment with a .csv or .xls? When I try, it sends it as .txt and when you open it up, it's all garbage! Also, how can I add headings to an .xls or .csv when using cpytoimpf. All I'm getting now is just data. Thanks!
ASKED: December 15, 2005  1:06 PM
UPDATED: November 22, 2009  12:12 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I just sent a spreadsheet to myself with the following and addresses and such changed:

SNDDST TYPE(*DOC) TOINTNET((‘whomever@whereever.COM’)) DSTD(‘DOCUMENT MAIL’) USRID(SYSTEM userid) DOC(document.XLS) FLR(folder)

I think there is an issue with any document if you do not send from the folder portion of the system with, of course, the limitiations of 8 character names. Others can perhaps confirm.

============================================================

First, don’t use SNDDST to send files such as .CSVs or .XLSs. Why would you think SNDDST had anything at all to do with PC files? It’s a SNA command for sending SNA distributions. It’s been adapted to allow sending text, but a .XLS is hardly a text file.

Further, SNA is not SMTP. If you’re going to be responsible for SMTP e-mail, you better have at least the most basic knowledge about what SMTP can do. The biggest thing it can’t do is send any message that contains any bytes with values that are not “ASCII printable text”. Because of that limitation, there’s a whole area of SMTP e-mail that’s known as “MIME attachments”. MIME procedures take attachments and convert their bytes to encodings that guarantee that all transmitted bytes meet the “printable text” restriction.

If you’re going to use SNDDST to send anything but guaranteed text, you’ll need to locate some procedures that can take your attachments, convert them to MIME encoding, add the appropriate MIME headers and generate the complete body of the e-kmail.

As for CPYTOIMPF. .CSVs don’t have anything but data unless you add rows that have something other than data. If you want some kind of ‘column heading’ row, then create one. Then use CPYTOIMPF to append to whatever non-data row you created.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following