My overall goal is to bulk copy sharepoint (moss2007) site's lists into sql database (to later query them etc). I gave up trying to use web services sharepoint offers because Query() service does not return ID's of fields that are actually referencing something
(like users) and GetListItems only returns limited amount of rows and does not provide a schema, means that for russian sharepoint, all column names are total rubbish and there is no way (programmatically, from web service reply) to know which one is which
Right now i am trying to write a web service that will return all kind of stuff i need - schema of the list, and rows of the list.
In rows, i need to return ID's of the fields where the field is a reference kind, like User, because, we have serious sized lists (>20000 items grown in less than a year) and we cannot afford truncate/insert, we need to only query for changes and insert/update
So, if i store for ex. username (not domain name but full name) as string, and user changes his surname, it wont get updated and queries would fail. I need to store an ID.
I currently use this code sample:
string const_sitelink = "http://moss2k7-2/sites/test/";
SPSite testsite = new SPSite(const_sitelink);
SPWeb testweb = testsite.AllWebs[""];
SPList list =testweb.GetList("/sites/test/Lists/List1&q
View Complete Post