JEDWare philosophy for our 3CX reporting
JEDWare philosophy for our 3CX reporting. 3CX has built-in reporting, that suits many 3CX customers, but not all. Therefore we
The CSV file have the following format:
The CSV end result for a Group Report will look similar to the one below, containing All Calls in a list.
In the JEDWare left menu, click Report -> Scheduled tasks, and click on the top menu CSV GENERATION
We do offer templates for:
This report hasn’t any settings, so you just have to fill in the Report Name, and the generation data. See more below the picture.
is_answered, direction, start_date, start_time, end_date, end_time, ringtime, talk time, caller name, caller number, destination name, destination number
1.) Name and schedule the CSV report, (Selection 1).
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
Select between 24 Hours, or AM/PM Time / Date format.
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.
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 said folder.
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
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.
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.
Find more info for Scheduled Reports in the posts below
JEDWare philosophy for our 3CX reporting. 3CX has built-in reporting, that suits many 3CX customers, but not all. Therefore we
3CX – CSV Report Generation for Excel or PowerBI In Scheduled tasks, you are now able to set up automatic
Scheduled Agent Report to CSV upload or e-Mail JEDWare Agent Report This Agent report will contain: ExtensionId, FullName, InboundAnswered, InboundLost,
Scheduled Group Report for CSV upload or e-Mail JEDWare GROUP Report This Report will contain values for: ExtensionId, FullName, InboundAnswered,
Scheduled Queue Report to CSV upload or e-Mail JEDWare QUEUE Report This Report will contain values for Ext, Name, Calls,
Scheduled Queue – Per Day Report to CSV upload or e-Mail JEDWare QUEUE – Per Day Report This Report will
Scheduled All-Calls Report to CSV upload or e-Mail JEDWare All Call Report The CSV file have the following format: is_answered,
Scheduled Company Report to CSV upload or e-Mail JEDWare Company Report The CSV end result for a Company Report will
Limits and TIP for our Reports Limits of Reporting 3CX V18.x limit in Reports is 20.000 Rows (Calls), in the
Contact:
JED IT- & Teleservice ApS
Bogensevej 90, DK-5270 Odense N, Denmark
VAT: DK-35653821
Phone +45 70 222 084
e-Mail: [email protected]