|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Log Parser - Telephone call log analysisI have a PBX (telephone server, if you will) that dumps call log data (SMDR) out to a text file. I think it might even be CSV. It may even be able to send it out over IP. I wanted to be able to write new records from the text dump to an SQL DB in real-time. For clarification, let's suppose: - Data spewed out over RS-232 / IP to .csv file or direct into "Log parser service": First Column=Date/Time, Second Column=Duration, Third Column=Source number, Fourth Column=Destination number . - "Log parser service" reads / captures data and maps and writes first column to sql-db1.table1.field1, second column to sql-db1.table1.field2, etc. - must be done in real time, so as soon as a call is logged a record must be written to DB. I have breifly glimpsed at MS Log Parser v2.2. It looks like it might be the answer, although it would involve some work. Has anyone ever used it as a service that would permanently run in the background requerying every 10 seconds, for example? I was hoping there might be something already written as a freeware, so if there is then please let me know. TIA, Jarryd I've used log parser and it does have a com interface which will allow you
to use it in a service. However I think you would be best off using some sort of port programming where the events you wish to trap are continually sent to a service which analyzes them and pushes them into the database when it meets the criteria you are looking for. -- Show quoteHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Jarryd" <jarryd@community.nospam> wrote in message news:OtI$bd0AHHA.144@TK2MSFTNGP02.phx.gbl... > Hi, > > I have a PBX (telephone server, if you will) that dumps call log data > (SMDR) out to a text file. I think it might even be CSV. It may even be > able to send it out over IP. I wanted to be able to write new records > from the text dump to an SQL DB in real-time. For clarification, let's > suppose: > > - Data spewed out over RS-232 / IP to .csv file or direct into "Log parser > service": First Column=Date/Time, Second Column=Duration, Third > Column=Source number, Fourth Column=Destination number . > - "Log parser service" reads / captures data and maps and writes first > column to sql-db1.table1.field1, second column to sql-db1.table1.field2, > etc. > - must be done in real time, so as soon as a call is logged a record must > be written to DB. > > I have breifly glimpsed at MS Log Parser v2.2. It looks like it might be > the answer, although it would involve some work. Has anyone ever used it > as a service that would permanently run in the background requerying every > 10 seconds, for example? I was hoping there might be something already > written as a freeware, so if there is then please let me know. > > TIA, > > Jarryd > > Hi Hilary,
I completely agree with all that you said. I am aware that log paser can do the job, but it would require a whole lot of configuring and testing that I would rather avoid. Do you know of any freeware packages that would be able to capture and analyse data from a specified port and insert it into a SQL table? TIA, Jarryd Show quote "Hilary Cotter" <hilary.cot***@gmail.com> wrote in message news:egWa$Q1AHHA.4348@TK2MSFTNGP04.phx.gbl... > I've used log parser and it does have a com interface which will allow you > to use it in a service. However I think you would be best off using some > sort of port programming where the events you wish to trap are continually > sent to a service which analyzes them and pushes them into the database > when it meets the criteria you are looking for. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Jarryd" <jarryd@community.nospam> wrote in message > news:OtI$bd0AHHA.144@TK2MSFTNGP02.phx.gbl... >> Hi, >> >> I have a PBX (telephone server, if you will) that dumps call log data >> (SMDR) out to a text file. I think it might even be CSV. It may even be >> able to send it out over IP. I wanted to be able to write new records >> from the text dump to an SQL DB in real-time. For clarification, let's >> suppose: >> >> - Data spewed out over RS-232 / IP to .csv file or direct into "Log >> parser service": First Column=Date/Time, Second Column=Duration, Third >> Column=Source number, Fourth Column=Destination number . >> - "Log parser service" reads / captures data and maps and writes first >> column to sql-db1.table1.field1, second column to sql-db1.table1.field2, >> etc. >> - must be done in real time, so as soon as a call is logged a record must >> be written to DB. >> >> I have breifly glimpsed at MS Log Parser v2.2. It looks like it might be >> the answer, although it would involve some work. Has anyone ever used it >> as a service that would permanently run in the background requerying >> every 10 seconds, for example? I was hoping there might be something >> already written as a freeware, so if there is then please let me know. >> >> TIA, >> >> Jarryd >> >> > > No, I know of no application out there that I know of that could do this. If
you have the money I have the time. -- Show quoteHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Jarryd" <jarryd@community.nospam> wrote in message news:%23U022X1AHHA.3604@TK2MSFTNGP04.phx.gbl... > Hi Hilary, > > I completely agree with all that you said. I am aware that log paser can > do the job, but it would require a whole lot of configuring and testing > that I would rather avoid. Do you know of any freeware packages that > would be able to capture and analyse data from a specified port and insert > it into a SQL table? > > TIA, > > Jarryd > > "Hilary Cotter" <hilary.cot***@gmail.com> wrote in message > news:egWa$Q1AHHA.4348@TK2MSFTNGP04.phx.gbl... >> I've used log parser and it does have a com interface which will allow >> you to use it in a service. However I think you would be best off using >> some sort of port programming where the events you wish to trap are >> continually sent to a service which analyzes them and pushes them into >> the database when it meets the criteria you are looking for. >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Jarryd" <jarryd@community.nospam> wrote in message >> news:OtI$bd0AHHA.144@TK2MSFTNGP02.phx.gbl... >>> Hi, >>> >>> I have a PBX (telephone server, if you will) that dumps call log data >>> (SMDR) out to a text file. I think it might even be CSV. It may even >>> be able to send it out over IP. I wanted to be able to write new >>> records from the text dump to an SQL DB in real-time. For >>> clarification, let's suppose: >>> >>> - Data spewed out over RS-232 / IP to .csv file or direct into "Log >>> parser service": First Column=Date/Time, Second Column=Duration, Third >>> Column=Source number, Fourth Column=Destination number . >>> - "Log parser service" reads / captures data and maps and writes first >>> column to sql-db1.table1.field1, second column to sql-db1.table1.field2, >>> etc. >>> - must be done in real time, so as soon as a call is logged a record >>> must be written to DB. >>> >>> I have breifly glimpsed at MS Log Parser v2.2. It looks like it might >>> be the answer, although it would involve some work. Has anyone ever >>> used it as a service that would permanently run in the background >>> requerying every 10 seconds, for example? I was hoping there might be >>> something already written as a freeware, so if there is then please let >>> me know. >>> >>> TIA, >>> >>> Jarryd >>> >>> >> >> > > Hi Jarryd,
Thanks for using Microsoft Managed Newsgroup. Please ignore some impolite words here which may lead to your unease. I think that it is just a joke. For your question regarding Log Parser v2.2, per my experiences, Log Parser can provide you high efficiency on querying such plain text files. Though there may be some configurations, I think it is worth your try. You may test it before you put it into your production environment. Even if you develop an application or use a third party freeware, a test before you put it into a production environment is also required. Just one more thing that I want to remind you that as a freeware it is not supported by Microsoft. However if you encounter any programming issue, you can have a new post in our programming related newsgroups (language related newsgroup is a better choice) and I believe you will get supports there. Hope this helpful. If you have any other questions or concerns, please feel free to let us know. It is always our pleasure to be of assistance. Charles Wang Microsoft Online Community Support ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ======================================================  |
|||||||||||||||||||||||
Other interesting topics