09-29-2015 05:12 AM - edited 03-14-2019 03:15 PM
Can someone please explain how I can change the date/time format in the CCDR report when I export the data to an SFTP location?
I get:
Node ID - Session ID - Sequence Number,Start Time,End Time,Contact\Type,Contact\Disposition,Originator\Type,Originator\ID,Originator\Directory Number,Destination\Type,Destination\ID,Destination\Directory Number,Called Number,Original Called Number,Application Name,Queue Time,Talk Time,Hold Time,Work Time |
1-479000083644-0,Wed Sep 02 06:55:30 CEST 2015,Wed Sep 02 06:55:34 CEST 2015,1,1,3,,079300155,2,,7011460233,7014457000,7014457000,AE-test,,0,,
But I would like to have 1-12000236548-0,2015-06-29 18:34:30.825,2015-06-29 18:34:33.264,1,1,3,,00655794289,2,,50410138,512588809,512588809,Poli-ACD,,0,, |
09-29-2015 06:14 AM
Hi
I've done this for a client before - I basically created a custom version of the report which exported the date field as a string rather than a datetime.
That requires access to CUIC premium and some SQL skills if you have them.
Aaron
10-05-2015 05:25 AM
Hi Aaron,
Good to know... But is is possible to expain me a little bit how? Or to export the custom report so I can import it again?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide