|
Title: Pbx data logger to insert auto unique identifier ? Post by: rich2010 on March 03, 2011, 11:57:46 PM Hi
We bought PBX data logger last year and it works great. It reads the smnp output from our Avaya IPO and binds the data via ODBC TO SQL Server. One issue that we have to overcome is that one of the fields from PBX is CALL_ID. This is a "unique" field for every call through the PBX. The problem is that anytime the Avaya is reset, for whatever reason, the CALL_ID number is also reset, so you can end up with non-unique entries in this column. We however always need them to be unique in the database. Is there a way to get PBX data logger to insert a value into a uniqueidentifier field in the database each time it logs a call into it? Or is there some other way to overcome this problem? Many thanks Rich Title: Re: Pbx data logger to insert auto unique identifier ? Post by: Arthur Grasin on March 04, 2011, 09:13:51 AM Just create an auto increment column in the database and don't bind this field within the ODBC plugin (exclude from binding at all).
|