Posts

Showing posts from 2010

c# script to delete very large second stage recycle bin items in sharepoint 2007

In SharePoint 2007, when item versioning is set to no limit for a document library, you could easily have a spiraling content database size.  When you try delete a ginormous item, it'll eventually get stuck in the second stage recycle bin, and you'll never be able to reclaim that database space or file space - a forced purging of the recycle bins through a UI operation will time out eventually, rolling back a huge transaction, probably freezing the site for your users - cue fire and brimstone. The solution is to run the following script off-hours.  Off hours helps minimize any potential blocks SQL server may issue against database pages as it goes around deleting the row content from alldocversions - from what I can tell, many I/O Page Latch locks are issued when SQL is deleting blobs, so to be nice to this script and run it off hours.  Compile it into a c# console application referencing the sharepoint dll. There isn't much for progress reporting included in the script...

sharepoint trick to edit "new item form" by adding to url

Image
Hide columns on NewForm, DispForm, EditForm in SharePoint list To remove columns from appearing on a display, edit item, and new item form in SharePoint lists, e.g.: The goal is to add some JavaScript into a Content Editor Web Part (CEWP) on the above page. To add web parts to any page within Sharepoint : On the URL of the form page you are, add to the end of it: &toolpaneview=2 (i.e. Or remove all the stuff (querystring) stuff at the end of URL and change it to DispForm.aspx?toolpaneview=2 . The page will then change to Edit Mode: From here, add a CEWP, content editor web part, to the page UNDER the form already on the page. This is very important, if will not work if the CEWP is not under the form. Modify the CEWP, open the source editor, and paste in: <script type="text/javascript"> var containers = document.getElementsByTagName("*"); for (var i=0;i<containers.length;i++) { if (containers[i].innerText == ...

Win 7 & SharePoint fix: webdav Explorer (windows explorer view's) slow performances issue

Since upgrading any client to Windows 7, SharePoint's Windows Explorer view got really really slow. Guess what, it has to do with IE 8's (maybe IE7 too) automatic proxy detection, not SharePoint.  You might experience this slowness connecting to any webdav server, including my iPhone's. Here is the fix: In Internet Explorer, open the Tools menu, then click Internet Options. Select the Connections tab. Click the LAN Settings button. Uncheck the “Automatically detect settings” box. Click OK and thank daniel cd  http://social.technet.microsoft.com/Forums/en-US/w7itpronetworking/thread/600a9825-0ba1-4c15-93f6-fc99c64b4930 or chief oddball  http://oddballupdate.com/2009/12/18/fix-slow-webdav-performance-in-windows-7/

Grilled Thick Lamb Chops with Stout-Citrus Glaze

Grilled Thick Lamb Chops with Stout-Citrus Glaze Time:  45 minutes 1 cup stout of your choice 1/4 cup balsamic vinegar 1 tablespoon grated lemon zest 2 tablespoons fresh lemon juice Salt 8 thick (about 1 1/2 inches) lamb rib or loin chops 2 tablespoons olive oil Black pepper. 1 . Combine stout, vinegar, lemon zest, lemon juice and salt in a small, heavy-bottomed saucepan. Bring to a boil over high heat, then reduce heat to medium and simmer vigorously until reduced to about 1/4 cup syrup, 20 to 25 minutes. 2.  Meanwhile, build a fire on one side of a grill. When fire has died down, and coals are medium-hot (you can hold your hand 5 inches above grill grate for about 2 seconds), move enough coals to other side of grill to form a single layer, leaving most coals on hot side. 3.  Rub lamb with oil, sprinkle generously with salt and pepper, place directly over hot part of grill and sear well, about 2 minutes a side. Move chops ...

Semiya Vada from the South Indies

Ingredients : Channa Dal (coarsely ground) Chopped Onion Green chillies chopped Garlic chopped Ginger chopped Curry leaves Vermicelli (roasted) Cumin Fennel Salt Oil Method : Mix channa dal, salt, chopped onion, chopped green chillies, chopped ginger, chopped garlic and chopped curry leaves. Roll into balls Coat with roasted vermicelli and flatten into cakes Deep fry in hot oil Serve with a chutney dip

San Francisco Trivia for Drupalers

A friend of mine was in town for the DrupalConSF and asked me about some San Francisco history. Thus it seems appropriate to publish some of the lesser known historical tidbits about SF that I've been meaning to resend out for awhile. Hope you enjoy & learn about SF, or use this in a drinking game/trivia night, etc. Credits to Stacey Irvine - an amazing and curious person - from Parody , of the Dive Bar Club fame. san francisco trivia The Questions Answers Why was Lawrence Ferlinghetti arrested in 1956 on obscenity charges? He published Alan Ginsburg's Howl Why was Abe Warner famous for his Cobweb Palace at Meig's Wharf? He refused to do anything to hurt a spider, including sweeping away cobwebs Why is San Francisco Sourdough unique, and can't be made elsewhere? The yeast that gives it that unique San Francisco flavor won't grow anywhere else Why is it said that Colma has more dead people than live ones? That's where all the cemet...

Project management for Drupal consultants

Project Management for Freelancers by Crystal Williams .
Image
The almighty comes down to two nude statues in a park and says "For a short period of time, I will bring you to life, and you can do whatever you would like to do." So these two statues come to life. They jump into a large set of bushes.  There is all kinds of rustling and banging around in the bushes. And of course the almighty peers around the bushes in time to see the male statue say to the female statue,  "Okay, now you hold down the pigeon, and I'll shit on it!" -  a. thomas schomberg

guacamole recipe, central mexican styled

Image
Colibri's Guacamole, from Jonathan Kakacek 1.5 avocado 1 to 1.5 Tablespoons of each -onion chopped -jalapenos chopped -cilantro -tomato teaspoon of salt or to taste .5 tsp 1.5 lime (juice, cut in half, use fork to poke and squeeze/twist) mix in a folding action and tah dah

Locking down Actions in SharePoint 2007 like Edit in Datasheet, Export to Spreadsheet

Image
Among the many requests we get to compose or decompose some of the basic functionality built into SharePoint 2007 - we get this one a lot.  For some very valid business reasons, Edit in Datasheet or Export to Spreadsheet (Excel / Access) violate some of the metadata rules or workflow customizations that may affect metadata.  I think this is due to the lack of robust field level security tied out to the users or groups in SharePoint.  It's not too hard to build this into SharePoint (most serious web applications have field level security), and I've even helped build field level security into a few widely employed web applications. So maybe its due to something else.  Either way, to disable the functionality, you basically gut SharePoint's webservices from the set of users you want to lock it down for. Go to [your site] > Site Settings > Permissions > Permission Levels Note: to do this for a single list, break permission inheritance at the list, th...

Upgrading custom sharepoint 2007 workflows in progress

From what research I've done, it seems safe to upgrade (via solution deployment) previously associated, deployed, and running SharePoint 2007 Custom Workflows (developed in Visual Studio) that are In Progress. The two key areas why I think this works is to do with the content that SharePoint hydrates each time a workflow moves into and out of memory.  In old-fashioned programmer speak, the program section and data section are saved with each instance of a workflow.  In current lingo, I understand Extensible Application Markup Language (XAML) is used to represent SharePoint workflow objects in XML thereby allowing the instances of all the data objects and the program code to be streamed into and out of memory in perpetuity.  If you think about how challenging this is to accomplish, you'll understand why I really respect this aspect of SharePoint, and how it adds to the awesomeness of skill displayed by their development team.  Caveat emptor: dehydration and r...

Dhal with Spinach recipe

Image
Dhal with Spinach  by Juliana Madan (my mamma!) 1 cup of any kind of dhal -- cook in pressure cooker with the following 1/2 tsp tumeric 1/2 tsp cumin 1 chopped tomato 2 Jalepenoes sliced You may need 1 or 1 & 1/2 cups of water to cook. After 10 mins or slow turn off & let it cool Add 1 or 2 bunches of chopped spinach into cooker & simmer till cooked. For seasoning Heat 2 TBSP oil Add 1 tsp mustard seeds-- when they pop crackles add the following ingredients to the oil 2 red dry chillies 1 onion chopped Pour on top of cooked dhal Add coriander leaves for garnish

Ribs recipe

Image
Sandhya Chib's Famous Ribs 1 c chopped onion 2 tbsp olive oil Few dry red chillis (break them in half if you really want the heat) 3 cloves garlic 1/2 c white vinegar 3/4 c packed brown sugar 1/3 c soy sauce 1/2 c chilli sauce Heat oil. Fry chillis. Add onion, fry 5 mins, add rest of ingredients, bring to boil. Remove from heat, pour over ribs, bake at 350 for one hour. Baste couple times. Turn up to 500 at end and brown for two mins.

michelin 2010 san francisco bib restaurant guide, redux

Image
Hi 2010, now where is my HAL 9000 I was sci-fi-promised!?   HAL:  "The 9000 series is the most reliable computer ever made. No 9000 computer has ever made a mistake or distorted information. We are all, by any practical definition of the words, foolproof and incapable of error." Why the redux? So I remember in 1992 thinking, why do some people think html is difficult ? Later that decade, I recall seeing the first copy of html for dummies (and screaming in agony).  I think that might have been the reference manual the coders at michelin.com still use - or they might just be using Microsoft Word 1997's "Publish as a Complete Web page" to do their famously anonymous site .  View source. What is a bib? A Bib Gourmand rating means the restaurant is an inspector's favorite for good value. For $40 or less, you can enjoy two courses and a glass of wine or dessert (not including tax and gratuity). San Francisco 2010 Bib Gourmand Restaurants (the filterable,...