Sponsored Content
Top Forums Shell Programming and Scripting Help on email data file as excel from unix!! Post 302248580 by sparan_peddu on Saturday 18th of October 2008 11:45:20 AM
Old 10-18-2008
Help on email data file as excel from unix!!

Hi,

I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it.

The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in solving this issue is appreciated.

Thanks,
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Send email with attachment in form of excel in unix

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

2. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

3. Shell Programming and Scripting

UNIX -> send data as excel in seperate cells

Hi I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells. File -> attachment.xls data data data data data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies

4. UNIX for Advanced & Expert Users

Zip an excel file and email using script.

Hi All, Currently i am using below script to attach excel and email from a Unix script. uuencode ASC.xls|mailx -m -s "ABCD_subject`TZ=CST+24 date +%d-%b-%y`" email@email.com Can anyone give me or help me in zipping excel and sending that email as the excel is very heavy. Thanks, (14 Replies)
Discussion started by: Nithin
14 Replies

5. Shell Programming and Scripting

How to extract data into excel from a database in unix

Hello viewers, I am connecting to db2 database from unix. I am executing a query for example select * from emp. I need to export the data obtained from the above command to a excel file. Could you please suggest how to proceed on this? thanks and regards, k.n.v.santosh (3 Replies)
Discussion started by: santoshaarudhra
3 Replies

6. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies

7. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

Hi, i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks Regards, Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies

8. UNIX for Dummies Questions & Answers

UNIX data to be updated to ms excel sheet

hi, i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

10. UNIX for Beginners Questions & Answers

Extract UNIX data to excel

Hi, I would like to extract the data from particular date, 1. may i know which command i need to use? 2. Extract from unix command (those extracted above) to excel? Please assist. Thanks (2 Replies)
Discussion started by: Peru
2 Replies
rt-email-dashboards(8)					     Request Tracker Reference					    rt-email-dashboards(8)

NAME
rt-email-dashboards - Send email dashboards SYNOPSIS
rt-email-dashboards [options] DESCRIPTION
This tool will send users email based on how they have subscribed to dashboards. A dashboard is a set of saved searches, the subscription controls how often that dashboard is sent and how it's displayed. Each subscription has an hour, and possibly day of week or day of month. These are taken to be in the user's timezone if available, UTC otherwise. SETUP
You'll need to have cron run this script every hour. Here's an example crontab entry to do this. 0 * * * * /usr/bin/perl /opt/rt4/local/sbin/rt-email-dashboards This will run the script every hour on the hour. This may need some further tweaking to be run as the correct user. OPTIONS
This tool supports a few options. Most are for debugging. -h --help Display this documentation --dryrun Figure out which dashboards would be sent, but don't actually generate or email any of them --time SECONDS Instead of using the current time to figure out which dashboards should be sent, use SECONDS (usually since midnight Jan 1st, 1970, so 1192216018 would be Oct 12 19:06:58 GMT 2007). --epoch SECONDS Back-compat for --time SECONDS. --all Ignore subscription frequency when considering each dashboard (should only be used with --dryrun for testing and debugging) perl v5.14.2 2013-05-22 rt-email-dashboards(8)
All times are GMT -4. The time now is 01:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy