Excel Services configuration - Video Tutorial

Secure Store Service - video demo

Calculated column Formula supporting Maximum number of IF ELSE statements and workaround for syntax error

Hi SP Folks,

One of the user got requirement with colour coding to a list view based on the values selected. so created a calculated columns to achive this functionality. but user experienced error after choose to go with extra color codes (which will extend the Furmula conditions) as:

"Calculated column sysntax error OR not supported", but formula syntax looks fine. After investiagtion

the calculated column supports only 7 levels of IF ELSE conditions in the formula, after that it will through above error. so after googling found solution HERE, and can be achivable by CASE statement as HERE(but i didn't try this)

the output result:

Thanks,
JK

Troubleshoot SharePoint Designer workflow errors

Hi All,

please find the File for the Detailed description. very usuful.


Thanks,
JK

Design Your Page Layout Online with YAML.

I Found very useful tool, and i am searching for a long time for such tool. finally got it.
It's Named as YetAnotherMulticolumnLayout (YAML).

Find Tool Here

Thanks,
JK

Ultimate CSS Gradient Generator

Found in FB shared by a freind:

http://www.colorzilla.com/gradient-editor/

Note: works only Moizlla, Safari, Chrome.

Visual Studio Express Edition VS Visual Studio Professional

The major areas where Visual Studio Express lacks features compared to Visual Studio Professional:

• No add-ins/macros
• Some Win32 tools missing
• No Team Explorer support
• Limited refactoring support
• Debugging is much more limited (particularly problematic for server development is no remote debugging)
• Lack of support for setup projects
• No report creation tools
• No Office development support
• No mobile platform support
• Limited set of designers
• Limited set of database tools
• No code profiling or test framework support
• No MFC/ATL support
• No support for compiling C++ to 64-bit images (workaround is to install Windows SDK which is free)

when you consider Expression Edition for WSS 3.0 Development, then the concerns are:
No debugging of running processes (e.g. ASP.NET)

The ability to attach the debugger to an already-running process has also been removed...

In order to debug SharePoint code, you need to attach the debugger to the 'already running process' w3wp.exe (the ASP.NET worker process). With this feature removed you would need to find a workaround such as trace calls or logging. It's a lot more inconvenient.
No integration with third party tools

Microsoft "made a business decision to not allow 3rd party extensibility in Express".

This also rules out the integration of very useful and helpful add-ins such as WSPBuilder into Visual Studio. These tools make SharePoint development and deployment much easier. (Note that it is possible to run the actual WSPBuilder tool from the command line but you miss out on helpful features for debugging/deployment and templates for new SharePoint items.)
To summarise: It's probably possible but SharePoint development can at times be difficult enough. With these features removed it will be much more difficult.

Event ID 7888; Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Event ID 7888

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888

Description: A runtime exception was detected. Details follow.

Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Technical Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource()
at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

Found Resolution @ HERE

Regards,
JK

Online Image Map Editor & URL Decoder/Encoder - very useful tool

Hi Folks,

i found the very useful tool, which is going to create image maps online. its handy & very useful, simple and definetly poweful tool. A must Book mark link

SNAP:

UPDATE ON 27/03/2012:  URL Decoder/Encoder
Please check this place
 Regards,
JK

Hide part of link in global navigation breadcrumb

Hi Friends,

Here the user requirement is to hide top level site URL(link) in the global Navigation breadcrumb in the sub site home page (where user is going to share the site URL with others), and not to hide entire breadcrumb.

Actual snap:

so i proceed to check with the IE Developper tool. and the structure in side DIV for the breadcrumb is as:
<SPAN id="ct100someblablablaID".... >
       <span>
          <a class="anchorclass">ROOT SITE COLLECTION</a>
       </span>
       <span>
          TEXT (>)
       </span>
       <span>
          <a class="anchorclass">SUB SITE COLLECTION</a>
       </span>
       <span>
          TEXT (>)
       </span>
and so on.

so decided to go with JQuery SLECTORS. and the respected script as follows:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {

$('#ctl00_PlaceHolderGlobalNavigation_PlaceHolderGlobalNavigationSiteMap_GlobalNavigationSiteMap span:nth-child(4)').css({'display':'none'});
$('#ctl00_PlaceHolderGlobalNavigation_PlaceHolderGlobalNavigationSiteMap_GlobalNavigationSiteMap span:nth-child(5)').css({'display':'none'});

});
</script>

so in the script selecting sub span elements with in root element SPAN ID,
$('#ROOT_ELEMENT_ID span:nth-child(4)').css({'display':'none'});
this hides my ">" char & selection child node 5 hides my "ROOT SITE URL".

and resulted O/P :

JQuery saved my life....

Regards,
JK

"Failed to load the workflow" error popup when try to open workflow in SharePoint Designer

When you open SharePoint Designer 2007 to create a new workflow, you get this error “Failed to load the workflow”

Solution One:
- Go to C:\Documents and Settings\<your user name>\Application Data\Microsoft\SharePoint Designer\ProxyAssemblyCache\(12.x.x.xxxx)
or
C:\users\<your user name>\Application Data\Microsoft\SharePoint Designer\ProxyAssemblyCache\(12.x.x.xxxx)
and delete 12.x.x.xxxx folder.
- Open SharePoint Designer again and it should work this time.

If it is still not working for you then try

Solution Two:
- Change trust level in the .NET 2.0 Configuration (the MMC snap-in, found in Administrative Tools).
- Go to .NET Framework 2.0 Configuration > Runtime Security Policy.
- Choose “Adjust Zone Security” and change Local Intranet to “Full Trust”
It should now work at this point, if not
Go to Intranet options, pushed the slider up to full trust.
Someone might have posted about that but it’s good if this post can help few.

Powershell script to List All Sharepoint Site collections and sub sites

Hi,

i came up with an requirement to gather all the site collections and sites and sub sub sites in our 2007 & 2010 environment. so decided to prepare a poweshell script which can list all site collection and it's sub webs list under the site collection and a Final count. the script as follows:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null
$siteUrl = Read-Host "Enter Site URL"
$rootSite = New-Object Microsoft.SharePoint.SPSite($siteUrl)
$spWebApp = $rootSite.WebApplication
$count = 0
           write-host "Site Collections"
           write-host ""
    foreach ($site in $spWebApp.Sites) {
        $count++
        write-host "Site Collections URL --> -->" $site.URL
           write-host ""
           write-host "SubSites"
           write-host ""
    foreach ($web in $site.AllWebs) {
        $count++
        write-host "SubSite URL --> --> -->" $web.URL 
        write-host ""
    } 
}
write-host "Total Count :" $count

Hope this script help in your requirement too.

Regards,
JK