ODBC TABLES AND SQL

[Tontas]

Hello this is my 1st post so please be gentle.

We have had symposium for about 6 months now HMMM and it is really good with historical reporting! - no really it is! .. I extract the data into excel and painfully manipulate it so it will go into an access database.

We noe have decided to connect via ODBC and everything is going ok until we need info on NR reason codes...We use codes for our wrap time (NR time) and use activity codes during calls for logging purposes. We also use code to tell if we are on a 121 or break etc.... there is no way of seeing at what state the phone was in when these codes where put in...

We have adapted to the standard report but I am finding it hard to replicate using ODBC and the symposium tables....

Is there anywhere i can tap into the standard suite of reports and pinch the SQL.??? if so how.

Many thanks

 

[DancingDave]

How about creating a bespoke Crystal Report template that you can import into Symposium?

Run the report with the new template and then do your export of data and conversion.

From what I've seen of Crystal, most things are possible, however, that's only an impression; I'm no programmer!!

DD

 

[joynew68]

Yes, connecting via ODBC there are not separated tables for Activity codes and Not Ready Reason codes like via Symposium SMI/ Reports.
But while Activity codes inserted during conversation are associated to relevant application-script, NRD codes have just System_Application.
So you can separate both kind of codes using filter for Application item :
equals or does not equal System_Application.

Hope it could help,

joy

 

[Tontas]

Sounds good.....

Could you point me at the right tables ... i get the activity info from ActivityCodeStat but not sure what table/s to link it to in order to determine the system_application or the application_script

thanks for the ideas!

T

 

[joynew68]

Go to table d(i,w,m) ActivityCodeStat --> choose Columns you need --> only incl rows where Aplication equals System_Application for NRDcodes or Application does not equal System_Application for Activity Codes …. finish.

Hope it makes sense,

joy

 

[Tontas]

brilliant that worked a treat... it is alwyas the simple things you overlook...thanks

T