Tuesday, 13 September 2016

Missing : Sharepoint App Template in Visual Studio 2015

     Trying to use Visual Studio 2015 Professional for SharePoint development. After installing the Office Developer Tools, it added additional templates to VS but did not include the "App for SharePoint" template as depicted on the tools web page.

 

 

Apps have been renamed to Add-Ins. "App for SharePoint" is now "SharePoint Add-In"


The newest Office tooling has another change. Here are screenshots of the different stages of the tooling.




 

Monday, 4 July 2016

Data Warehouse Tips



Sr.No.Data Warehouse (OLAP)Operational Database(OLTP)
1It involves historical processing of information.It involves day-to-day processing.
2OLAP systems are used by knowledge workers such as executives, managers, and analysts.OLTP systems are used by clerks, DBAs, or database professionals.
3It is used to analyze the business.It is used to run the business.
4It focuses on Information out.It focuses on Data in.
5It is based on Star Schema, Snowflake Schema, and Fact Constellation Schema.It is based on Entity Relationship Model.
6It focuses on Information out.It is application oriented.
7It contains historical data.It contains current data.
8It provides summarized and consolidated data.It provides primitive and highly detailed data.
9It provides summarized and multidimensional view of data.It provides detailed and flat relational view of data.
10The number of users is in hundreds.The number of users is in thousands.
11The number of records accessed is in millions.The number of records accessed is in tens.
12The database size is from 100GB to 100 TB.The database size is from 100 MB to 100 GB.
13These are highly flexible.It provides high performance.

Data Warehouse Features

The key features of a data warehouse are discussed below:
  • Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations. These subjects can be product, customers, suppliers, sales, revenue, etc. A data warehouse does not focus on the ongoing operations, rather it focuses on modelling and analysis of data for decision making.
  • Integrated - A data warehouse is constructed by integrating data from heterogeneous sources such as relational databases, flat files, etc. This integration enhances the effective analysis of data.
  • Time Variant - The data collected in a data warehouse is identified with a particular time period. The data in a data warehouse provides information from the historical point of view.
  • Non-volatile - Non-volatile means the previous data is not erased when new data is added to it. A data warehouse is kept separate from the operational database and therefore frequent changes in operational database is not reflected in the data warehouse.
Note: A data warehouse does not require transaction processing, recovery, and concurrency controls, because it is physically stored and separate from the operational database.

Data Warehouse Applications

As discussed before, a data warehouse helps business executives to organize, analyze, and use their data for decision making. A data warehouse serves as a sole part of a plan-execute-assess "closed-loop" feedback system for the enterprise management. Data warehouses are widely used in the following fields:
  • Financial services
  • Banking services
  • Consumer goods
  • Retail sectors
  • Controlled manufacturing

Types of Data Warehouse

Information processing, analytical processing, and data mining are the three types of data warehouse applications that are discussed below:
  • Information Processing - A data warehouse allows to process the data stored in it. The data can be processed by means of querying, basic statistical analysis, reporting using crosstabs, tables, charts, or graphs.
  • Analytical Processing - A data warehouse supports analytical processing of the information stored in it. The data can be analyzed by means of basic OLAP operations, including slice-and-dice, drill down, drill up, and pivoting.
  • Data Mining - Data mining supports knowledge discovery by finding hidden patterns and associations, constructing analytical models, performing classification and prediction. These mining results can be presented using the visualization tools.


Friday, 1 July 2016

Error:SharePoint 2013 workflow requires a compatible workflow service configured with SharePoint such as Workflow Manager. The workflow service is either not installed or not configured. Follow this link to find out how to set up workflow.


SharePoint Workflow Manager Service Error:

SharePoint 2013 workflow requires a compatible workflow service configured with SharePoint such as Workflow Manager. The workflow service is either not installed or not configured. Follow this link to find out how to set up workflow.

register-spworkflowservice:a parameter cannot be found the name matches parameter name workflow uri




Solutions:

Please use the command as below and it should work:


Register-SPWorkflowService -SPSite "http://sp2013dev:55/" -WorkflowHostUri "https://sp2013dev.localhost:12290/" -AllowOAuthHttp -Force



Automating SharePoint site backup using Power Shell and windows Task Scheduler

SharePoint administrators need to run regular backups using Power Shell, the STSADM tool or in Central Administration. But taking these backups on a daily basis can be a tedious process, hence either we can sit back and take backup, waiting for it to get over or we can go home and sleep on the couch, while the Power Shell and Task Scheduler take cares of the rest.


Creating Power Shell script to take Backup Daily Folder Wise:



Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue
try
 {
    $today = (Get-Date -Format dd-MM-yyyy)
    $backupDirectory = "E:\Backup\DailySiteCollectionBackUp\$today"
  # Backup file Location
    $backupFile = "E:\Backup\DailySiteCollectionBackUp\$today\Backup.dat"
  # Log file location
    $logFile = "$backupDirectory\BackupLog.log"
  # Address of the Site Collection to backup
    $Site = "http://sp2013dev:100/"
 
 # Location of the Backup Folder
    if (-not (Test-Path $backupDirectory))
    {
      [IO.Directory]::CreateDirectory($backupDirectory)
      #New-Item $logPath -type $backupDirectory
    }

 # Get backup start date and time
    $backupStart = Get-Date -format "MM-dd-yyyy HH.mm.ss"
 
  # creates a log file  Start-Transcript -Path
    Start-Transcript -Path $logFile
   
 # This will actually initiate the backup process.
      Write-Host  
      Write-Host  
      Write-Host "Backup starting at $backupStart for $Site "
      Write-Host "******************************************"
     Backup-SPSite -Identity $Site -Path $backupFile -Force
     $backupComplete = Get-Date -format "MM-dd-yyyy HH.mm.ss"
      Write-Host  
      Write-Host  
      Write-Host "Backup Completed at $backupComplete for $Site "
      Write-Host "******************************************"

 Stop-Transcript
 }
Catch
 {
  $ErrorMessage = $_.Exception.Message
  write "$today BackUp Failed   $ErrorMessage  ">>$logFile

 }



Task Scheduler:

1.Open Tools -Task Scheduler
2.In the Center pane,right-click Create Basic Task




3.Assign the task a meaningful name – such as SharepointSiteBackup-FolderWise






4.Choose “Daily” on the When do you want the task to start screen



 5.Specify the parameter for the Daily task schedule



6.Choose “Start a program” from the what action do you want the task to perform



 7.On the start a program screen type in the command as the screenshot below. The Task scheduler is intelligent enough to recognise that you want to run Power Shell and that you supplied arguments.


























Cloud Computing:

Data Warehousing

A data warehouse is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured and/or ad hoc queries and decision making. This tutorial adopts a step-by-step approach to explain all the necessary concepts of data warehousing.

Please refer the below links,


http://www.tutorialspoint.com/dwh/

http://www.dba-oracle.com/art_dbazine_oracle_10g_data_warehouse.htm


Concepts:



Oracle Data Warehousing:

Monday, 21 December 2015

Create Site Columns and Add them to Content Types Using Power Shell in SharePoint 2013:


How to create SiteColumns and Add them to Content Types Using PowerShell in SharePoint 2013 - See more at: http://www.sharepointpals.com/post/How-to-create-SiteColumns-and-Add-them-to-Content-Types-Using-PowerShell-in-SharePoint-2013#sthash.eaWxgRLq.dpuf
Please refer this link

How to create SiteColumns and Add them to Content Types Using PowerShell in SharePoint 2013 - See more at: http://www.sharepointpals.com/post/How-to-create-SiteColumns-and-Add-them-to-Content-Types-Using-PowerShell-in-SharePoint-2013#sthash.eaWxgRLq.dpuf

http://www.sharepointpals.com/post/How-to-create-SiteColumns-and-Add-them-to-Content-Types-Using-PowerShell-in-SharePoint-2013