topic Can you update a table in a Versioned SDE Database externally from SharePoint? in ArcGIS for SharePoint Questions https://community.esri.com/t5/arcgis-for-sharepoint-questions/can-you-update-a-table-in-a-versioned-sde-database/m-p/436383#M1177 <HTML><HEAD></HEAD><BODY><SPAN>Hi There</SPAN><BR /><BR /><SPAN>Is it possible to update a table in a versioned SDE database from SharePoint? My table contains a register of assets that I want non-GIS people to be able to add items to.</SPAN><BR /><BR /><SPAN>I have done some investigation and testing of the editing experience interfacing SDE tables from SharePoint using Database Connections to Multi-Version Views (Viewed in SharePoint via SharePoint Designer built pages).</SPAN><BR /><BR /><SPAN>The SharePoint experience</SPAN><BR /><SPAN>??? New records can be added. The OBJECTID is mandatory and unfortunately has to be manually added. The OBJECTID is not auto-populated nd because it is mandatory can???t be left to SDE to auto-allocate the next ID the behind the scenes.</SPAN><BR /><SPAN>??? Old and new records from current edit session can be deleted</SPAN><BR /><SPAN>??? Old records can???t be Modified. New records can be modified just the once before they to lock-up. If the end-user makes a mistake adding a new GIS_ID or GIS_Source record it isn???t easy for them to correct it.</SPAN><BR /><BR /><SPAN>I haven't tried accessing the table from SharePoint as an 'External List' but suspect I'll encounter same issue.</SPAN><BR /><BR /><SPAN>So does anyone know if non-feature related tables residing within a versioned SDE database can indeed be edit externally via a non ESRI client such as SharePoint?</SPAN><BR /><BR /><SPAN>Any advice on alternative approach also greatly appreciated.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Hayden</SPAN></BODY></HTML> Tue, 10 Jan 2012 23:12:38 GMT HaydenFoley 2012-01-10T23:12:38Z Can you update a table in a Versioned SDE Database externally from SharePoint? https://community.esri.com/t5/arcgis-for-sharepoint-questions/can-you-update-a-table-in-a-versioned-sde-database/m-p/436383#M1177 <HTML><HEAD></HEAD><BODY><SPAN>Hi There</SPAN><BR /><BR /><SPAN>Is it possible to update a table in a versioned SDE database from SharePoint? My table contains a register of assets that I want non-GIS people to be able to add items to.</SPAN><BR /><BR /><SPAN>I have done some investigation and testing of the editing experience interfacing SDE tables from SharePoint using Database Connections to Multi-Version Views (Viewed in SharePoint via SharePoint Designer built pages).</SPAN><BR /><BR /><SPAN>The SharePoint experience</SPAN><BR /><SPAN>??? New records can be added. The OBJECTID is mandatory and unfortunately has to be manually added. The OBJECTID is not auto-populated nd because it is mandatory can???t be left to SDE to auto-allocate the next ID the behind the scenes.</SPAN><BR /><SPAN>??? Old and new records from current edit session can be deleted</SPAN><BR /><SPAN>??? Old records can???t be Modified. New records can be modified just the once before they to lock-up. If the end-user makes a mistake adding a new GIS_ID or GIS_Source record it isn???t easy for them to correct it.</SPAN><BR /><BR /><SPAN>I haven't tried accessing the table from SharePoint as an 'External List' but suspect I'll encounter same issue.</SPAN><BR /><BR /><SPAN>So does anyone know if non-feature related tables residing within a versioned SDE database can indeed be edit externally via a non ESRI client such as SharePoint?</SPAN><BR /><BR /><SPAN>Any advice on alternative approach also greatly appreciated.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Hayden</SPAN></BODY></HTML> Tue, 10 Jan 2012 23:12:38 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/can-you-update-a-table-in-a-versioned-sde-database/m-p/436383#M1177 HaydenFoley 2012-01-10T23:12:38Z