improved kayako console import V3 to V4 (php ./index.php /Base/Import/Version3/1)

import.sh

#!/bin/sh

DatabaseHost="localhost"
DatabaseName=$1
DatabasePort=""
DatabaseSocket=""
DatabaseUsername=$2
DatabasePassword=$3

isImportCompleted() {
 echo -n "$(date)" >> import.log
 echo -e "\
 ${DatabaseHost}\n\
 ${DatabaseName}\n\
 ${DatabasePort}\n\
 ${DatabaseSocket}\n\
 ${DatabaseUsername}\n\
 ${DatabasePassword}\n"| \
# tee -a import.log | \
 php ./index.php /Base/Import/Version3/1 | \
 sed '/Version3 Import/d' | \
 sed '/====================/d' | \
 sed '/Database Host:/d' | \
 sed '/Database Name:/d' | \
 sed '/Database Port (enter for default port):/d' | \
 sed '/Database Socket (enter for default socket):/d' | \
 sed '/Database Username:/d' | \
 sed -re 's/Database Password://' | \
 sed '/^\s*$/d' | \
 tee -a import.log | \
 grep -s "Completed"
}

echo "\n$(date) start" >> import.log
until isImportCompleted
do
 echo -n "."
done
echo "$(date) completed" >> import.log