Solved

Quickly export ~60 Exchange 2010 calendars to csv

Posted on 2016-08-31
4
60 Views
Last Modified: 2016-09-14
I have the need to export ~60 Exchange 2010 Calendars to CSV for import into a new application. The calendars are shared by individual user mailboxes and I need to export mailbox owner, start date\time, end date\time, subject, and location. I thought this would be a simple task, but I've searched all over and tried everything I can find to no avail. I've tried every example of Powershell script I can find, but I know nothing about scripting and can't get any of them to run without errors I can't even begin to solve. I purchased a utility that integrates with Excel that has allowed me to manually export one calendar at a time at a rate of about one per 1.5 hours. I'm looking for any help or advice I can get to just batch export what I need. I'd be happy to just buy a tool to do this if I have to.
0
Comment
Question by:Brook_Lane
4 Comments
 
LVL 3

Expert Comment

by:François Peroux
ID: 41779159
Hello,

This solution should help you with : http://www.powershellneedfulthings.com/?p=26.

You have all the description to proceed.

Let me know !
0
 

Author Comment

by:Brook_Lane
ID: 41779218
Any other suggestions that are less time consuming? I started working through the process, but this will require me to setup another system with 32 bit Windows that I don't currently have, plus the installation of the Exchange tools are a few other utilities before I can even test the script and hope that it works. I was hoping someone had something in powershell that actually works (or maybe that I can actually understand and use is the better way to put it) or that some utility exists that can complete the task if I were to purchase it.
0
 
LVL 11

Accepted Solution

by:
Tej Pratap Shukla ~Dexter earned 500 total points
ID: 41779236
Hi,
You can easily export calendar to Excel from configured user account in Outlook. But It may take long time. If you want to go with this way then you can go through below given link:
http://exchange-server-guide.blogspot.com/2016/07/export-calendar-from-outlook-to-excel.html

If you want to go with a tool I would suggest you to go with Exchange Export Tool of SysTools.
You will get many advanced features with this tool and the best thing is that it also provides 24 x 7 Support.
They will help you throughout the process.
0
 
LVL 9

Expert Comment

by:Kevin k
ID: 41781511
There are many solutions out their to accomplish this task easily and efficiently. The best I can see is a script to automate the process of setting up Outlook and logging in and then exporting from there: http://www.powershellneedfulthings.com/?p=26%EF%BB%BF

Follow the document to get Outlook calendar Information, and select your required to export to csv file - Use PowerShell to Export Outlook Calendar Information

How to export calendar items to csv-file with powershell.


Hope this helps!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now