Link to home
Start Free TrialLog in
Avatar of Cedar Crest College
Cedar Crest College

asked on

Import Calendar from CSV File to Office 365 Calendar

Hello Experts,
   We are an Office 365 customer and we have meeting room signs that will read the Office 365 Calendars for our rooms.  We are using a web-based meeting room solution for booking these rooms.  We can export the calendars out with a variety of information, and in CSV (or similar) format.

   I would like to be able to have a way to import these events into a room calendar in Office 365.  So far, I have not found a solution to this issue and was hoping that someone here could suggest a PowerShell, batch file or even a third-party product solution to importing these calendars on a schedule.

Thank you all in advance!
ASKER CERTIFIED SOLUTION
Avatar of Vasil Michev (MVP)
Vasil Michev (MVP)
Flag of Bulgaria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Cedar Crest College
Cedar Crest College

ASKER

Vasil - thank you for the link, I am going to try it this afternoon or tomorrow and see.  It looks like it should work!
OK - so I am making progress, but am currently hung up on running the script...

When I run it I get:

Exception calling "AutodiscoverUrl" with "1" argument(s): "Autodiscover
blocked a potentially insecure redirection to
https://autodiscover-s.outlook.com/autodiscover/autodiscover.xml. To allow
Autodiscover to follow the redirection, use the AutodiscoverUrl(string,
AutodiscoverRedirectionUrlValidationCallback) overload."
At H:\Import-CalendarCSV.ps1:120 char:3
+         $service.AutodiscoverUrl($EmailAddress);
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], ParentContainsErrorRecordE
   xception
    + FullyQualifiedErrorId : AutodiscoverLocalException

I can't seem to figure out how to use AutodiscoverURl?

Any help would be great!

Thanks!
Do not use Autodiscover. The EWS URL for O365 is well known: https://outlook.office365.com/EWS/Exchange.asmx

Provide it with the -EWSURL parameter
I will give that a try on Monday - strange that it would default to autodiscover to a non-working URL..
The URL is working, the method however requires some special handling as you are being redirected from one site to another and switching from HTTP to HTTPS. And the script does not handle that. Much easier to simply use the hardcoded value.
Thank you for your help, using the -EWSUrl did the trick!
With a little modification, the script did the trick.  Thanks!