SharePoint

1. Read the question carefully
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
4. If the question is inappropriate then click the 'vote to remove message' button

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
   
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
   
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
   
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
   
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
   
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
   
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
   
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
   
   
9. Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
   
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
    
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
    
    
12. No advertising or soliciting.
    
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

<SharePoint:DateTimeControl ID="dtcProjectStartDate" runat="server" DateOnly="true" />
             <SharePoint:InputFormCompareValidator ID="cmpPorjectStartDate" runat="server" ForeColor="Red" ErrorMessage="Please Enter Date"
                  ControlToValidate="dtcProjectStartDate$dtcProjectStartDate" Type="Date" Operator="DataTypeCheck" BreakBefore="true"
                  Display="Dynamic"></SharePoint:InputFormCompareValidator>

using (SPSite site = new SPSite("http://appes-pc/my/personal/dotnet")) // Site Collection
{ 
    using (SPWeb web = site.OpenWeb()) // Site
    {
        SPList list = web.Lists["My Contacts"]; // List
        int i = 1;
        foreach (SPListItem item in list.Items)
        {
            Console.WriteLine("Item: " + (i++).ToString());
            Console.WriteLine(item.Name);
            Console.WriteLine(item.Title);
            Console.WriteLine(item.GetFormattedValue("First Name"));
            Console.WriteLine(item.GetFormattedValue("Last Name"));
            Console.WriteLine(string.Empty);
        }
    }
}
Console.ReadKey(false);

We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube. Our Authentication method to login users is FBA (Forms Based Authentication)
 
Our Goal is to show only subset of data from SSAS cube for each user based on their role which has already been defined in SSAS side.
 
FBA authenticates users against AD and all authorized user are already member of respective role in SSAS based on their clearance level. We need Excel Services passes EffectiveUserName to SSAS and for that we enabled the EffectiveUserName in global settings of Excel Services on SharePoint central admin.
 
Than in Excel, we have enabled the Windows Authentication in the Excel Service Authentication Settings of Connection Properties as we read on some blog posts. But after accessing it via the SharePoint, the following error occurred.
 
“The data connection uses Windows Authentication and user credentials could not be delegated.” As I already stated, I don't want to delegate user credentials to SSAS. It's already been configure for Excel Services to use single account to connect to Analysis Services. I only want to pass EffectiveUserName.
 
Using windows authentication is not an option because users access the site from extranet and internet

function Add-WebPartToPage {
 
    [CmdletBinding()]
 
    Param(
 
       [Parameter(Mandatory=$true, Position=0, ValueFromPipeline=$true)]
 
       [System.Object]$web,
 
       [Parameter(Mandatory=$true, Position=1)]
 
       [string]$pageTitle,
 
       [Parameter(Mandatory=$true, Position=2)]
 
       [Microsoft.SharePoint.SPList]$list,       
 
       [Parameter(Mandatory=$false, Position=3)]
 
       [System.Object]$webpart,
 
       [Parameter(Mandatory=$false, Position=4)]
	   
	   [string]$webPartTitle,
 
       [Parameter(Mandatory=$false, Position=5)]
	   
	   [string]$panelTitle,
 
       [Parameter(Mandatory=$false, Position=6)]
	   
	   [int]$CSPUElevel,
 
       [Parameter(Mandatory=$false, Position=7)]
	   
	   [int]$panelType
 
    )
 
   Process
 
   {
 
        #if webpart specified then add it to the page
        if($webpart)
        {
            $pageName = $list.Title + "/$pageTitle.aspx"
			$pageName = $pageName -replace " ",""
            $page = $web.GetFile($pageName)
            $page.CheckOut()
            $mgr = $web.GetLimitedWebPartManager($pageName, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
              
			if($webPartTitle)
			{
				$webpart.Title = $webPartTitle
			}
            $webpart.ChromeType = "None"
			#++ Extended Settings
            if($webpart.GetType().Name -eq "DynamicWebPart")
            {
            # 
                $pinProperties = $webpart.GetType().GetProperties()
                foreach ($prop in $pinProperties)
                {
				    if(($panelTitle) -and ($prop.Name -eq "PanelTitle"))
				    {   
                        $webpart.PanelTitle = $panelTitle
				    }
				    if(($CSPUElevel) -and ($prop.Name -eq "CSPUElevel"))
				    {
                        $webpart.CSPUElevel = $CSPUElevel
				    }
				    if(($panelType) -and ($prop.Name -eq "PanelType"))
				    {
					    $webpart.PanelType = $panelType
				    }
                }
            }
			#-- End of Extended Settings
            $mgr.AddWebPart($webpart, "FullPage", 0)
            Write-Host -f Green "Webpart $webpart.WebBrowsableObject added to the page"
            
            $page.CheckIn("Checked in Automatically")
            #$page.Publish("Published Automatically")
        }
   }
 
}