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

 

 

2 Responses

  1. Joan Martin
    Joan Martin at |

    Technology never ceases to amaze me. Every other say there are new developments and even more interesting things being talked about for future. Endless possibilities makes me even more curious. Wonderful insights here at you blog. Shall keep watching this space for more! :)

  2. Erik Bendt
    Erik Bendt at |

    You’re so cool! I don’t think I’ve truly read through something like that before. So good to discover another person with unique thoughts on this subject. Seriously.. many thanks for starting this up. This website is something that is required on the internet, someone with a little originality!

Leave a Reply