Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CmdrGravy

    Excel Render - Strange Results

    Has anyone come across this before... Our reports are deployed through sharepoint, when people run a report and choose to export it to Excel the report will sometimes come out in Excel OK but at other times extra lines are inserted between the data lines, the data lines are shrunk so they're...
  2. CmdrGravy

    Time Spent while Agent Not Answering Calls

    It's been a while since I last saw an Aspect but as well as ring time you can also find out wait time, hold time and ring time. You need to check in the options to see exactly what is included in these measurements but I am pretty sure you can use either wait time or ring time to get the info...
  3. CmdrGravy

    Offline Database for Reporting

    This was a while ago so I don't remember all the details anymore but I did have a system setup to merge data from 2 ACD's using a VB program and a MySQL database. It's easy enough to get the data out from both ACD's, I think I grabbed the Apps and Groups tables along with the Call Details and...
  4. CmdrGravy

    Cause Scheduled Program to 'Fail'

    That's a good idea, Thanks.
  5. CmdrGravy

    Info prompts

    Do I understand this correctly ? You have a report which can be ran off monthly ( or for other periods ? ) so you want a prompt when it's scheduled so you can choose "Last Month" or whatever period you want to schedule it for ? Basically what you need to do is write formula which looks at your...
  6. CmdrGravy

    Cause Scheduled Program to 'Fail'

    Hi, I'm using Seagate Info 7.5 Most of our reporting needs to take place on a MySQL database which is populated by a VB program every night around midnight. If this program crashes then the MySQL database is not populated and the reports return blank. This VB program is also scheduled to run...
  7. CmdrGravy

    CINFO on MySQL ?

    Hi, My CINFO database is currently stored in Access but has grown to around 200MB ( even after compaction ) and I would like to move it to a proper database. However I cannot afford SQL Server, Oracle or Informix so I am wondering if anyone has found a way of using MySQL as the CINFO database...
  8. CmdrGravy

    Script To Read CCT Tables Required

    Thanks EJW, I have found it's quite easy by looking at the CCT_STEP and CCT_VARIABLE table provided you realise that Aspect have misnamed the fields and the Major Version field is actually telling you if the step is in the Edit or Released set. Aspect tell you what all the individual parts of a...
  9. CmdrGravy

    Script To Read CCT Tables Required

    Hi List, This is probably a shot in the dark but maybe someone out there will be able to offer some advice... The ACD I support provides call routing for only around 400 or so analysts but the call flows are have developed into a tortorous spiders web of Supergroups and Groups where we've...
  10. CmdrGravy

    Seagate info 7.5

    The link below explains a lot better than I just did the various ways Seagate Info can be set up: http://support.crystaldecisions.com/communityCS/TechnicalPapers/si_boilerplatearch.pdf.asp?recDnlReq=Record&dnlPath=si_boilerplatearch.pdf"
  11. CmdrGravy

    Seagate info 7.5

    I think there are 2 things you could look at doing which might help the situation: 1) Customise the reports so that all the departments could get the information they required for their own department from one report which would cut down the number of reports you are producing. 2) Seagate is...
  12. CmdrGravy

    Seagate info 7.5

    If you get any joy on this from Aspect please let me know because I'd be very interested in their soloution. I think I tend to agree with you that 300 - 400 reports a night is very likley to over run to the next day, if you have from between Midnight - 8AM then that's around 480 mins which...
  13. CmdrGravy

    Trying to list all Agent Idle Codes in Report Runner/Writer

    I think the problem is that if no one has selected a particular code during the reporting period then it does not appear in the report because none of the records will refer to that code. I think you either need to find some way of querying the data which will always include all the Idle Code...
  14. CmdrGravy

    warning from Outlook, tools to turn it off or allow control permanent

    Unfortunatley if the error is being generated by Outlook I don't think there's anyway of turning it off, at least not that I've ever seen in Report Runner or Outlook. The best bet is to see what the error is moaning about and prevent it from occuring. If you can post the text of this error...
  15. CmdrGravy

    Subreport/Querying Problems

    Would it be possible to to create something in Access which collates the data you need into one table ? You could probably write a small bit of VB code or something to perform the collation and either schedule that to run before your report or just run it every day or so to collate that days...
  16. CmdrGravy

    website is done in php and I don't know php

    ?id=HKJLiTet is a method of passing information back to the PHP Scrip so that it can react in some way based on the type of information passed back. I am guessing "HKJLiTet" is some kind of product id and that somewhere there is a database which contains the information for all your...
  17. CmdrGravy

    Probably Simple

    First of all you need to make sure you have set up Oracle ODBC DSN's for your other call centres on the reporting server. Once you've done that go into the "Aspects Reports/Picklists/" folder and look for the picklist relating to Call Centres, I think this is called CallCenter. Edit...
  18. CmdrGravy

    Teleset does not ring, only flashes LED on incoming call

    This is probably superflous advice but have you absloutley ruled out your users messing around with the volume on their telsets. Almost all the problems reported to me regarding telsets not ringing out turn out to be caused by the users turning the volume down accidentally and then not being...
  19. CmdrGravy

    Optimizing Aspect Call Center Reports

    michael, go to this url http://gravychain.co.uk/club/node/view/597 and you will find my description of the process I followed and all the relevant files etc.
  20. CmdrGravy

    Exporting Crystal Reports With Date In File Name ?

    I noticed that you can schedule batch files using SI7 but I haven't really investigated this much. I don't quite understand what you mean though when you say you can base the run condition on the presence of a generated file, do you mean you can somehow pass the outputted filename to the batch...

Part and Inventory Search

Back
Top