Make your SharePoint farm aware of pending patches to apply

Good day, I will leave this little but wonderful trick here in my blog. Whenever you experience the following message while applying patches in SharePoint by running the following command: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures And then error happens telling you: The applicationcontent command is invalid or a failure has been ncountered. The server farm will not work with missing installs. Add “-cmd installcheck -noinstallcheck” to the command-line to ignore this warning. Please make sure to run the following PowerShell command on each server in the farm, before running the PSConfig command again: Get-SPProduct … Continue reading Make your SharePoint farm aware of pending patches to apply

Best Practices for Nintex Forms Development

Good day people, its long time without posting here. Starting today I promise to myself start doing it more often. Looking at my backups found some conference notes that I took while attending Nintex conference few years ago. Wanted to share these notes related to Nintex Forms Best Practices Ensure you know what the customer wants to do without a form or a workflow design, just identify what they need from the business perspective, don’t jump into Nintex right away, try to understand the business outcome first Form Design Don’t go crazy with form design, first make sure you capture … Continue reading Best Practices for Nintex Forms Development

Our perception got impacted

Good day, today I just want to leave evidence about an error that customer faced yesterday on production servers and that initially the affected users got the impressions that SharePoint was failing epically. Picture your self-coming to work at 8am and as soon you log in into your computer and access your internet explorer the home page displays a message stating “Connection Refused”. And then you hit refresh over and over and always display this message. Then you try another SharePoint application and got an “Unknown Host” error: Tickets started coming like crazy and after reviewing SharePoint LOGS, IIS Application … Continue reading Our perception got impacted

Get the members of specific Office 365 role

Good day, this time I was asked to retrieve who the Company Administrators and SharePoint Service Administrators are from customer tenant.  The following is the steps I’ve used to deliver the requested Info: I downloaded the Microsoft Online Service Sign-In Assistant from the following URL https://go.microsoft.com/fwlink/p/?LinkId=286152, proceeded to install Install the Azure Active Directory for Windows PowerShell Module, as an Administrator loaded the PowerShell console and executed the Install-Module MSOnline command, specified yes, “Y” two times, first for NuGet and then for Untrusted Repository Inside the PowerShell session, executed the following PowerShell commands: Import-Module MSOnline Connect-MsolService this command loaded an authentication window, … Continue reading Get the members of specific Office 365 role

Old school SharePoint tip

Good day colleagues, while supporting SharePoint 2010 custom application, suddenly new requirement out of the blue came up.  They said, stakeholder says that it will be great if this form can be accessed in a kiosk inside the plant, can you make it happen? Oh, and please remove the navigation stuff like the left and top links so kiosk will display only the form, no navigation or any other thing that may confuse people. As a developer, you will think, not a problem I can use some CSS to hide some classes. But there is another simple way to get … Continue reading Old school SharePoint tip

Unsupported expression in good old InfoPath

Even though Is been announced that InfoPath is deprecated, but supported until April 2023 you can read more here  the reality is that there is a significant amount of customers that still rely on the InfoPath form based solutions for dealing with data entry challenges in the organization on a daily basis. As a consultant, I currently support multiple clients on InfoPath Form related issues. Today I want to talk about a recent discovery and of course share the solution. This is a custom list with an InfoPath list form used for storing OA’s (Operational Activities) assignment information, of course, … Continue reading Unsupported expression in good old InfoPath

Make you SharePoint Admin chuckle for a minute

If you have Full Control permissions over a List or Document Library, navigate to the Library Settings and from the Columns section click the Created By column, this will take you to the Change Column form. Locate the section Additional Columns Settings, usually a Person or Group field has the Name (with presence) as the default show field value, well change to something else like Department and get your SharePoint Admin entertained for hours trying to figure it out.

Video

Prevent Document Download in SharePoint Online

Good day colleagues, wanted to share with you all how to configure a document library that doesn’t allow users to download his content. In our scenario here is to expose a document library to a group of people inside the company, but the requirement was that these people shouldn’t be able to download the content, this is just a document library for content consumption, no collaboration at all and of course read only for visitors.

It is simple to achieve the desired outcome because there is a permission already in the system that allows us exactly what we need, but it has some limitations that you should know first before you commit to deliver what business ask us to do.

As general understanding please read the following descriptions about the permissions already available in SharePoint, please read to the end because you will see what permissions makes sense for us to use.

  • Full Control – Has full control.
  • Design – Can view, add, update, delete, approve, and customize.
  • Edit – Can add, edit and delete lists; can view, add, update and delete list items and documents.
  • Contribute – Can view, add, update, and delete list items and documents.
  • Read – Can view pages and list items and download documents.
  • View Only – Can view pages, list items, and documents. Document types with server-side file handlers can be viewed in the browser but not downloaded.

Yes, the View Only permission gives us the required behavior. In other words, this permission allows us to visualize documents inside a browser (of course with the help of Office Web Apps or Office Online Server) and documents cannot be downloaded. The question here is: What are the documents we can visualize in the browser using Office Online Server? The answer is Only Office Documents and what Office Documents are we talking about? Word, PowerPoint, Excel.

This means that:

PDF or any other file type that is not an office document can be downloaded ☹

Let’s explore how to configure this:

  1. Create a security group that has the View Only permission
  2. Create and configure a document library
  3. Test with another user that the download is not possible

Let’s see it in action here in this video, since now, thanks for reading, thanks for watching, thanks for sharing.

Just make sure your Read List and Read Item operation in your ECT have the same fields

Had some fun during the weekend. Customer asked me to add 3 new fields to an existing External Contents Type hosted on a SharePoint 2010 farm. Simple right? SQL Server Modify the pre-production database and alter the table to create 3 new varchar fields Add some dummy content to some records in pre-production farm SharePoint Designer Open the pre-production site collection and locate the External Content Type Open the external content type look at the operations and update the fields including the new ones After saving the changes I proceeded to test, and got an error, the view was not … Continue reading Just make sure your Read List and Read Item operation in your ECT have the same fields

Invoking User Profile Service when Selecting from People Picker in InfoPath

While supporting a customer on InfoPath development, he ask me how to retrieve data from a specific user using the Profile Web Service, but he want to invoke the service after selecting a user from a people picker control, problem was that the Action section in the people picker control was disable so he was asking why and how can we accomplish what he wants. I remember that I was able to implement same exact scenario a while back ago but didn’t remember how, so I did some basic research and this is what you need to do: Step 1 … Continue reading Invoking User Profile Service when Selecting from People Picker in InfoPath