root@pi3plus:/var/www/html/upload/cgi-bin/files# pwd
  /var/www/html/upload/cgi-bin/files

  * files

  script_sendsms.sh  script_test.sh  sendsms.log  sms_message.txt  tmp.txt

====== first version ======


  * script_sendsms.sh

  #!/bin/bash
  
  re='[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
  smsgw=root@10.11.12.253
  inputfile=$(ls files/* | grep xlsx)
  
  xlsx2csv $inputfile --all > files/all.csv ;
  
  echo `date`----- >> files/tmp.txt
  
  while IFS=, read -r col1 col2
  do  number=$(echo $col1 | grep '^[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
    echo $number
  
  if [ "$number" != '' ]; then
  #   echo yes
      echo 0$number
      echo 0$number >> files/tmp.txt
  #   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/id_rsa.pub $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
  #   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
      ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'" < /dev/null
  #    sleep 5
     echo Remote Command Return Code: $?
  #    sshtest=$(ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'")
  #    sshtest = $(ssh -o "StrictHostKeyChecking=no" $smsgw "asterisk -x 'dongle sms dongle0 i80$number testing'")
  #    echo $sshtest
  else
      echo no
  fi
  done < files/all.csv
  
  rm files/*.xlsx
  rm files/*.csv
  

====== New version passing the text field ======

  #!/bin/bash
  
  re='[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
  smsgw=root@10.11.12.253
  inputfile=$(ls files/* | grep xlsx)
  logfile=files/sendsms.log
  message=$(cat files/sms_message.txt)
  
  xlsx2csv $inputfile --all > files/all.csv ;
  
  echo `date`----- >> $logfile
  
  while IFS=, read -r col1 col2
  do  number=$(echo $col1 | grep '^[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
   echo $number
  
  if [ "$number" != '' ]; then
  #   echo yes
  #    echo 0$number
      echo 0$number >> $logfile
  #   ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/id_rsa.pub $smsgw "asterisk -x 'dongle sms dongle0 0$number testing'"
       ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle sms dongle0 0$number $message'"
  #    ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'" < /dev/null
  #    ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle show devices'" < /dev/null
      echo 0$number
      sleep 2
      echo Remote Command Return Code: $? >> $logfile
  #   sshtest=$(ssh -o "StrictHostKeyChecking=no" -i /home/www-data/.ssh/www-data $smsgw "asterisk -x 'dongle ussd dongle0 *123#'")
  #   sshtest = $(ssh -o "StrictHostKeyChecking=no" $smsgw "asterisk -x 'dongle sms dongle0 i80$number testing'")
  #   echo $sshtest
  else
      echo no >> $logfile
  fi
  done < files/all.csv
  
  rm files/*.xlsx
  rm files/*.csv