SharePoint – Abdel-Rahman.IT

SharePoint 2010 video streaming

Abdel-Rahman Awad

Jun 9 |09:45

Everything you want to know about what the default player web part can and can not

http://blogs.msdn.com/b/sanjaynarang/archive/2010/05/26/media-web-part-in-sharepoint-2010-faq.aspx

2. What file formats are supported or can be played in Media Web Part?

Media Web Part is a Silverlight control. So, all the formats supported by Silverlight can be played using MWP. Look at this article for details on that: Supported Media Formats, Protocols, and Log Fields.

There must be consideration about the size of files you wish to support the web application (default 50MB) level and whether to bring BLOB Storage in use if you want to support large files.

Just turn up at web application level should be done with caution – since (at least in MOSS) to max file size effectively means that for every upload steals the RAM corresponding max size while uploading runs. That means if you turn up to the max file size of 1 GB and two users upload at the same time so grab SharePoint 2x1GB RAM on the server (if they sit at the same WFE) while uploading runs – this could potentially send the farm to its knees.

SPAlert And SPView

Abdel-Rahman Awad

Jun 9 |08:21

I am developing a news module for SharePoint 2010 and we wanted to create a list alert based on a list view, for each channel / folder … but we needed to do that programmatically

I surfed the internet looking for a solution or a code explaining how to do that but without any luck

so i decided to investigate the properties of the out of the box alert object and see what special values does it

have that makes it connected with the list view

But still that didn’t had any indications where is the alert object is associated with the list view

i only had one last place to look at and that was the SPALert properties bag … and yes there the connection to the list view happens

I made that custom code for creating an SPALert with the caml filters of the default list view

public static bool CreateAlert(string folderName)
{
 return DoNewsAction<bool>((web) =>
{
web.AllowUnsafeUpdates = true; 
SPList list = web.Lists[ValueHelper.NewsListName];
 SPFolder folder = list.RootFolder.SubFolders[folderName];
 if (folder == null|| string.IsNullOrEmpty(folder.ServerRelativeUrl)) return false;
 SPAlert alert = web.Alerts.Add();
 alert.AlertFrequency = SPAlertFrequency.Daily;
 alert.AlertType = SPAlertType.List;
 alert.AlwaysNotify = false;
 alert.DeliveryChannels = SPAlertDeliveryChannels.Email;
 alert.EventType = SPEventType.Modify;
 alert.List = list;
 string filter = string.Format(@"<Or><Eq><FieldRef Name='ItemFullUrl'/><Value type='string'>{0}</Value></Eq><BeginsWith><FieldRef Name='ItemFullUrl'/><Value type='string'>{0}/</Value></BeginsWith></Or>", folder.ServerRelativeUrl.TrimStart('/'));
 string viewQuery = list.DefaultView.Query;
 if (viewQuery.Contains("<Where>") && viewQuery.Contains("</Where>"))
 {
 viewQuery = viewQuery.Substring(viewQuery.IndexOf("<Where>") + "<Where>".Length, viewQuery.LastIndexOf("</Where>") - (viewQuery.IndexOf("<Where>") + "<Where>".Length));
 alert.Filter = string.Format(@"<And>{0}{1}<And>", filter, viewQuery);
 }
 else
 {
 alert.Filter = filter;
 }
 //use a view filtering option
 alert.Properties.Add("filterindex", "4");
 //the list view to associate with the alert item
 alert.Properties.Add("viewid", list.DefaultView.ID.ToString("D"));
 //the path of the folder to be alerted on
 alert.Properties.Add("filterpath", string.Format("{0}/", folder.ServerRelativeUrl.TrimStart('/')));
 //alert me only if item was modified in that view
 alert.Properties.Add("eventtypeindex", "2");
 //send sms alert
 alert.Properties.Add("sendurlinsms", "False");
 //the mobile view url
 alert.Properties.Add("mobileurl", string.Format("{0}/_layouts/mobile/ ", web.Url));
 //the site collection url
 alert.Properties.Add("siteurl", web.Site.Url);
 //the default item display form
 alert.Properties.Add("dispformurl", list.DefaultDisplayFormUrl);
 alert.Title = string.Format("{0} : News", folderName);
 alert.User = web.CurrentUser;
 alert.Update(true);
 return true;
 });
 }

That took some time to understand

Settings Category Rss

Abdel-Rahman Awad

Oct 29 |08:07

In SharePoint each list item can be configured to have rss feeds, and actually feeds can be filtered , sorted and grouped the same way like when creating list view , Actually the rss feeds outside the box is for each list view and the default list feeds are the feeds of the list default view

In our case we need to create Rss feeds for a publishing wiki pages list and be able to get have rss for each topic category in the wiki categories … so solution will be creating list view for each category and using the rss feeds for those views

Configure the List Rss Setttings

Navigate to your wiki Pages list choose list settings

Choose Rss Settings

For the Rss Settings make it look something like that
For configuring the actual content of each record in the feed it is up to you to choose what you want to show

For me i choosed the wiki content and tags
Create List View for each wiki category

Now go back to the list settings and choose to create a new view in the views section

Write the View name to be the category name for example “Abbreviations”

select values you want to display in the view( will not affect the data in the rss feeds … data in the rss feeds are

always retrieved according to the list rss settings … so data will be displayed according to the previous step )

In the filters section make it look something like this … choose the field you want which is in our case “Category”

Is equal to “Category Value” for example “Abbreviations”

Repeat step 3 for each category value in the category options
Use the list view Rss Feeds Url

To get the Rss feed for each view navigate to the list settings

Choose the view you want and click the Rss button to go for the Rss Url

Good to know

WriteRssFeed supports 3 overload methods:

SPList.WriteRssFeed(Stream) :

Writes the RSS feeds from the list to the specified document stream.

SPList.WriteRssFeed (Stream, Int32) :

Writes the RSS feeds from the list that are associated with the specified meeting to the specified document stream.

SPList.WriteRssFeed (Stream, Int32, SPView) :

Writes the RSS feeds from the list that are associated with the specified meeting and view to the specified document stream.

< Pasted from this topic >

SPRSS : Enhanced Rss Functionality for wss : http://sprss.codeplex.com

Codeplex Project that enhance the out of the box list rss feeds

Making better and clean rss feeds read more
Step by step for using the SPRSS read more
Some cool scenarios embedding external world inside SharePoint using SPRSS read more

Changing SPAlert EventType

Abdel-Rahman Awad

Oct 18 |14:05

So i was trying to edit all the web alerts to be triggered only when and item is modified instead of being sent if any changes happen to a list like add edit, delete etc..

But guess what … the normal SharePoint API doesn’t work for that … it changes it in the object model and you can see it in the SharePoint manager that it is changed

Still the user gets the alerts whenever any new item is added to the list, which drove me crazy some long couple of search hours, I found that blog post

And here is the explanation and right way of doing it

The EventType property, this didn’t work out the way I wanted it too. I was having a problem with setting the EventType on an SPAlert to SPEventType.Add.

My code wouldn’t throw an error but neither would it set the EventType to SPEventType.Add, instead it would stay at SPEventType.All.

I fixed this by using the following codes to set the "eventtypeindex" property of the SPAlert:

all = 0

added = 1

modify = 2

deleted = 3

web discussions = 4

web.AllowUnsafeUpdates = true;
StreamWriter file = new System.IO.StreamWriter(AlertReportPath, true);
foreach (SPAlert alert in web.Alerts)
    {
        try
        {
            if (alert.Status == SPAlertStatus.On)
            {
                //alert.EventTypeBitmask = 2;
                //alert.EventType = SPEventType.Modify;
                alert.Properties["eventtypeindex"] = "2";
                alert.Update(false);
            }
        }
        catch(Exception ex)
        {
            Logger.logEntry("ProActive.SharePoint.CmdTool.Tasks", "EditAlerts", "failed to edit web alert", ex, EventLogEntryType.Error);
            Console.WriteLine("editing web alerts failed : " + web.Url + ex.Message + "\n");
        }
    }
file.Close();
web.Update();
web.AllowUnsafeUpdates = false;

It is a known issue so keep this in mind next time you are editing a list alert item.

Cross Forest People Picker

Abdel-Rahman Awad

Aug 28 |17:23

To use peoplepicker-searchadforests with credentials, which you need to specify if you don’t have two-way trusts in place, you must first set an encryption key:

STSADM.exe -o setapppassword –password <encryptionpassword>

Then you need to specify an account for traversing the other domain and the web application that should be able to add users from that domain. You need to set the property for each web application you want to be able to traverse the other domain:

STSADM.exe -o setproperty -pn peoplepicker-searchadforests -pv domain:<domain which will be traversed>,<account with rights for traversing the domain>,<account password> -url <url for the webapp where you want to add users from the other domain – example: http://mywebapp>

Example

STSADM.exe -o setproperty -pn peoplepicker-searchadforests -pv domain:ProActive,ProActive\Abdel-Rahman.Awad,******* -url http://mywebapp

SP 2010 Installation Part(19) – Excel Services Configuration

Abdel-Rahman Awad

Mar 23 |14:59

This Post is part of SharePoint 2010 Installation Series

To increase Excel Services limits:

Navigate to SharePoint Central Administration > Application Management > Manage Service Applications.
Select your Excel Service Application.
On the Ribbon, click Manage.
Click Trusted File Locations and on the following page, select your trusted location. (Typically, this is listed as http:// in the Address column.)
In the Workbook Properties area, set the Maximum Workbook Size property to 2000 and the Maximum Chart or Image Size to 100 MB

A Good sample of SharePoint Services is

http://fo-developer-07/Pages/excelservicessample.aspx

Or your services web application url /Pages/excelservicessample.aspx

For more information about using excel services and good examples see this video here

And here

SP 2010 Installation Part(18) – Power Pivot Configuration

Abdel-Rahman Awad

Mar 23 |14:55

This Post is part of SharePoint 2010 Installation Series

Content copied from here

To make full use of the server components you just installed, download the authoring tools to create and then publish your first Power Pivot-enabled workbook.

Open a port

If you are deploying a new server, you might need to open a port so that remote users can access your site.

On the computer that hosts the Power Pivot server, click Control Panel, and then double-click Windows Firewall.
Click Change Settings.
Click Exceptions.
Click Add port.
In Name, enter a descriptive name, such as Port 80.
In Port number, enter 80.
For Protocol, use the default selection TCP.
Click OK.

Grant Permissions

Users will need SharePoint permissions before they can publish or view workbooks. Be sure to grant Read permissions to users who need to need to view published workbooks and Contribute permissions to users who publish or manage workbooks. You must be a site collection administrator to grant permissions.

In the site, click Site Actions.
Click Site Permissions.
Select the checkbox for the site collection Members group.
On the ribbon, click Grant Permissions.
Enter the Windows domain user or group accounts who should have permission to add or remove documents.
Do not use e-mail addresses or distribution groups unless the application is configured for Claims authentication.
Click OK.
Select the checkbox for the site collection Visitors group.
On the ribbon, click Grant Permissions.
Enter the Windows domain user or group accounts who should have permission to view documents. As before, do not use e-mail addresses or distribution group if the application is configured for classic authentication.
Click OK.

Install Power Pivot for Excel Add-in and Build a Power Pivot Workbook

After you have the server components installed in a farm, you can create your first Excel 2010 workbook that uses embedded Power Pivot data, and then publish it to a SharePoint library in a Web application.

Before you can build Excel workbooks that include Power Pivot data, you must start with an installation of Excel 2010, followed by the Power Pivot for Excel add-in that extends Excel to support Power Pivot data modeling.

For instructions on how to install Power Pivot for Excel and create Power Pivot data sources, see How to: Install the Power Pivot for Excel Add-in and Creating Power Pivot Workbooks in Excel.

Add Servers or Applications

Over time, if you determine that additional data storage and processing capability is needed, you can add a second Power Pivot for SharePoint server instance to the farm. For instructions, see How to: Scale a Power Pivot for SharePoint Deployment.

Pasted from <http://msdn.microsoft.com/en-us/library/ee210708(SQL.105).aspx>

After you install the Excel 2010 and Power Pivot for Excel 2010, use Power Pivot to create a workbook (say Test.xlsx).

b. Publish the workbook to the Shared Documents folder on the default Web site (http://machinename ).

c. Open SQL Server Management Studio, click Connect > Analysis Services and type http://<machinename>/Shared%20Documents/Test.xlsx into the Server Name field.

d. Click Connect.

A connection should appear in the Object Explorer and you should be able to browse the cube in your Excel workbook. This confirms that you have Power Pivot set up correctly.

Now that you have successfully installed and configured Power Pivot, you might want to configure Reporting Services on your SharePoint farm to enable additional functionality. Use the Reporting Services Installation and Configuration document to install and configure Reporting Services in SharePoint Integrated mode. You can then use Report Builder to create reports using Power Pivot workbooks that you have been published to a Power Pivot Gallery as data sources.

SP 2010 Installation Part(17) – Performance Point Configuration

Abdel-Rahman Awad

Mar 23 |14:54

This Post is part of SharePoint 2010 Installation Series

Navigate to central administration home page

navigate to central administration home page

Select application management and then create new site collection

Navigate to the new site collection site main page

And then select the tab create dashboards

Start using performance Point services

You will be redirected to /Pages/ppssample.aspx

Select run dash board designer

The dashboard designer will be installed

On your machine and then you will be ready to go and design

Your dashboards

SP 2010 Installation Part(16) – My Site Configuration

Abdel-Rahman Awad

Mar 23 |14:53

This Post is part of SharePoint 2010 Installation Series

After restarting your computer log in as the farm administrator

In my case Fo-dev-07-SP-Farm

There are some IE8 bugs in the current UI…so push F12
Click "Browser Mode: IE8 Compact View" and select "Internet Explorer 7".
Open the central administration site / System Settings

/ Manage services in this farm
Make sure the User Profile Service and User Profile Synchronization service

Are started

My case User Profile Synchronization service is not started , click start

After starting the service you should wait a couple of minutes tell the timer jobs ends its work you can check that in the timer job status in the central administration

Also make sure the the two services forefront Identity are up and running

Do and iisreset
After that navigate back to the central administration / Application Management/

Manage Service Applications
Select User Profile Service Application
Select Configure Synchronization Connections
Select Create New
Select "Walk me through the settings using this wizard" and Next
Make the form look like this and then click ok

Now you have a new sync connection

Go back to "User Profile Service Application" page from "Manage Service Applications"
And then select Start Profile Synchronization
Select "Start Full Synchronization" then click "OK".

This will take a few minutes as a job is scheduled to do this
For more information on the User Profile imports go to:

C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\ and run MSIISClient.exe
Now you can navigate to My site and see your activities but also note that the organization chart maps the organization properties of the user in the active directory

for more information about that Read this topic

SP 2010 Installation Part(15) – Server Optimization

Abdel-Rahman Awad

Mar 23 |14:52

This Post is part of SharePoint 2010 Installation Series

Fix the Host Name Problem

Method 1: Disable the loopback check

Follow these steps:1. Click Start, click Run, type regedit, and then click OK.

2. In Registry Editor, locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

3. Right-click Lsa, point to New, and then click DWORD Value.

4. Type DisableLoopbackCheck, and then press ENTER.

5. Right-click DisableLoopbackCheck, and then click Modify.

6. In the Value data box, type 1, and then click OK.

7. Quit Registry Editor, and then restart your computer.

Method 2: Specify host names

To specify the host names that are mapped to the loopback address and can connect to Web sites on your computer, follow these steps:1. Click Start, click Run, type regedit, and then click OK.

2. In Registry Editor, locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0

3. Right-click MSV1_0, point to New, and then click Multi-String Value.

4. Type BackConnectionHostNames, and then press ENTER.

5. Right-click BackConnectionHostNames, and then click Modify.

6. In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.

7. Quit Registry Editor, and then restart the IISAdmin service.

Open Environment Variables

Right-clicking My Computer and going to Properties then Advanced System Properties or by going to the System Control Panel and click Advanced System Properties.

From the Advanced System Properties Window go to Environmental Variables. From Environment Variables in System Variables go to Path and click Edit…

From the Exit System Variable Window, scroll to the end of Variable value:

Enter the exact text below, ensure that there are no spaces at the beginning or end of the statement.

;C:\Progra~1\Common~1\Micros~1\webser~1\14\bin

Click OK a few time to return to the desktop and reopen your Command Prompt, you should be able to use Stsadm and Psconfig without having to first navigate to SharePoint Root (formerly the 12 Hive) any longer.

Category: SharePoint

SharePoint 2010 video streaming

SPAlert And SPView

Settings Category Rss

Changing SPAlert EventType

Cross Forest People Picker

SP 2010 Installation Part(19) – Excel Services Configuration

This Post is part of SharePoint 2010 Installation Series

SP 2010 Installation Part(18) – Power Pivot Configuration

This Post is part of SharePoint 2010 Installation Series

SP 2010 Installation Part(17) – Performance Point Configuration

This Post is part of SharePoint 2010 Installation Series

SP 2010 Installation Part(16) – My Site Configuration

This Post is part of SharePoint 2010 Installation Series

SP 2010 Installation Part(15) – Server Optimization

This Post is part of SharePoint 2010 Installation Series

Archives

Categories

Category: SharePoint

This Post is part of SharePoint 2010 Installation Series

This Post is part of SharePoint 2010 Installation Series

This Post is part of SharePoint 2010 Installation Series

This Post is part of SharePoint 2010 Installation Series

This Post is part of SharePoint 2010 Installation Series

Tags

Archives

Categories