Panasonic TCP/IP to database logger.

[dpacza]

Good afternoon.

I have a panasonic TDE 200 that I am trying to do smdr with over TCP/IP (port 2300), writing the result out to a SQL Server database.

I am having trouble passing the PCCSMDR password to the phone system to connect

I have downloaded the ACSII data query and parser module, but can not get the PBX data.

Thanks

[Arthur Grasin]

By default, the Panasonic NCP/TDE system requires a username/password (default: SMDR/PCCSMDR) to connect to the TCP/IP feed.

You can activate the ASCII Data Query and specify the login/password
request as:

SMDR#0D#0APCCSMDR#0D#0A

[dpacza]

Good morning.

The connection string worked perfectly.

I would now like to take the output and write it to a database.  I have configured the parser to do this, however it does not appear to be working (it is writing to the screen).

I have configured and tested a SQL server connection, and confirmed that the underlying database exists?

Thanks.

David.

[Arthur Grasin]

Please, read our tutorials:

http://www.aggsoft.com/pbx-data-logger/tutorials.htm

[dpacza]

Good afternoon.

How much would it cost us for you to provide an end to end solution?  We would like to use your software to do TCP/IP SMDR from a Panasonic TDE200, to a table in a SQL Server 2008 database.

Thanks.

David.

[Arthur Grasin]

Hello David.

In your case your need the Professional license + the SQL plugin. Prices are here:

http://www.aggsoft.com/pbx-data-logger/buy.htm

[dpacza]

Good morning Arthur. 

I understand the products that I need, however I am having do not have the time to work with your products to customized the retrieval of the data stream from our Panasonic TDE200 and write it out to a SQL database.

Are we able to pay AGG time and materials to provide us with a complete solution (preconfigured) that I can simply install, run a script (or follow detailed specific instructions), and have your software write to the database?

Thanks.

[Arthur Grasin]

Please, look here:
1. http://www.aggsoft.com/pbx/panasonic-kx-tde-200-ring-cost.htm
2. http://www.aggsoft.com/asdl-pbx-system-data-logger-export.htm

In you case, you need:

1. Install the software and select the necessary options in the installation wizard (your PBX, database type, etc).
2. Configure the query plugin (see link #1 above).