ĐÀO TẠO DOANH NGHIỆP : SỞ KHOA HỌC CÔNG NGHỆ TỈNH ĐỒNG NAI

ENTERPRISE TRAINING: DONG NAI DEPARTMENT OF SCIENCE AND TECHNOLOGY.

HÌNH ẢNH TẬP HUẤN LỚP SHAREPOINT WORKFLOW VÀ KIẾN TRÚC SHAREPOINT

PHOTOS OF SHAREPOINT WORKFLOW AND ARCHITECTURE CLASS.

HÌNH ẢNH TẬP HUẤN LỚP SHAREPOINT WORKFLOW VÀ KIẾN TRÚC SHAREPOINT

PHOTOS OF SHAREPOINT WORKFLOW AND ARCHITECTURE CLASS.

Thursday, May 2, 2013

Sharepoint 2010 User Permissions


1.1.1     Create permission level

1.     Go to site collection >> Site Actions >> Site Permissions

2.     Click to Permission Levels

3.     Click to Add a Permission Level

4.     Name: Add Items. Grant permission is Add Items (consider set permission to List or Library again)

5.     Continue create more permission levels “Edit Items” by code

6.     Code to create permission level

7.     Result as:

1.1.2     Create Group

1.     Back to home page >> Site Actions >> Site Settings

2.     Click to People and groups

3.     Click More, then click new >> New Group

4.     Input group name: Honda – Add items, Choose the permission level group members get on this site is Add items

5.     Continue create new group: Honda – Edit items, Choose the permission level group members get on this site is Edit items by code

6.     Code to create new group and assignment of the roles to the group.

7.     Continue create new group: Honda – Payment Online, Choose the permission level group members get on this site is View Only

8.     These group was created

1.1.3     Add Users to group

1.     Click to Honda – Add Items group then click New >> Add Users

2.     Continue add user to group Honda – Edit Items by code

3.     Continue add user to Honda – Payment Online group by code

4.     Code to add user to group

5.     User was added to group

1.1.4     Permission on List or Library

1.     As default sharepoint account existing in three groups (View, Add, and Edit) and it is inherited permissions, so it has View, Add, and Edit permission. Now I want sharepoint account has view and edit item on Provinces list. Click to Provinces >> on ribbon click to List >> List Permission

2.     Click to Stop Inheriting Permissions

3.     Choose Honda – Add Items group >> click Remove User Permissions

4.     Continue i want sharepoint account has view and Add item on Employees list. Click to Employees >> on ribbon click to List >> List Permission

5.     Click to Stop Inheriting Permissions

6.     Choose Honda – Edit Items group >> click Remove User Permissions

7.     Login with sharepoint Account, on Provinces list sharepoint only have View and Edit permissions

8.     Try access to NewForm.aspx

9.     You can not add new item with access denied

10.  On Employees list sharepoint only have View and Add permissions

11.  Try access to EditForm.aspx

12.  You can not Edit item with access denied

1.1.5     Permission on List – Library and features programmatically

1.     Go to Site Actions >> Site Settings >> People and Groups >> click to Honda – Payment Online group then remove user in this group

2.     On web part we will see permission of sharepoint account

3.     Code here

4.     Login by sharepoint account, it don’t have permission Add Provinces, so Add Provinces button isn’t Enable

5.     Code here

6.     You try Add new Provinces by another button

7.     You can not add new item with access denied

8.     Code here

9.     Login by sharepoint account, it don’t have permission Edit Employees, so Edit Employees button isn’t Enable

10.  Code here

11.  You try Edit Employees by another button

12.  You can not add new item with access denied

13.  Code here
Download code at here

Wednesday, April 17, 2013

Sharepoint 2010 List filtering by date range

1.    Add new item for Task list
2.    Go to Site Actions >> Edit Page
3.    Add web part Date Filter
4.    Edit Web part
5.    In the options pane that appears, change the Filter name to 'Start Date', and change the default value to 'offset from today 7 days: Before today'. Then click ok.
6.    Underneath that, add another date filter and change its filter name to 'End date', and change the default value to 'offset from today: 0 days: After today'. Then click ok.
7.    Now save the page in your browser, then open the page up in SharePoint designer (SPD) - in design view.
8.    Edit page in Advanced Mode

9. Once opened in SPD, click on the list web part to select it, then in the ribbon click on the list view tools > options > parameters icon.


10.  Add two new parameters, one called 'startdate'. Leave the parameter sources and default values as default.
11.  Add two new parameters,  called 'Enddate’. Leave the parameter sources and default values as default.
12.  Click OK
13.  Click on the start date filter and click add connection
14.  In the dialog that pops up change the dropdown value to 'Send filter values to', click next.
15.  Ensure that 'connect to a web part on this page' is selected in the next dialog and click next.
16.  Change the target action in the next dialog to 'Get parameters from' and click next.
17.  In the next dialog, select 'Start Date' from the first box, and 'Startdate' from the second box and click next. Then click finish.
18.  Click Finish
19.  Click on the End date filter and click add connection
20.  In the dialog that pops up change the dropdown value to 'Send filter values to', click next.
21.  Ensure that 'connect to a web part on this page' is selected in the next dialog and click next.
22.  Change the target action in the next dialog to 'Get parameters from' and click next.
23.  In the next dialog, select 'End Date' from the first box, and 'Enddate' from the second box and click next. Then click finish.
24.  Click Finish
25.  Now we have our date filters feeding the list with its values but we still have to set up the filter on the list. Click the list web part to select it, then in the ribbon click on the list view tools > options > filters icon.
26.  The filter criteria box wills popup. First add a rule 'Start Date > Greater than or equal to > [Startdate]'.
27.  Click to “Click here to …”
28.  Then add another clause 'Start Date > Less than or equal to > [Enddate]'. Click ok.
29.  Now save the page and open it back up in your browser. It will, by default, show all tasks Start Date in the last seven days thanks to the default setting of the start date filter. Changing these filters will filter the list according to the date ranges set.
30. You can write your caml query in sharepoint designer