Thursday, February 18, 2010

The Farm is unavailable Error - while running stsadm

Another day, when I was trying to activate a feature by running STSADM, it resulted with an Error message to me saying: "The Farm is unavailable"
The Farm is unavailable Error - while running stsadm

The cause of this issue is: I was running STSADM under an account which doesnt has the access to SQL Server!

Once I ran the command again with another account which has the access to SQL server (Server Roles: DBCreator & Security Admin) it went well!

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Wednesday, February 17, 2010

IFilters in SharePoint - What is that? why should I care about? How do I configure them?

 What is IFilters in SharePoint? Well, as per Microsoft: "The IFilter interface scans documents for text and properties (also called attributes). It extracts chunks of text from these documents, filtering out embedded formatting and retaining information about the position of the text."

Out of the box SharePoint will index many types of content. This includes a lot of popular file formats (.ppt, .doc,  .xls, etc). But for some special file types like PDF, TIFF we got to install IFilters in order to index those file types.

You can now index the following files with free ifilter pack: .docx, .docm, .pptx, .pptm, .xlsx, .xlsm, .xlsb, .zip, .one, .vdx, .vsd, .vss, .vst, .vdx, .vsx, and .vtx
http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en

You can download the PDF IFilter from: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025. Follow the KB: http://support.microsoft.com/kb/2293357 to configure it. 

Here is the excellent site with list of FREE IFilters: http://www.ifilter.org/Links.htm


Step by step guide on configuring IFilters:
Configuring iFilter for PDF Search in SharePoint 2010 - Step by Step

For MOSS 2007:
http://www.surfray.com/resources/tech-blog/292-how-to-index-pdf-files-in-sharepoint.html
http://www.moss2007.be/blogs/vandest/archive/2007/09/19/sharepoint-2007-and-pdf-indexing.aspx 
http://ekhichdi.com/e/search-result-for-PDF-file-in-Sharepoint-269.html

Here is the related article on setting up the Icons for custom file types: http://salaudeen.blogspot.com/2013/03/how-to-add-custom-file-type-icons-in-sharepoint.html

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Tuesday, February 16, 2010

Creating Fusion Charts in SharePoint with SharePoint Designer - Simple way

Fusion Charts is a great free product, it helps us to create animated & interactive charts for web & enterprise applications. We can use fusion charts to display our SharePoint list data!

So, Here I'm going to show, how to use fusion charts in SharePoint with simple example.

Here is the 10 steps:
1. Download the fusion charts free version from: http://www.fusioncharts.com/free/
2. Create a new document library
3. Upload the .SWF files from fusion charts into SharePoint Library.
fusion chart for sharepoint 2010


4. Create a simple list (Here "Project Cost" with 2 columns, say: Title, Cost).
fusion chart sharepoint list

5. Open the SharePoint designer, Create a new Aspx page, Drop a Dataview webpart, Drag and Drop the Title and Cost columns into data view web part.

fusion chart sharepoint designer
 use fusion chart sharepoint


6. Lets do some clean up. Delete everything in between
 <xsl:template name="dvt_1.body">
            <xsl:param name="Rows"/>




and
</xsl:template>


Now, your code should look like:
fusion chart sharepoint 2007


7. Fusion Charts follows a specific format XML for the Data input. Say for example, for column charts, we need to give the input in the below format: (This format differs from one chart type to another. You can refer the fusion chart documentation or sample charts for the format).

<graph caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units'
decimalPrecision='0' formatNumberScale='0' chartRightMargin='30'>
<set name='Project A' value='1000' color='AFD8F8' />
<set name='Project B' value='2000' color='F6BD0F' />
<set name='Project C' value='3000' color='8BBA00' />
<set name='Project D' value='4000' color='FF8E46'/>
</graph>

8. So now, we are going to use two XSL variables: varDataset and varChartData to frame the XML
Insert the below code just below
<xsl:template name="dvt_1.body">
            <xsl:param name="Rows"/>

<xsl:variable name="varDataset">
        <xsl:for-each select="$Rows">
                 &lt;set name=&apos;<xsl:value-of select=" @Title"/>&apos; color=&apos;1D8BD1&apos; value=&apos;<xsl:value-of select="@Cost"/>&apos;  /&gt;
      </xsl:for-each>   
  </xsl:variable>

 <xsl:variable name="varChartData">
      &lt;graph caption=&apos;Project Cost Chart&apos; xAxisName=&apos;Project Name&apos; yAxisName=&apos;Cost&apos; showNames=&apos;1&apos; decimalPrecision=&apos;0&apos; formatNumberScale=&apos;0&apos; &gt;
      <xsl:value-of select="$varDataset" />
      &lt;/graph&gt;  
      </xsl:variable>

9. Now, we need the code, which renders our chart. insert the below code.
  <tr>
  <td>
         <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="500" height="400">
          <param name="movie" value="http://teamsites.crescent.com/sites/saltest/Charts/FCF_Column2D.swf?chartWidth=500&amp;chartHeight=400" >
            <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:whitespace-preserve="yes" xml:space="preserve">
                </xsl:text>
            <param name="FlashVars" value="&amp;dataXML={$varChartData}&amp;chartWidth=500&amp;chartHeight=400"><param name="quality" value="high" /></param></param>  </object>
      </td>
      </tr>

</xsl:template>           

So the complete XSL code would be:
 <xsl:template name="dvt_1.body">
   <xsl:param name="Rows"/>

  <xsl:variable name="varDataset">
        <xsl:for-each select="$Rows">
                 &lt;set name=&apos;<xsl:value-of select=" @Title"/>&apos; color=&apos;1D8BD1&apos; value=&apos;<xsl:value-of select="@Cost"/>&apos;  /&gt;
      </xsl:for-each>   
  </xsl:variable>

 <xsl:variable name="varChartData">
      &lt;graph caption=&apos;Project Cost Chart&apos; xAxisName=&apos;Project Name&apos; yAxisName=&apos;Cost&apos; showNames=&apos;1&apos; decimalPrecision=&apos;0&apos; formatNumberScale=&apos;0&apos; &gt;
      <xsl:value-of select="$varDataset" />
      &lt;/graph&gt;  
      </xsl:variable>

<tr>
  <td>
         <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="500" height="400">
          <param name="movie" value="http://teamsites.crescent.com/sites/saltest/FusionCharts/Charts/FCF_Column2D.swf?chartWidth=500&amp;chartHeight=400" >
            <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:whitespace-preserve="yes" xml:space="preserve">
                </xsl:text>
            <param name="FlashVars" value="&amp;dataXML={$varChartData}&amp;chartWidth=500&amp;chartHeight=400"><param name="quality" value="high" /></param></param>  </object>
      </td>
      </tr>
 </xsl:template>


10. Finally, we got the fusion chart
fusion chart sharepoint 2007
Related Fusion Chart Articles:


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Thursday, February 11, 2010

SharePoint Permissions: Read Vs View Only - What's the Difference?

Wonder, What is the difference between Read and View only permission in SharePoint?

Here is the difference between Read and View Only: With view only permission, users can not View/Download the documents into the client applications, like Microsoft Excel! (But downloading the documents is possible, like Saving the document to their local system, Right click >> Save As. Also they can view the documents online, if office web apps is available.)
SharePoint Permissions: Read Vs View Only Difference

Lately, found another interesting difference: Users with View only permissions are not able to find the documents in search results! Also, if they type the URL of the document directly in the browser or click on the file name they gets access denied!!
sharepoint view only access denied
Related Post:


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Monday, February 8, 2010

Image tabs for the web sites

I wanted to have image tabs like the below picture, for my web site.





 We can get this by little Javascript and HTML it self.  Here is how i've done this.

<html>
<head>
<title></title>
<script language="javascript" type="text/javascript">

function setTabContent(Caller)
{
var s='Content-'+Caller;
document.getElementById('TabContainer').innerHTML=document.getElementById(s).innerText;
for (i=1;i<=6;i++)
{
document.getElementById("Tab"+i).className="";
}
document.getElementById(Caller).className="selected";
return false;
}

</script>
<link rel="Stylesheet" href="styles.css">
</head>
<body onload="javascript:setTabContent('tab1')">

<div id="Content-Tab1" style="display: none">
I&#39;am the content from Hiddent div 1!!! </div>
<div id="Content-Tab2" style="display: none">
I&#39;am the content from Hiddent div 2!!! </div>
<div id="Content-Tab3" style="display: none">
I&#39;am the content from Hiddent div 3!!! </div>
<div id="Content-Tab4" style="display: none">
I&#39;am the content from Hiddent div 4!!! </div>
<div id="Content-Tab5" style="display: none">
I&#39;am the content from Hiddent div 5!!! </div>
<div id="Content-Tab6" style="display: none">
I&#39;am the content from Hiddent div 6!!! </div>
<div>
<ul class="TabStrip">
<li>
<a id="Tab1" class="selected" href="javascript:void(0)" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
Overview</span></span></a>
</li>
<li>
<a id="Tab2" href="javascript:void(0);" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
Description</span></span></a>
</li>
<li>
<a id="Tab3" href="javascript:void(0);" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
Learn More</span></span></a> </li>
<li>
<a id="Tab4" href="javascript:void(0);" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
References</span></span></a>
</li>
<li>
<a id="Tab5" href="javascript:void(0)" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
Images</span></span></a>
</li>
<li>
<a id="Tab6" href="javascript:void(0);" onclick="javascript:setTabContent(this.id)">
<span class="wrap">
<span class="innerWrap" style="WIDTH: 80px">
Feedback</span></span></a>
</li>
</ul>
</div>
<div id="TabContainer">
</div>
</body>
</html>

Style.css
.TabStrip
{
 font: 11px Verdana, sans-serif;
 border-bottom: solid 1px #408000;
 margin-left: 1px;
}

.TabStrip li
{
display: inline;
}

.TabStrip li a
{
 padding-left: 10px;
 background: transparent url('img/TabLeft.png') 0px 0px no-repeat;
 line-height: 24px;
 color: #ffffff;
 text-decoration:none;
 
}


.TabStrip li a .wrap
{
 color: #ffffff;
 font-weight:bold;
 padding-right: 10px;
 line-height: 24px; 
 background:transparent url('img/tabRight.png') right 0px no-repeat;
}

.TabStrip li a:hover
{
 color: #ffffff;
 text-decoration:underline;
}

.TabStrip li a .innerWrap
{
 line-height: 24px;
 background:transparent url('img/tabMiddle.png') 0px 0px repeat-x;
 text-align: center;

}

.TabStrip li a.selected
{
 padding-left: 10px;
 background: transparent url('img/TabLeftSelected.png') 0px 0px no-repeat;
 line-height: 24px;
  text-decoration:none;
}

.TabStrip li .innerWrap
{
 cursor: default;

}


.TabStrip li a.selected .wrap
{
 background-image:url('img/tabRightSelected.png');
 line-height: 24px;
 padding-right: 10px;
 color: #000000;
 font-weight:bold;
}

.TabStrip li a.selected .innerWrap
{
 background-image:url('img/tabMiddleSelected.png');
 padding-top: 0px;
}



You can download the images here:









You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


You might also like:

Related Posts Plugin for WordPress, Blogger...