Force Left Nav To at least 200 Pixels wide
Force Body To at least 500 Pixels high
SharePoint MindsharpBlogs > Corro'll Driskell > Posts

 Single Post

Dec 11
Published: December 11, 2008 18:12 PM by  Corro'll Driskell   Powered by: Mindsharp and Summit 7

There are a number of requests in regards to rolling up calendar events from various sites to a site hosting a master calendar.  The most economical choice is to use SharePoint Designer 2007.


 "This post, only, focuses on creating linked calendars." 
1.  You will need to open up the site that will host the master   calendar.  After selecting the URL for the hosting site, Click on the Open button.


OpenSite


 OpenDialog
2.  After the web site is opened in SharePoint Designer you will see all related folders and files displayed in the Folder List.
SitePath
3.  Click on the Task Pane menu and Select the  Data Source Library. The Data Source Library is displayed.

TaskPane_DataSource DataSourceLibrary


4. From the Data Source Library task pane, select Connect to another library... the Manage Library dialog box appears.  Click on the Add button.


Connect to library

ManageLibDialog


5. The Collection Properties dialog box is displayed.  In the Display Name text box, type the name of the site.  In the Location text box, type in the URL for the source site.  Click on the OK button to close the Collection Properties and Click the OK button to close the Manage Library dialog box.

 
CollectionProperties


 Note: The new Collection - IT Services - is available from in the Data Source Library.

 
LinkedSiteDataLibrary


6. In the Data Source Library task pane, navigate to the Current Site Collection .  Click the plus symbol next to Current Site.  Next, Click the plus symbol next to the Linked sources and Click Create a new linked source… button. Next, Click on the Configure Linked Source... Button.


LinkedDataSource


 DataSourceProperties

7.  The Link Data Sources Wizard dialog is displayed.  In the Available Data Sources list box, ensure that the Current Site Collection data sources are displayed.  Next, Click on the SharePoint Lists and select the Calendar list.  Next, Click on the Add button.


LinkedDataSources_Sales


8.  In the Available Data Sources list box, Click on the IT Services Collection's data sources are displayed in the Available Data Sources.  Next, Click on the SharePoint Lists and select the Calendar list.  Next, Click the Add button.  Finally, Click on the Next button.


LinkedDataSources_ITServices


9.  In the 'Select the link type that best represents the relationship between the selected sources' section, Select the option, 'Merge the contents of the data sources.  Choose this option if you'd like to sort, group, and filter the sources as one long list.'  Click the Finish button. 


LinkedDataSources_Merger


10.  The Data Source Properties are displaying the added Calendars in the Component source properties section.  Click on the OK button.


LinkedDataSources_Calendars


Note: After the Linked Data Source is saved, it is named New Data Source in the Linked sources section.


LinkedDataSource_New


11. Using SharePoint Designer, Create a new ASPX page in the current site.  Click in the Form control to position your cursor.


NewPage 


12.  Click on the Data View menu.  Next, Click on Insert Data View.. option.  The DataFormWebPart is added in the Form control.

DataViewTaskPane

 
DataFormWebPart


13.  Navigate to the Data Source Library task pane. Drag and drop the merged calendars - New Data Source - onto the DataFormWebPart on the new page.

 
DataFormWebPart_Add


14.  Click on the 'On Object User Interface' (OOUI), It will open the 'Common Data View Tasks'.  Click on the Edit Columns.. option.


DataFormWebPart_CDVT


15.  Remove both Modified By and Modified from  Displayed Columns list box and add Location field from the Available fields list boxNext, Click on the OK button.


 DataFormWebPart_EditColumns DataFormWebPart_EditColumnsResults


16.  Navigate back to the Common Data View Tasks properties.  Click on the Filter option.  Use the table below to configure the filters. After configuration, Click the OK button.

Field Name
Comparison
Value
And/Or
Start Time
Greater Than or Equal To
[Current Date]
Or
End Time
Greater Than or Equal To
[Current Date]
And


DataFormWebPart_Filter


17.  Save the page and preview in the browser.  You can add events to all calendars included in linked sources and it is reflected in the rendered page.
Note: You can attach the page to the master page for the site to ensure that it is branded like all other pages.




 Comments

No comment(s) to show

 Add Comment

* Required Field
Your Name *
Your Blog Url
Message Subject *
Message Body *