Send email attachment using Operating System Script(UNIX) in Oracle Alerts
Good Day
Kindly assist:
I am creating an Alert that will notify supervisors of staff members who are due for probation report. I am using Operating System Script(Unix) as source.I have already developed the script.
Now the challenge is if there are 3 employee records then the alert will send 3 different emails with each employee record. Now I want to add a condition that will iterate through records and send only one email listing all employee records.
Your assistance will be highly appreciated.
Thanking you in advance
Moderator's Comments:
please use for your code and data, code tags, thanks
I'm looking for a sample of some code that will take the output from a file and generate an email that will include that text as an attachment. the script is in the borne shell. any help? (2 Replies)
Hello All,
This is a common question that I found lot of results in the forums.
I am trying to use uuencode to attach a file and send email. I have no issues sending email, but not able to attach any files using sendmail.
Is uuencode part of sendmail or does 'uuencode' utility need to be... (1 Reply)
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)
I am using the following command to send PDF attachment with a mail.
uuencode <attachment.pdf> <attachment.pdf>|mailx -s <subject> <mail_id> < <Message_file.txt>
This one send the message with attachment. I would like send PDF attachment with the mail
Can any one help with this issue ?
... (0 Replies)
i know its pretty repeated query, but i need to post it in this new thread coz i need it urgently
uuencode /var/tmp/chandra/emaillist.txt emaillist.txt | mail -s "message with encoded attachment"
am unable to send the attachment emaillist.txt present in the path /var/tmp/chandra/
Is... (11 Replies)
Hi,
I have written below disk space monitoring script to monitor disk space every minute. I have scheduled this script through cron. But now my problem is this script alerts the users continuously until the space is freed up. These emails are filling up the inbox exponentially until the space... (3 Replies)
Hi All,
The below code is working fine for me.
mailx -s hello abc@xyz.com <<EOT
Hello !!!
How are you?
Regards
Rahul
EOT
But i am not able to send csv file with the mail .Getting just themail but not the attachment.
uuencode /path/s1.csv | mailx -s hello abc@xyz.com <<EOT... (9 Replies)
Hello Guys,
Here is the requirement!!
I want to check the mail with attachment received or not through unix scripting.
And send an notification email when mail with attachment already received.
Any thoughts on this is much appreciated!!
Regards,
Harry (0 Replies)
Heyy,
any help would be grateful....
LOOKING FOR THE WAYS TO SEND AN EMAIL WITH ATTACHMENT & HTML TABLES IN BODY THROUGH SHELL SCRIPT (LINUX)..NOT SURE, IF WE HAVE ANY INBUILT HTML TAG OR UNIX COMMAND TO SEND THE ATTACHMENTS. KINDLY HELP
below is small script posted for our understanding..... (2 Replies)
Discussion started by: Harsha Vardhan
2 Replies
LEARN ABOUT DEBIAN
ledgersmb::dbobject::employee
LedgerSMB::DBObject::Employee(3pm) User Contributed Perl Documentation LedgerSMB::DBObject::Employee(3pm)NAME
LedgerSMB::DBObject::Employee - LedgerSMB class for managing Employees
SYOPSIS
This module creates object instances based on LedgerSMB's in-database ORM.
METHODS
The following method is static:
new ($LedgerSMB object);
save
Saves an employee. Inputs required
entity_id
May not be undef
start_date
end_date
dob date
may not be undef
role
Not the database role. Either manager or user
ssn
sales
manager_id
employee_number
search
Returns a list of employees matching set criteria:
employeenumber (exact match)
startdate_from (start of date range)
startdate_to (end of date range)
first_name (partial match)
middle_name (partial match)
last_name (partial match)
notes (partial match)
Undef values match all values.
set_entity_class
Sets the entity class to 3.
get_managers
Retrieves a set of managers and attaches to $self->{all_managers}
save_location
Saves the location data for the contact.
Inputs are standard location inputs (line_one, line_two, etc)
save_contact
Saves contact information. Inputs are standard contact inputs:
entity_id
contact_class
contact
description
save_bank_account
Saves a bank account to an employee.
Standard inputs (entity_id, iban, bic)
get_metadata()
This retrieves various information vor building the user interface. Among other things, it sets the following properties:
$self->{ar_ap_acc_list} = qw(list of ar or ap accounts) $self->{cash_acc_list} = qw(list of cash accounts)
get Returns the employee record with all the inputs required for "save" populated.
Also populates:
locations
List of location info
contacts
List of contact info
notes
List of notes
bank account
List of bank accounts
save_notes
Saves a note to an employee entity.
Standard inputs (note, subject, entity_id)
delete_contact
required request variables:
contact_class_id: int id of contact class contact: text of contact information person_id: int of entity_credit_account.id,
preferred value
delete_location
Deletes a record from the location side.
Required request variables:
location_id location_class_id person_id
Returns true if a record was deleted. False otherwise.
delete_bank_account
Deletes a bank account
Requires:
entity_id bank_account_id
Returns true if a record was deleted, false otherwise.
get_user_info
Attaches the user_id and username to the employee object.
If the user does not have manage_users powers, this will simply return false
Copyright (C) 2007, The LedgerSMB core team.
This file is licensed under the Gnu General Public License version 2, or at your option any later version. A copy of the license should
have been included with your software.
perl v5.14.2 2012-03-10 LedgerSMB::DBObject::Employee(3pm)