{"id":7135,"date":"2017-01-16T18:14:18","date_gmt":"2017-01-16T10:14:18","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=7135"},"modified":"2023-07-31T11:38:09","modified_gmt":"2023-07-31T03:38:09","slug":"rollup-lists-across-different-sharepoint-site-collections-using-boostsolutions-data-connector","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/rollup-lists-across-different-sharepoint-site-collections-using-boostsolutions-data-connector\/","title":{"rendered":"Rollup lists across different SharePoint site collections using BoostSolutions Data Connector"},"content":{"rendered":"<p>One requirement of our customers is displaying a list from another SharePoint site or site collection. For example, they create several site collections for departments or teams to maintain contents, but they also need to display these contents on one page. There are a few ways to tackle this, and you can try Data Connector (one feature is importing data from external data source to SharePoint list) to solve it.<\/p>\n<p>This scenario will demonstrate how to do this:<\/p>\n<p>In the company, each team has a SharePoint site collection with an Announcement app. The team maintain their own announcements.<\/p>\n<p>This is Announcement list in site collection A.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7137\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-1.png\" alt=\"data-connector-1\" width=\"611\" height=\"295\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-1.png 611w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-1-300x144.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/p>\n<p>And this is Announcement list in site collection B.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7138\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-2.png\" alt=\"data-connector-2\" width=\"544\" height=\"295\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-2.png 544w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-2-300x162.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/a><\/p>\n<p>And this is the Announcement list in site collection C. This list is used to show the content of the Announcement app from the site collection A and B.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7139\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-3.png\" alt=\"data-connector-3\" width=\"601\" height=\"286\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-3.png 601w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-3-300x142.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p>And here is how I did it\u2026<\/p>\n<p>1. Login Site Collection 3 as administrator. And then enter Site Settings \u2013 Data Connector Settings page. Create first job as following.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7140\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-4.png\" alt=\"data-connector-4\" width=\"672\" height=\"464\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-4.png 672w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-4-300x207.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p>In Direction section, select From external data to list option, which means import data from external data source.<\/p>\n<ul>\n<li>In List section, select Announcement 3 in site collection C as target list.<\/li>\n<li>In External Data and Authentication section, configure these settings:<\/li>\n<li>Select SharePoint 2013 in External Data Type option.<\/li>\n<li>Enter url of Announcement 1 list (which locates in site collection A) in URL textbox.<\/li>\n<li>Then enter username and password. And verify the connection.<\/li>\n<\/ul>\n<p>In Column Mapping section, map the columns of these two announcement lists.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7141\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-5.png\" alt=\"data-connector-5\" width=\"704\" height=\"178\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-5.png 704w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-5-300x75.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>In Run Options section, select the checkbox of Enable ADD operations.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-6.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7142\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-6.png\" alt=\"data-connector-6\" width=\"702\" height=\"234\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-6.png 702w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-6-300x100.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><\/p>\n<p>2. Save the job.<\/p>\n<p>3. Create the second job as following:<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-7.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7143\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-7.png\" alt=\"data-connector-7\" width=\"741\" height=\"874\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-7.png 741w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-7-254x300.png 254w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/a><\/p>\n<p>4. Run these two jobs.<\/p>\n<p>5. Go to Announcement 3 list, you will see that announcements of site collection A and B in the current list.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-8.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7144\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-8.png\" alt=\"data-connector-8\" width=\"446\" height=\"410\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-8.png 446w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2017\/01\/data-connector-8-300x275.png 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One requirement of our customers is displaying a list from another SharePoint site or site collection. For example, they create several site collections for departments or teams to maintain contents, but they also need to display these contents on one page. There are a few ways to tackle this, and you can try Data Connector [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,347],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7135"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7135"}],"version-history":[{"count":2,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7135\/revisions"}],"predecessor-version":[{"id":7145,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7135\/revisions\/7145"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}