Sharepoint Image Library and Datasheet view

Is it called Picture Library or Image Library? I never remember. Well nevermind.

There are a lot of YASQs that relates to consitency. I've been caught in a trap frequently by customers because I've assumed that functionality in one place is also available in the next in Sharepoint. Today it was the "Edit in Datasheet" button that came into play.

The customer was organizing pictures in folders in a Picture Library (or was it Image Library?) and found pictures hard to categorize. The built in Slideshow feature did not seem to work very well with the folders, nor with other views. The slideshow feature will always display the entire contents of the picture library and does not pay respect to neither views (filters) nor folders, even though the link is displayed in the context of a view or a folder.

I initially recommended to discard the use of folders and use metadata columns instead. This allows for more advanced categorization of data than the hierarchical folder structure. In fact I recommend never making folders inside a document library, because sooner or later people are going to copy a document into several folders in order to "tag" it with the appropriate context information.

In fact they should "folder-enable" columns to auto-generate views grouped by the column instead of having folders at all.

Well, so we're moving all the files out of the folders and tagging them with metadata instead. That's a perfect task for the DataSheet View; just open the folder, switch to datasheet view, set the value in the first row (likely the folder name) and finally drag the Excell cell-copy-thingy downwards to apply the value to all rows.

There is no Datasheet view on the Image Library. This also implies that there is no easy way to apply metadata after you upload a batch of pictures (which you normally do). I tried applying all my FrontPage Magic by inserting the toolbar-button from a regular Document Library and re-wiring the List guids and all that stuff. Looked good, felt bad. No errors, but no datasheet view either.

My initial guess is that the Image library, much like the Form Library are "same, same but different" and that the regular rules don't not apply. If someone out there got this thing working please write about it, because noone else has. Otherwise; at least you don't have to spend a couple of hours deschiffring sharepoint ListViewXml as I just did (again).

Filed under:

Comments

# KjellSJ said:

Using metadata + views is also correct for "tagging" (categorizing/classifying) according to Information Architecture and the LATCH method for structuring the information space: location, alphabetic, time-based, category, hierarchy (ranking). Folders are not. Lets hope that the synapses of our customers are not forever burnt on folders.

Wednesday, May 25, 2005 3:46 PM
# KjellSJ said:

What would have been perfect was to have a web-part with a treeview panel that would show listing metadata according to their hierarchy/ranking, and when clicking a node in the treeview, all list items having that metadata value (or value set) would be listed in a details panel.

This would give the users their beloved "folders". Two web-parts could also be used. The filtered list could then be just a customized filtered doc-lib view related to a node's metadata value set.

Note that I have not thought of how to get SharePoint metadata values to be hierarchical, but this can surely be solved somehow. Maybe some of the treeview web-parts out there can be used ?

Thursday, May 26, 2005 2:45 PM
# Rauri said:

After putting in a big push for my employer to move their photos from disorganised directories into oranised sharepoint meta data, it all ground to a halt. We have 2 options:

a) Very easy to edit information (datasheets) and very hard to preview pictures (thumbnails)

or

b) Very hard to edit information and very easy to preview pictures.

My solution was to use a document library so datasheets work, and I added a thumbnail column which uses a formula to replace the image string with a thumbnail string. Unfortunately, at this stage I only know how to do this formula in excell, requiring a few manual steps.

Tuesday, June 19, 2007 3:03 AM
# mlw said:

The lack of a datasheet view in MOSS image libraries is annoying.  I've been using a tool called DockIT (Vyapin Software) which allows me to do bulk picture imports and supply a spreadsheet or CSV to use to populate the metadata fields.

Thursday, July 12, 2007 3:29 PM
# KP said:

I am looking for a solution to using the slide show with a view.  Has anyone been able to figure this out OOTB?

Monday, August 06, 2007 3:24 PM
# Jim said:

dying for an OOB solution too...

Friday, August 10, 2007 1:06 PM
# Jim Uslan said:

Check this out...

groups.google.com/.../c642b8efab81da59%23c642b8efab81da59

Friday, August 24, 2007 3:12 PM
# SharePoint Picture Library Plus said:

Great post.

Please check this web part:

SharePoint Picture Library Plus

www.kwizcom.com/ProductPage.asp

Suggestions and comments are welcome.

Sunday, October 28, 2007 3:09 PM
# Alana said:

You can create an access view in a picture library and use this to quickly tag pictures instead of the datasheet view.

Monday, November 17, 2008 11:51 PM
# Les said:

You can create a new view in a Photo Library, then once you are in the view, where you select the columns and such, go all the way to the bottom and look for the Style section. Choose Basic table and it will give you the view you want and can put into Datasheet View

Tuesday, December 30, 2008 2:45 PM
# Olgunka-va said:

<a href= http://adultchatsfinder.com >chat online</a>

Sunday, March 01, 2009 1:42 AM
# Kelly said:

Les, how exactly do you put this into datasheet view, I cannot get this functionality

Sunday, April 19, 2009 9:17 PM
# Robin Majumdar said:

@Alana : yes, but that Access View requires Microsoft Access in order to manipulate the data/columns and doesn't allow for in-browser batch editing like the Datasheet view does.

@Les : I had a view (with grouping) in a picture library, changed the "Style" to "Basic table" but I still don't see the "Edit in Datasheet" option on the Actions drop down.

Monday, April 20, 2009 11:56 AM
# Nuno said:

I have the same problem... how did you succeeded in it?

How can icreate an access view?

Wednesday, August 12, 2009 2:06 PM
# Kyla Ensor said:

Has anyone come across a non-access way to use a datasheet style view for bulk editing of meta data within a photo library?

Tuesday, July 20, 2010 2:10 PM