Page 1 of 1

Wrap up time format in report

PostPosted: Tue Jul 03, 2018 7:48 am
by shan
Dear all,

The wrap-up time column in the "Export Call Report" is showing in date and time format of excel, whereas it should show the values in numbers (seconds).
Please assist me ASAP in getting this fixed.

wrapup_time
02-07-18 23:16
30-06-18 17:04
03-07-18 0:52
03-07-18 1:31
03-07-18 3:47
03-07-18 6:05
03-07-18 8:47
03-07-18 9:40
03-07-18 9:41
03-07-18 10:08
03-07-18 10:13
03-07-18 10:17

Re: Wrap up time format in report

PostPosted: Tue Jul 03, 2018 8:51 am
by blackbird2306
I think this has just something to do with your excel cell format settings and is not a vicidial issue. Download the .txt report and open it with Notepad++ and then find the right wrapup time column. Is it there also in sqldate format?

Re: Wrap up time format in report

PostPosted: Tue Jul 03, 2018 9:03 am
by shan
No this is not an excel issue. For inbound calls, its showing correct. But for outbound calls, it is showing incorrect only.

Re: Wrap up time format in report

PostPosted: Tue Jul 03, 2018 10:17 am
by blackbird2306
I'm referring to your previous posts and give you the same advice as Matt gave you: Upgrade or even better reinstall your vicidial system. You wrote about customizations in your code, somehow you seem to have broken some elementary things.
http://vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=38251
http://vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=38412