Generate a Summary report

Shell Programming and Scripting
1

Hi All,

Script to meet my requirement might be simpler for UINIX experts.. :slight_smile:
I need to generate an summary report in .txt file using shell script

I have Reject directory in Unix server which contains all reject files for three diff categories- Presentation, Chapter and Scene

Following are the reject files

Reject_Lookup_Error_Presentation.csv
Reject_Lookup_Error_Chapter.csv
Reject_Lookup_Error_Scene.csv
Reject_Read_Error_Presentation.csv
Reject_Read_Error_Chapter.csv
Reject_Read_Error_Scene.csv

_____________________________________________________

Summary report Should be generated by identifying the file name and size. If any of the file size related to Presentation (*_Presentation.csv) is > 0 then. The summary report should display - "Presentation file has error in loading"
If all files related to presentation are 0 size then it should display "Presentation file loaded successfully"

Now my Summary report should look like below

_______________________________________

Presentation file has loaded successfully
Chapter file has error in loading
Scene file has error in loading

_____________________________________

Kindly help me with the code. I need it urgently.

2 
 
for file in Presentation Chapter Scene
do
count=$(find . -type f -prune -name "*_$file.csv" -size +0c -print | wc -l)
if [ $count -ne 0 ]; then
echo "$file file has error in loading" >> logfile
else
echo "$file file has loaded successfully" >> logfile
fi
done

Hope this helps

3

@Pikk45

Your code cause the "Reject" directory to be scanned 3 times ...
you should change it to do it in one pass instead. :wink:

4 
 
find . -type f -prune \( -name "*_Presentation.csv" -o -name "*_Chapter.csv" -o -name "*_Scene.csv" \) -size +0c -print | awk ' /Presentation/{p=p+1}
/Chapter/{c=c+1}
/Scene/{s=s+1}
END {print p, c, s}' | read Presentation Chapter Scene
for count in $Presentation $Chapter $Scene
do
if [ $count -ne 0 ]; then
echo "$count file has error in loading" >> logfile
else
echo "$count file has loaded successfully" >> logfile
fi
done

@ctsgnb: Hope this does the trick :slight_smile: