Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Emailing file as an attachment

Posted on 2006-07-13
12
Medium Priority
?
395 Views
Last Modified: 2013-12-26
I am having hard time figuring out how to send an output file as attachment.

My environment:
Generating a sql output - output.csv file
Trying to send it as attachment in outlook mail. Not succeeding. Its sending some junk chars and that too in body of message like:

begin 644 output.200607131533.csv
M14U"05)1("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
@-C<Y,C@P(%5N;"!#86QL<R!4;R!(;VUE($]R($)U<PH@
`
end

OS : HP UX

My shell script looks like :

Connect="report/report
Addr="email@mail.com"
File="output"

sqlplus -s $Connect @report.sql

ux2dos -ascii $File.csv  $File.csv  2>> /dev/null

( uuencode $File.csv $File.$(date).csv
) | mailx -s "Report $(date)" $Addr

Can you guys correct me if I am missing any thing.
0
Comment
Question by:csreeni
12 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 17103115

Try this:

cat $File.csv | uuencode  $File.$(date).csv | mailx -s "Report $(date)" $Addr


0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 17103134

Or also:

uuencode  $File.$(date).csv <$File.csv | mailx -s "Report $(date)" $Addr

0
 

Author Comment

by:csreeni
ID: 17103928
No luck. I am still receiving junk, but not an attachment.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 48

Expert Comment

by:Tintin
ID: 17104254
Perhaps Exchange is configured to only recognise MIME encoded mail and not uuencoded mail.

Try loading mimetools on your server and MIME encode the CSV file.
0
 
LVL 38

Accepted Solution

by:
yuzh earned 1000 total points
ID: 17104976
For M$ PC mail client, it is better to use mutt to do the job, you can download the
binary package from:
http://hpux.cs.utah.edu/hppd/hpux/Networking/Mail/mutt-1.5.11/

If you use uuencode to send the mail, at the other end, the user has to save the mail as a file and then use uudecode to extract the attachmemt.

Please read the answer in http:Q_20305167.html  to learn more details.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 17107878

I think its the 'date' function, try this:

uuencode  $File.$(date +%YYYYMMDD).csv <$File.csv | mailx -s "Report $(date)" $Addr



0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 17107885

Or this:

uuencode  ${File}_$(date +%YYYYMMDD).csv <${File}.csv | mailx -s "Report $(date)" $Addr
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 17109489

Or even this:

uuencode  "$File.$(date).csv" <$File.csv | mailx -s "Report $(date)" $Addr
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17121083
The comment from yuzh might be worth considering.
I couldnt see much wrong with your syntax, so had a quick check
http://www.shelldorado.com/articles/mailattachments.html

For File attachments with MIME, it recommends using mutt

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Displaying information on the statusbar.   Continuing from the third article about sudoku.   Open the project in visual studio. Status bar – let’s display the timestamp there.  We need to get the timestamp from the document s…
Introduction: The undo support, implementing a stack. Continuing from the eigth article about sudoku.   We need a mechanism to keep track of the digits entered so as to implement an undo mechanism.  This should be a ‘Last In First Out’ collec…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question