Table of Content

Home › Developer Guide › Direct access to MiaRec DB ›
 

Connect to MiaRec DB from Excel

You can connect from Excel to MiaRec Database and export all call records to spreadsheet. This will allow you to do some analyzing of data with the help of Excel.

This article contains step by step instructions for importing call details 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:

Access MiaRec DB via ODBC driver

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". Table "calls" contains information about all recorded calls. All other tables contain data, which is used internally by MiaRec.

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 this example we choose "Table" view.

Excel ODBC configuration

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

Excel ODBC configuration

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

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

There is no "duration" column, because it can be automatically calculated as "disconnecttime" minus "setuptime". 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.