bDrwx
1/17/2017 - 1:00 PM

parse CDR by line Parsing CDR for importing to MongoDB Janvar APP

parse CDR by line Parsing CDR for importing to MongoDB Janvar APP

more S170111A.txt | awk -F";" '{ print strftime("%Y-%d-%m %H:%M:%S",mktime(substr($1,2,4) " " substr($1,6,2) " " substr($1,8,2) " " substr($1,10,2) " " substr($1,12,2) " " substr($1,14,2))) "," $3 "," $7 "," $8 "," $20}'

mongoimport -d fsb -c cdr --type csv --headerline --columnsHaveTypes --file imp.p1