{"id":4223,"date":"2016-07-20T12:21:07","date_gmt":"2016-07-20T06:51:07","guid":{"rendered":"http:\/\/www.vyapin.com\/blog\/?p=4223"},"modified":"2021-05-14T13:30:22","modified_gmt":"2021-05-14T13:30:22","slug":"retaining-list-item-ids-across-site-collections-or-sharepoint-farms","status":"publish","type":"post","link":"https:\/\/www.vyapinsoftware.com\/blog\/retaining-list-item-ids-across-site-collections-or-sharepoint-farms","title":{"rendered":"How to Retain List Item IDs across site collections or SharePoint farms?"},"content":{"rendered":"<p>SharePoint generates a unique ID for each item in a list. Here\u2019s some additional information about list item IDs:<\/p>\n<ul style=\"list-style-image: url('https:\/\/www.vyapin.com\/blog\/wp-content\/uploads\/2016\/07\/icon-blue-tick-e1469001060162-1.png');\">\n<li>IDs are auto-generated in each list and are not unique across the site.<\/li>\n<li>The item IDs are 1-based integer, which is one greater than the ID of the item that was previously added.<\/li>\n<li>If the item is deleted, its ID is not reused.<\/li>\n<\/ul>\n<h2>Auto-generated List Item IDs:<\/h2>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/auto-generated-list-item-ids-1.png\" data-lbwps-width=\"506\" data-lbwps-height=\"160\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/auto-generated-list-item-ids-1-300x95.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4225 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/auto-generated-list-item-ids-1.png\" alt=\"Auto generated list item ids\" width=\"506\" height=\"160\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/auto-generated-list-item-ids-1.png 506w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/auto-generated-list-item-ids-1-300x95.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<h2>Deleted item ID is not reused:<\/h2>\n<p>If you delete the \u2018item4\u2019 from SharePoint and add the new list item as \u2018Item5\u2019, then SharePoint generates ID as 5 instead of deleted Id 4 (as shown below).<\/p>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/deleted-item-id-not-reused-1.png\" data-lbwps-width=\"522\" data-lbwps-height=\"153\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/deleted-item-id-not-reused-1-300x88.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4226 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/deleted-item-id-not-reused-1.png\" alt=\"Deleted item id not reused\" width=\"522\" height=\"153\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/deleted-item-id-not-reused-1.png 522w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/deleted-item-id-not-reused-1-300x88.png 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<p>Based on the above information, if you thought it is very difficult to retain item IDs during migration across different sites, your assumption is incorrect. Vyapin&#8217;s latest version of <a href=\"https:\/\/www.vyapinsoftware.com\/products\/sharepoint-migration\/dockit\/sharepoint-migration-tools\"><strong>XPlica for SharePoint<\/strong><\/a> v6.9 caters you to retain list item IDs when migrating List Item across different sites and even different farms.<\/p>\n<p>This is applicable only for list items migrated across SharePoint lists (except libraries). For this purpose, XPlica Server Agent has to be installed in the premise target SharePoint server and <b><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/new-version-of-xplica-for-sharepoint-version-6-7-has-been-released\">Vyapin Sandbox solution<\/a><\/b> has to be deployed in the target Office 365 tenant (SharePoint Online).<\/p>\n<h2><u>How to retain List Item IDs using XPlica v6.9?<\/u><\/h2>\n<p>Whether you are migrating entire site contents or list contents using XPlica, navigate to the \u2018SharePoint Columns Options\u2019 step of XPlica wizard (as shown below) and select \u2018Migrate selected columns\u2019 and provide the column name \u2018ID\u2019 in the list as shown below. This directs XPlica to retain the source ID for the migrated List Item.<\/p>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1.png\" data-lbwps-width=\"725\" data-lbwps-height=\"541\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1-300x224.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4227 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1.png\" alt=\"Migrate selected columns\" width=\"725\" height=\"541\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1.png 725w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1-300x224.png 300w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1-624x466.png 624w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/migrate-selected-columns-1-200x150.png 200w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/a><\/p>\n<p>Xplica does retain the list item ID as in source when source list item ID value is not already in use in the target list item. If source list item ID is already in use in the target list item, then XPlica leaves the ID to be auto- generated by SharePoint (as shown below).<\/p>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/source-list-items-1.png\" data-lbwps-width=\"514\" data-lbwps-height=\"153\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/source-list-items-1-300x89.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4228 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/source-list-items-1.png\" alt=\"Source list items\" width=\"514\" height=\"153\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/source-list-items-1.png 514w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/source-list-items-1-300x89.png 300w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/a><\/p>\n<h2>Target list before retain list item ID:<\/h2>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-before-retaining-list-item-id-1.png\" data-lbwps-width=\"407\" data-lbwps-height=\"231\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-before-retaining-list-item-id-1-300x170.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4229 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-before-retaining-list-item-id-1.png\" alt=\"Target list before retaining list item id\" width=\"407\" height=\"231\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-before-retaining-list-item-id-1.png 407w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-before-retaining-list-item-id-1-300x170.png 300w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/a><\/p>\n<h2>Target list after retain list item ID:<\/h2>\n<p><a href=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-after-retaining-list-item-id-1.png\" data-lbwps-width=\"383\" data-lbwps-height=\"363\" data-lbwps-srcsmall=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-after-retaining-list-item-id-1-300x284.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4230 size-full\" src=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-after-retaining-list-item-id-1.png\" alt=\"Target list after retain list item ID\" width=\"383\" height=\"363\" srcset=\"https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-after-retaining-list-item-id-1.png 383w, https:\/\/www.vyapinsoftware.com\/blog\/wp-content\/uploads\/2016\/07\/target-list-after-retaining-list-item-id-1-300x284.png 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/a><\/p>\n<div class=\"myclass\" style=\"font-size: 22px; font-weight: bold; text-align: center;\"><a href=\"https:\/\/www.vyapinsoftware.com\/products\/sharepoint-migration\/dockit\/sharepoint-migration-tools\">Read\u00a0More About XPlica Tool<\/a> | <a href=\"https:\/\/www.vyapinsoftware.com\/download\/dockit\">Download XPlica Tool Now<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>SharePoint generates a unique ID for each item in a list. Here\u2019s some additional information about list item IDs: IDs are auto-generated in each list and are not unique across the site. The item IDs are 1-based integer, which is one greater than the ID of the item that was previously added. If the item [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":4227,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[144],"tags":[60,64,66],"class_list":["post-4223","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-sharepoint-content-migration","tag-sharepoint-migration","tag-sharepoint-online-migration"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/4223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=4223"}],"version-history":[{"count":6,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/4223\/revisions"}],"predecessor-version":[{"id":7905,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/4223\/revisions\/7905"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/media\/4227"}],"wp:attachment":[{"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=4223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=4223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vyapinsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=4223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}