07-25-2008
Excel attachment in e-mail
Hi,
Is it possible to generate an excel file by UNIX Shell script?
I have modify the ho.sh script as follows and i have made spool file in sql file as spool /u08/Temp/ho.txt
ho.sh
------
#!/bin/csh
#!/bin/bash
#!/bin/ksh
setenv ORACLE_HOME /opt/app/oracle/product/8.1.7
setenv ORACLE_SID riker
set BINARIES=/usr/bin
set APPDIR=/u08/Temp
$ORACLE_HOME/bin/sqlplus adsl_stats/adsl_stats01 @$APPDIR/ho.sql
uuencode $APPDIR/ho.txt $APPDIR/ho.txt | mailx -s "Attachment" mail@com
The above script generate the mail with text file that conatins the query output as an attachment in crontab but while ftping the file it shows permission denied( i hve given chmod 777 to this file).
Could you please tell me any command or script that should convert the text file into an excel file in UNIX, i nedd to schedule it in crontab with mail generation option.
Thanks in advance
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
This question has been asked many time before. I did search other questions. But was not able to work out.
Really sorry for repeating the same question.
I have mail and mailx and sendmail installed.
It Tried this
uuencode FILENAME.txt FILENAME.txt | mail mymail@yahoo.com
the attachment... (3 Replies)
Discussion started by: sushrut
3 Replies
2. Shell Programming and Scripting
Hi,
I have a shell script which send email with an attachment in the form of an email. However, the when I open the attachment, all the data comes in one column. How do I format the data in the excel sheet while sending the email?
Thanks (8 Replies)
Discussion started by: bdebroy
8 Replies
3. UNIX for Advanced & Expert Users
Hi ,
I am using mailx command for sending the mails. Rightnow I am sending the attachment (by using uuencode $filename) as a seperate mail.I wanna send the attachment also with the same mail. (6 Replies)
Discussion started by: sharif
6 Replies
4. Shell Programming and Scripting
Hi
Could someone help me with the details on how to send an attachment through mail in unix.
I have an html file in my unix machine and I want this to be send to some mail id, plese help with the steps.
Regards
Ajay (2 Replies)
Discussion started by: ajaykumarboyana
2 Replies
5. UNIX for Dummies Questions & Answers
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies
6. Shell Programming and Scripting
#!/bin/ksh
(
echo "MIME-Version: 1.0"
echo "Content-Type: multipart/mixed; boundary=frontier"
echo "--frontier"
echo "Content-Type: text/html"
echo "Content-Disposition: inline"
echo "\n"
echo "<html><body><h1>this is html formatted text</h1></body></html>"
echo "--frontier"
echo... (1 Reply)
Discussion started by: thulasidharan2k
1 Replies
7. Shell Programming and Scripting
Hi,
I am trying to send email with attachment using mailx command. I am using the folowing command:
uuencode XX_HWSW_BUYERWISE_88963631_1.xls XX_HWSW_BUYERWISE_88963631_1.xls | mailx -s "Test Mail as Attachment" oracleams@xyz.com
I get the email in the inbox. However, when I try to open the... (5 Replies)
Discussion started by: asp_julius
5 Replies
8. Shell Programming and Scripting
Hi All, found similar posts, but not exatcly what i wanted.
I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column. I need below data in 4 columns.
Unix file
Name,ID,Trade,Date... (3 Replies)
Discussion started by: robinbannis
3 Replies
9. UNIX for Beginners Questions & Answers
i am trying to get an SQL output into an excel attachment and the other output into mail body as excel format. i am getting the excel format in the mail body, but i am not getting the excel attachment. and the output is coming in one cell in the excel. is it possible to get the excel output with... (11 Replies)
Discussion started by: maddelav
11 Replies
10. UNIX for Beginners Questions & Answers
Hie,
I need to attach an .xlsx file as an attachment to a mail. I have used the mail option but i dont think there is anything for attachment. Can you show me how else can i do it? I am not allowed to install mutt since it is a workplace and they have their restrictions. And its a Bash Shell (2 Replies)
Discussion started by: barryallen
2 Replies
LEARN ABOUT OPENSOLARIS
script
script(1) User Commands script(1)
NAME
script - make record of a terminal session
SYNOPSIS
script [-a] [filename]
DESCRIPTION
The script utility makes a record of everything printed on your screen. The record is written to filename. If no file name is given, the
record is saved in the file typescript. See WARNINGS.
The script command forks and creates a sub-shell, according to the value of $SHELL, and records the text from this session. The script ends
when the forked shell exits or when Control-d is typed.
OPTIONS
The following option is supported:
-a Appends the session record to filename, rather than overwriting it.
NOTES
script places everything that appears on the screen in filename, including prompts.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
WARNINGS
script can pose a security risk when used in directories that are writable by other users (for example, /tmp), especially when run by a
privileged user, that is, root. Be sure that typescript is not a link before running script.
SunOS 5.11 30 Jan 2004 script(1)