Extracting data from the "blue" database

[Odium]

Hi,

in computers where Symposium client is installed, using the ICCM_PREVIEW_DSN (odbc components) i can import data to ms excel from any table in the symposium "blue" db.

Now, my problem is that i don't know the table name where
DN to POSID correspondance are registered.

can anyone help ?
thank you.

 

[atchuvely101]

If you are referring to table with phonesets (TN, name etc) then its called SwitchPort

 

[Odium]

Hi, thank you for your help, i've already tried the SwitchPort table but there's something wong with the retrieved data:

SwitchID : only obtained data fields with value "1"
PortAddress: everything OK here
PositionID: this is nonsense values, doesn't appear to be
valid PosID's, must of the fields have duplicated numbers or "0".
Type : everything OK here
Status : everything OK here

and finally my extensions (DN) doesn't appear nowhere.

any ideas why PosID doesn't appear correctly and why DN are
missing ?

thank you very much for any help !
Jose.

 

[Supernn]

Within Symposium there's no link between the DN and the Position ID.
This is something you can collect on your PBX.

This was one of the reasons why we insert a part of the Position ID into the Name field of the PortAddress.

As soon as the agents login, the eAgentLoginLogout table gets updated with the field Position ID.

Can you tell me why you need the link between DN and Position ID?

 

[Odium]

infact, i need DN to TN (PortAdress) mapping correspondance.

because PosID = DN + 500 (in my case).


thx again.

 

[Supernn]

You should print it in the PBX and capture the output.
If you use Excel (like mv.xls, you can retrieve it from this site:

http://www.pepedog.com/meridian)

you can create easy to use filters and keep your TN's sorted.

 

[Odium]

thank you , will try it

 

[tex52]

Is there a way to pull from the Symposium database without having to install the Sympoisium Client? We are running 6.0.

 

[Supernn]

You need the Sybase drivers for this.

 

[DancingDave]

Ref Odium's question above

any ideas why PosID doesn't appear correctly and why DN are
missing ?

We too were looking to get a print out of all pos ids (so our IVR suppliers could ensure all pos ids were registered with their CTI server) and we also found that the field was populated with zeros.

The response from Nortel was that "it may be an error in the NTP, or a bug in the software". As we run Symposium 4.2, there's scant chance of getting this looked at.

Oh, well.

DD

 

[tex52]

Can someone tell me where I can get the sybase drivers? are they on the CC 6.0 cd?

 

[D41G0N]

When you install the SCCS client on a workstation, it installs the Sybase ODBC "driver" on the workstation and creates DSNs that then use the provider.

 

[tex52]

I do not want to have to install the SCCS client. This is going on a server and I just want to be able to connect to the DB without having the overhead of the client.

 

[D41G0N]

what we did is install sysbase (included on the sccs client software cd) on the sever. One of the components it installs is the SYBASE OPEN CLIENT ODBC provider. Create a system DSN using this provider to connect to the SCCS blue DB.

 

[Emo008]

You need install the Sybase Open Client for DB connectivity.

The DN - PosId is in a table (NIUser), you only have access to the views.

 

[brewerdude]

Here's a good thread that speaks to how to connect directly to the Sybase database:

http://www.tek-tips.com/viewthread.cfm?qid=1263747