Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

How to get the calenderdata from Outlook 2007 into Qlikview

Hello,

Do anyone have an example or idea How to get the outlook data into Qlikview?

Any help is appreciated..

-Sravan

7 Replies
Highlighted
Not applicable

How to get the calenderdata from Outlook 2007 into Qlikview

hI guys..

No ideas.. This could not be that hard right??

Highlighted
Not applicable

AW:How to get the calenderdata from Outlook 2007 into Qlikview

Hi,

you can export your data and save it as excel- or csv-file.

File --> Export --> Save as File

Greets

Highlighted
Not applicable

AW:How to get the calenderdata from Outlook 2007 into Qlikview

My question was actually wrong. I need the absenties to be exported and saved as csv or Qlikview data.. I cannot achieve that..

Highlighted
Not applicable

AW:How to get the calenderdata from Outlook 2007 into Qlikview

There are ODBC and ADO connections to Outlook. Try an internet search.

Do you want an extract from a user calendar or from the Exchange server?

Sorry, this is not something I am not familiar with at all.

Highlighted
Not applicable

AW:How to get the calenderdata from Outlook 2007 into Qlikview

Hi Ivang

I want from an Exchange server which is attached to the Outlook.. The absenties in my company are noted according to dates and saved there.. I want to get that list into Qlikview..

Highlighted
Not applicable

How to get the calenderdata from Outlook 2007 into Qlikview

Hi,

have a look at:


How to retrieve Exchange and Outlook data with the Jet 4.0 OLE DB provider in Access 2000
Then you can use Exchange as a data-source like any other database!

Best regards

Stefan
Highlighted
Not applicable

How to get the calenderdata from Outlook 2007 into Qlikview

It is possible to create a vbs script to export data from your calendar into a Csv, then load it in qlikview. This vbs can be a function called inside the Reload script of Qlikview.

In this case, different ways are possible to access calendars ( webdav, OLEDB, MAPI...)