Datasheet View for Picture Library

I love metadata, so it’s always annoying when I am suddenly not able to bulk update items in SharePoint. The Picture Library doesn’t come with a datasheet view option. How to get around this?

This URL: htps://SHAREPOINT/sites/SiteCollection/Images/Forms/BatchEdit.aspx?ShowInGrid=True&View=%7BDCBF7E0E%2D60C2%2D4555%2D91C2%2DB086EE2F9FA1%7D&InitialTabId=
Ribbon%2EList&VisibilityContext=WSSTabPersistence

Well almost. Keep this part. Change this part.

First create a view in your picture library that doesn’t have any thumbnails, but does have the columns you want to edit. Put the URL for that view in the part before the “?”

Find the guid for your view. I do that by opening the view in SharePoint Designer, clicking on the WebPartPages web part, and finding the ViewGuid. (If you have an easier way to do this, please share!)

Your guid will look something like this: {DCBF7E0E-60C2-4555-91C2-B086EE2F9FA1}

Replace: { with %7B    – with %2D    and } with %7D

The guid should now look like this: %7BDCBF7E0E%2D60C2%2D4555%2D91C2%2DB086EE2F9FA1%7D and will replace this part of the URL:

htps://SHAREPOINT/sites/SiteCollection/Images/Forms/BatchEdit.aspx?ShowInGrid=True&View=
%7BDCBF7E0E%2D60C2%2D4555%2D91C2%2DB086EE2F9FA1%7D
&InitialTabId=Ribbon%2EList&VisibilityContext=WSSTabPersistence.

You’ll now be able to use this URL to access the picture library in datasheet view.

Advertisements

2 Responses to Datasheet View for Picture Library

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: