Search results for query: *

have u tried to run the dtsrun command on the dos prompt directly? Also what is the user account for running the store procedure? Is it the same account u logged on the windows? I got the same problem before as the sql account doesn't have authority to run in command.

Thanks

Thanks You very much! I have created a report to count number of trunk used per minute by the orig_time and term_time for each trunk record in calldetail.

Chris13, Can you share how to build a canvas for custom-view to show usage of a trunk-group as a graph in 1/2-hour intervalls. Thanks Samuel

I want to have it. Can you send to me at wfyeung@hotmail.com. Thanks Samuel

For question 2, if you want to add calldetail, why don't you modify the 'Agent Perfomance (Detail) Report' instead? For question 1, what do you change on the formula? MISC1 and MISC2 are the field for network interqueue calls. Please provide more detail.

jocago, hello, I am interesting how to write a vb to update the output filename. Can u provide more information? Many Thanks Samuel

Dear all, Just a stupid question. Where can I find out the exam. schedule/location? I am in Hong Kong. Any exam in HK? Many Thanks

thanks, currently i am using the same tech to extract data based on sql by condition on the term_date. it is fast but still taking around a few mins to complete. as we have over 10 sites, the volume of data is also growth. I am afraid it will take too long to be done. moreover, the most hard...

One more finding is that calldetail in SQL2K will set as view instead of table. I don't know why it is located/classified as view. Moreover, I have an question whether we can copy the data from call_today instead of calldetail (a big table). The problem is how to ensure the full data copied...

Moebius01, Yes, I extract data daily from calldetail table in SQL2K and no error encounters so far. I just setup ODBC connection to the oracle and then setup a DTS package to import the data. By using the link server, I am not sure whether it works or not as I am not good in SQL2K. Regards...

in this case, i think Ibass solution is better.

I am note sure if this can help. Can I suggest to put 1 more group/order by date for each person? If you group/sort the record by date in desc order, then the first record will be most recent record. group by id group/sort by date in desc order print the first record when id...

Hello jestrada101, sorry to jump in. Would you check the command 'select expert' under the report in the menu bar? If the selection criteria for date is not there, please setup it.

Thanks you very much. I will check with my colleagues.

Yes agree not to use the interflow...............but I am only to do reporting. For call flow, I dun have right to speak........... As I am new to call center stuff, can u tell me more about CLI/ANI? Thanks

Chris13, Thanks you so much! Track Number.............This is the interesting part....I though they had the same track number. Unfortunately, they are not same. That is why I can't relate those records. For interqueue, yes it is as what u say. However, I get problem if it is interflow...

Thanks Chris13 and Moebius01. We have interflow setting and I have checked 2 messages recorded in Call Detail table in each ACD. Seems there is no any relationship between these messages. So it is hard to calclulate the queue time as these 2 messages should be counted as 1 but the queue time...

Moebius01, Sorry to jump in. But I really have question as below. Refer to the second problem 'Reporting' for interflow, do u have any suggested solution for it???? Many Thanks Samuel

Hello Drisk, Can u teach me more about how to calculate "C = Average Call Duration in Seconds"???? What type of xacts should be included??? For example, call_type = ???, trans_type = ??? and disposition = ????. Many Thanks Samuel