Agent Time Detail Report

[Alexvs]

Hi,

My admin.php version is as follows:

VERSION: 2.2.1-237
BUILD: 100510-2015

I'm trying to download the Agent Time Detail report which I've run for yesterday and it doesn't export all the "0" values which means some of the values are now in the wrong columns. From what I can tell it is actually ignoring these values and moving everything over to the left. These reports are being used daily by the team leaders but there is alot of manual work involved for them having to fix where everything should be just to get the correct figures.

The Agent Status Detail report however works perfectly recognising all values including "0" and therefore we can use these figures knowing they're correct.

Can this issue be fixed easily? Or can something be changed by the IT team here to get it working?

Thanks

[mflorell]

Please open a ticket in the Issue Tracker with a full description of the problem and an example download if possible.

[williamconley]

and please post your installation method (name and version of .iso and installation instructions, link if it's an online instruction set).

also remember that upgrading to the latest SVN will often resolve issues (if anyone else has reported the same issue). even if you stick with 2.2.1, but latest SVN of that branch (forgive the note if you've already done that, i didn't check your build to see if it was the latest, this is general advice ).

[Alexvs]

Thanks I've logged a ticket for it.

I'm not sure of the installation method as we had a consultant install it for us.

As for the latest SVN, I'll have to have a read as not sure what that is and if it'll help or be compatible with how we're working using SIP.

Thanks for your help.

[williamconley]

SVN is how you would load the latest update to this version of this software (bug releases, etc) or upgrade to the next version.

Click on VICIDIAL Wiki at the top of this screen and then How to Use SVN.

In case there have been any bugs since you installed your software, this is the method to get the "latest greatest" or at least the "repaired and patched" of the version you are using.

[Alexvs]

I have a further question regarding this report so didn't want to start another thread. Also I've spoken with the IT team at my office and as they didn't install Vici they're not comfortable upgrading the system and we don't really want to get a consultant in again in order to do it all for us due to costs. Is there a way for us to write a report that pulls off the same information as the time detail but without any of the space padding in the cells and in an excel format that includes all the values in the correct time format using our current version? We have people in IT that can use asterisk, MySQL and PHP and if a query could be made in any of these then that would be ideal.

At the moment the only way to get all of the data including "0" values is to copy and paste the table into excel and use text-to-columns, using | as the delimiter. Only problem with this is that all of the cells are padded out with spaces and in text format meaning they can't be used for formulae I use to work out month to date values and when I remove all spaces it changes the format into hh:mm:ss which is correct except all minutes become hours which is wrong. Sorry to go on and if this has crossed over to a feature request then I can submit this in the correct area if you wish.

Thanks

[mflorell]

Yes, you can take the source of that report and edit it under a different name if you like. You could also ODBC into the database in your favorite reporting program(like Crystal Reports or MS Access) and do it right from there.

[Alexvs]

This is excellent news, I'll try the Access route first. Thanks again, support on this site is great and so quick

[mflorell]

For the "Agent Time Detail" report, did you notice the DOWNLOAD link on that page?

[Alexvs]

Yeah I tried this and logged an issue on the Issue Tracker for a bug that I found. When downloading this report it ignores all zero values and moves the next cell to the left so they're all in the wrong columns. I've also found when trying to create some stats as the values are padded with spaces I can't do sums on them unless I remove spaces which then formats them to time (hh:mm:ss) with all the minute values changing to hours and seconds to minutes unless the value is over an hour already. Hope that makes sense.

[mflorell]

Issue Tracker Link:
http://www.eflo.net/VICIDIALmantis/view.php?id=394

[Alexvs]

Yeah that's the issue I logged and have an example report attached to it to show what it currently looks like.

[lvish]

Hi


I have added '00:' to Ftime variable under precision M in functions.php. With this addtion am able to get the reports exported to excel or open office with out any issues. Excel cell format is set to [h]:mm:ss.

Only difference is all time related report displays in hh:mm:ss even if the value of hh is 00.

Am Not sure of the effect of this php script change in any other report/ database.

regds

lvish

VERSION: 2.6-365a
BUILD: 120420-1620,