Posts tagged Hosting cheap european sharepoint server 2010 hosting

SharePoint 2013 Hosting – HostForLIFE.eu :: Send Email Using PowerShell

Jul 5th

Posted by Peter in European SharePoint 2013 Hosting

Windows PowerShell cmdlets have the capability of sending emails. We can craft an email and its various components, such as recipients, email body, email attachments, etc. using PS code. This feature removes manual effort and human intervention of composing and sending emails. This opens various avenues to make your programs more dynamic as well as appealing business-wise.SharePoint-2013-Hosting1

Use Cases

A few use cases where this capability is instrumental are,

  • Send email to target audience at the end of a script, with the result files as attachments
  • Send email as a part of monitoring scripts. For instance, a PS script sending out mailers when a SharePoint subsite exceeds a size limit set by administrator
  • Send email to administrator when a .NET site is not used frequently, based on site visits thresholds set by administrators

The Script

Explanation

The primary cmdlet responsible for sending the email is Send-MailMessage. It accepts various parameters. Below is a description of the parameters that are primarily used.
Parameters Type Description/Remarks
-To String The recipient of the email. For multiple recipients separate them as individual strings. For example – “user1@demo.com”, “user2@demo.com”
-From String The sender of the email
-Cc String The recipient who will be copied in the email
-Bcc String The recipient who will be copied but not listed in the email
-Subject String The subject line of the email body
-Body String The email body of the message.Multiple lines including variables can also be appended. HTML elements and stylings (bold, italics, etc.) can also be included as shown in the script above.
-Attachments String The path of the attachment fileIt is worth noting that, for attachments that exceed the limits set by the email service provider, it might fail. Hence, it is recommended to exercise caution for before attaching files in emails. For larger attachments, shared locations can be used.
-SmtpServer String The SMPT server that is responsible for establishing communication. This is very vital.
-BodyAsHtml String This parameter specifies that the email body contains HTML and will be rendered as per HTML standards.

Illustration

Modify the parameters and variables as per your requirements, execute the program, and that’s it!

The email will be delivered to your recipients!

, , , , , , , , , , , , , , , , , , ,

SharePoint 2013 Hosting – HostForLIFE.eu :: Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM

Jun 27th

Posted by Peter in European SharePoint 2013 Hosting

In this article, I am sharing code snippets to create List items and update items with Taxonomy or Managed Metadata field on a custom list. I have seen some threads on how to update the multi-value taxonomy fields also. The below code demonstrates both single/multi-valued, taxonomy column update snippets via JSOM.
SharePoint-2013-Hosting1
Create List Item 

Let us quickly test this via Chrome Developer Console.

Go to page and view site in the Classic experience.
Press F12. Go to Developer Console and paste the above code in the console.
Press Enter.
We should get an undefined logged-in console. Don’t worry. Ignore this message.
Now let us try this out, call this function in chrome console developer like below
If you get the above message, an item will be created in the list and the Taxonomy field would have been set. Please refer to the below screenshot for reference.
The same way, you can try multi-value also by passing the parameter as false in the CreateItem method.
Update Item

Use the same Chrome Developer Console technique to quickly test this function. Type ”UpdateItem(8,false)”. Please note that we are updating the same item created using CreateItem method.

Calling update method
Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM
Output
Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM
, , , , , , , , , , , , , , , , , , ,

Remote PowerShell Execution For SharePoint On-Premises

Jun 20th

Posted by Peter in European SharePoint 2013 Hosting

We all know PowerShell is mostly used by SharePoint admins to manage their servers in a farm. SharePoint admins perform many activities as part of the SharePoint administration. In this article, we will learn how to execute remote PowerShell commands from one server on a remote server.SharePoint-2013-Hosting1

Why do we need this remote execution of PowerShell script?

  • Managing multiple servers and running a command on every server individually is time-consuming.
  • Centralized server (one server) to run a script on all remote servers gives more control over process.
  • Prevents uneccessary access to all servers.
  • Tighter and secure environment.
  • Single script to run on one machine and updating multiple servers at once.

Use case

For the sake of the article, we will take an example on how to deploy WSP from client to SharePoint Server A.

Setup Remote Server

Check if WINRM service is started and running. Go to services.msc and see if Windows Remote Management (WS-Management) service is running.

Enable PowerShell Remoting. Run the below command in PowerShell (as administrator).
Enable Server as Remote server. Run the below command in PowerShell (as administrator).

Run the below 2 commands one after another.

Notes
  • Firewall rule must be enabled to allow communication with the server.
  • Ensure the user has permission to SharePoint content database.

Setup Up Client machine

Enable PowerShell Remoting. Run the below command in PowerShell (as administrator).

Enable Client. Run the below command in PowerShell (as administrator).

We have configured the client to run remote commands on any remote server.
Run commands from the client machine.
Get user credentials and store in variables.

Enable SSP and Get Session object to enter to remote server.

Run command via -ScriptBlock attributes. Using script block, you can run multiple commands at once on a remote server.

Now, enter the session of the remote server.

On successfully running this, it will run all the invoke commands on the remote server. Go to the server and check if WSP is updated.

Using the Invoke-Command method, you can run any command available and it will execute in the remote server.
Examples of other commands.

Summary

In this article, we have learned how to enable remote execution of PowerShell script on SharePoint server and in an example, deployed WSP rom the client to a SharePoint Server.
, , , , , , , , , , , , , , , , , , ,

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint Column Formatting: Display A Single line Of Text As Hyperlink

Jun 13th

Posted by Peter in European SharePoint 2013 Hosting

In this article, we will see how we can make a single line of text column’s values be displayed as a hyperlink with icon and how to create a dynamic href. Suppose you have an email field in your list which is a single line of text. Single line of text values will be displayed as normal text in SharePoint modern views.
SharePoint-2013-Hosting1Scenario
Suppose you have custom list name ‘Xyz’ and it has one column named ‘Email’ which is a single line of text (due to business requirements you have not chosen to use people and group or you are storing some external user’s email id in this column). Now when you see this in Default list view it would be displayed like below.
Now you need to make this Email column values clickable so that on click it opens an email client new mail window with ‘To’  field pre-populated. We will have to just customize this field to display it as anchor tag with href set to mailto:’brucewayne@gmail.com’.
We have 2 options to achieve this:
  1. Using SPFx extension Field customizer
  2. Using Column Formatting option
The first one would need you to create a package and write custom code, so here we will use the second option using the Column formatting option.
Microsoft has introduced column and view formatting to let us control how default list views are displayed. We won’t be able to change the value of fields but we will be able to change its formatting. Now let us see how can we achieve this.
Go to List Settings -> Edit Column ‘Email’ – Find option Column formatting,
Add the below Json inside text area.

Click Ok and go back to view and refresh the page, you should see the below.

On click of link it will open a new mail window (based on your default client configuration) with To, Subject and body field populated.
Below is what we get in anchor tag for the first item
mailto:brucewayne@gmail.com?subject=Wonder women here&body=Hey Batman%0D%0AJust checking, if you have saved the world?.%0D%0A—%0D%0A%0D%0AClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=1 
If you look closely the Json we have used hass some placeholders to place dynamic values of list item.
brucewayne@gmail.com – comes from @currentField
Batman – comes from [$Title]
1 – comes from [$ID]
In a similar way we can use any column values using the format [$<ColumnName>]
If we know how to format this Json, we can do wonders…there are some great examples on microsoft docs.
I will try to explain some basic structure based on our example for understanding.
  • The first – “elmType”: “div” – Here we are saying that we need the element to be rendered as div
  • Now within this div, we will create 2 children of type anchor tag (one for email and one for icon) – yes, this could have been done in a single anchor tag but I wanted to understand how it works so I kept 2 childrens both childrens “elmType”: “a” is anchor(a is html tag)
  • For the first one we are having attribute  “txtContent”: “@currentField” – This tells it to render text inside anchor tag as value of current field.
  • Then we have ‘attributes’ –  it is Json because we are setting different attributes like target and href.
  • Within href we are using again using json object as we need to concate some values, hence ‘operator’ is ‘+’ and operands are array of values with static text and dynamic values(from other columns in list item).
  • Values within array are separated by comma, a typical javascript array.
  • As explained before some of fields like $Title, $ID are being used to create href link.
  • href could have been built by simply using ‘+’ operator like below,
“href”: “=’http://finance.yahoo.com/quote/’ + @currentField”
Summary  – This article will give you a basic start on using the column formatting feature. This can be really helpful to style columns values without any customizatoin and it will work for all the OOTB views. If you are really into what operators, expressions and elm and other attributes are supported, refer to the Json schema.
, , , , , , , , , , , , , , , , , , ,

SharePoint 2013 Hosting – HostForLIFE.eu :: Export Import Content Types In SharePoint Online Using PowerShell

May 23rd

Posted by Peter in European SharePoint 2013 Hosting

In SharePoint, we have lists and libraries for collaboration purposes. The lists and libraries contain a huge number of columns.SharePoint-2013-Hosting1

For better understanding and reusability, these are grouped in content types.

Content types are, hence, reusable collections of metadata which can be attached to any list or library. They help us to organize and handle the data in a better and more efficient way.

There are 2 types of content types.

  • Site Content types
    This is present in the root level of the site which can be used by subsequent subsites and lists/ libraries.
  • List Content types
    These are associated with lists and libraries and are a subset of site content types.

Let’s take an example where content types are required.

Suppose, we have an Employee site which contains list like EmployeeData, HREmployeeData, FinanceEmployeeData, EmployeeDocuments, HRDocuments.

In this case, as we can see for EmployeeData and HR EmployeeData, we can have similar columns related to employees (For example, Firstname, Lastname, Ph Number, Address). So, here there are 2 possibilities.

  • We can either create a parent content type as Employee(which contains basic Employee details). Then, create HREMPContenttype and EMPContentype which will inherit from Employee.
  • Or, we can create a content type Employee and add that in the 2 lists. Then, add additional columns for the respective list.

Same goes for documents as well.

Now comes a situation where we need the same content types or a few of them in a separate site.

In on-premise, we have a content type hub for publishing the content type to be used across multiple locations. But, in SP Online we do not have the feature.

There is an option to export and import content type.

In the below PowerShell CSOM code, we can export the content type in XML file and use in the respective sites as required.

Please store the DLLs in respective ISAPI folder before proceeding with the code.

Similarly, we can import the respective content types to a destination site collection using the below script.

 

, , , , , , , , , , , , , , , , , , ,

SharePoint 2013 Hosting – HostForLIFE.eu :: The Generic REST Library CRUD Operation in SharePoint

May 16th

Posted by Peter in European SharePoint 2013 Hosting

For one of my clients, I was working on developing custom forms to interact with SharePoint lists and document libraries.
SharePoint-2013-Hosting1
In that project, there were so many forms to be developed. So, I decided to develop one generic library that can be reused to perform operations using REST API.

The aim of this library is to create a generic set of methods as well, keeping one thing in mind that it should be enhanced easily to include more features.

In this library, there are a total 4of four files.

ListManager.js
This file is used to specify list columns we are working with.

ListUtility.js
This file contains all generic methods.

Main.js
Use this file to write application logic. This will be the main file referenced in our page, the rest of the files are loaded from Main.js itself.

Utility.js
It can be used to specify constants as well as utility methods.

I have also provided detailed information and instructions in attached zip file.

, , , , , , , , , , , , , , , , , , ,
123»