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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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,
AutodiscoverRedirectionUrl Validation Callback) overload."
At H:\Import-CalendarCSV.ps1: 120 char:3
+ $service.AutodiscoverUrl($ EmailAddre ss);
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~ ~~~
+ CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordE
xception
+ FullyQualifiedErrorId : AutodiscoverLocalException
I can't seem to figure out how to use AutodiscoverURl?
Any help would be great!
Thanks!
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,
AutodiscoverRedirectionUrl
At H:\Import-CalendarCSV.ps1:
+ $service.AutodiscoverUrl($
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~
+ 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
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.
ASKER
Thank you for your help, using the -EWSUrl did the trick!
ASKER
With a little modification, the script did the trick. Thanks!
ASKER