Hi AllI've recently had the pleasure of being given a csv file containing all room resource appointments for the next year. Currently we run approximately 50 room resources with several hundred appointments in the spreadsheet which need to be added (so resource 1 has 10 appointments, resource 2 has 5 etc to resource 50 with 8 for example).I was wondering therefore if there was a simple way to import these appointments into the system without having to manually add every single one. I hoped the EMS would have a simple command like 'Add-CalendarItem' so i could just use import-csv and pipe the relevant fields across but i don't appear to be able to find anything of this nature so any help would be appreciated.Many ThanksExchange2007 SP1, U8 systemI do have permissions to all the mailboxes/calendars in question

There's currently no way of doing this AFAIK though it can probably be scripted via EWS. I've seen this feature requested to allow Exchange Administrators to add items to people's calendars for things such as company wide holidays via PowerShell so you don't have to manually send out invites, etc...MVP | MCSE:M | MCITP: Enterprise Messaging Administrator | MCTS: OCS + Voice Specialization | http://www.shudnow.net

Hi ElanThanks for your response - I feared this may be the case :D . I'll have a look at EWS now and see if I can craft something useful ..Thanks again

Hi, Based on my knowledge, currently, Exchange does not have a powershell command able to have the Exchange Admin to add calendar item into mailbox directly. If you would like to add company wide holidays to everyone calendar folder, I recommend that you could use Outlook holiday file: Customize the Outlook calendar with your company's important HR dates http://office.microsoft.com/en-us/outlook/HA010750021033.aspx Based on current situation, I do not find a simple method (other than dev) import the calendar items into the 50 Resource Room Mailbox. Maybe you can consider following method: 1. Create 50 Appointment calendar CSV files for separate Resource Room mailbox 2. Create 50 PST files with same name as the alias of the Resource Room mailbox and create calendar folder in the 50 PST files 3. Use Outlook Import feature to import the CSV files to separate Calendar folder in the PST files 4. Use following command to import the PST files to separate mailbox: Get-Mailbox -OrganizationalUnit Resource | Import-Mailbox -PSTFolderPath C:\PSTFiles Mike Shen TechNet Subscriber Support in forum

Hi, Any update regarding the problem?Thanks,Mike

Hi MikeMany thanks for the information. I'll pursue the csv - pst idea and see how we get on .. it certainly seems as if it could be quicker than manually adding every entry.I'm pretty sure the compnay wide holidays will be the next on the list too so thanks for that link also :)Many thanks