Shift reminder system


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shift reminder system
# 1  
Old 06-16-2011
Shift reminder system

Hi,
Help me with a script which can read shift related data(in .csv file) and send a mail to the user reminding them about the shift.. Already there is a table with empid,name,mailid) need to use this table for this task
# 2  
Old 06-16-2011
what is shift related data ?

give the input csv file and the output expected
# 3  
Old 06-16-2011
input file looks like this
Date Shift1_name Shift2_name Shift3_name
16/6/11 raja ramu somu
.....

i want a script that could read the name and send a mail on a daily basis(mailid if raja is stored in a table) ., telling him about the shift...
# 4  
Old 06-16-2011
what table ?

what you have tried so far ?
# 5  
Old 06-16-2011
i have created a table with the fields,
empid name mailid
1 raja raja@xy.com
and entered the values of all persons who are in that file...

Now i want a script that could fetch the data in (input file .csv file) and compare it with the above table to send a mail to specific persons reg their shifts
# 6  
Old 06-16-2011
So , you want a script which runs and checks only the "Date" part from the file and mail to the user . ( the sample mail something like this : Raja -> Shift1 ) ?
# 7  
Old 06-16-2011
Hi Panyam.,
Ya, u r partly right ., validation needs to be done not only for "Date" part but also for the "name" part since there can be more than one person in a shift.. so there should be some scenario wherin u can get the name and compute their EMPID and by using that u can send a mail to a particular user!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shift command help

#!/bin/bash hostname=$1; shift for hostname in $1 do ping $hostname done I want to run the above script as hostname.sh yahoo.com google.com cnn.com. I want to shift each hostname to $1. How can do that with above code as currently it's not shifting. (5 Replies)
Discussion started by: scj2012
5 Replies

2. Shell Programming and Scripting

Use of Shift command

Hello Expert Can any one please explain what is the use of shift command in general terms: set -- $(ls -t) shift rm -Rf $* what is the use of shift command over here. Thanks a lot for your help (2 Replies)
Discussion started by: aks_1902
2 Replies

3. UNIX for Dummies Questions & Answers

A Shift into UNIX

Hi, Firstly, I did a search for this question both on this site and on the internet and have not been able to find a suitable answer that is not general in nature. I have always been a Windows user. I use my girl friend's mac every now and then, but I always come back to windows. For a... (1 Reply)
Discussion started by: mearex
1 Replies

4. UNIX for Dummies Questions & Answers

shift not working

Hi, I wrote one script, in between script needs to use 10th and 11th positional parameters, that time i used "shift". Here i am facing the below find problem, ./DataCount.sh: cannot shift I tried 1) I have read man pages for shift 2) Before but * and ** 3) Simple shift with out giving... (4 Replies)
Discussion started by: Nagapandi
4 Replies

5. Shell Programming and Scripting

shift command

Hi Folks, In shell scripting the maximum no. of command line parameters becomes 9(Am i right). If we want to get more than 9 parameters we use the shift command. Even here there are two possibilities. 1. Without the use of variables - The arguments are lost and the lost no. is equal to the... (6 Replies)
Discussion started by: Nisha
6 Replies

6. UNIX for Dummies Questions & Answers

shift command

There is an error when i am trying to use the shift command in this way: ($1 = -d, $2 = 123, $3 = -c etc etc) for $arg in $@ do case $arg in "-d") shift; (so that the $2 will become the $arg now) (and while it loop the 2nd time,) ... (1 Reply)
Discussion started by: AkumaTay
1 Replies
Login or Register to Ask a Question