Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Amalgamating data from WSS lists on different sites & servers

  Asked By: Bob    Date: Dec 24    Category: Sharepoint    Views: 1466

I need to be able to amalgamate the data from four (soon to be more) identical lists.

One of the lists resides on the client's internal SBS server and the other lists reside on a number of sub-sites of an external hosted WSS site. The client uses these lists to collect lead information from associates and internally.

For reporting purposes they would like to amalgamate the lists into one "super list" which they can then slice and dice as they like either with different views or in Excel.

I've had a look at the Using Microsoft Frontpage 2003 to Customize SharePoint Products chapter in Bill's book which gives an outline of how to do what I want to do, but I can't see how to get the lists from the external hosted site to appear as Data Sources. Is that possible?

Is it also possible to merge list data into one new list which is effectively what I want to do.

Or is there a better way?

This is WSS, so none of the SPS bells and whistles are available.



4 Answers Found

Answer #1    Answered By: Kalyan Pujari     Answered On: Dec 24

Anybody got any ideas on this? And, no, I have no idea why the original post was in a microscopic font!

Answer #2    Answered By: Jagdish Joshi     Answered On: Dec 24

Numerous rollup solutions have been created.

Coras Works offers a commercial solution. As I recall there is a free
solution called cRollup or something like that.

Or you could write a Web Service that gets the data  from the various
lists and merges the XML into one DOM and return that to a DVWP.

Answer #3    Answered By: Shara Johnson     Answered On: Dec 24

Could you translate DOM & DVWP for me please. Newbie Alert! :-)

Would a Web Service require rolling out Visual Studio or is it simpler
than that?

Answer #4    Answered By: Christop Mcfadden     Answered On: Dec 24

DOM = Document Object Model
DVWP = Data View Web Part

Yes, the easiest way to create a Web Service is with VS.NET.

Need more? Ask another follow up...