How to import call history to Excel

You can connect from Excel to MiaRec Database and import all call records to spreadsheet.

Then you can do some analyzing of data with the help of Excel.

This article contains step by step instructions for importing databa from MiaRec Database to Excel.

 

These instructions are written for Excel 2007, but it is possible to use also other versions of Excel.

 

Excel will connect to MiaRec Database via ODBC driver.

You need to create ODBC connection according to instructions in following article:

http://www.miarec.com/knowledge/kb146

 

When ODBC connection is created, you are ready to configure Excel.

 

Open Excel and select "Data" tab, then click on button "From Other Sources".
Then select from drop-down list "From Data Connection Wizard" (see below screenshot).

 

Excel ODBC configuration

 

You will see new dialog (see below screenshot).
Select "ODBC DSN" and click "Next".

Excel ODBC configuration

 

On the next step you will see a list of available ODBC connections.
One of these connections should be our new one ("MiaRecDatabase").
Select it and click "Next".

Excel ODBC configuration

 

Now you will see the list of tables from MiaRec database.
You should select only "calls" table and click "Next".
All other tables are not interested for you.

Excel ODBC configuration

 

Now Excel will ask you to save this connection in a file, so, you will be able to use it later.

Excel ODBC configuration

On the next step you will see "Import Data" dialog.
You can choose simple "Table" view or "PivotTable Report" or even "PivotChart and PivotTable Report".
You should read a documentation about Pivot Table inside Excel help. They are very powerful for analyzing data.
In my example I selected "Table" view.

Excel ODBC configuration

On below screenshot you will see how data is looking in Excel.

There are many fields in "calls" table. Some of them may be not interested for you.
The most interested are:

  • setuptime
  • disconnecttime
  • callernumber
  • callername
  • calleenumber
  • calleename
  • filename

 

Excel ODBC configuration

 

There is no "duration" field, because it can be automatically calculated as "disconnecttime" minus "setuptime".
And you can add new column in Excel and enter such formula there. Change a Display Format for this column to "Time" and you will see a duration of every call.