Data Log via IP into tables

PhilAJ

New member
Local time
Today, 18:54
Joined
Sep 13, 2009
Messages
5
I need to write an application to collect and process data coming from our Telephone digital pbx.

I have a connecton to the system - via a network cable - and can connect using HyperTerminal and see the data coming through as calls are made.

Ideally, I would like to do this in VBA in Access - and have a module just 'sit there' receiving the data and putting it into a table.

Could anyone tell me how I can develop code or use a control that will capture this data?

Thanks in advance

Phil
 
i don't even know what a pbx is, but you already said you have the connection. fool around with it. see if it has a relation to access in anyway. for example, see if there is a type library you can download for that device you're using. an example i could use would be if i wanted to move about in firefox. office programs do not have firefox libraries in them, because there were none available up until like last year. so....if I wanted to create the ff object in VBA, i would download the DLL from mozilla, check the box in access references, and WHALLAH! the programming objects appear in the intellisense dropdown! maybe you could do the same thing with this "thingy" your using for calls?


i just thought i'd mention this too....I use PHP to get IP addresses and domain names of visitors. not sure if it would be any use to you, but if you know PHP, the HTTP_REMOTEHOST of the $SERVER variable is easy to use to capture and put in remote or outside reports.
 
Last edited:
Thanks for reply Ajettrumpet.

Sorry - should have explained further - a pbx is basically the control box of a telephone system. Stood for 'Private Branch Exchange' - but basically now used to just describe the little box in the corner that conrtrols the dozen or so telephone. The main telephone line comes into this box and then this handles the distribution to extensions.

The data related to each call, ie Phone No, time on, extension no etc, is put out through an IP connection and I can see it in Hyperterminal as it happens, but it isn't stored anywhere, hence i need to capture it real time.

There are no libraries for it - or certainly none you can buy - because they want you to buy their software at a couple of thousand £ a go.

I guess what I need is some sort og library or control that just listens on a Port on an IP address and gets the data.

Phil
 
Found lots of stuff about the MSComm control...but how how I get it into Access. Can't see it in the references or the additional Controls.

Will this let me listen over IP on a specific port ?

Thanks
 

Users who are viewing this thread

Back
Top Bottom