[LØST] Kørsel af script via Crontab - Forskelle fra normal kørsel

#Adding information from static config file
[ -r /scripts/meraimport/config.sh ] && . /scripts/meraimport/config.sh

#Splash Intro
echo "################################################" >> $LOG
echo "#Script indsætter data fra MERA. Build: rc-1.0c#" >> $LOG
echo "################################################" >> $LOG
echo " " >> $LOG
echo "Today is $FDATE and starting Mera Data Import." >> $LOG
echo " " >> $LOG
echo "Changing to import dir: $SYSTEMDIR" >> $LOG
cd $SYSTEMDIR

echo " " >> $LOG
echo "Looking for new Mera Exports..." >> $LOG
LIST=(`find ./ -maxdepth 1 -name "*.xlsx"`)
if [ ${#LIST[@]} -gt 0 ];
then
        for f in *.xlsx
        do
                echo "  $f - Found!" >> $LOG
        done
        echo " " >> $LOG
        echo "Converting to .csv" >> $LOG
        echo "This might take a while..." >> $LOG
        for f in *.xlsx
        do
                /usr/local/bin/in2csv --no-inference $f > ./output/${f%.*}.csv 2> /dev/null
                echo "  $f - Done!" >> $LOG
        done

        echo " " >> $LOG
        echo "Inserting Rows from generated .csv" >> $LOG
        CSVLIST=(`find $SYSTEMDIR/output/ -maxdepth 1 -name "*.csv"`)
        if [ ${#CSVLIST[@]} -gt 0 ];
        then
                for f in $SYSTEMDIR/output/*.csv
                do
                        noPath=${f##*/}
                        noExt=${noPath%.*}
                        /usr/local/bin/csvsql --db mysql+mysqlconnector://$dbUser:$dbPass@$dbString:$dbPort/$dbSchema --tables $noExt --no-create --insert < $f >> $DLOG
                        echo "  Success - inserting $noPath into Table: $noExt - Done!" >> $LOG
                        STATUS='0'
                done

                echo " " >> $LOG
                echo "Cleaning up temporary files.." >> $LOG
                rm ./output/*

                echo " " >> $LOG
                echo "Create save folder if not exist.." >> $LOG
                if [[ ! -e $SAVEDIR ]];
                then
                        mkdir $SAVEDIR
                        echo "Folder created" >> $LOG
                elif [[ ! -d $SAVEDIR ]];
                then
                        echo "$SAVEDIR already exists but is not a directory" >> $LOG
                fi

                echo " " >> $LOG
                echo "Moving imported xlsx files to save directory" >> $LOG
                mv merae744.xlsx $SAVEDIR/merae744_$DATE.xlsx
                mv merae745.xlsx $SAVEDIR/merae745_$DATE.xlsx
                mv merae746.xlsx $SAVEDIR/merae746_$DATE.xlsx

                echo " " >> $LOG
                echo "Done moving files - Deleting files above 7days" >> $LOG
                # find $SYSTEMDIR/save/* -mtime +7 -exec rm {} \;

                echo " " >> $LOG
                echo "Changing permission on save folder" >> $LOG
                chown -R mera:mera $SYSTEMDIR/save

                echo " " >> $LOG
                echo " - Done!" >> $LOG

                echo " " >> $LOG
                echo "Zipping the logfiles and prepare for mail." >> $LOG
                cd /tmp
                bzip2 -k -z --best dbinsert.log

                echo " " >> $LOG
                echo "Sending email to $ADMIN and closes the script."  >> $LOG

                STATUS='0'
        else
                echo "$FDATE - NO CONVERTED FILES FOUND..." >> $LOG
                echo "Exiting Script - NO IMPORTED DATA.." >> $LOG
                STATUS='1'
                                break
        fi

else
        echo "$FDATE: - No Files found!!!!" >> $LOG
        echo "Verify that MERA has exported files" >> $LOG
        echo "Exiting Script - NO IMPORTED DATA.." >> $LOG
        STATUS='1'
fi

if [ $STATUS -gt 0 ];
then
        mail -s "FAILURE IN MERA DATA IMPORT - $DATE" $IT < $LOG
        echo "$FDATE: FAILUIRE importing mera Data - Investigate ASAP" >> $INSALOG
else
        echo "$FDATE: SUCCESSFULL import of mera data" >> $INSALOG
        cat $LOG |mutt -a $DLOG.bz2 -s "Success Mera Import Script: $DATE" -b $ANMO -b $KN -b$IT
        rm -rf $DLOG.bz2
fi