Solved

Emailing file as an attachment

Posted on 2006-07-13
12
392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

 
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 250 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

Industry Leaders: 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: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
Introduction: Dialogs (2) modeless dialog and a worker thread.  Handling data shared between threads.  Recursive functions. Continuing from the tenth article about sudoku.   Last article we worked with a modal dialog to help maintain informat…
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.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 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