Author Archives: Micah Richard

SharePoint 2013 Hosting – ASPHostPortal.com :: How to Configures Refining SharePoint Search and Searchable Columns

Adding search refiners and creating searchable columns with SharePoint On the web can be a small bit diverse then with SharePoint 2013 on premise. In this blog post I’ll clarify how to add search refiners and the best way to make custom columns searchable. You will find 5 significant components we ought to implement

ahp banner sharepoint-01

  • Create a custom column
  • Add some content
  • Map a crawled property to a refinable managed property
  • Created the alias
  • Configure the refiners

Solution

  1. Create your custom column, for example Product.
  2. Create some content with the custom column.
  3. Wait for the column to be added as a crawled property, this might take up to 24 hours.
  4. Open the SharePoint admin center and click on Search.
    1hdvl
  5. Click on Manage Search Schema.
  6. Depending on the type of column you will need to use different type of preset Managed Properties.
    Managed property name Data type for mapping
    RefinableDate00 – RefinableDate19 Dates.
    RefinableDecimal00 – RefinableDecimal09 Numbers with max three decimals.
    RefinableDouble00 – RefinableDouble09 Numbers with more than three decimals.
    RefinableInt00 – RefinableInt49 Whole numbers.
    RefinableString00 – RefinableString99 Strings, Person or Group, Managed Metadata, Choice and Yes/No
  7. Search the related type on Managed Property.
    2ksdhvp
  8. Click on Edit Map Property in het drop-down menu.
  9. Add the Crawled property of the custom column, in our example it will be ows_Product.
    3jkbnl;fc
  10. Fill in the alias, this will make the column searchable.
  11. Save the changes.
  12. Close the SharePoint admin center and open the search center result page.
  13. Set the page in edit modus and edit the Refinement web part.
    4dkjvb
  14. Click on Choose refiners, and add the managed property, in this example RefinableString01
  15. Change the display name to the custom columns name, otherwise the refiner will be shown as RefinableString01
  16. Search for some content and enjoy the result!

Result

5jkbsdvloBest Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: Deploying Managed Metadata Fields Declaratively

In this article, we will see how we are able to deploy Managed metadata fields in a declarative way in SharePoint

A managed metadata column lets you handle the data that people can enter into a column. Users select the terms or phrases that they enter within the column from a pre-defined set of managed terms.

ahp banner sharepoint-01The challenge comes if you desire to provision your custom managed metadata navigation field inside a declarative way, and adding this column to a content variety or a list instance without having losing all the strong functions that comes along making use of this field sort.

Out on the Box, if you added a managed column for your list SharePoint performs some actions behind the scene:

Creates a hidden note field attached to your column
Attached your list to two event receivers to update the taxonomy hidden list .
Fills in some properties related to the current web and taxonomy list id
Creates a taxonomy search managed  property after a full crawl that could be used as a refiner or even as a category column if you are planning to use the Product Catalog model.

So you’ll find a lot of articles explaining how you can deploy Managed Metadata Fields declarative in SharePoint, but they are scattered, so I decided to aggregate all of the suggestions and tricks to cover this activity.

  • Taxonomy Field  declarative XML, no tricks here

    <Field ID=”{20A3C69E-FFFB-43F4-BBDF-2D22BAF0EB84}”
    Type=”TaxonomyFieldType”
    DisplayName=”$Resources:myResourceFile,EventType”
    ShowField=”Term1033″
    Required=”TRUE”
    EnforceUniqueValues=”FALSE”
    Group=”Custom”
    StaticName=”CustomEventType”
    Name=”CustomEventType”
    Filterable=”TRUE”
    Sortable=”TRUE” />

  • SharePoint creates a hidden note field to be field with chosen values even though filling the taxonomy field, right here comes the tricky element, although adding your custom field towards the list you must add this hidden field in addition to it, The Display name need to comply with the following convention ‘TaxonomyField_0′ and the static name should adhere to the following convention ‘TaxononmyFieldTaxHTField0′, without having following this conventions SharePoint search will not create the crawled property for your custom column ‘ows_taxId_CustomEventType’, and for certain will not generate the managed house

    ‘owstaxidKataraEventType’<Field ID=”{09F37A61-50FE-413E-941F-3BEE2A1B5BF8}”
    Name=”CustomEventTypeTaxHTField0″
    StaticName=”KataraEventTypeTaxHTField0″
    SourceID=”http://schemas.microsoft.com/sharepoint/v3/fields”
    Type=”Note”
    DisplayName=”CustomEventType_0″
    Group=”Katara”
    Hidden=”TRUE” />

  • Soon after declaring the schema of each field you must get them connected together, and ought to attach the developed column to a specific Term Set and distinct Term to choose from as a source, this could possibly be achived by adding a function event receiver making use of the following code snippet.SPSite site = properties.Feature.Parent as SPSite;

    Guid eventFieldId = new Guid(“{20A3C69E-FFFB-43F4-BBDF-2D22BAF0EB84}”);if (site.RootWeb.Fields.Contains(eventFieldId))
    {
    TaxonomySession session = new TaxonomySession(site);
    if (session.TermStores.Count != 0)
    {
    var termStore = session.TermStores["Managed Metadata Serivce"];
    var group = termStore.Groups["YOUR GROUP NAME"];
    var termSet = group.TermSets["YOUR TERM SET NAME"];var eventTypeTerm = termSet.Terms["THE TERM NAME CONTAINING YOUR VALUE"];

    TaxonomyField eventField = site.RootWeb.Fields[eventFieldId] as TaxonomyField;

    //Attach the note field to the taxonomy field
    eventField.TextField = new Guid(“{09F37A61-50FE-413E-941F-3BEE2A1B5BF8}”);

    // Connect to MMS
    eventField.SspId = termSet.TermStore.Id;
    eventField.TermSetId = termSet.Id;
    eventField.TargetTemplate = string.Empty;
    eventField.AnchorId = eventTypeTerm.Id;
    eventField.LookupWebId = site.RootWeb.ID;

    if (eventField.TypeAsString == “TaxonomyFieldTypeMulti”)
    ageGroupField.AllowMultipleValues = true;

    eventField.Update();
    }
    }

  • Within this stage we’ve got our field provisioned and added to our site as a web site column, the next step is usually to add it to a content sort, the trick here is we should add two hidden fields ‘TaxCatchAll’ & ‘TaxCatchAllLabel’ fields,If it doesn’t, then you won’t get facets showing up correctly in faceted search. Note that not having the TaxCatchAll and TaxCatchAllLabel pair of columns in your list or library or content variety can cause that.
  • so our field references will probably be like the following

    <FieldRef ID=”{20A3C69E-FFFB-43F4-BBDF-2D22BAF0EB84}” DisplayName=”$Resources:FILENAME_Columns,EventType;” Required=”TRUE” Name=”CustomEventType” Filterable=”TRUE” Sortable=”TRUE” />
    <FieldRef ID=”{09F37A61-50FE-413E-941F-3BEE2A1B5BF8}” DisplayName=”CustomEventType_0″ Hidden=”TRUE” Name=”CustomEventTypeTaxHTField0″ />
    <FieldRef ID=”{f3b0adf9-c1a2-4b02-920d-943fba4b3611}” DisplayName=”Taxonomy Catch All Column” Required=”FALSE” Hidden=”TRUE” Name=”TaxCatchAll” Sealed=”TRUE” Sortable=”FALSE” />
    <FieldRef ID=”{8f6b6dd8-9357-4019-8172-966fcd502ed2}” DisplayName=”Taxonomy Catch All Column1″ Required=”FALSE” Hidden=”TRUE” Name=”TaxCatchAllLabel” ReadOnly=”TRUE” Sealed=”TRUE” Sortable=”FALSE” />

  • Now we come to the next trick, referencing these columns to a list template within the schema.xml file , the trick right here would be to declare the TaxHiddenList ‘TaxCatchAll’ & ‘TaxCatchAllLabel’ correctly to the the list schema, these fields are a lookup columns so they need the information list (source), following is the definetion, NOTE the List attribute.

    <Field Type=”LookupMulti” DisplayName=”Taxonomy Catch All Column” StaticName=”TaxCatchAll” Name=”TaxCatchAll” ID=”{f3b0adf9-c1a2-4b02-920d-943fba4b3611}” ShowInViewForms=”FALSE” List=”Lists/TaxonomyHiddenList” Required=”FALSE” Hidden=”TRUE” CanToggleHidden=”TRUE” ShowField=”CatchAllData” SourceID=”{1e46f7fe-3764-40b5-abd1-1746c716214b}” Mult=”TRUE” Sortable=”FALSE” AllowDeletion=”TRUE” Sealed=”TRUE” Version=”2″ />
    <Field Type=”LookupMulti” DisplayName=”Taxonomy Catch All Column1″ StaticName=”TaxCatchAllLabel” Name=”TaxCatchAllLabel” ID=”{8f6b6dd8-9357-4019-8172-966fcd502ed2}” ShowInViewForms=”FALSE” List=”Lists/TaxonomyHiddenList” Required=”FALSE” Hidden=”TRUE” CanToggleHidden=”TRUE” ShowField=”CatchAllDataLabel” FieldRef=”{F3B0ADF9-C1A2-4b02-920D-943FBA4B3611}” SourceID=”{1e46f7fe-3764-40b5-abd1-1746c716214b}” ReadOnly=”TRUE” Mult=”TRUE” Sortable=”FALSE” AllowDeletion=”TRUE” Sealed=”TRUE” Version=”2″ />

  • Finally, we require to attache the “TaxonomyItemSynchronousAddedEventReceiver” & “TaxonomyItemUpdatingEventReceiver” to update all the hidden fields.

    <Receiver>
    <Name>TaxonomyItemSynchronousAddedEventReceiver</Name>
    <Type>ItemAdding</Type>
    <Assembly>Microsoft.SharePoint.Taxonomy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Assembly>
    <Class>Microsoft.SharePoint.Taxonomy.TaxonomyItemEventReceiver</Class>
    <SequenceNumber>10000</SequenceNumber>
    </Receiver>
    <Receiver>
    <Name>TaxonomyItemUpdatingEventReceiver</Name>
    <Type>ItemUpdating</Type>
    <Assembly>Microsoft.SharePoint.Taxonomy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Assembly>
    <Class>Microsoft.SharePoint.Taxonomy.TaxonomyItemEventReceiver</Class>
    <SequenceNumber>10000</SequenceNumber>
    </Receiver>

Best Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: SharePoint Workflow Options to Drive Workforce Productivity

These days several organizations still rely on obsolete practices to handle their day to day operations. These approaches have an adverse influence on the workforce productivity in terms of wasted man-hours required to carry out a simple activity. Using the rise in competitors and service industrialization, leading enterprises are looking for techniques to grow to be much more effective in optimizing time for production of goods or solutions that conform to quality norms. These enterprises strive to create automated workflows with state of the art automation technologies to achieve better output.

ahp banner sharepoint-01Even though process automation has been around for some time now, there are not many takers for it as organizations still favor to carry on using the legacy approaches for managing day to day operational activities to save a number of dollars.

How workflow automation assists?

Managing workflows call for effective collaboration amongst workflow participants. Take into account a easy example of an approval approach for updating a set of content material on a internet site, exactly where an employee’s content suggestions are reviewed 1st by his manager after which by the group head followed by the technical head. The employee, the manager, the head, the technical team are participants inside the content material approval workflow. They communicate by means of emails, telephone calls or by manually following up with each other. Besides, you can find a great deal of reminder events that consume plenty of time. This is a simple approach which demands effective coordination among departments and internal teams. To expedite the process one particular requirements to scale up the process and automate it to ensure that when every single workflow participant performs its job, the subsequent participant gets an automatic update quickly. A unified communication platform can go a lengthy way in easing the method. In this example, after the content material has been authorized by the manager, an alert will likely be sent for the head for the next round of review followed by the technical head’s overview. Similarly, there are a large number of processes that run across organizations and communicating by means of emails and phone calls become tedious and time consuming.

SharePoint workflows to help your company operations

SharePoint workflow solutions assist organizations by automating manual processes and aid workflow participants grow to be a lot more efficient and productive when functioning with documents, types and libraries in SharePoint. Making use of SharePoint, an employee can start a workflow on a document and simply achieve his task. SharePoint facilitates automated workflows across various operational scenarios. A few of these scenarios are collecting feedback, collecting digital signatures, document translations and group approval processes. These workflow solutions can assist organisations save man-hours and effectively utilize their resources.

Best Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

ASPHostPortal.com Announces Reliable Zikula 1.4.0 Hosting Service

ASPHostPortal.com, the leader of ASP.NET & Windows hosting provider launches Reliable Zikula 1.4.0 Hosting with comprehensive package.

ASPHostPortal.com-Announces-Reliable-Zikula-1.4.0-Hosting-Service

With the Best excellent service, ASPHostPortal.com is one of the primary Windows hosting providers providing good quality provider with quality assistance. Their servers are built using the most current know-how. They’re enthusiastic about web hosting and attempt to deliver an outstanding degree of assistance to each customer. Their world wide web hosting options are well suited for tiny to medium-sized weblogs, personal, charity or business websites. Currently, they launch Zikula 1.4.0 Hosting with reliable technology and cost-effective value.

Zikula is an open source site builder that is quick and simple to use. Using a number of themes, plugins, and user-friendly tools, it is a simple and highly flexible method to get your business webpage, online shop, or blog up and running. Zikula is a powerful PHP-based application development framework which has content material management capabilities built-in. The idea is to expose all the functionality of a common Application Improvement Framework, with all the up-and-running ease of a conventional CMS.

This is achieved by constructing Zikula on top of other development frameworks and implementing a modular approach to feature development.

The day has ultimately come, ASPHostPortal.com Announces Reliable Zikula 1.4.0 Hosting. Zikula 1.4.0 has Symfony at it is foundation, which consists of Doctrine. And Zikula 1.4.0 integrates Twitter’s Bootstrap 3 and Font Awesome 4 and utilizes jQuery for exciting web user-interfaces and effects.

“Zikula : an OpenSource PHP Application Framework and CMS for the site, No matter what your demands, Zikula can give the solution. Whether it is a big corporate web presence with ecommerce, a little basic blog or a community portal, Zikula can do it all. Zikula is infinitely expandable with modules and plugins that may add the functionality you need. And all with tomorrow’s technology. Greatest of all, it really is totally totally free. ASPHostPortal provides you with the support and help you need,” said Dean Thomas, Manager at ASPHostPortal.com.

With 7 data centers that located in USA, Europe, Australia and Asia, ASPHostPortal is superior provider in the hosting market place. They supplies Zikula 1.4.0 Hosting only from $5/month with 30 days funds back assure. Furthermore, ASPHostPortal has been awarded as one from the very best hosting firms within the market due to the excellent hosting overall performance this hosting offers. To supply ideal hosting functionality, this company often maintains the server with expert group in ASP.NET Technology. To learn a lot more about Zikula 1.4.0 Hosting, please visit http://asphostportal.com/Zikula-1-4-0-Hosting

About ASPHostPortal.com

ASPHostPortal.com will be the Reliable, Cheap and Recommended Windows & ASP.NET Hosting. ASPHostPortal.com has capability to support the latest Microsoft and ASP.NET technologies, such as: like: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 5, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. ASPHostPortal include shared hosting, reseller hosting, and sharepoint hosting, with speciality in ASP.NET, SQL Server, and architecting very scalable options. ASPHostPortal.com strives to provide most likely the most technologically advanced hosting solutions obtainable to all customers the world over. Protection, trustworthiness, and efficiency are on the core of hosting operations to create particular each website and software hosted is so secured and performs at the ideal feasible level.

SharePoint 2013 Hosting – ASPHostPortal.com :: Example for Simple CRM and SharePoint Integration

Throughout the Swedish SharePoint and Exchange Forum 2006 held just outdoors Stockholm on Rosenön this spring, I showed how to make a basic integration of MS CRM and MS SharePoint 2003.

Both technologies are very versatile and are easily integrated with other software, mainly on account of the helpful webservices which can be obtainable.

ahp banner sharepoint-01
The integration I created was to automatically produce a workspace when a new account was developed. The following measures describe how this was produced attainable:

  1. Create a site in SharePoint that will contain all subsites.
  2. Create a new attribute in CRM, nvarchar 255 that will contain the SharePoint site URL.
  3. Create an IFrame in CRM. Modify the onload JavaScript in CRM to set the src of the IFrame to the SharePoint site URL (if it is not null).
  4. Create a dll that creates the SharePoint site and return the new sites URL and can be called on by a CRM workflow.
  5. Modify the workflow.config to add the functionality to the workflow manager.
  6. Create the workflow triggered by Create on account that creates the site and return the URL. Set the new SharePoint-site-url attribute to the return value of the function.

This integration is great, and it is also achievable to create a far more enhanced handling by using the PreCreate Callout instead of utilizing the workflow. However, the workflow-addon designed may be constructed to become quite generic and may hence be utilized for other purposes at the same time, (as an illustration making a SharePoint website for every Opportunity).

I’ll base the SharePoint-site-name around the accountname attribute that is not guaranteed to be special. Within this example I will not go through how to make a duplet checking plan, which need to also be produced, in the event the websites should be depending on accountname. The sitename could also be depending on the account GUID which is assured to be unique.

I will now go through each from the six points in much more detail:

  1. Produce a SharePoint web site that may include all subsites
    Just make use of the regular SharePoint interface, choose generate from the prime menu and then pick site, nearly at the bottom on the list, no distinct template is needed. Note the url to the newly developed website.
  2. Generate a new attribute for the SharePoint web site url
    In CRM, select settings, customizations, customize entitys, account, attributes, create. Create a new attribute called as an illustration “new_spsiteurl” as nvarchar and length 255 (255 must be sufficient for anyone :).
  3. Generate an IFrame in CRM
    Now pick types and views in CRM. Select type. You must now see the editable version on the account form. Click “New Tab” within the appropriate hand menu. Name the new tab “SP Site” or something acceptable. The tab must now be visible.

Choose the “SP Site” tab then pick “Create section” from the right hand menu. Get in touch with it anything good. Also choose to not show the name in the section.

In the new section, select “Add field”. Choose the newly created attribute, “new_spsiteurl”. Verify the checkbox for read-only. Click OK.

Now choose “Create IFrame” from the proper hand menu. Produce an IFrame within the section designed above. Check the checkbox in formatting that makes it fill the form. Get in touch with the IFrame one thing like “IFRAME_spframe”. Click ok to make.

Click the “Form Properties” inside the right hand menu in the bottom. Edit the onLoad script. Place within the following script:

If (crmForm.all.new_spsiteurl.DataValue != null)
{
crmForm.all.IFRAME_spframe.src = crmForm.all.new_spsiteurl.DataValue;
}

Close the dialogs. Click save and close on all forms. When you are back to the main CRM-window, select account in the entities list and click “publish”.

Produce the workflow addon dll

Open Visual Studio 2003 (it will operate with VS 2005 also, however, if you’d like to do this with callouts, you may have to comply with the instruction concerning callout improvement in VS 2005 that I have blogged about earlier, with reference to Arash weblog).

Develop a brand new standard C# project having a straightforward class-file. Name the project some thing like “WFAddons”. Rename the cs-file something like “WFAddons”, be sure that the code is coherent with the naming of the file to avoid any confusions.

Make sure you might have a reference to the SharePoint-dll.

With each of the code to create the SharePointsite, the file ought to appear some thing like this:

using System;
using Microsoft.SharePoint;

namespace WFAddons
{
public class WFAddons
{

public string CreateWorkSpace(string accountname)
{
SPSite siteCollection = new SPSite("http://localhost/sites/konton");
SPWebCollection subSites = siteCollection.AllWebs;

SPWeb mySite = subSites.Add(accountname);
mySite.Title = accountname;
mySite.Name = accountname;
mySite.Update();
return mySite.Url;
}
}
}

Inside the row: SPSite siteCollection = new SPSite(“http://localhost/websites/Micah”);
Modify the url to match the web site created in step 1.

Now set the output directory for the CRM-assembly folder. This is usually located right here:
c:\Program Files\Microsoft CRM\Server\bin\assembly\ but is dependant around the CRM-installation.

Compile the project.

Modify workflow.config

Within the folder: c:\Program Files\Microsoft CRM\Server\bin\assembly\, open the file workflow.config and before the finish tags

(
</methods>
</workflow.config>
)

add the following:

<method name="Create workspace"
assembly="WFAddons.dll"
typename="WFAddons.WFAddons"
methodname="CreateWorkSpace"
group="SharePoint functions">
<parameter name="accountname" datatype="string"/>
<result datatype="string"/>
</method>

Generate the workflow

Now, all you might have to do is generate the workflow that can run all this and tie every little thing with each other. Open the workflow manager, select account, and generate a brand new workflow that will be triggered on create. Within the editor, pick “Insert Action” and choose “Call assembly” choose the group name (exactly the same set in workflow.config above), and also the pick the strategy name. Inside the new dialog window, double-click the parameter (the name set in workflow.config) and pick dynamic worth and select the entity Account and decide on the attribute accountname. Inside the primary action dialog, a youcan now see this mapping. Enter an action name, like “create workspace”. Click “Save”.

Best Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: Establishing Reporting Services 2012 With SharePoint 2013

This post will stroll by means of the steps required to setup SQL Server Reporting Solutions in Integrated mode with SharePoint 2013. As was the case with all the new Excel data model, you will need at least SQL Server 2012 SP1 to get this to work as I describe

ahp banner sharepoint-01Fundamentally, you will find no true differences with how this installs when in comparison with installing SSRS 2012 on a SharePoint 2010 farm in SharePoint mode, so if you have landed right here seeking 2010 information, it need to be valid, but the screens will appear somewhat different.

To begin with, it’s critical to know that SSRS will install as a SharePoint service application. This certainly signifies that it has to be installed on a machine that is certainly part of the the SharePoint farm. What this doesn’t mean is that you ought to install SharePoint in your SQL server and join it for the farm (please Don’t do that!). In a single SharePoint front end atmosphere it is a lot much better to add SSRS for your SharePoint server than it is to add SharePoint to your SQL server. Naturally, when you have a separate SharePoint application server, that is the most effective location for it.

To set up, receive the SQL Server 2012 SP1 (or higher) media and mount it on tyour SharePoint server. Run the installer, pick new install and adhere to the prompts. Sooner or later you may get to the feature section screen, and assuming that machine has no prior SQL on it’s going to appear one thing like the following when completed.

1jkblkrbveYou will notice that everything chosen is below the Shared Functions section, which signifies that it’s not installed as component of a SQL instance. In reality, you’ll notice that we do not possess the data engine installed at all. The two Reporting Services possibilities shown would be the only items which can be truly needed for SSRS Integrated mode to work. As you’ll be able to see, I’ve also chosen SQL Server Information Tools (formerly BIDS) and Management Tools at the same time. I prefer to install these tools as a matter naturally on SharePoint servers, as they can come in handy for connectivity testing or rapid BI project creating.

Follow the remaining prompts till the installation is total.

Another point that you should note is that the order of operations is important here. In the event you install Reporting Solutions – SharePoint before installing SharePoint around the farm, the option to create a Reporting Services application is not going to seem. That’s since it won’t be registered with the farm as a service application. If this happens, you can run the following PowerShell to register the Service Application

Install-SPRSService
Install-SPRSServiceProxy

Once registered, the service application could be developed as beneath. In the event you set up Reporting Service – SharePoint after the server has been joined to the farm, then the above methods are taken care of for you automatically.

The next factor that you just have to do would be to provision the service application. From Central Administration, navigate to Handle Service applications. Then, in the new menu, Select SQL Server Reporting Services Service Application.

2hveorehbFill out the resulting form as appropriate, and select OK. Make sure that you navigate to the bottom of the form and select the applications to activate SSRS on.

3uiehvorOnce the service application and proxy have been created, click on it to access the management screen.

4hnwleknYou will want to access every single of the sections and fill out the proper alternatives for your installation. The directions are pretty self-explanatory, so I will not go into them here. At a minimum, you should back up your encryption important in the crucial management section, Set your unattended execution account (the default account to utilize when no credentials are accessible), as well as your e mail server settings if you would like to be able to provide reports by way of e mail. If you’d like to enable self service subscriptions and alerts, fill out that section, and it contains guidelines for setting up the SQL agent service to support it.

One of the most important section is Technique Settings, which controls the bulk of how Reporting Solutions will run. Clicking on it accessed the service itself, and it’s the first spot that you will see an error for those who have configuration troubles. In early builds, I have noticed an error comparable for the following:

The requested service, ‘http://localhost:xxxxx/SecurityTokenServiceApplication/securitytoken.svc/actas’ could not be activated

(xxxxx is a neighborhood port which varies from farm to farm)

This indicated a problem with all the SecurityTokenService, which you’ll be able to see by accessing IIS. After carrying out a bit poking around, I tried to access the service directly inside a browser by way of its base url:

http://localhost:xxxxx/SecurityTokenServiceApplication/securitytoken.svc

I was then presented with an error indicating that the server was also low on memory. The answer? Allocate much more RAM. It was running with 4 GB and only SharePoint installed, nevertheless it did have the majority of the service applications activated. The lesson – if you want all of the services to function, give your server sufficient memory. Bumping it to 8 GB did it in my case.

In case you can access your method settings, then you should be very good to go. The following step would be to allow SSRS in you web site collections, and I strategy on carrying out a post on that within the really close to future. Stay tuned.

Best Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: Customize Process Approval Email to Consist of Link to Respective Job

In SharePoint 2013 workflow architecture is drastically changed when compared with SharePoint 2010. Some new activities like “HttpSend” are introduced for the platform and some activities are improved a whole lot. On the other hand some scenarios became quite hard to implement.

ahp banner sharepoint-01
Let’s assume that we’ve a SharePoint 2013 Visual Studio primarily based workflow and require to assign a task to a user. We count on the notification e mail to contain the hyperlink to respective task. is not it ?

In SharePoint 2010 it was quite easy to include the process url in the mail. But which is not the case anymore. It’s not achievable to include the task url in the default mail. As an alternative it’s sent like below that is not user friendly.

1ivojrbIn this post I’ll show a workaround to resolve the problem. Following are the steps we need to perform

  1. Add “SingleTask” activity and configure necessary parameters2dskvb
  2. Modify WaitForTaskCompletion property to false
    This will avoid the “SingleTask” activity to wait until the approval. Furthermore change “WaiveAssignmentEmail” property value to “Yes” which avoids the notification email.2jkebfog
  3. Compose an email manually
    In this email I’ll include a link to assigned task. To get the guid of task list, I will use “GetTaskListId” activity. Furthermore I’ll get the task id from “SingleTask” activity output.From those elements I’ll construct the url of the assigned task

    e.g.: “http://sp13/sites/dev/DOAApprovalForm.aspx?List=”+taskListId.ToString()+”&ID=”+taskItemId+”

    Then I’ll construct the email body as I wish

    “<html><body style=’font-size:11pt;font-family:Segoe UI Light,sans-serif;color:#444444;’><div>Contract comment is : ” + contractComment+ ” </br>Please approve this <a href=”+siteUrl + “SitePages/DOAApprovalForm.aspx?List=”+taskListId.ToString()+”&ID=”+taskItemId+”>Task</a></div></body></html>”

  4. Handle Approve or Reject actions using a “Pick” activityWe will use “WaitForFieldChange” activity to pause the workflow until user presses Approve or Reject buttons. Since there are two possible values in the pausing field we need to use a “Pick” activity

    4juarehvo

  5. As mentioned earlier, we will use “WaitForFieldChange” activities on both branches, configured for “TaskOutcome” field.5inhgelorgFor the first “WaitForFieldChange” activity, the FieldValue is set to “Approved” and for the other one it is “Rejected”
  6. I’ll update the taskOutcome with respective values to continue the workflow6lkejnfglergbThis will allow us to modify email as we wish and pause the workflow until the task is approved or rejected
    7bckedv

Best Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: Developing a Site Collection in 2010 Mode in SharePoint 2013

These days I got phoned up by a buddy who asked how on earth he could programmatically produce a web site collection in 2010 mode in SharePoint 2013. Why he wanted to do this I’m not confident, and it is not the point of this post

ahp banner sharepoint-01It’s truly pretty uncomplicated if you appear at the documentation of some of the SPSiteCollection.Add() strategies which take an int as a compabilityLevel parameter. Passing in 14 in this parameter will make certain you get the 2010 appear and really feel. For reference the SPSite.SelfServiceCreateSite() technique has equivalent overloads.

SPWebApplication webApp = new SPSite(<a href="http://host/">http://host</a>).WebApplication;
SPSiteCollection siteCollections = webApp.Sites;
uint lcid = 1033;
int compatLevel = 14;
string webTemplate = "STS#0";
SPSite newSiteCollection = siteCollections.Add("sites/test", "Title", "Description", 1033, compatLevel, webTemplate,
 "DOMAIN\\User", "Name", "Email_Address", "DOMAIN\\User", "Name", "Email_Address");

If you want to do it I PowerShell you can use the following command:

New-SPSite -Url http://host/sites/test -OwnerAlias "DOMAIN\User"

And via Central Admin:

3lkdnvlrBest Recommended SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability

SharePoint 2013 Hosting – ASPHostPortal.com :: Sharepoint Designer Workflow Email Link to List

The majority of the workflow finish users requirement is, there ought to be a hyperlink to review the workflow item in their email.

ahp banner sharepoint-01
I am just sharing a speedy tip to send an e mail to a sharepoint Item by adding hyperlink to the message physique

  1. Add a “Send an Email” action to your workflow. Edit the action to pull up the e-mail configuration dialog.
  2. Select the text and click the “Add hyperlink” button noticed below.1ehlrehb;rWhen prompted for the address of the link click the string builder button to add the URL
    2lkdvlbl;brj
  3. In SharePoint, go to the kind library exactly where your InfoPath types are stored, and click an existing InfoPath type to open it in the browser.
  4. Copy the URL with the InfoPath kind. The URL could resemble the following:
    http://ServerName/SiteName/_layouts/FormServer.aspx?XmlLocation=/SiteName/LibraryName/Form1.xml&Source=http%3A%2F%2FServerName%2FSiteName%2FLibraryName%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1

    where ServerName could be the name of your SharePoint server, SiteName is the name of the SharePoint web site, LibraryName may be the name with the SharePoint kind library, and Form1.xml is definitely the name of an InfoPath kind Copy the URL and paste inside the string builder window .Get rid of the shaded portion just after

    http://ServerName/SiteName/_layouts/FormServer.aspx?XmlLocation=

    3lkehflreInstead of that add a lookup [%Current Item:Encoded absolute URL%]  as shown below

    4fbrtnrtn

  5. click OK and publish workflow

Now anytime you develop a new InfoPath type and save it to the form library, the SharePoint Designer workflow is began, and an e-mail is sent to the recipients you specified for the e-mail in the SharePoint workflow. When a user opens the email and clicks on the hyperlink inside the e-mail, the InfoPath kind opens within the browser.

Best SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com  is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability.

SharePoint 2013 Hosting :: Place SharePoint Social Features to Function Within Your Organization Today

Social media has permeated each aspect of our lives and every single facet of the World wide web. In some ways, it has become synonymous with the internet. While some sites are completely dedicated to social media, nearly all web sites have some social media content material. Firms as well as other organizations usually are not immune to this. Really, numerous businesses have improved their achievement by wholeheartedly adopting social media and making use of it to connect with their clients. Microsoft SharePoint might help you use social media to make your organization greater both internally and externally.

ahp banner sharepoint-01Newsfeed

Internal communication and collaboration has in no way been less difficult now that SharePoint contains Newsfeed. It operates within a extremely comparable manner to Facebook and Twitter. Group members can “follow” each other and view one particular another’s documents, websites, tags, and so on. They’re able to “mention” one another, view existing “activities”, and also “like” every single other’s content material.

Like Twitter, SharePoint consists of a microblogging function. You can post updates about your function, post on a team site, refer other folks to posts utilizing an @mention, reference relevant tags inside your post, share conversations by means of links, “like” any post, and add images, videos, links, and external URLs proper into your posts.

Newsfeed App

If you need to remain connected around the move, the Newsfeed App enables you to access and interact together with your newsfeed on your Windows Telephone, iPad, or iPhone.

Sharing Documents and Websites

Part of the new Workplace 365 is SkyDrive Pro, an enterprise-grade version of SkyDrive that you simply can use to shop your documents privately or share them together with your colleagues. You’ll be able to also share sites, send guest hyperlinks to people outdoors of one’s organization, and receive newsfeed updates whenever collaborative documents are updated.

User Profiles

Like earlier releases of SharePoint On the web, this new version contains user profiles. Some of the notable adjustments include: a streamlined navigation method enabling you to switch sections a lot more effortlessly, privacy/sharing alternatives for all fields, and newsfeed sharing and following settings set to “off” by default to boost privacy, requiring you to opt in to these attributes if you would like to make use of them.

Staying in Touch

As the workforce continues to turn into much more mobile, staying in touch is vital, as well as the days of forwarding around emails all day are more than. To maintain up together with the face-paced planet, you may need immediate content sharing and collaboration. SharePoint’s new social functions answer that require and a lot of other individuals.

Best SharePoint 2013 Hosting

ASPHostPortal.com
ASPHostPortal.com  is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal  the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability.