Shell command to detect file size

Tables:

guid - request reference guid params - add reference to the audio and csv status 0,1 - process start / stop notification

common cdr

id phoneno dialedtime answeredtime dialstatus endtime reason calltype - ivr,voiceplay sipdomain - ipaddress sipcodec -

summary cdr

id
guid
userid
callerid
source
destination
templateid
dialedtime
answeredtime
endtime
dialstatus
reason 
created
updated
deleted

rails g scaffold Record guid:string userid:integer callerid:string source:string destination:string templateid:integer dialedtime:integer answeredtime:integer endtime:integer dialstatus:string reason:string call templates

id name desc flocation mode - 0 - active , 1- inactive timestamp

rails g scaffold CallTemplate name:string desc:string flocation:text mode:integer,{comment => '0- active mode,1 -inactive mode'}

Concept:

/usr/bin/sox "output1.wav" -r 8000 -c 1 -s -2 "output1x.wav"

balaji@balaji-HP-ProBook-440-G1:~$ cat csv\ db/1lakh.csv | wc -l 99999

balaji@balaji-HP-ProBook-440-G1:~$ head -99999 csv\ db/1lakh.csv

To print the fields from second fields to last field, you can omit the last field position.

cut -d':' -f2- file.txt

sed -n 16224,16482p filename > newfile

sed -n 1,16p csv\ db/1lakh.csv

audiomaps

userid audioid guid cliporder status

rails g scaffold AudioMap userid:integer audioid:integer guid:text cliporder:integer status:integer

csvmaps

userid csvid guid status

rails g scaffold CsvMap userid:integer csvid:integer guid:text status:integer

generators

guid userid csvfile csvcount processedcount status

rails g scaffold Generator userid:integer guid:text csvfile:text csvcount:string processedcount:string status:integer