Monitor Work from Home Employees with Employee Desktop Live Viewer.

Read More

Use PowerShell to Export/Import calendar Items from Office 365

Aftab Alam
Aftab Alam Updated On - 18 Aug 2020

Businesses, for successful execution of their projects, conduct meetings and communicate their ideas and strategies. That’s why the managers plan meetings using calendar applications and share it with the others. But sometimes, the managers many need to have an offline copy of the calendar events to share with some other users or clients.

So, you need to export the calendar items from Office 365 and you can do it using the PowerShell cmdlets easily.

  1. Create a network-shared folder to save the PST file.
  2. The users account should have the read/write permissions to the Exchange Trusted Subsystem group on the folder.

Now start the process –

  1. Run the following command that will let you any kind of script whether it is signed or not. It will ask you to confirm your selection related to the change in execution policy. Click Y
    Set-ExecutionPolicy Unrestricted

  2. Run the second command to input the credentials of Office 365 account.
    $livecred=Get-Credential

  3. A pop-up will open and ask you to input the credentials of office 365 account.
  4. you need to create a session with the Office 365. run the below command –
    $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri
    https://outlook.office365.csom/powershell-liveid/ -Credential $UserCredential –
    Authentication Basic –AllowRedirection

  5. It will again ask you to input the credentials of your Office 365 account.
  6. When the Powershell is connected with the Office 365 complelely, then you can import the whole session by running the following command;
    Import-PSSession $Session –DisableNameChecking

  7. In last, you can run the cmdlet to export the entire calendar folder ot export the data within the range.
    New-MailboxExportRequest –Mailbox -IncludeFolders ‘Calendars’ –FilePath ‘D:\Meeting Room\Adam.pst’


    Or

    Export-Mailbox-Identity –StartDate ‘22/06/2016’ –EndDate ‘16/09/2017’ –IncludeFolders ‘\Calendar’ –FilePath \\PSTFile\FolderName\FileName.pst

Import calendar into the Office 365 mailbox

If you have a CSV file with the important calendar events, then you can import the CSV file into the Office 365 mailbox by following the steps;

  1. Install the EWS Managed API from the below URL –
    https://www.microsoft.com/en-us/download/details.aspx?id=35371
  2. Assign Impersonation Rights to the account.
  3. Create the CSV file having all the fields like Date, Subject, Start Date, End Date, Start Time, and End Time.
  4. Now, run the command;
    Import-CalendarCSV -CSVFileName D:\Monthly Meetings\calendar.csv -EmailAddress
    jacob@domain.com -Impersonate $true
  5. If the account does not have the impersonation rights, then you can run another command;
    Import-CalendarCSV -CSVFileName D:\Monthly Meetings\calendar.csv -EmailAddress
    jacob@domain.com -username jacob@domain.com -password 1234!@#$
Limitations of the manual import/export
  • The manual methods do not let you apply filters easily in the calendar items.
  • You need to create a CSV file for importing the calendar items, which may be time-consuming.
  • You can export or import the calendar items of the single mailbox only that maybe not enough for a large project.
  • If any field in the CSV file is missing, then there is no way to skip it.
  • The account should have impersonation rights while importing the data.
  • If the session is stopped abruptly during the export, then you will have to start the export process again. It may also corrupt the PST file.
  • There can be some errors in the Mailbox Export Request Access path is denied.
  • Conclusion

    To overcome the limitations of the manual import/export method, you should use the Kernel Office 365 Backup & Restore tool. This software lets you take the selective backup of unlimited mailboxes and restore multiple PST files to multiple Office 365 mailboxes. The Office 365 Backup & Restore tool gives you the flexibility of choosing any folder from the mailbox, apply filters to it, and save it in the PST file. There is no limitation on the number of mailboxes for taking the backup and the tool will save a separate PST file for each mailbox.

    Download Software

    Similarly, you can import the entire PST file or its chosen folders into the Office 365 mailbox. After the completion of import/export, you will get a complete migration report with the status of each migrated item. You can also save the migration report in a CSV file.