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!
Cedar Crest CollegeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vasil Michev (MVP)Commented:
You can use some EWS based script, such as the one here: https://blogs.msdn.microsoft.com/emeamsgdev/2012/02/13/powershell-script-to-import-calendar-items-into-exchange-mailbox-from-csv-file/

Or you can do it one at a time via Outlook.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cedar Crest CollegeAuthor Commented:
Vasil - thank you for the link, I am going to try it this afternoon or tomorrow and see.  It looks like it should work!
Cedar Crest CollegeAuthor Commented:
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!
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Vasil Michev (MVP)Commented:
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
Bruce SarteCommented:
I will give that a try on Monday - strange that it would default to autodiscover to a non-working URL..
Vasil Michev (MVP)Commented:
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.
Cedar Crest CollegeAuthor Commented:
Thank you for your help, using the -EWSUrl did the trick!
Cedar Crest CollegeAuthor Commented:
With a little modification, the script did the trick.  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.