LOGIN
Go to App

Scheduled Agent Report to CSV upload or e-Mail

JEDWare Agent Report

This Agent report will contain: ExtensionId, FullName, InboundAnswered, InboundLost, OutgoingAnswered, OutgoingLost, InternalAnswered, InternalLost, TotalAnswered, TotalLost, AnsweredProcent, LostProcent, TotalTalkTime, AverageTalkTime

The CSV end result for a JEDWare Agent Report, when imported to Excel, will look similar to the one below

How to set up an Agent Report in CSV format.

In the JEDWare left menu, click Report -> Scheduled tasks, and click on the top menu CSV GENERATION

Select the Agent report

We do offer templates for:

  • —-Agent—-
    Agent report 
    Agent report – Outbound
    Agent report – Total
    Group report
    Group report – Total
  • —-Status—-
    Agent Status
    Agent Status Group
    Agent Status Detailed
    Agent Status Detailed Group
    Queue – Availability
  • —-Queue—-
    Queue report
    Queue – Per day
    Queue – Inbound Activity
    Ring Group
  • —-Miscellaneous—-
    All Calls report
    Trunk
    Company total report

Click OK, and we are ready to set up the report

1.) Select the Agents you want in this report (1)

2.) Include in the report, Call types and weekdays (2)

Select the specific settings for your Report selection, eg. only lost Inbound Calls, only Monday and Friday and so on.

3.) You can use our Exclude settings, (3)

Use exclusions, if you don’t want to report calls shorter than xx seconds, or perhaps Calls with a Talktime shorter than xx Seconds.

4.) Name and schedule the CSV report, (4)

Explanations of the file settings

4a.) Name the report

4b.) Select the Interval for creating this Report;

You can select Hourly, Daily, Weekly, or Monthly.

4c.) Select the Range of this report,

If you selected Hourly In the above Interval, you can now select 
Hourly or Extended hourly with start and end time

If you selected Daily In the above Interval, you can now select Today or Yesterday

If you selected Weekly, you now have to select a day for this Report generation

If you selected Monthly you will have to select First or Last day of the Month for this report generation

4d.) Now set a Time for your Report Generation

4e.) Select the Date format, 24 Hours, or AM/PM Time / Date format.

4f.) Select your timezone

This can be handy if the server is split between different Countries and this report is to be used at a specific timezone. Eg. the Server is placed in Norway, but the user that needs the report is placed in the US, here you can select a US TimeZone, and the report will use the US local timezone for the creation of this Report.

4g.) Select the Delivery method of this CSV Report either by Email or by File Upload

E-mail is quite simple, you can add one or several e-mails for this report (For several, please divide by a comma) We look out for if the email address looks correct and give it a Green Checkmark if it does.

If you select File upload, there are several things you have to have in your mind. We look out for if the path looks correct and give it a Green Checkmark if it does, but we cannot see if the folder exists and if the right rights are in place for this destination folder.

First, please choose the directory where you want your CSV files to be stored. 

PLEASE NOTE, your 3CX Server has to have access to the folder you chose as the destination folder. We cannot check these rights from JEDWare, so make sure that your 3CX Server has the right to write in the selected folder. 

5.) The Help Botton leads you to this document (5)

JEDWare Standard Help Button

FORMATS and placement for our saved CSV Reporting files:

Linux: /folder –

Example: if /opt then the file will be found at /opt/callhistory_xx-xx-2023.csv

Windows: Drive:/folder 

Example: if C:/CSVfiles then the file will be found at C:/CSVfiles/callhistory_xx-xx-2023.csv

6.) At last, remember to click the Create Button (6)

Your automatic CSV generation is now scheduled to run. If you chose to save as File on your Harddisk, you will be able to find the CSV files in the directory you have chosen, after the Time of generation, and if you selected to have the report e-mailed to you, it will arrive as soon as it has been created.

7.) If you are editing an existing report and regret, please press the Cancel button (7)

JEDWare standard RED Cancel button

8.) Overview of your Scheduled Reports

In the Tasks, you will find your Scheduled Reports. From here you can Enable / Disable the Schedule, you can edit the Scheduled Report, you can Delete your Schedules Report, and you are able to Run the report “right now”, to check out if your report settings are as expected.

9. Happy Reporting:-) 

Find more info for Scheduled Reports in the posts below

Contact:

JED IT- & Teleservice ApS

Bogensevej 90, DK-5270 Odense N, Denmark

VAT: DK-35653821

Phone +45 70 222 084

e-Mail: [email protected]

Facebook Linkedin Youtube

Links:

Partners

Privacy Policy

Terms of Service

DPA

How to install