Search results for query: *

Has anyone found a way to automate getting the web traffic data generated by Google Analytics into a SQL table. There is no ftp option within GA, only an automated email, which supplies an attachment containing the report in pdf or csv format. There are a few loose ideas I have, but I don't...

Has anyone managed to write to the NBUser table? We want to batch update/correct the user departments, titles etc, but the only way we can see to do it so far is by using the web client for a one by one horrendous manual process. We can view the table but can't write to it using the sysadmin...

I am running SQL Server 2000. I have a large table of several million records. All I want to do is to add a new column, so I go to table design, insert a new column, put in the column name and change the type to int. Then when I hit save it just hangs. Egg timer. I have left it for 2 hours...

I am using SQL Server 2005. We have a dozen linked servers, which I can use a SELECT query fine to access the data and I can run the system stored procedures EXEC sp_catalogs 'LinkedServerName' & sp_tables_ex LinkedServerName fine to see what is in the Server/db. The problem I have is that...

I have stored procedures, which display data perfectly in 15 minute interval blocks eg 17 May 2009 00:00:00 17 May 2009 00:15:00 17 May 2009 00:30:00 etc etc However, when I run the report in Reporting Services the 00 has changed to 12 eg 17 May 2009 12:00:00 17 May 2009 12:15:00 17 May 2009...

I have dozens of jobs that run overnight to pull back data from a few separate databases. They have been running for a few years, with very little trouble at all. They always succeed. Now suddenly, last night one of the jobs failed. Only one job. How can this suddenly happen? I ran the DTS...

Been a while since I have done scripting so this may be an easy one for you to answer. Script xxx says QUEUE TO SKILLSET aaa WITH PRIORITY 1 and script zzz says QUEUE TO SKILLSET bbb with PRIORITY 2. If there is a steady flow of calls coming into xxx, and one call came into script zzz, where...

We have recently upgraded to CC6 and have discovered a loss of functionality. In our master script we had a command ---------------------------- IF OUT OF SERVICE SkillsetGroupA THEN EXECUTE SCRIPT Script1 END IF ---------------------------- SkillsetGroupA is a skillset variable that contains...

We have CC6 and we do not use the standard historical reports. Instead we connect to the database and write our own queries against it. We have 2 days - 10th and 12th June - where there is no data in the dApplicatonStat view, but there is data in the iApplicationStat view. Anyone got any...

I have a query and the end user needs to have the postcode field in the dataset in either this format 'AB1 1AB' or this format 'AB12 1AB' (For the non Brits, UK postcode can be 7 or 8 characters) Currently the database has them stored as AB11AB or AB121AB i.e. no space separating the high and...

Does anyone know why the Calls Answered figures in the dAgentByApplication tables differ from the figures in the dApplication table. I use Crytal Reports to sum Calls Answered for one application for one day from the dApplicationByAgent table and the dApplication table and there is a difference...

I have a Crystal Report that counts up all weekend calls, by month. I have created a Crystal formula to perform this - I am trying to recreate this in a stored procedure to use elsewhere, but the results are quite different. SELECT Datepart(yy,CONVERT(DateTime, CONVERT(varchar(10)...

Hi guys I am experienced in Crystal Reports, SQL Server 2005 and bits and pieces of HTML, Javascript, ASP. I want to learn Visual Basic to improve my job prospects - lots of jobs local to me ask for VB6 or VB.Net - but I don't know where to start - VB6, VBA, VB.Net, VBScript..so confusing! I...

Hi guys, had a weird problem start today. I've been using Crystal 9 & 10 on a daily basis for a couple of years now - currently using 10. I created a simple report today and went to drag in a field from the field browser into the report in preview mode, as I normally do and I got the old...

I scanner a pile of University handouts straight into pdf format and, muppet that I am, I scanned some of them the right way around and some of them upside down. Obviously, I want them all to be the right way up. I have used a freeware program to split up the pdf into single files, but when I...

We have a major issue here that is affecting delivery of our service. We have 2 sites, with a Symposium server on each, which are networked together. Staff at each site log in to their respective local Symp server. We have a skillset that is quite exclusive - only a handful of agents have it...

Hi,guys I had reports that a supervisor was watching the standard agent display in RTD's and that calls were not going through to the longest idle agents and that people were receiving calls when they were not ready for them*. I have used Crystal Reports to check the data and have the...

On the real-time reports, an team leader has reported an agent having the word "Consultation" in there. (Where it usually says idle, active etc) Can anyone tell me what that means and what has to happen for that to appear?

How can I do it? I can store digitcollects in a variable and use them but I'm stumped with this CDN one.

Hi guys We had somebody here today from Nortel trying to sell us Symposium 6. We are currently on 5 (I guess). He was talking about the historical reporting, particularly to do with the email inbound contacts, and I asked the question, "can you connect Crystal Reports to the databases?" and...