I was planning to start working on something like this myself. Was planning to do this in WSH or similar, just a small script which runs on windows startup (not login) which monitors the COM port for activity (COM/ActiveX object) and forwards it to the script for processing, which then formats it and drops it in an Access or SQL DB via ODBC.
It would be nice to have the 'automatic handover' to Programmator, but I wouldn't know how to go about that. Your solution is smarter on the whole (Windows service which can be monitored and restarted easily). Personally, I wouldn't worry about the front-end, MS Access + Excel can do miracles with DB data. Let me know if I can help in any way... I'm running a (live) KXTD-1232 ----- Original Message ----- From: "David CM Weber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 17, 2004 9:47 PM Subject: KX-T: SMDR Poll I have been thinking about my own company's needs as far as keeping track of SMDR data. I'm a programmer by trade, and I ended up tossing around some ideas and came up with the following: Computer runs a service which monitors for SMDR data (and will automagically give up the COM port should programator get spawned [details need to be worked out]) Computer will parse the SMDR data, and put the data into a nice database. There will be another application/front end to work with the database to allow for searching of data, make graphs, charts, etc.. Is this something that anyone would be interested in? I figure w/ the information in a database, it would be easy to search through and be less cumbersome than text files or *gasp* hardcopy printouts. _________________________________________________________________ KX-T Mailing list --- http://kxthelp.com/ Subscription changes: http://kxthelp.com/mailman/listinfo/kxt _________________________________________________________________ KX-T Mailing list --- http://kxthelp.com/ Subscription changes: http://kxthelp.com/mailman/listinfo/kxt
