Import ULS log files to SQL Server database for Sharepoint 2010

Sometime you may need to import ULS log files to SQL server . It can be done with several ways by using SQL Server import tools or import from an Excel file to SQL  server. Or you can use fallowing free open source windows application tool. With this tool it can be done with more quickly . By multy-threading and bulk insert architecture feature provides you that ULS logs contains total 1.500.000 row  can be upload in  apprx. 2 minutes. (as you know it depends on your configuration and hardware)

Than you can query SQL tables as you wish : Fallowing query will return execution time over 1 sec for SPMonitoring event records.

select * from WFE1
where [ExecutionTime] > 1000 and [Eventid] =’b4ly’
order by [ExecutionTime] desc

“All These source codes are freeware and is provided on an “as is” basis without warranties of any kind, whether express or implied, including without limitation warranties that the code is free of defect, fit for a particular purpose or non-infringing. The entire risk as to the quality and performance of the code is with the end user

For Download  ULStoSQLImporter v1.0  for Sharepoint 2010:
http://spstools.codeplex.com/releases/view/93135

Advertisements

CabMaker v1.0 (Command Line Tool)

If you have ever need explore or change a file content inside of wsp file,  you already know that changing extention and rename it as “Cab” file , you can open or extract contained files by using well know compress programs like zip or rar openers. But what if after you change some file for example after fixing an element.xml file , if you  need to make again a wsp , this very simple tool can help make cab(or wsp) files.

Usage: cabmaker <source folder> <cab file name>
Examples :
cabmaker c:\mySolution c:\mysolution.wsp
cabmaker c:\mySolution c:\mysolution.cab

Download:
For 64 bit systems:
https://spstools.codeplex.com/releases/view/86657#DownloadId=371493
For 32 bit systems:
https://spstools.codeplex.com/releases/view/86657#DownloadId=371494

 

 

 

Sharepoint Tools – WssDownload v1.0 (Command Line Tool)

Hi Everyone,

WssDownload  tool has been relasead. You can use this tool for download all documents in a Document Library as preventing folder structure to your server harddrive.
If you wonder why have i developed this tool , consider a scenario that publishing feature is been corrupted or not activated and windows explorer view not running and you have hundreds of files in your library, how could you download them manuelly ? so i think it is clear that you can use it .

For Download.
http://spstools.codeplex.com/releases/view/80908

WssDownload x86 can be used 32 bit Sharepoint 2007 systems.
WssDownload x64 can be used both Moss2007 x64 and Sharepoint 2010 systems.

* This is a command tool that using sharepoint object model and should be run in sharepoint installed server

Usage:
WssDownload <site url> <library name> <download path>

Example:
WssDownload http://blog.bugrapostaci.com Presentations c:\\downloads

🙂

Good Tools for Fixing Missing Features on Sharepoint

Some scenarios removing a feature unproperly or after migration your sharepoint to upper version  or in a development envoriment adding removing solutions with multiple times cause  getting several kind of feature errors like “Failed to find the XML file at location ’12\Template\Features\{feature name}\feature.xml’

Here is a very good article about this problem and solution.
http://blogs.msdn.com/b/tehnoonr/archive/2009/02/15/resolving-the-error-failed-to-find-the-xml-file-at-location-12-template-features-feature-name-feature-xml.aspx

 You may need belowed tools for fixing that problem. (Some tools are using  just stsadm at background but giving you a visual form experience.)

Wss Remove Feature From Tool
http://archive.msdn.microsoft.com/WssRemoveFeatureFrom
In some situation the STSADM command STSADM.EXE -o deactivatefeature is not able to deactivate a feature either on site collection or on site level.
This can (e.g.) happen if the feature definition for the feature that has to be removed is not installed in the farm.
This tool allows to remove the feature from the site or site collection completly.
Usage:
WssRemoveFeatureFromSite -scope (site|sitecollection) -url <url-to-site> -featureid <featureid> -force

Wss Analyze Features  Tool
http://archive.msdn.microsoft.com/WssAnalyzeFeatures
This tool allows to verify if the feature definition files for all installed features are present on the file system. Also allows to verify if the features used in site collections an sites are installed on the server.
In addition it can create a checklist file which can be used to verify if a server has all features installed required to act as destination for a content deployment job of an existing sitecollection.
Usage:
WssAnalyzeFeatures -url http://server:port
This command will verify all features on the server and in the site collection.
It will create two files:
– ProblemFeatures.txt outlining all identified problems.
– ContentDeploymentFeatures.txt this is the created checklistfile. It will contain all features that have to exist on the target to be able to act as target for a content deployment of the site collection.
WssAnalyzeFeatuers -verify ContentDeploymentFeatures.txt
this command will verify the features installed on the server against the features listed in the ContentDeploymentFeatures.txt checklistfile which was created on the source server.

SharePoint Feature Administration and Clean Up Tool
http://featureadmin.codeplex.com
Find faulty FeatureDefinitions and cleanly uninstall them.
Find Feature remainders in Sites, SiteCollections, WebApps and in the Farm, from e.g. forcefully uninstalled Features from farm without deactivating them before, causing errors.
Also, de-/activate Features Farm wide.

Faulty Feature Tool v2
http://www.moss2007.be/blogs/vandest/Documents/FaultyFeatureTool_EXE.zip

 .

LangStore for Sharepoint 2010

Sharepoint developers knows LangStore for building Multilingual Sharepoint 2007 Sites  by Chris O’Brain. This is very useful tool and i personally thanks Chris for this great tool. But when you want to use this tool with sharepoint 2010 it has some compatiblity issues .
Some of Site columns collide with comming out of the box columns already used by site content type for example “catagory”. I download and change code with schema.xml and element.xml of MultilingualItemType like below:

<FieldRefs>

<FieldRef Name=LinkTitle />

<FieldRef ID={E5C8FDA4-BDA7-4419-8A4E-DE102964884B}
Name=LangStoreCategory Required=true />

<FieldRef ID={D36535DC-31D1-4eb2-9C5C-58CE11EDA226}
Name=LangStoreDescription Required=false />

<FieldRef ID={160036D9-C1A0-419a-AFCE-4CF0525E2160}
Name=LS_LANG_EN Required=false />

<FieldRef ID={21C5A600-9BE5-4f2a-ABD8-271206FC988F}
Name=LS_LANG_TR Required=false />

<FieldRef ID={20DA8826-4CAC-41ca-9399-A82C50E9D66F}
Name=LS_LANG_EN-US Required=false />

<FieldRef ID={1DC99CF7-6667-44ee-83AB-0A5D46D0A092}
Name=LS_LANG_EN-GB Required=false />

<FieldRef ID={600081D6-5AA3-4901-AC55-5537C044D383}
Name=LS_LANG_FR-FR Required=false />

<FieldRef ID={E96813DE-E8A8-4640-AF8D-1E4AC4292B3E}
Name=LS_LANG_DE Required=false />

</FieldRefs>

.

And i also change all project for suitible with Sharepoint 2010 project for VS 2010 IDE.

 

 

Original Langstore :

http://www.sharepointnutsandbolts.com/2008/12/building-multi-lingual-   sharepoint-sites.html

 

Orginal Langstore Download:

http://splanguagestore.codeplex.com/

You can download LangStore2010 from:

http://rapidshare.com/files/425395340/LangStore2010.rar

Sharepoint Log management with ULS Viewer

Hi Everybody ,

Sharepoint logs is one of the important point for developers . When an error occures you may want to examine sharepoint logs in drive:\Program Files\Common Files\Microsoft Shared\Web Server Extentions\[12,14]\Logs.These log files are text based and sometimes its make me creazy for searching related data .Because its hard to find some thing in these texts files. There are some tools for easily manage your logs.

What is ULS Viewer:

ULSViewer allows users to open a ULS log file and display its contents in a user friendly format. Users can then perform advanced functions such as filtering, sorting, highlighting, loading logs, appending logs, etc in order to single out the data that is important to the user. This information can be used to diagnose problems with machines running ULS services, or to monitor machines and the events they create in realtime.

Toggle Correlation Tree and Notification features are most i like.In SharePoint 2010 has come with new error handling feature named  “correlation id”  which is help us to trace a series of event inside SharePoint.

Download: http://code.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308

ULS Viewer for sharepoint: