Friday, 23 January 2015

From the most known Statistical Packages

STATA: Statistics (STA) + Data (ATA). Data Analysis and Statistical Software

SAS: Statistical Analysis Software. Business Analytics and Business Intelligence Software

SPSS: Statistical Package for Social Sciences. IBM solution for Statistics

Sunday, 28 December 2014

Adding multiple group owners for SharePoint 2010 site

When you edit the Group Settings for a SharePoint group, and try to add multiple owners so that they can all edit the membership for this group; you got the message:

You are only allowed to enter one item.

The workaround for that is to define the group owner as another SharePoint group rather than multiple users.

Thursday, 25 December 2014

SharePoint 2010 Custom List: Row Level Secuity

Business Case: Sharing a comprehensive list data among different stakeholders where every stakeholder can view\read only those row as per her Role\Unit

(1) Export the existing list data into SharePoint custom list including the column: Unit.
(2) Add a new empty temporary column: trigger update.
(3) Build a row level security based on the field row for each row.

Let's elaborate on step number (3), where we are going to create a new workflow assocuated with this list and to run on every Create\Update item.

a) Create Permissions groups within SharePoint. 
Each Group will be equivalent to each Unit, same name.

b) Create the workflow:
1) Open the SharePoint site with Microsoft SharePoint Designer.
2) Navigation --> Site Objects --> Lists and Libraries --> Open that specific custom list with the data.
3) From the upper toolbar: list Workflow to create a list workflow.

4) Set Start options for the workflow: Item Created\Changed.

5) Edit Workflow.

6) Click Impersonation Step on the top toolbar to add a new Impersonation step, then remove the existing Step 1.

7) Click on the orange underline to activate the toolbar Action button.

8) Add a new action: Replace List Item Permissions.

9) Similarly, beneath it, add a new action: Add List Item Permissions.

10) Since we are interested to set the security on the item level, this workflow will do the function on the current item, replace this list in both steps with Current Item

11) To guarantee that the owners still have the permissions to access this list item, grant site owners all the permissions in the first replace step.

12) Now, to the core idea which is matching the field Unit with the equivalent group.
The result is that each row will have Read Access granted to the group members for the equivalent members of the group with the same name.

13) Save and Publish.

14) It is recommended to break the inheritance for this custom list so that the list items would be immune to any permissions changes at higher levels.

15) One time step: activate the workflow on all the items through through filling in the temporary column  created earlier: Trigger Update. A simple way to do it is through filling it within the Spreadsheet view for the list. Delete the temporary column:Trigger Update from the list.

Tip, SharePoint 2010: Easier way to change Date &Time list column types into Date Only

The normal way (Through SharePoint website)

The easy way (Through SharePoint Designer application)

Microsoft SharePoint Designer --> Open Site --> Lists and Libraries --> Select a specific list --> Edit list columns --> Filter column Type (Select Date and Time)

Double click to open column editor (right click to open Column settings, Same Dialog!!! ) --> change Display format into Date only

Thursday, 27 November 2014

Attach database failed for Server. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Unable to open the physical file . Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

Connect to the server using an administrator account with access to the file system for the database files and through Windows Authentication rather than using sa through SQL Server Authentication.

Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list

Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list

This command just surprisingly solved it:

%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i

This repeats IIS registration\installation although I had no problem while installing it as Windows Feature.