Thursday, September 10, 2009

TechNet Script Center

Received an email today about Microsoft Script Center, and the evolution of what used to be called the 'Community-Submitted scripts'. The new TechNet Script Center allows you to upload scripts directly under your profile (Windows Live/Passport), draft and publish scripts (not unlike this blog), get ratings, and host a discussion board for each script.

In the bad old days, believe it or not, the method to submit scripts was to email them with the script in the body of the email to a Microsoft address. While it seemed low-tech, they were actually extremely reliable and pretty quick turning submissions around.

Like it a lot as a way to share some generic code snippets/modules, things that don't justify setting up a whole project with source control such as CodePlex.

Be sure to keep an eye on my TechNet Script Center Contributions. I'm posting a few that have been useful historically.

Wednesday, September 9, 2009

Word 2007/MOSS Metadata Integration

Word 2007/MOSS Metadata Integration

Looked up some sites on how to pull data into a Word template from a MOSS List. Scarily examples with a ton of code embedded either in the doc or through a seperate .net app. Finally found a modestly stable technique that involved linking to the SharePoint list through an Access db, and then using that Access db as a source of a Mail Merge in Word. Not bad - unidirectional and has a few moving parts.

Then, this technique: Word 2007/MOSS Metadata Integration, uses a document library with columns, similar to setting up a list, then the columns can be used in a Word 2007 document with bidirectional updating.

Challenge I've ran into so far is versioning of the template, not seeing an easy way yet to update the template used on existing documents if columns are ever modified, added or deleted.