Create Cross-Site Data Source

We use a Site Directory list from the root site collection as the master listing of all sites and it would be handy to be able to reference this directory from the various site collections throughout the web application. OTB, you can’t reference a list from one site collection to another. We used to use the script built from Cross-site List Snapshot Version 2.0, but lately we’ve been experiencing issues with it. This is how to create a data source in Designer and modify the data-view web part to use it.

First, create the view in the list that you’ll want to display on the sub-site.

Open the list in SharePoint Designer. Get the GUID for the list (copy it into notepad.)

Open the view of the list:

Click on the “WebPartPages:SXLTListView” to get the Tag Properties. This will give the View Guid. Copy and save this out to notepad as well.

Now, open the child site in designer. Select “Data Sources” and “SOAP Service Connection”. Enter a login for a service account that will have rights to read the list.

On Source, in the Service description location put “/_vti_bin/lists.asmx” and Connect Now.

Change Operations to “GetListItems” and enter in the saved GUID for listName and viewName:

In the General Tab, name the SOAP data source.

Select OK:

Open the page for the directory. Insert > Data View > SOAP Services:

Remove the extra columns:

To fix the hyperlink, select the cell (not the header, the first cell with data in it,) right-click, and Format Item as > Hyperlink:

Change “Text to display” to: {substring-after(string(@ows_URL),’, ‘)}

And “address” to: {substring-before(string(@ows_URL),’,’)}

Save and publish (if required.)

Advertisements

4 Responses to Create Cross-Site Data Source

  1. rmickler says:

    Thank you so much, this was the first solution i’ve read for this that actually worked!

  2. Rovonda Fleming says:

    Hey there,
    I tried this solution and followed every step but when we went to insert the soap that was created on the page, it never showed up at all. We don’t get any error message or anything. Did I miss something?

    • Mara says:

      Hi,
      I have the exact same problem. When i insert it, it doesn’t show up. Did you ever fix this problem?
      Thanks!

      • sharepointdiva says:

        Sorry, I don’t know what the problem would be without having the issue in front of me. It’s really hard to troubleshoot without an error to work from.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: