Enhanced SharpSSH – In .NET 3.5 & Support for SFTP Delete

On my current project we had a requirement to drop a file onto an SFTP server.  SharpSSH seems to the only free and open source option around for .NET

Some of the pain points of SharpSSH

• SharpSSH was written in older version of .NET and relies on algorithms in Org.Mentalis.Security.Cryptography for encryption and hashing which is now natively supported by System.Security.Cryptograph so using SharpSSH as is does not seem right
• Sftp implementation does not support deleting a file (although it is very simple to add that!)
• Not complied with a Strong name key

Making above changes looked easy enough, so here is the download of SharpSSH – SFTP component for .NET which:

• Uses algorithms in System.Security.Cryptograph instead of Org.Mentalis.Security.Cryptography
• Compiled using  .NET 3.5 with strong name  and Project converted to Visual Studio 2008
• Supports Deleting a file, directory and renaming over SFTP

Download Enhanced SharpSSH Here

Convert a WebPart Zone in MOSS into Accordion or Tabs Style Interface

This is a web part that turns all the visible web parts with a Title in a Zone into Tab or Accordion interface.  Just drop the webpart into a zone and see it convert all the visible webparts with a title in the zone  into part of Tab or Accordion.  It renders one tab/accordion menu per webpart.

Originally inspired by EasyTabs from PathToSharePoint but instead of embedding some JavaScript with Content editor web part, it’s a custom web part providing a property to control if it renders Tab or Accordion and JavaScript bit is done using jQuery.

Some customary screen shots!

WebPart Zone Converted into Tabs

WebPart Zone containing the TabAccordion WebPart in Edit mode

WebPart Zone converted into Accordion

WebPart Zone containing the TabAccordion WebPart in Edit mode

Properties of the WebPart

Download Full Source Code. Hopefully it’s commented just enough to understand what’s going on in the JavaScript.

WSP Solution can be downloaded from here. Once the package is deployed, Activate the Kark SharePoint Web Parts feature at Site Collection level and Tab Accordion web part will be available in the Web Part Gallery.

UPDATE
Have changed the JavaScript to render tabs at the top

Download WSP Here

Here is a screenshot

Please excuse the ugly looking Tabs, but hopefully CSS should be really easy to change

Created Date in SPListItemVersion does not respect locale settings?

A Quick post! On a recent project we had a custom control that was showing document version history information such as “Created By” and “Date Created” in a table format, it was looking all good. After the day light savings time (British Summer Time) one of the tester spotted a bug in document version history control where “Date Created” was still showing the GMT time, it looked like SPListItemVersion.Created was not respecting day light savings time.

TimeZone.xml looked good and every other Dates on the site were showing correct time. It turns out that SPListItemVersion.Created was only showing time in GMT (Don’t know why!) so a simple fix was to convert the time into local time at the render time.

lblDateCreated.Text = version.Created.ToLocalTime().ToString();

Various MOSS Enterprise Search Stuff – Part I

Recently I have been working on a large Content Management solution that required 300+ custom Managed/Metadata Properties in MOSS Search and had requirements to allow user to search on all of the Metadata Properties. MOSS Search Index was also used to run a number of reports such as “What Asset (Image, Video, Document etc) is used on what page?”

While working with MOSS Search I came across a number of things that I think are worth sharing.

Programmatically setting up Shared Scope

APIs to work with MOSS Search related Administration tasks such as creating Scopes, Managed Properties etc are very straight forward and well documented under Getting Started with the Enterprise Search Administration Object Model

But if you want to set up a shared scope, then it’s not very obvious from API how to do it. ScopeCollection.Create method as shown below takes owningSiteUrl as a parameter and to set up a shared scope just pass in null for owningSiteUrl and the scope will be created as a Shared Scope!

</p> <p>public Scope Create (<br />     string name,<br />     string description,<br />     Uri owningSiteUrl,<br />     bool displayInAdminUI,<br />     string alternateResultsPage,<br />     ScopeCompilationType compilationType<br /> )<br /> 

Programmatically setting up “Include values from a single crawled property based on order specified”

Programmatically setting up mappings to crawled properties is straight forward, if you want to add multiple crawled properties and include value only from a single crawled property based on the order than from the UI, you can simply check the radio button next “Include values from a single crawled property based on order specified”.

To do it programmatically add multiple Crawled properties to MappingCollection and then set ManagedProperty.RespectPriority property to true, here is some code (pseudo code really!) to add multiple crawled property mappings

</p> <p>Schema propertiesSchema = new Schema(SearchContext.Current);<br />                 ManagedPropertyCollection managedProperties = propertiesSchema.AllManagedProperties;<br />                 ManagedProperty managedProperty = managedProperties["Test Property"];<br />                 MappingCollection mappingCollection = managedProperty.GetMappings();</p> <p>//Create Crawled Property Mappings</p> <p>Mapping propMapping = new Mapping(new Guid("00130329-0000-0130-c000-000000131346"),<br />                                                  "ows_Modified_x0020_By",<br />                                                   "31",<br />                                                   managedProperty.PID);</p> <p>Mapping propMapping1 = new Mapping(new Guid("b725f130-47ef-101a-a5f1-02608c9eebac"),<br />                                                  "11",<br />                                                   "31",<br />                                                   managedProperty.PID);</p> <p>//Add in the order in which you want it to appear in the Admin UK<br />                 mappingCollection.Add(propMapping);<br />                 mappingCollection.Add(propMapping1);</p> <p>managedProperty.SetMappings(mappingCollection); // You have to do this for Mappings to work<br />                 //Tell it to respect priority!<br />                 managedProperty.RespectPriority = true;<br />                 managedProperty.Update();<br /> 

If you look at the Mapping object’s constructor below

</p> <p>public Mapping (<br />     Guid crawledPropset,<br />     string crawledPropertyName,<br />     int crawledPropertyVariantType,<br />     int managedPid<br /> )<br /> 

It takes a Guid (crawledPropset) which is the category of crawled property (SharePoint, People, etc) and also takes an int (crawledPropertyVariantType) which represents the DataType of crawled property, I find it annoying that list of possible values crawledPropset and crawledPropertyVariantType is not very handy so here are the possible values

Some Possible Values of crawledPropertyVariantType

Data Type	crawledPropertyVariantType
string	31
bool	11
integer	20
datetime	64
Something to do with Custom field	4127

*Please note that above values are what I have encountered till now *

Commonly Used crawledPropset

Category	crawledPropset
Sharepoint	00130329-0000-0130-c000-000000131346
Basic	0b63e343-9ccc-11d0-bcdb-00805fccce04
Mail	aa568eec-e0e5-11cf-8fda-00aa00a14f93
Office	f29f85e0-4ff9-1068-ab91-08002b27b3d9
People	00110329-0000-0110-c000-000000111146

Filtering by approval status in ContentByQueryWebPart

If you need to programmatically set properties on ContentByQueryWebPart to filter the data by approval status than FilterField is _ModerationStatus FilterType is ModState

webPart.FilterField1 = "_ModerationStatus";
webPart.FilterType1 = "ModStat";
webPart.FilterValue1 = "Approved";