Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Winbatch using Serial Extender pushing to MySQL Database

Status
Not open for further replies.

Buhdakahn

IS-IT--Management
May 10, 2011
2
0
0
US
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?
 
I found that there may be as many as 25 fields. here is breaking the string down with dilimiters
N;033;00;4274; ; ; ;T000020; ; ; ; ; ; ; ; ; ; ; ; ;05/02;14:45;00:04:36;A;790019543364480
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top