Caller ID Software

caller id softwareYES Tele.com, Caller ID Software Experts

Caller ID Software
 Programming
 Programming
 Hardware
Home
Hardware
Programming
Hardware
Contact







Posting Caller ID Data to a Web Site

When you're out of the office, have access to your call data via the Internet.
  • Post Caller ID to Web Site as soon as caller id data is received
  • Post Call Summary at end of call, both incoming and outgoing
  • E-Mail Call Data
  • Send Call Data as SMS Message to Cell Phone
  • Save Call Data in Web Accessible Text File
  • Save Call Data in Web Database
When our free WinLog Software receives the Caller ID data from our Identifier, it can post it to a web site. The Web site can then e-mail, send an SMS message to a cell phone, save the data to a text file of database. As shown in the WinLog Setup form below, all you have to do is specify the Web Site the data should be sent to.


The Technical Details

In the WinLog setup form you can specify when data is posted to the Web. There are 3 options:
  • Immediately as Caller ID signal is received
  • At the end of an Outgoing Call
  • At the end of an Incoming Call

You can specify the above options to be enabled or disabled.

To post just Caller ID data check Post Caller ID to Web" and select "Disable" for the "Post End of Call Data" option.

To post just outgoing you uncheck "Post Caller ID to Web" and select "Outgoing" for the "Post End of Call Data" option.

To post just incoming you uncheck "Post Caller ID to Web" and select "Incoming" for the "Post End of Call Data" option.

When any of the above events occurs, an HTTP call is made via the Windows API. In this example we post to a fictitious site "mySite.com". The POST data is processed by an PHP script named "calls.php".

When the call to the Windows API is made, Windows will use the default browser to post the data to the web site. If the browser is not already running Windows will Run the browser. In the WinLog setup you can specify any site and cgi script. The data can be posted to perl, PHP, ASP, ASPX, or any cgi that will accept the data in the standard http post format (&field=data).

The following data is posted:

  • The phone number (&number=)
  • Caller ID Name or WinLog Phonebook Name (&database=)
  • Call Type (CID, IN, OUT) (&Type=)
  • Call Length (&Length=)
  • Call Record Number (&Index=)
An Example HTTP POST string:
http://www.mySite.com/call.php?ID=4441403&calltime= 3:34pm&calldate=APR 27,2009 &name=YES TELECOM&number=954-344-7665&database=YES Telecom&Index=71826&Type=IN2 &Length=0:01:14&DOW=MON

To display the call records, use an URL like this:

http://www.yourWebSite.com/LogTable.php?ID=4441403 (ID is Identifier Serial Number)

Add &rows=XXX, where XXX= number of records to display:

http://www.yourWebSite.com/LogTable.php?ID=4441403&rows=100

For a compact mobile format use:

http://www.yourWebSite.com/MobileTable.php?ID=4441403

    ID = Identifier Serial Number
    calltime = Time call began
    calldate = Date of Call
    name = Caller ID Name
    number = Pone Number, Dialed or Caller ID
    database = Contact Name in record associated with the phone number
    Type = Type of Call, OUT, IN, or Ring (not answered). IN and Ring are followed by the number of time the phone rang.
    Length = Length of Call in Hours:Minutes:Seconds
    DOW = Day of the Week.

Sample PHP Scripts

The following sample PHP script the process the POST data. The first section e-mails the data. The second section save the data in a text file. The last section save the data to a mySQL database table.





The following PHP script displays the call data in a tabular form.





Download Now Download PHP Scripts 3K bytes zipped

Click Here for Instructions to the Create SQL Database

The following SQL query creates the mySQL table used in the above PHP script. 

CREATE TABLE `Calls` (
  `id` mediumint(9) NOT NULL default '0',
  `record` mediumint(9) NOT NULL default '0',
  `datetime` varchar(36) character set armscii8 NOT NULL default '',
  `DOW` char(4) character set armscii8 NOT NULL default '',
  `length` varchar(8) character set armscii8 NOT NULL default '',
  `calltype` varchar(6) character set armscii8 NOT NULL default '',
  `number` varchar(16) character set armscii8 default NULL,
  `name` varchar(15) character set armscii8 default NULL,
  `database` varchar(32) character set armscii8 default NULL,
  `Time` varchar(7) character set armscii8 NOT NULL default '',
  `Date` varchar(12) character set armscii8 NOT NULL default '',
  KEY `id` (`id`,`record`)
) ENGINE=MyISAM ;