I setp a MySQL database called CDR and I am using winbatch to capture from the Serial interface on the CS1000 to a HPDL 320 server.
Capturing data from the serial port and writing it to the MySQL database all works great. Instead of a record id and the output string. I would like to break it down by In/Out bound, EXT and outside number. I would index these three table to make for faster reports.
I need the CS1000 break down of each line, Example
N 033 00 4272 T000020 05/02 14:45 00:04:36 A 790019541231234
I figured the last set of number is a number I can figure out teh date and time, but I would really like a complete breakdown of each possible line I could encounter. Does anyone know if this exist?
Capturing data from the serial port and writing it to the MySQL database all works great. Instead of a record id and the output string. I would like to break it down by In/Out bound, EXT and outside number. I would index these three table to make for faster reports.
I need the CS1000 break down of each line, Example
N 033 00 4272 T000020 05/02 14:45 00:04:36 A 790019541231234
I figured the last set of number is a number I can figure out teh date and time, but I would really like a complete breakdown of each possible line I could encounter. Does anyone know if this exist?