Calculate week number in SharePoint

Add a cal­cu­lat­ed field col­umn and use this for­mu­la:

 

=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)

 

I have seen sites that use this for­mu­la:

=INT(([datecolumn]-DATE(YEAR([datecolumn]-WEEKDAY([datecolumn]-1)+4);1;3)+WEEKDAY(DATE(YEAR([datecolumn]-WEEKDAY(datecolumn-1)+4);1;3))+5)/7)

But in my case i had to get rid of the brack­ets [] and replace the semi­colons ; with a com­ma ,

 

Why?

Beats me!

 

Give one user full control of another user’s mailbox in Office 365

To give your­self or anoth­er user full access to some­one else’s mail­box in Office 365 you have to use pow­er­shell. It can’t be done online.

Mailbox access

In this exam­ple we are going to give Pieter full access to the mail­box of Danielle use this com­mand:

Add-MailboxPermission Danielle@kops-ict.nl  -User  Pieter@kops-ict.nl -AccessRights FullAccess

Inbox access

As an alter­na­tive you can also give per­mis­sions to an inbox only

Here’s the code:

Add-MailboxFolderPermission -Identity Danielle@kops-ict.nl:\Inbox -User Pieter@kops-ict.nl -AccessRights Owner

 

For more detailed infor­ma­tion, please refer below arti­cle:

Give an Admin­is­tra­tor the Abil­i­ty to Open and View the Con­tents of a User’s Mail­box(http://help.outlook.com/en-us/140/gg709759.aspx )

Open another user’s mailbox in Office 365

In Office 365 you can open anoth­er user’s mail­box. Here’s how.

Go to the out­look web access page. In the left col­umn find your user­name and right click on it.

Instruction
Right click on your user­name

 

 

 

 

 

 

 

 

 

 

 

 

Then select “Oth­er user’s inbox”

Select other user's inbox
Select oth­er user’s inbox

 

 

 

 

 

 

 

 

 

 

 

In the dia­log box that appears, enter the name of the desired mail­box or use the address­book icon to do a full search.

Enter the name of the desired mailbox
Enter the name of the desired mail­box

 

 

 

 

 

And click OK. Now you will see the oth­er user’s mail­box appear in the left col­umn.

There's your other user's mailbox
There’s your oth­er user’s mail­box

 

 

 

 

 

 

 

 

 

 

 

 

 

When you receive an error stat­ing that you have no per­mis­sion to open the inbox when you are sure it exists, you may need to get the right per­mis­sions from your admin­is­tra­tor.

Not found or no permission
Not found or no per­mis­sion

 

 

 

 

 

I also have an arti­cle that explains how to set the right per­mis­sions.

Read it here.

Data adapter failed during onload using a dataconnection file from InfoPath Form

The problem: When accessing a SQL table or view from a browser enabled InfoPath Form gives you an error Data adapter failed during OnLoad

Even­tID: 5566

This hap­pens when using a dat­a­con­nec­tion to a SQL serv­er using a .udx file.

To solve this you need to have Enable embed­ded SQL authen­ti­ca­tion checked. Also if your SQL runs on anoth­er serv­er you need cross domain acces. So make sure that Allow Cross-domain data access for User Form Tem­plates is checked.


Change these set­tings in Cen­tral Administration/Configure InfoPath Forms Ser­vices

  • http://<servername:port>/_admin/ipfsConfig.aspx

Click for a lager view

HTML page as a landing page before entering SharePoint

Do you for some rea­son you would like to have a land­ing­page to be dis­played before a vis­i­tor enters the Share­Point site? This post gives an option to do just that.

What we need to do is to set a new fold­er where vis­i­tors “land”. There you will have cre­at­ed an index.html that suits you.

First make sure your new index.html is ready and works fine. On that page you can add a link back to the Share­Point site. (I used /Pages/Default.aspx)
You can test your new page by enter­ing /LandingPage/Index.html after the url of your Share­Point site. (http://www.contoso.com/LandingPage/Index.html)

To set the new fold­er we’re going to edit the web.config of the Share­Point site. You can find this file in the <systemdrive>\inetpub\wwwroot\wss\VirtualDirectories\<sitename>
But remem­ber to make back­up copies before mak­ing any changes.

Right under <system.web> enter these three lines:
<urlMap­pings enabled=“true”>
<add url=”~/” mappedUrl=”/LandinPage/Index.html”/>
</urlMappings>

Replace LandingPage/Index.html with the fold­er and name of your html page.

Save the web.config and restart the iis. (iis­re­set from the com­mand prompt)

Hidden property cannot be set on web part

I was con­struct­ing a web­page with an InfoPath form and a Query­Fil­ter web­part on it. After sav­ing it i coud­n’t open the new page from a brows­er. It threw a cor­re­la­tion error at me.

Using the ULSview­er i traced down to this errormes­sage: hid­den prop­er­ty can­not be set on web part [web part name] since it is a stand­alone web part.

 

The rea­son i got this error was that i placed the Query­Fil­ter web­part out­side of a web­part­zone on the page. Mov­ing it into a web­part­zone (i first had to cre­ate one) solved my prob­lem.

Access denied error when trying to create a crawl schedule in SharePoint 2010

When you receive an access denied while cre­at­ing a new crawl sched­ule this just might be the solu­tion.

On the search serv­er the local user WSS_WPG needs read & write priv­i­leges on the Tasks fold­er. This fold­er resides in the win­dows sys­tem fold­er. I my case a reset of IIS was unnec­es­sary.