SSRS Sharepoint Integrated mode – adding CSV pipe export option

CSV Pipe export option is not available for default installation of SSRS sharepoint integration mode setup. To enable this option you should edit the configuration file. If you have the multiple WFE server then you have to apply fix on all server. Below script will solve the issue of editing the config file.

Just run the below powershell script in admin mode, It will do the required changes on reporting service application.

 

 

Sharepoint 2013 Search components

Understanding the Sharepoint 2013 search components in details. Understanding the below components are helps to configure scalable search implementations.

Search component name Description Server

Crawl component

Crawls content sources to collect crawled properties and metadata from crawled items and sends this information to the content processing component.

 App Server

Content processing component

Transforms the crawled items and sends them to the index component. This component also maps crawled properties to managed properties.

 App Server

Analytics processing component

Carries out search analytics and usage analytics.

 App Server

Index component

Receives the processed items from the content processing component and writes them to the search index. This component also handles incoming queries, retrieves information from the search index and sends back the result set to the query processing component.

 App Server

Query processing component

Analyzes incoming queries. This helps optimize precision, recall and relevance. The queries are sent to the index component, which returns a set of search results for the query.

 WFE and mirrered on APP server as well for failover

Search administration component

Runs the system processes for search, and adds and initializes new instances of search components.

 AppServer

Search databases

Search database name Description

Crawl database

Stores tracking information and historical information about crawled items such as documents and URLs. It also stores information such as the last crawl time, the last crawl ID and the type of update (add, update, delete) during the last crawl.

Link database

Stores unprocessed information that is extracted by the content processing component and information about search clicks. The analytics processing component analyzes this information.

Analytics reporting database

Stores the results of usage analysis.

Search administration database

Stores search configuration data.

More informaiton read here

Sharepoint 2013 best practices

Many company started adopting the sharepoint 2013 as you aware. I have found one interested MSDN artical on best sharepoint 2013 best practices.  Sharepoint 2013 Best practices here.

You can find all required information about blow topics.

Performance
Feature Overview
Capacity Planning
Installation
Upgrade & Migration
Infrastructure
Backup & Recovery
Database
Implementation and Maintenance
Apps
Developing
Debugging etc 

 

Client Object Model and Linq to Sharepoint implementation

SharePoint 2010 Client side and server side code for CRUD list item. Sample contains client side object model

Sharepoint object model samples 
  Client Object Model  LINQ to SharePoint
Create List Items  string siteUrl = "http://cmsstores"; ClientContext clientContext = new ClientContext(siteUrl); SP.List oList = clientContext.Web.Lists.GetByTitle("Students"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Firstname"] = txtFname.Text.Trim(); oListItem["Lastname"] = txtLname.Text.Trim(); oListItem.Update(); clientContext.ExecuteQuery();   try { using (MyEntitiesDataContext dc = new MyEntitiesDataContext(SPContext.Current.Site.Url)) { EntityList listItems = dc.GetList("Students"); StudentsItem objnew = new StudentsItem() { Firstname = txtFname.Text.Trim(), Lastname = txtLname.Text.Trim(), Country = Country.USA, Title = txtTitle.Text.Trim() };// Insert the new list item to the list dc.Students.InsertOnSubmit(objnew); dc.SubmitChanges(); } } catch (Exception ex) { throw; }
Update List Items  string siteUrl = "http://cmsstores"; ClientContext = new ClientContext(siteUrl); SP.List oList = clientContext.Web.Lists.GetByTitle("Students"); ListItem oListItem = oList.GetItemById(6); oListItem["Firstname"] = txtFname.Text.Trim(); oListItem["Lastname"] = txtLname.Text.Trim(); oListItem.Update(); clientContext.ExecuteQuery();   try { using (MyEntitiesDataContext dc = new MyEntitiesDataContext(SPContext.Current.Site.Url)) { EntityList listItems = dc.GetList("Students"); StudentsItem updateobj = (from c in listItems where c.Id == 4 select c).First(); updateobj.Lastname = "Item2"; updateobj.Firstname = "Item2"; txtLname.Text = updateobj.Id.ToString(); dc.Students.InsertOnSubmit(updateobj); dc.SubmitChanges(); } } catch (Exception ex) { }  
Delete List Item  string siteUrl = "http://cmsstores"; ClientContext = new ClientContext(siteUrl); SP.List oList = clientContext.Web.Lists.GetByTitle("Students"); ListItem oListItem = oList.GetItemById(6); oListItem.DeleteObject(); clientContext.ExecuteQuery();  try { using (MyEntitiesDataContext dc = new MyEntitiesDataContext(SPContext.Current.Site.Url)) { EntityList listItems = dc.GetList("Students"); var updateobj = (from c in listItems where c.Firstname == objTitle select c).First(); dc.Students.DeleteOnSubmit(updateobj); //Submit the changes dc.SubmitChanges(); } } catch (Exception ex) { }  

SharePoint 2010 Virtual PC Setup

If you want to practice the Sharepoint 2010 Then it is better to install required software in virtual PC and run it using your Host operating system.

Recently i have configured SharePoint 2010 VHD using open source Oracle’s VirtualBox. This is also similar to Virtual pc provided by Windows OS.  Advantage of virtualbox is you can run it on any OS like Linux or MAC etc and it is free. As like Virtual PC, virtualbox support the USB, CD Drive and network connection as well.

I’m using this virtualbox from last one month, Performance also good compared to virtual pc. Loading the Saved State and saving the running state also fast compared to virtual PC. Overall performance of the virtualbox is really good. I’m using it on 4GB RAM desktop and Laptop. Both system its performance is awesome. Just check the YouTube video for its performance for opening the Site and Central Admin.

Note: If you want to use the SharePoint 2010 for development then it is best to use VirtualBox. If you need the configured virtualbox copy then just request for your copy here. I have installed all required software like Windows 2008, Sharepoint 2010 and Visual studio 2010 trial versions, If you want to practice the Sharepoint 2010 then use it as it is. If you want it for commercial development then just activate the trial copy the use it.

Tags:

sharepoint 2010 best practice development virtual pcvirtual pc 2010sharepoint 2010 virtual pcsharepoint 2010 virtual pc downloadvirtualbox sharepoint 2010 vhdVirtual PC SharePoint 2010sharepoint2010 vhd virtualbox