SharePoint List Item Editor 1.06

SharePoint List Item Editor 1.06 brings you a useful application which makes it easier for SharePoint developers and users to preview, update, insert and delete SharePoint list items. You'll no longer have to rely solely on the web UI interface and the standard datasheet view. It's developed in C# and .NET 3.5. This is a small WinForm tool that populates a standard DataGridView control with the items of SharePoint lists. The list data can be fetched with either the SharePoint object model or with the standard SharePoint web services which allows for remote preview/updating of list items. List items are being updated using either the SPWeb.ProcessBatchData or the SharePoint Lists web service which ensures great performance for batch updates. 

1. You can open SharePoint lists and libraries using both the SharePoint object model and the standard SharePoint web services (for the second mode you don't need to have SharePoint installed on the machine you run the tool on)
2. List view scopes support - the contents of individual folders can be browsed as well as recursive view of all list items
3. Bread-crumb for folder navigation
4. You can select the fields to be displayed for editing, specify a CAML query for the result set, select a specific SharePoint list view
5. Copy-paste of single cells, rows, columns, regions; paste of multiple new items possible
6. Batch check in/out for document libraries
7. Batch setting of moderation/approval status
8. Batch creation of list/library folders
9. Upload multiple files to document libraries
10. The update of items automatically resyncs the items, so readonly/system fields get refetched from the source list
11. The changing of the FileLeafRef field renames the file for document libraries
12. The row header shows proper icons for checked out documents, the approval status and whether the item was modified in the editor
13. Different icons for documents checked out by the current user and other users
14. "Enhanced UI" option - lookup fields can be displayed as plain text or as drop-downs, support for multiple lookups too
15. "Explorer" button - opens the standard web folder windows explorer view with the contents of the selected library/list (see note below)
16. "Explorer" button for the current list/library folder
17. "Explorer" button can also browse the containing web
18. Documents can be opened from an icon in the "FileLeafRef" column
19. "Browse attachments" context menu item - opens the web folder windows explorer view with the location of the list item's attachments
20. "Ssuppress events" option for list item updating when the WSS object model is used - the synchronous and asynchronous events are enabled/disabled when the list items are being updated
21. Open web lists dialog
22. List of recently opened lists shown in the open menu
23. Farm explorer showing the SharePoint object hierarchy for easier list selection (no web services support)
24. Site collection explorer showing the webs, subwebs and lists of a selected site collection using the standard SharePoint web services
25. Create and modify list views functionality

• Several improvements:
• • Upload files to document libraries - files are being uploaded using the HTTP PUT support of SharePoint (windows' web folders support is quite tricky and not that reliable, so this is a good replacement for that functionality)
  • Open files from web - a list of all web's lists is displayed for easier and quicker selection of a list to open
  • Adding/updating more than several hundred items - update in chunks introduced, no restrictions and bugs for bigger number of updated items now
  • Several minor improvements to the UI of the multiple select picker
  • List of recently opened lists shown in the open menu
  • Farm explorer showing the SharePoint object hierarchy for easier list selection (no web services support)
  • Site collection explorer showing the webs, subwebs and lists of a selected site collection using the standard SharePoint web services
  • Create and modify list views functionality
  • Views changed in the "views" menu strip
• Bugs fixed:
• • Combo box column for lookup field when lookup list is empty - crushing fixed
  • Nasty error message boxes for combo box column for lookup field when invalid data is loaded/pasted removed - now a cell error message icon is displayed
  • Crush when wrong data is pasted to a multiple lookup field with multiple select column - fixed
  • Crush when a survey list is opened - fixed
  • Crush when navigating folders containing spaces in their URLs - fixed

• SharePoint 2007 and SharePoint 2010