How to keep two SharePoint Lists in sync when located on 2 different servers

Patrick
  • How to keep two SharePoint Lists in sync when located on 2 different servers Patrick

    I have two lists. One is on site A which is on server A and the second one on site B on server B. So i decided to use PowerShell to export the list on site A and then grab the export and load it to the list on site B, but i only want to export the new items, if any.

    Any ideas how i could only pick up the new items from a list. The new image will only show is if the date/time is less than two days old on the item lists.

  • I would do this as a event receiver versus some kind of powershell script. Your best bet would be to add a hiddent field to the list that signifies whether it has been copied or not making it easier to identify the records that need to be moved over.

    You may also be able to use Content Deployment depending on the particulars.

  • Mike thanks for the response. Actually i explain well in my intial post.I wanted to use powershell to export that data to csv and then import the csv data to the second sharepoint list How to use Event Receiver in this case when the 2 lists are on 2 different services/server. Please elaborate

  • any list should have a modified and created date. This information needs to be exported in your csv files. On the other farm you would run a script thats gets the items by a unique identifier maybe the id or you create a new column for sync information. I've done this for a sql to sharepoint replication. I write a GUID in this field. During import/export i'm checking an filling this field. Now you can sync the items in both directions. Checking the modified date will help to see if the item was modified and needs replication.

    This way you can identify items that have never been synced and synced items can be checked on modified date. If needed the column with the GUID can be set to hidden, so users don't get confused.

    More info's on updateing system infos of lists:

    http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistitem.aspx

    http://www.moss2007.be/blogs/vandest/archive/2009/04/13/sharepoint-2007-update-system-properties-created-created-by-modified-modified-by.aspx

    Ciao Marco

  • If you can get away with syndication instead of duplication (which would mean it would be read only on one site), I would try to build some kind of view that reads from the list in the "master" site, e.g. a custom web part that uses the OOTB web services to retrieve the data. Don't forget to add caching.

Related questions and answers
  • to Spreadsheet, but it does not appear to support automated subdivision of the list items into separate worksheets. I do not know if Excel Services that come with MOSS are capable of it, but we do... of heavy work in the object model. I only mentioned the Export to Spreadsheet because that's the only available method I know of off-hand, and its options are limitted. So I am comfortable with all manner of work level that can be suggested. I should also note that keeping the list linked with the spreadsheet is undesired. We want to be able to download the spreadsheet as a reference. Because

  • run MOSS and profiles are synced, I get 1000's of changes that are occuring in the user information list. So right now since the GetChanges method only pulls items in chunks of 1000, i have to use the lastchangetoken and call getchanges several times and then sort through 1000's of items just to get at the one's I want. First question: Does anyone know how to exclude hidden lists or certain...I'm trying to pull back the last x number of list items in all non-hidden lists for a given web. My original code would go through all lists and run the following code: SPQuery query = new SPQuery

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using Publishing Portal Template. I am developing using VSTS 2008 + C# + .Net 3.5. I have defined a custom list manually on a SharePoint site (all column types of the custom list are SharePoint built-in types), and I want to define some customized rules to filter this list to display only a part of the list. Any reference code? EDIT1: Here is my current code. I have used such code to retrieved the items I need, but how to display the retrieved items in a SharePoint list? SPSite

  • The definition of the 'View Only' permissions level is as follows: Members of this group can view pages, list items, and documents. If the document has a server-side file handler available, they can only view the document using the server-side file handler. What is considered to be a server-side file handler in the context of SharePoint? Is this an HTTPHandler? What technology is it based on, how do I write one?

  • I am trying to iterate over a List and view properties on some items that live within that list, and down one or two levels; this is on a SharePoint 2010 server. So far I have been able to connect to the site and iterate over the Folders and the Items in the top level, but what I want is to be able to iterate over items within the Folders. Out structure is as follows: site - http://localhost/my_site list - Pages Folder - News ItemB - Article ItemA - Contents The site is easy enough to connect to, with that I can get the list, Folder and ItemA's and output them so I can see

  • I have a lookup column in multiple lists that points to a list of dates. These dates go in ascending order, and since the list posts are sequential, the older dates start to become irrelavent, forcing users that add new list items to scroll through to the bottom of the drop-down box to select the lastest date. As you can tell this can be very tedious, all I need is for the lookup column to sort by DESCENDING order, and I've tried fooling with the lookup list's view, but I think it disregards the view and only looks at the list items. Any thoughts?

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I have two sites of the same site colleciton and I want to use Data Source Library to make site A be able to use lists defined in site B. From site A, I am using "Connect to another library" to add site B. And from Data Source Library of site A, I can see lists defined in site B. My question is how to use such lists in a page of site A? I followed the guide here, http://office.microsoft.com/en-us/sharepointdesigner/HA101191181033.aspx

  • So I did create on an SPWeb 20 custom lists and then a tasks list. For each of those 20 lists I've created 20 site lookup columns. I then created 20 Content Types based on Task content type. Then I've added each content type to the Tasks list. After that I've added each lookup site column to the corresponding list content type. So far so good. I've built a custom WebPart that displays task items... = list; SPQuery query = new SPQuery(view); System.Text.StringBuilder sbViewFields = new System.Text.StringBuilder(); // all fields from view foreach (string field in view.ViewFields

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I have created a list in top level site. And I want to use the list in a child site (e.g. adding the list to a page in child site by using Page --> Add Web Parts --> Browse), but can not find the list created in parent site in this way. Any ideas how to use the list (created in parent site) in a child site? BTW: I can use the list (created in parent site) in parent site without any issues.

Data information