I am trying to set up a data view web part to show information from a list on a different site collection in the same web application. The information I need to get includes people with their presence bubble and a choice value. I have been struggling with this for a while now, so to try and sort it out I've gone down a few paths in SPDesigner.
The SOAP connection Connection string:
http://<url of site collection>/_vti_bin/list.asmx?WSDL
I selected theGetListItems
drop down and added the name of the list name as the filter. The people come back in the XML<92;#Peter Griffin>
. I was told that this was not in fact the users id, but the id that is assigned to that user when they first visit that particular iste collection. So not enough information there to get the presence.REST connection Connection string:
http://{url}/_vti_bin/owssvr.dll?Cmd=Display&List={list GUID}&XMLDATA=TRUE
. I've tried this with/without the View GUID tooXML Data I can't actually get this one working
Creating a list within the site to see what the XML sould be displayed like to get the bubble. Each person field is made up of 4 XML elements that show 1, the whole string to be output {user}, 2 the id, 3 title, 4 span to be inserted with JavaScript (I think)
I'm not too sure whether I should start tackling external lists/content types yet. The list is already set up and someone has made custom web parts that point to it (C#). They said that they couldn't get the presence bubble out in the project and I don't know C#, so I was hoping there was a way I could do it in SPDesigner with some XSL possibly?
If anyone has any suggestions I would love love love to hear from you! I'm going insane! Each step has taken a while to get working and still no closer.
Thank you!!