rss

Sharepointology

Sharepointology is the study and handling of Microsoft Office SharePoint Server

Bulk editing metadata in a Sharepoint Picture Library

Posted 18Aug09 by Erwin in End User having 7 comments »

One of our SharePoint users asked me if it was possible to select a range of multiple images in a SharePoint Picture Library and edit their metadata in one go?

In a Document library you can do this by using the “Edit in datasheet” option, in the datasheet  you can bulk edit the metadata, but for some reason the Picture Library doesn’t have that option.

But, if you have Access 2007 installed on your pc,  you can create an Access View which allows you to use Access 2007 to populate the metadata.

1. Go to your Picture Library and Create a new view

Bulk_Picture_Create_View

2. Choose Access View

Bulk_Picture_Access_View

3. Save the file somewhere

Bulk_Picture_Save_As

4. Datasheet is the best way to edit bulk data

Bulk_Picture_Datasheet

5. Edit your metadata, click in another record to save the changes

Bulk_Picture_Edit

RSSIf you like this post then please consider subscribing to my full feed RSS. You can also subscribe by Email and have new posts sent directly to your inbox.

Silverlight 3 Released

Posted 12Jul09 by Erwin in General having no comments »

silverlight3Silverlight 3 is a major update and delivers a ton of new features and capabilities.

You can read more about Silverlight 3 in the following blog posts:

SharePoint Best Practices Conference Notes (London 2009) – Day 3

Posted 07May09 by Erwin in General having no comments »

Intranet, Extranet and Internet best practices. (Steve Smith, Spence Harbar)

  • If you need an extranet, VPN could be an option.
  • If you have 2 Web Front End servers, one for Intranet and one for Internet, keep both web applications on both servers, it’s easier to update.
  • Web Application Best Practices:
    • Don’t allow servers to access the internet.
    • 64 bit hardware.
    • Use Network Intrusion Detection (Host based detection causes extra server load).
    • Consider Transport Layer Security(SSL, IPSEC) between servers carefully, it’s complex.
  • SSL Best Practices:
    • Offload from SharePoint.
    • Sticky session on NLB (see white-paper on combined knowledge site).
    • Use port 443.
    • Use A Records in DNS.
    • Use fixed IP Addresses.
    • Use SSL for Central Administration (password sent over the network).
    • ForeFront Anti-Virus for SharePoint.

Read the rest of this entry »

Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0

Posted 30Apr09 by Erwin in Setup having 1 comment »

Microsoft announced that Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0 has been released to the Microsoft Download Center.

Web Part to show upcomming birthdays in SharePoint V2.0

Posted 26Apr09 by Erwin in General having 4 comments »

codeplexI’ve updated my SPOShowBirthdayWebPart on the SharePointology project on Codeplex.com.

SPOShowBirthdayWebpartSPOShowBirthdayWebPart is a webpart that will display all users whose birthday is coming up in x days.

Changed in V2.0:

  • Replaced username by Firstname and Lastname.
  • Made Name column link to the user profile page

Download SPOShowBirthdayWebPart v2.0.

Prerequisites
This webpart uses the RunWithElevatedPrivileges function to impersonate the administrator in SharePoint Server 2007. After you do this, you may receive the following error message when you try to enumerate all user profiles:

“Access Denied. Only an administrator may enumerate through all user profiles.”

Microsoft released a hotfix package for this bug “SharePoint Server 2007 hotfix package: May 8, 2008″,
http://support.microsoft.com/kb/952294

About

My name is Erwin Bastiaensen and I am a Software Architect from Belgium, with a huge interest in technology. Lately I have been involved in some Java projects and implementing, interfacing and extending a Sharepoint portal.

You can contact me at sharepointology[@]gmail.com.

View Erwin Bastiaensen's profile on LinkedIn