Sync table with calander

Question

Post reply

Sync table with calander

venkat5677

SSC Eights!

Points: 854
More actions
November 11, 2014 at 5:17 am

#397629

Hi
Does any body done sync values from table to calender. I got SQL Server 2012 and Outlook 2013.
I want to know is there any way all appointments booked in table should sync with exchange server automatically.
Any idea?
Thanks,
Venkat
November 13, 2014 at 10:42 pm

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

I have no idea but sounds very interesting. If nothing else, this reply will serve to "bump" this interesting question.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQL Hamster Ten Centuries Points: 1059 More actions · Answer 2

I haven't done this, but I've used Powershell to get data out of Exchange Server into SQL Server, maybe Powershell would be a good way to go the other direction.

If you used Powershell to export the data in SQL to a text file and then imported it, that might work. This link talks about importing CSV items to the Calendar:

http://blogs.msdn.com/b/emeamsgdev/archive/2012/02/13/exchange-2007-2010-powershell-import-calendar-items-from-csv-file.aspx

venkat5677 SSC Eights! Points: 854 More actions · Answer 3

Thanks Hamster for your replay.

I definable try this, currently followed below steps.

1. I imported a calender file in .csv format from outlook server

2. checked how column order was placed.

3. prepared a query to extract values in same order in .csv file (may be in feature SSIS will do this task)

4. convert this .csv format to iCalendar or vCalendar file (.vcs)

5. import this file to exchange server ( this task i waiting for network admin team to do because they are the owners)

Question: do i need to prepare separate file for each user or is there any way one file with all users

SQL Hamster Ten Centuries Points: 1059 More actions · Answer 4

I don't know for sure, but it looks like for the Import-CalendarCSV command you have to supply the value for the -EmailAddress parameter: so yes you would need to do this for each user.