Solved

Quickly export ~60 Exchange 2010 calendars to csv

Posted on 2016-08-31
4
74 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 12

Expert Comment

by:Ajit (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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
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
To show how to generate a certificate request 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 Servers >> Certificates…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

730 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