Solved

Quickly export ~60 Exchange 2010 calendars to csv

Posted on 2016-08-31
4
70 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 11

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Read this checklist to learn more about the 15 things you should never include in an email signature.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

839 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