By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Call Logging

P: n/a
Hi

I have written a few applications using VBA in both Excel and Access.
These proved quite successful and I have been asked to write something
a little more complex.

Basically we have a phone system that produces data on port 4001. I
need to be able to capture this data and deliver it to a table so that
I can then write reports that will show who called, when called,
duration of call, etc.

I will be OK with the reporting side of it but have no idea where to
start with capturing the data. I am happy to be able to capture the
data to a file and then use an import to get it to the database.

In order to start the logging process a password needs to be
transmitted in one block / packet.

At the moment I can telnet to port 4001 and enter the user name and
password I then see a line output for every call that is made. It is
theses lines that I need to capture somewhere in order to manipulate
them later.

Any help gratefully received.

Thanks

James
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On 17 Feb 2004 07:13:45 -0800, ja***@frog.co.uk (James) wrote:

Contact the vendor of the phone system. They have every incentive to
make it easy to work with their equipment. If they are any good, they
already have some whitepapers or sample programs available for you to
use as a starting point.

-Tom.
Hi

I have written a few applications using VBA in both Excel and Access.
These proved quite successful and I have been asked to write something
a little more complex.

Basically we have a phone system that produces data on port 4001. I
need to be able to capture this data and deliver it to a table so that
I can then write reports that will show who called, when called,
duration of call, etc.

I will be OK with the reporting side of it but have no idea where to
start with capturing the data. I am happy to be able to capture the
data to a file and then use an import to get it to the database.

In order to start the logging process a password needs to be
transmitted in one block / packet.

At the moment I can telnet to port 4001 and enter the user name and
password I then see a line output for every call that is made. It is
theses lines that I need to capture somewhere in order to manipulate
them later.

Any help gratefully received.

Thanks

James


Nov 12 '05 #2

P: n/a
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<1a********************************@4ax.com>. ..
On 17 Feb 2004 07:13:45 -0800, ja***@frog.co.uk (James) wrote:

Contact the vendor of the phone system. They have every incentive to
make it easy to work with their equipment. If they are any good, they
already have some whitepapers or sample programs available for you to
use as a starting point.

-Tom.

Thanks for the suggestion Tom

What little information I have has come from the Vendor. We are
working very closely with them as this is a new phone system on the
market. Unfortunately the call logging side is way down their list of
priorities, which is why I am embarking on this project.

I believe the phone system is based on "Apache Server" if that helps
anyone else give me a clue as to how to capture this data.

Cheers

James
Nov 12 '05 #3

P: n/a
You've probably already thought of this, but this post would probably get better response in a unix/linux group. It's not an Access problem. Btw, I assume
you're on windoze. This sounds like the kind of thing that is readily done under unix/linux -- in which case you should know about Cygwin -- which is open
source, free linux environment that runs under windoze and might make this a lot easier.

On 18 Feb 2004 00:44:36 -0800, ja***@frog.co.uk (James) wrote:
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<1a********************************@4ax.com>. ..
On 17 Feb 2004 07:13:45 -0800, ja***@frog.co.uk (James) wrote:

Contact the vendor of the phone system. They have every incentive to
make it easy to work with their equipment. If they are any good, they
already have some whitepapers or sample programs available for you to
use as a starting point.

-Tom.

Thanks for the suggestion Tom

What little information I have has come from the Vendor. We are
working very closely with them as this is a new phone system on the
market. Unfortunately the call logging side is way down their list of
priorities, which is why I am embarking on this project.

I believe the phone system is based on "Apache Server" if that helps
anyone else give me a clue as to how to capture this data.

Cheers

James


Nov 12 '05 #4

P: n/a
Pat
James,
I work in a call center, so your question appealed to me. Since you say
that you can telnet to view the data live, my approach would be to first
find a way to automate a telnet session and retrieve this data.

Searching on Google with "VB telnet" I found a few interesting pages (and
one commercial Active X control) discussing ways of interfacing via telnet.
From what little I read, it seems that you can scrape the data from your
telnet sessions into tables or files.

HTH. I'd be interested to hear how your project turns out.
Pat
"James" <ja***@frog.co.uk> wrote in message
news:68**************************@posting.google.c om...
Hi

I have written a few applications using VBA in both Excel and Access.
These proved quite successful and I have been asked to write something
a little more complex.

Basically we have a phone system that produces data on port 4001. I
need to be able to capture this data and deliver it to a table so that
I can then write reports that will show who called, when called,
duration of call, etc.

I will be OK with the reporting side of it but have no idea where to
start with capturing the data. I am happy to be able to capture the
data to a file and then use an import to get it to the database.

In order to start the logging process a password needs to be
transmitted in one block / packet.

At the moment I can telnet to port 4001 and enter the user name and
password I then see a line output for every call that is made. It is
theses lines that I need to capture somewhere in order to manipulate
them later.

Any help gratefully received.

Thanks

James

Nov 12 '05 #5

P: n/a
Andrew W <accessdev at pobox dot com> wrote in message news:<11*************@news.rcn.com>...
You've probably already thought of this, but this post would probably get better response in a unix/linux group. It's not an Access problem. Btw, I assume
you're on windoze. This sounds like the kind of thing that is readily done under unix/linux -- in which case you should know about Cygwin -- which is open
source, free linux environment that runs under windoze and might make this a lot easier.
Yeah - this is the sort of thing the perl hackers would eat for
breakfast :-) You could probably put together a three-line script that
would output a nice CSV file that could be opened by (for instance) a
popular Windows-based desktop database...

Apache's a web server, though, so it seems odd that the only interface
is by telnet - I'd guess there's an HTTP interface. Have you tried
pointing a browser at that port, rather than a telnet client?

On 18 Feb 2004 00:44:36 -0800, ja***@frog.co.uk (James) wrote:
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<1a********************************@4ax.com>. ..
On 17 Feb 2004 07:13:45 -0800, ja***@frog.co.uk (James) wrote:

Contact the vendor of the phone system. They have every incentive to
make it easy to work with their equipment. If they are any good, they
already have some whitepapers or sample programs available for you to
use as a starting point.

-Tom.

Thanks for the suggestion Tom

What little information I have has come from the Vendor. We are
working very closely with them as this is a new phone system on the
market. Unfortunately the call logging side is way down their list of
priorities, which is why I am embarking on this project.

I believe the phone system is based on "Apache Server" if that helps
anyone else give me a clue as to how to capture this data.

Cheers

James

Nov 12 '05 #6

P: n/a
Andrew W <accessdev at pobox dot com> wrote in message news:<11*************@news.rcn.com>...
You've probably already thought of this, but this post would probably get better response in a unix/linux group. It's not an Access problem. Btw, I assume
you're on windoze. This sounds like the kind of thing that is readily done under unix/linux -- in which case you should know about Cygwin -- which is open
source, free linux environment that runs under windoze and might make this a lot easier.


Thanks Andrew (and Pat who responded elsewhere)

I think I am getting somewhere. By adding a Windows socket control
into my application I think I should be able to capture the data line
by line as it comes out of the phone system via socket 4001. I can
then append it to a file for further manipulation.

I am currently experiencing difficulty getting the control enabled as
kit is reported as not being correctly licensed but I have posted that
issue to Microsoft.

I will update everyone if it works.

thanks again

James
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.