Bash Script

How to convert xls files to csv in Linux

Install xls2csv

yum -y install xls2csv

To convert your xls file to csv, just type this command:

convertxls2csv -x filename.xls -c filename.csv

This script is very useful if you have a lot of excel files to convert. This will help you save a lot of time than converting it one by one.

#!/bin/bash
for files in *.xls
do
convertxls2csv -x "$files" -c "${files%.*}.csv"
done

Asterisk 1.2 auto install script for CentOS 4 and CentOS 5

I created an auto install script to install Asterisk 1.2 for CentOS 4 and CentOS 5. This script will install the following:

  • Zaptel
  • Libpri
  • Asterisk
  • Asterisk Addons
  • Open Source G729 Codec

Before running these script, you must install the some software needed to compile Asterisk.
For CentOS 4:

yum install gcc kernel kernel-devel bison openssl-devel

For CentOS 5:

yum install gcc kernel kernel-devel bison openssl-devel libtermcap-devel ncurses-devel

kernel-smp-devel (instead of kernel-devel) is necessary if you are using a dual core processor.

Syndicate content