Hello
To do :
'automate the process of generating report and send it to client every 15 days after encrypting the report file'
Did so far :
- generate Java program to encrypt the file.
- generate SQL query to run the report.
Is there any body who can help me to go further ?
... (7 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
i have a Oracle table like
col1 col2
---- -----
a 1
b 2
c 3
when i write a script for it , it gives me all the data in one column.
Please give me the solution which gives the exact result like we see in sql editors.
for a in `echo "
set feedback off;
set pagesize 40;... (1 Reply)
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
I am using Sun Solaris ver. 5.10 and trying to send an HTML table in email body using mail command in C shell script.
I tried following commands:-
#1
mail -m "MIME-Version: 1.0;Content-type:text/html;charset=UTF-8" receiver@mail.com < file.html #2
mail -m "Content-type: text/html;" -s "This... (4 Replies)
Hello All,
I have a query here. I am sending an HTML table(which I am creating it by a call to REST API, in a LINUX box) and from there I have to send it into an email. So following are the poins on same:
As data is not static so it is writing Dynamic data and creating HTML file.
There is... (9 Replies)
Below is the code snippet and I'm not able to generate the table in email, output email has nothing
if ; then
echo "File $fName exists."
awk -F "," ' BEGIN {
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Subject: Out OF Network Fee - Portfolio Level Stats"
print... (1 Reply)
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT DEBIAN
ledgersmb::mailer
LedgerSMB::Mailer(3pm) User Contributed Perl Documentation LedgerSMB::Mailer(3pm)NAME
LedgerSMB::Mailer - Mail output for LedgerSMB
SYNOPSIS COPYRIGHT
#====================================================================
# LedgerSMB
# Small Medium Business Accounting software
# http://www.ledgersmb.org/
#
# Copyright (C) 2006
# This work contains copyrighted information from a number of sources
# all used with permission.
#
# This file contains source code included with or based on SQL-Ledger
# which # is Copyright Dieter Simader and DWS Systems Inc. 2000-2005
# and licensed under the GNU General Public License version 2 or, at
# your option, any later version. For a full list including contact
# information of contributors, maintainers, and copyright holders,
# see the CONTRIBUTORS file.
#
# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
# Copyright (C) 2002
#
# Author: DWS Systems Inc.
# Web: http://www.sql-ledger.org
#
# Contributors:
#
# Original Author and copyright holder:
# Dieter Simader dsmimader@sql-ledger.com
#====================================================================
METHODS
LedgerSMB::Mailer->new(...)
Create a new Mailer object. If any arguments are passed in, a message that uses them will be automatically prepared but not sent.
$mail->prepare_message(to => $to, from => $from, ...)
Prepares and encodes base message for sending or adding attachments.
Arguments
to, from, cc, bcc
Address fields for the email.
subject
The subject for the email.
message
The message body for the email.
contenttype
The conttent type for the body of the message, not for any attachments.
notify
Sets the Disposition-Notification-To header (read receipt request) for the message. This header will only be added if a from address
is set.
$mail->attach(data => $data, file => $file, filename => $name, strip => $strip)
Add an attachment to the prepared message. If $data is specified, use the value of that variable as the attachment value, otherwise attach
the file given by $file. If both a file and data are given, the data is attached. filename must be given and is used to name the
attachment.
$strip is an optional string to remove from the filename send with the attachment.
$mail->send
Sends a prepared message using the method configured in ledgersmb.conf.
perl v5.14.2 2012-03-26 LedgerSMB::Mailer(3pm)