Rollup lists across different SharePoint site collections using BoostSolutions Data Connector

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.

This scenario will demonstrate how to do this:

In the company, each team has a SharePoint site collection with an Announcement app. The team maintain their own announcements.

This is Announcement list in site collection A.

data-connector-1

And this is Announcement list in site collection B.

data-connector-2

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.

data-connector-3

And here is how I did it…

1. Login Site Collection 3 as administrator. And then enter Site Settings – Data Connector Settings page. Create first job as following.

data-connector-4

In Direction section, select From external data to list option, which means import data from external data source.

  • In List section, select Announcement 3 in site collection C as target list.
  • In External Data and Authentication section, configure these settings:
  • Select SharePoint 2013 in External Data Type option.
  • Enter url of Announcement 1 list (which locates in site collection A) in URL textbox.
  • Then enter username and password. And verify the connection.

In Column Mapping section, map the columns of these two announcement lists.

data-connector-5

In Run Options section, select the checkbox of Enable ADD operations.

data-connector-6

2. Save the job.

3. Create the second job as following:

data-connector-7

4. Run these two jobs.

5. Go to Announcement 3 list, you will see that announcements of site collection A and B in the current list.

data-connector-8