Validate input files daily


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Validate input files daily
# 1  
Old 04-01-2013
Validate input files daily

We have a job which we need to run on daily bases, before loading data in a table we need to validate whether the input file is received or not.
Daily client will place the files in a particular path.Below files which I need to process for 04/01/2013(Load date).
src_sps_d_Call_Center_Reporting_20130329(yyyymmdd) _01.dat
src_sps_d_Call_Center_Trancation _20130329(yyyymmdd )_01.dat
src_sps_d_Payment_transaction _Reporting_20130329(yyyymmdd )_01.dat
src_sps_d_Call_Loan_ Reporting_20130329(yyyymmdd )_01.dat

I have one ss_calendar file which contains whether load date will contain file or not.
Servicer ,Load date, file will come or not
SPS, 3/29/20013,N
SPS , 4/1/2013, Y
Ocwn, 3/29/2013,N
Ocwn,4/1/2013, N

And I have another file ss_Load_Proc which contains information about which load day should contain which file.
Servicer , Load day, inputfiles
SPS , Tuesday,Monday and Friday
SPS ,Wednesday Tuesday
SPS, Thursday , Wednesday
SPS , Friday,Thursday
OCWN , Monday , Monday

Suppose if I am loading data for 04/01/2013 date ,first from SS_Calendar I want to check whether for SPS servicer will file come or not.If the indicator in Y then in ss_Load_Proc file I should check whether days in inputfiles column and DD in Input file are same or not.If day matches then I shouid touch one file.If file is missing then I should drop email to team and update the name(date) in Missing.TXt file.


Please tell the procedure to write shell script.

Last edited by katakamvivek; 04-01-2013 at 08:25 AM..
# 2  
Old 04-01-2013
Please use codetags as advised!!

Make your statements more human readable please.. Smilie
# 3  
Old 04-01-2013
Did you do anything for this??

Started up with something?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Validate input files and update

We have a job which we need to run on daily bases, before loading data in a table we need to validate whether the input file is received or not.Inputfile formatsrc_sps_d_Call_Center_Reporting_yyyymmdd_01.dat SPS-Service nameYYYY-yearMM-MonthDD-dayLike above we will get n number of files for... (1 Reply)
Discussion started by: katakamvivek
1 Replies

2. Shell Programming and Scripting

How to validate user's input..?

$Input_filename=$ARGV; if (!-d $Input_filename && ! -e $Input_filename) { print "USAGE: Please enter '$ABCD/def/dsed.txt' as an arguement \n"; exit; } 1. Input Is suppose to be something like "$ABCD/def/dsed.txt". if the input is wrong the script should throw an ERROR message.... (2 Replies)
Discussion started by: Rashid Khan
2 Replies

3. Shell Programming and Scripting

Epic - Validate input size

Is there an easy way to validate an input field size. Let us say a script is asking to enter 10 digits mobile number, how do I write a script to validate it is numeric and is 10 digits in length? I just need an easy way w/o using looks ...etc. Is there such a away ? Here is what I have so far... (6 Replies)
Discussion started by: mrn6430
6 Replies

4. Shell Programming and Scripting

Another validate input Question.

I'm writing a bash shell script to 'help' me post to susepaste (I can NEVER remember the time options). Here's the code: #!/bin/bash ########## # # Project : personal script. # Started : Wed Aug 03, 2011 # Author : Habitual # Description : susepaste c-li script with user... (5 Replies)
Discussion started by: Habitual
5 Replies

5. Shell Programming and Scripting

How to validate input parameters?

Hi, I wonder how I can know if the input parameters to the script are numbers or text Thanks (11 Replies)
Discussion started by: Gengis-Kahn
11 Replies

6. Shell Programming and Scripting

Validate and sort input

Hi, This will most likely be a simple answer. Currently I have a situation where my script will be sent various options: -o1 -o2 -oe3@somthing.com Now, if I want to run a certain command based on the option I am sent, I am doing the following. for o in $(echo $options) do if ... (3 Replies)
Discussion started by: stuaz
3 Replies

7. Shell Programming and Scripting

validate input

the user inputs names that have to be inside square brackets I want to check if the user puts the brackets and if not ask him to re-enter the names (9 Replies)
Discussion started by: DDoS
9 Replies

8. Shell Programming and Scripting

Need to validate a date input format

Hi all, I have a shell script(K shell) which takes a date as input. i want the input to be in DD-MM-YYYY format. Can i enforce such a format of input string using just one line of code? OR do i need to parse the input date into different components and test them using Case statements... (2 Replies)
Discussion started by: rajugp1
2 Replies

9. Shell Programming and Scripting

How to validate input values

Hi How would i validate value of a variable whether it is number,date or string Thanks in advance Sas (5 Replies)
Discussion started by: SasDutta
5 Replies

10. Shell Programming and Scripting

validate input from user for file name

Hello, This may have been addressed already somewhere, however I am looking for the easiest/shortest way to validate a response from a user for a file name. The file name should not have any of the following characters ~`!@#$%^&*()_-+={|\:;"'<,>.?/ Further the response should not have any... (2 Replies)
Discussion started by: jerardfjay
2 Replies
Login or Register to Ask a Question