IP PBX Manual Reporting - Revision history

Mike Lunn: /* Export CDR Report */

2014-10-17T14:45:30Z

Export CDR Report

Mike Lunn: /* Queue Graphs */

2014-10-17T14:43:24Z

Queue Graphs

Mike Lunn: /* Queue Graphs */

2014-10-17T14:42:53Z

Queue Graphs

Mike Lunn at 19:51, 4 June 2013

2013-06-04T19:51:04Z

Mike Lunn at 19:50, 4 June 2013

2013-06-04T19:50:33Z

Nichole: /* Queue Graphs */

2013-05-23T17:37:09Z

Queue Graphs

Nichole: /* Reports */

2013-05-23T17:29:08Z

Reports

Mike Lunn at 20:26, 24 April 2013

2013-04-24T20:26:05Z

Mike Lunn at 20:25, 24 April 2013

2013-04-24T20:25:45Z

Show changes

Mike Lunn at 20:21, 24 April 2013

2013-04-24T20:21:30Z

@@ Line 115: / Line 115: @@
 #Enter the date range and retrieve the report that you want to export (see steps for Viewing Report).
 #Click the '''Export''' button then specify the location where you want to download the report.
 == Queue Graphs ==

← Older revision		Revision as of 14:43, 17 October 2014
Line 213:		Line 213:
	\|}		\|}

−	NOTE: Time/Date in the reports is displayed in Epoch time. Excel does not have a native way to translate this to a format that is easily read. In order to do this, create a new column in the spreadsheet and use the following formula:

−	~~=(A1/86400)+25569~~
−
−	where A1 contains the UNIX time should convert to Excel date/time. A1 is the cell designation. Once you enter this formula in one cell, be sure to format the cell to Custom: date:h:m:s, and you will see the date and time. Then you can mouse over the bottom right corner of the cell and a bold + will display, click and drag down, and the cell data will be copied down the column, updating the cell number to reflect appropriately.

	===== Graph Tab =====		===== Graph Tab =====

@@ Line 212: / Line 212: @@
 | style="border:0.0069in solid #0000ff;  padding-top:0in;  padding-bottom:0in;  padding-left:0.075in;  padding-right:0.075in" | Time spent paused out of the queue. Number of calls displayed in parenthesis.
 |}
 ===== Graph Tab =====

@@ Line 68: / Line 68: @@
 Transferred: Connected call successfully transferred.
-Busy: Call out a trunk returned busy status, or extension was busy.
+Congestion: Call out a trunk returned busy status, or extension was busy.
 Note: Defines the call is still active, and the status will update when completed. Click on the call record for details.

@@ Line 11: / Line 11: @@
 Call Data Records (CDR) can be sorted by specific time periods. CDR may also be exported in the same date range format. The records have also been enhanced for easier reading, and comprehension of data. To sort simply select the date range you wish to be displayed, and then press the view button. The display will be arranged and sorted according to your date selections.
-[[File:cdrreports.png|center]]
+[[File:Cdrreports.png|center|Cdrreports.png]]
 {| style="border-spacing:0"
 |-
-| style="background-color:#b8cce4; border-top:0.0069in solid #0000ff; border-bottom:0.0069in solid #0000ff; border-left:0.0069in solid #0000ff; border-right:none; padding-top:0in; padding-bottom:0in; padding-left:0.075in; padding-right:0.075in" | <center>'''Sections/Fields'''</center>
+| style="background-color:#b8cce4;  border-top:0.0069in solid #0000ff;  border-bottom:0.0069in solid #0000ff;  border-left:0.0069in solid #0000ff;  border-right:none;  padding-top:0in;  padding-bottom:0in;  padding-left:0.075in;  padding-right:0.075in" | <center>'''Sections/Fields'''</center>
-| style="background-color:#b8cce4; border:0.0069in solid #0000ff; padding-top:0in; padding-bottom:0in; padding-left:0.075in; padding-right:0.075in" | <center>'''Description'''</center>
+| style="background-color:#b8cce4;  border:0.0069in solid #0000ff;  padding-top:0in;  padding-bottom:0in;  padding-left:0.075in;  padding-right:0.075in" | <center>'''Description'''</center>
 |-
 | '''Date/Time'''
@@ Line 75: / Line 75: @@
 Exited With Key: Call to Queue that follows the Exit Menu key press
 |}
@@ Line 87: / Line 89: @@
 #Locate to the '''General Settings''' section (second section from the top).
 #Locate the SPC Reports User Password field (bottom of section)
-#It may be helpful to change this to a user-friendly password. If you change the password be sure to [[File:savechanges.png]] and '''Apply Changes''' .
+#It may be helpful to change this to a user-friendly password. If you change the password be sure to [[File:Savechanges.png]] and '''Apply Changes''' .
 #Make a note of this password.
-#On the PC that will be used to access CDR Reports and Queue Graphs via SPC, open a web browser and navigate to the IPitomy PBX login screen [[File:reportslogin.png]]
+#On the PC that will be used to access CDR Reports and Queue Graphs via SPC, open a web browser and navigate to the IPitomy PBX login screen [[File:Reportslogin.png]]
 #Using the right sideSmart Personal Console (User Login) input the word “reports” as the user name and the password that you noted previously.
 #Click on '''Login'''.

@@ Line 118: / Line 118: @@
 Queue Graphs display additional call information for ACD Queues. A PBX must be licensed for ACD for this button to appear.
+[[File:queuegraphs.png|center]]
 {| style="border-spacing:0"
@@ Line 155: / Line 155: @@
 The Overview Tab offers an overall summary of the calls for the period in question for that queue. The overview will display textual information for answered and unanswered calls, as well as a graph summarizing the information.
+[[File:overviewtab.png|center]]
 {| style="border-spacing:0"
@@ Line 188: / Line 188: @@
 The Agents tab displays details for queue members.
+[[File:agentstab.png|center]]
 {| style="border-spacing:0"
@@ Line 214: / Line 214: @@
 The Graph Tab provides a graphical view of queue calls only. Inbound and outbound calls are tabulated but not graphed. The graph tab divided into time segments defined by the Sorting setting set previously. The information presented in this tab will allow you to determine busiest times and when call coverage is most needed.
+[[File:graphtab.png|center]]
 ===== Logs Tab =====
 The Logs Tab will display the complete call log for the queue from your search setting. It will display the time of the call, the direction of the call either inbound or outbound, the caller ID that was delivered with the call, the location that the call was delivered to, the wait time for the caller, the total duration of the call, and finally the outcome of the call or the final status of the call. See the table for CDR Report Descriptions for detailed information about the fields.

@@ Line 110: / Line 110: @@
 '''STEPS:'''
-#From the '''Reporting''''''Reports '''page, click on the '''CDR Report''' button. The '''CDR Report''' page appears.
+#From the '''Reporting=>''''''Reports '''page, click on the '''CDR Report''' button. The '''CDR Report''' page appears.
 #Enter the date range and retrieve the report that you want to export (see steps for Viewing Report).
 #Click the '''Export''' button then specify the location where you want to download the report.

@@ Line 99: / Line 99: @@
 '''STEPS:'''
-#From the '''Reporting''''''Reports '''page, click on the '''CDR Report''' button. The '''CDR Report''' page appears.
+#From the '''Reporting=>Reports '''page, click on the '''CDR Report''' button. The '''CDR Report''' page appears.
 #Select the '''From''' and '''To''' date range by click on the box next to the From and To fields. Use the calendar control page that appears to select the desired dates.
 #Click the '''View''' button. A report with call information from the date range parameter that was entered is displayed.