Wrap up time format in report

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Wrap up time format in report

Postby shan » Tue Jul 03, 2018 7:48 am

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
ViciBox v.7.0.3-160505
kernel: 4.1.20-11-default
Asterisk 11.22.0-vici
svn, version 1.8.10 (r1615264)
openSUSE Leap 42.1 (x86_64)"
architecture: x86_64
Dahdi 2.11.1
libpri.so.1.4
Vicidial VERSION: 2.12-552a
BUILD: 160429-0835
© 2016 ViciDial Group
shan
 
Posts: 38
Joined: Tue Sep 12, 2017 11:53 pm

Re: Wrap up time format in report

Postby blackbird2306 » Tue Jul 03, 2018 8:51 am

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?
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Wrap up time format in report

Postby shan » Tue Jul 03, 2018 9:03 am

No this is not an excel issue. For inbound calls, its showing correct. But for outbound calls, it is showing incorrect only.
ViciBox v.7.0.3-160505
kernel: 4.1.20-11-default
Asterisk 11.22.0-vici
svn, version 1.8.10 (r1615264)
openSUSE Leap 42.1 (x86_64)"
architecture: x86_64
Dahdi 2.11.1
libpri.so.1.4
Vicidial VERSION: 2.12-552a
BUILD: 160429-0835
© 2016 ViciDial Group
shan
 
Posts: 38
Joined: Tue Sep 12, 2017 11:53 pm

Re: Wrap up time format in report

Postby blackbird2306 » Tue Jul 03, 2018 10:17 am

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
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 83 guests