Code Samples

Access to XMLHttpRequest at 'from origin has been blocked by CORS policy: Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, https. .net core angular

2019-02-23T17:10:00.003-05:00

Issue: The angular application was getting error from API that the origin has been blocked by CORS policy.

Solution: Make sure that the url configured in angular (usually in environment.ts file missing http or https). Example below:

Error Configuration:
export const environment = {
production: false,
apiUrl: 'localhost:56425/api'
};

Correct configuration:

export const environment = {
production: false,
apiUrl: 'http://localhost:56425/api'

};

Generate SQL Scripts for the Migration - .Net Core Entity FrameWork

2018-08-20T13:58:00.002-04:00

Script-Migration command helps to generate the SQL Scripts (for code first model) that can be run directly from SQL Server Management Studio

Syntax:

SYNTAX
    Script-Migration [-From] <String> [-To] <String> [-Idempotent] [-Context <String>] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>]

Example:

Script-Migration -from "20180523175151_InsertComponentType" -to "20180604012237_OPIDTableInsert"

Command For Angular Build with AOT

2018-05-17T11:37:00.000-04:00

ng build "--verbose" "--environment=test" "--aot"

Get All Timer Jobs Status from a Farm in GridView using PowerShell

2018-01-11T17:13:00.000-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

function Get-SPTimerJobStatus
{
    Get-SPTimerJob | sort Name | ForEach-Object {
        $lastRun = $_.HistoryEntries | Select-Object -first 1
        if ($_.WebApplication -eq $null) { $level = "Farm" }
        else { $level = $_.WebApplication.Url }
        
        $values = @{
            "Name" = $_.Name
            "Level" = $level
            "StartTime" = $lastRun.StartTime
            "EndTime" = $lastRun.EndTime
            "Status" = $lastRun.Status
        }
        New-Object PSObject -Property $values | Select @("Name","Level","StartTime","EndTime","Status")
    }
}
Get-SPTimerJobStatus | Out-GridView

Find out all Site Collection Administrators from a Web Application using PowerShell

2018-01-11T17:10:00.001-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

############### VARIABLES ################################

$rootsiteUrl = "https:/webappurl"

################################################################

$rootSite = New-Object Microsoft.SharePoint.SPSite($rootsiteUrl)
$spWebApp = $rootSite.WebApplication
 
foreach($site in $spWebApp.Sites)
{
    foreach($siteAdmin in $site.RootWeb.SiteAdministrators)
    {
        Write-Host "$($siteAdmin.ParentWeb.Url) - $($siteAdmin.DisplayName)"
    }
    $site.Dispose()
}
$rootSite.Dispose()

Remove Trusted Identity Token Issuer from SharePoint using PowerShell

2018-01-11T17:07:00.000-05:00

clear 
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue 
Add-PSSnapin Microsoft.SharePoint.Powershell

Remove-SPTrustedIdentityTokenIssuer STSWebSite

Add Certificate SharePoint Trusted Root using PowerSHell

2018-01-11T17:04:00.000-05:00

clear  
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue  
Add-PSSnapin Microsoft.SharePoint.Powershell 

$invocation = (Get-Variable MyInvocation).Value
$currentfolder = Split-Path $invocation.MyCommand.Path
$SolutionPath=$currentfolder + "\STSPublicCert.cer"
New-SPTrustedRootAuthority -Name "STSTrustRenewed" -Certificate $SolutionPath

Renew FAST Search Certificate using PowerShell

2018-01-11T16:53:00.001-05:00

This script is more useful for the environments that uses self signed certificates for FAST Search

###################################
# Apply Certificate to FAST
###################################

Clear
Remove-PSSnapin AdminSnapIn -ErrorAction SilentlyContinue
Remove-PSSnapin Microsoft.FASTSearch.PowerShell -ErrorAction SilentlyContinue
Remove-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$userName = "Domain\ServiceAccountName"
$FastContentServiceName = "FAST Content"

write-host "Applying Certificate to FAST" -ForegroundColor Green
#Release worker processess with IISRESET
iisreset

stop-service FAST*

$installerdir = $env:FASTSEARCH + "installer\scripts"
echo $installerdir
cd $installerdir
$pw = ConvertTo-SecureString -AsPlainText -force test
.\ReplaceDefaultCertificate.ps1 -generateNewCertificate $true -certificatePassword $pw
$cert = @(dir cert:\LocalMachine\My -recurse | ? { $_.Subject -eq 'CN=FASTSearchCert' })[0]
$thumb = $cert.Thumbprint

Start-service FAST*

.\SecureFASTSearchConnector.ps1 -certThumbprint $thumb -ssaName $FastContentServiceName -username $userName

Generate DOCX to PDF file using Word Automation Service (WAS) in SharePoint using PowerShell

2018-01-11T16:47:00.000-05:00

Note: This script will be very useful to test whether the WAS service is working properly in the environment. In addition, it will help to find out the source and destination libraries have proper permissions for the WAS to generate the PDF

clear  
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue  
Add-PSSnapin Microsoft.SharePoint.Powershell 

$webAppUrl = "http://webappurl"


[void][System.Reflection.Assembly]::LoadWithPartialName( "Microsoft.Office.Word.Server" ) 

$jobSettings = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJobSettings 

$jobSettings.OutputFormat = "PDF" 

$job = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJob( "Word Automation Services", $jobSettings ) 

$job.UserToken = (Get-SPWeb $webAppUrl).CurrentUser.UserToken 

#Provide the full document url with docx and pdf location

$job.AddFile( "http://webappurl/Shared%20Documents/test1.docx", "http://webappurl/Shared%20Documents/ConvertedDoc.pdf" ) 

$job.Start( )

write-host "Complete"

Disable Sandbox Model for Word Automation Services using PowerShell

2018-01-11T16:39:00.000-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

$sp = Get-SPServiceApplication | where {$_.TypeName.Equals("Word Automation Services")}  
$sp.DisableSandbox = $true
$sp.Update()

Perform IISReset in all the servers of a SharePoint Farm using PowerShell

2018-01-11T16:33:00.002-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

If ((Get-PSSnapIn -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )  
{ Add-PSSnapIn -Name Microsoft.SharePoint.PowerShell } 
 
$host.Runspace.ThreadOptions = "ReuseThread" 
 
#Definition of the funcion that performs the IIS RESET in all the servers 
function PerformIISReset 
{     
    try 
    {         
        #Getting the servers where the IISReset is going to be done 
        $spServers= Get-SPServer | ? {$_.Role -eq "Application"} 
        foreach ($spServer in $spServers) 
        {             
            Write-Host "Perform IIS Reset in server $spServer" -f blue 
            iisreset $spServer /noforce "\\"$_.Address 
            iisreset $spServer /status "\\"$_.Address 
        }         
        Write-Host "IIS Reset completed successfully!!" -f blue   
    } 
    catch [System.Exception] 
    { 
        write-host -f red $_.Exception.ToString() 
    } 
} 
 
Start-SPAssignment –Global 
PerformIISReset 
Stop-SPAssignment –Global

Extract WSP (SharePoint Solution) file from SharePoint Farm using PowerShell

2018-01-11T16:25:00.002-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

$solName = "Sample.wsp"
$farm = Get-SPFarm

$file = $farm.Solutions.Item($solName).SolutionFile
$file.SaveAs("c:\Sample.wsp")

write-host "Completed"

Set Master Page Url using PowerShell - SharePoint

2018-01-11T16:22:00.000-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

################ ENVIRONMENT VARIABLES #########################

$webAppUrl = "https://webappurl"

################################################################


$mainSite = $webAppUrl 
$web = Get-SPWeb $mainSite
$web.MasterUrl = "/_catalogs/masterpage/v4.master"
$web.Update()
$web.Dispose()

Write-host "Completed"

Enable Crawl for DropOffLibrary Documents using PowerShell - SharePoint

2018-01-11T16:17:00.001-05:00

clear  
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue  
Add-PSSnapin Microsoft.SharePoint.Powershell 

################## ENVIRONMENT VARIABLES ##################

$siteUrl = "https://record-site-coll-url"


###########################################################

$dropOffLibrary ="Drop Off Library"
try
{
    $site=Get-SPSite $siteUrl
    $web=$site.RootWeb
    $docLibrary =$web.Lists[$dropOffLibrary]
    # Change the advanced settings
    $docLibrary.NoCrawl = $false;
    $docLibrary.Update()
    $site.Dispose()
    write-host "Completed"
}
catch
{
    write-host "Error"
}

Create Send To Connector using PowerShell - SharePoint

2018-01-11T16:10:00.001-05:00

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

#################################### ENVIRONMENT VARIABLES #########################################

 $WebApplicationURL = "https://webappUrl"  ## eg: "http://spddwebapp"
    $RecordCenterSiteColls = @("SiteColl1","SiteColl2")
  
 
####################################################################################################
    
    $ServiceURL = "_vti_bin/officialfile.asmx"
    write-host "Opening web app object."
    
    $WebApp = Get-SPWebApplication $WebApplicationURL


function AddSendToConnection($sendServiceURL, $siteName )
{

    #Get the Web Application
   
     
    $SPOfficialFileHost = New-Object Microsoft.SharePoint.SPOfficialFileHost

    #Set Send to Options#

    #Send to Connection Name
    $oFName = $siteName + " Send To Conenctor"
    $SPOfficialFileHost.OfficialFileName = $oFName

    #Send to Target location
    
    #write-host "Office File Url - $offFileUrl"
    $SPOfficialFileHost.OfficialFileUrl = $sendServiceURL

    $SPOfficialFileHost.ShowOnSendToMenu = $true

    #Send to Operation

    $SPOfficialFileHost.Action=[Microsoft.SharePoint.SPOfficialFileAction]::Move

    $SPOfficialFileHost.Explanation = "Send to connection for documents move to other record site collections."

    $WebApp.OfficialFileHosts.Add($SPOfficialFileHost); 

    $WebApp.Update()

}



write-host "Loop through all receiver site collections."
foreach ($rSite in $RecordCenterSiteColls)
{
    $fullSiteURL = $WebApplicationURL + "/sites/" + $rSite
    $sendServiceURL =   $fullSiteURL + "/" + $ServiceURL
    write-host "Send service URL - $sendServiceURL"
    AddSendToConnection $sendServiceURL $rSite
    write-host "Succesfully added Send To Connector for $rSite"
}

write-host "Completed"

Export Content Types using PowerShell - SharePoint

2018-01-11T15:58:00.001-05:00


clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell
####################### ENVIRONMENT VARIABLES #######################
$contentTypeSourceWeb = "http://webapp/sites/contenttypehub" #Site Collecton
# The exported content type is stored in the XML file
$xmlFilePathForContentType = "C:\Script-SiteContentTypes.xml" 
#####################################################################

#Content Type group you are looking to export
$contentTypeGroupName = "Custom Content Types"
$sourceWeb = Get-SPWeb $contentTypeSourceWeb

#Create Export File
New-Item $xmlFilePathForContentType -type file -force
#Export Content Types to XML file
Add-Content $xmlFilePathForContentType "<?xml version=`"1.0`" encoding=`"utf-8`"?>"
Add-Content $xmlFilePathForContentType "`n<ContentTypes>"
$sourceWeb.ContentTypes | ForEach-Object {
    if ($_.Group -eq $contentTypeGroupName) {
        write-host "Adding content type to file."
        Add-Content $xmlFilePathForContentType $_.SchemaXml
    }
}
Add-Content $xmlFilePathForContentType "</ContentTypes>"
$sourceWeb.Dispose()
write-host "Completed"

Largest FREE Microsoft eBook Giveaway!

2017-12-30T18:16:00.003-05:00

https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/

ASP.Net Core 2.0 Free Ebook PDF

2017-12-30T18:10:00.000-05:00

https://www.microsoft.com/net/download/thank-you/aspnet-ebook

Enable Wifi on Ubuntu Machine

2017-11-19T19:43:00.002-05:00

Issue: The wifi is not working on Ubuntu machine. The network options shows
'Wifi Disabled'

Solution:
1. Make sure your hardware wifi switch is enabled. Usually from keyboard you should be able to switch it on using Wifi symbol key (or with combination of function key and wifi key)

2. To verify if the wifi is blocked by hard or soft switches, you can by running th below command from terminal

Command:
user@machine:~$ rfkill list all
Output:
0: phy0: Wireless LAN
   Soft blocked: no
   Hard blocked: no
1: brcmwl-0: Wireless LAN
   Soft blocked: no
   Hard blocked: no

The output shows if soft or hard switches are blocking. If all of them shows no as shown above, that indicates that all look good. If not then see which one shows yes and use the below command.
Command:
user@machine:~$ sudo rfkill unblock all
Enter password and this will unblock the soft switch

If option 'hard blocked' in the output shows yes, that means the machine wifi hardware is disabled and you can enable it as described in point 1 above.

Citrix Receiver (.ica) does not launch

2017-06-21T10:39:00.002-04:00

Issue: The Citrix Receiver file (lunch.ica) does nothing after clicking on it

Solution:
1. Go to default programs with the path: Control Panel\All Control Panel Items\Default Programs
2. Click on “Associate a file type or protocol with a program” as depicted below:

3. Locate .ica file in the loaded extensions, select it, and click on ‘Change program’ option as depicted below:

4. Click ‘Look up for the program in pc’ and when the browse popup is open provide the path for wfcrun32.exe

Note: Usually if the Citrix was installed in C drive then the path of the program will be like below:

C:\Program Files (x86)\Citrix\ICA Client\wfcrun32.exe

5. With the association of the above exe for .ica files, the citrix receiver should open the file properly now.

Files\Java\jdk1.8.0_131) was unexpected at this time.

2017-06-02T13:46:00.002-04:00

The possible issue could be related to the JAVA_HOME environment variable value. If the value is referring to a path like below you will most likely get this kind of error.
Ex:
C:\Program Files\Java\jdk1.8.0_131

Solution (that worked for me):

1. Change the JDK path as provided below:
C:\Program~1\Java\jdk1.8.0_131

Note for Windows users on 64-bit systems

Progra~1 = 'Program Files'Progra~2 = 'Program Files(x86)'

Please refer the below link knowing more about setting the JAVA_HOME.
Site Link: Set JAVA_HOME

CSS3114: @font-face failed OpenType embedding permission check. Permission must be Installable (Google Fonts Offline)

2017-02-03T21:25:00.003-05:00

Error: CSS3114: @font-face failed OpenType embedding permission check. Permission must be Installable

Solution: Add mimemap to web.config file under <system.webServer> section

Script:

<staticcontent>
      <remove fileextension=".woff"/>
      <mimemap fileextension=".woff" mimetype="application/octet-stream"/>

</staticcontent>

Creating Self Signed Certificate with MAKECERT.EXE - ( HTTPS SHA256)

2017-02-03T21:08:00.000-05:00

1. Find MakeCert.Exe in your machine, the path depends on the OS. If you have VisualStudio, open the Visual Studio Command Prompt and run the below scripts.

Script:

#1. Root Cert
makecert -r -n "CN=IPMRootCert" -pe -sv IPMRootCert.pvk -a sha1 -len 2048 -b 01/01/2014 -e 01/21/2050 -cy authority IPMRootCert.cer
pvk2pfx.exe -pvk IPMRootCert.pvk -spc IPMRootCert.cer -pfxIPMRootCert.pfx

#2. Project Cert
makecert.exe -iv IPMRootCert.pvk -ic IPMRootCert.cer -n "CN=cissipm.ed.gov" -pe -sv cissipm.ed.gov.pvk -a sha1 -len 2048 -b 01/21/2010 -e 01/21/2050 -sky exchange cissipm.ed.gov.cer -eku 1.3.6.1.5.5.7.3.1
pvk2pfx.exe -pvk cissipm.ed.gov.pvk -spc cissipm.ed.gov.cer -pfx cissipm.ed.gov.pfx

2. Script 1 above, creates the Root Certificate (three certs .pfx, .pvk, .cer). For Windows OS, import .pfx (To Personal) and .cer (To Trusted Root Folder) certificates using Cert Manager

3. Script 2 above, creates the project or application Certificate (three certs .pfx, .pvk, .cer). For Windows OS, import .pfx (To Personal) and .cer (To Trusted Root Folder) certificates using Cert Manager

Refresh FAST Search Certificate With PowerShell

2016-11-02T14:37:00.002-04:00

Question: How to refresh/re-apply a FAST Search Certificate in SharePoint 2010 Environment?

Solution: Apply certificate using PowerShell. The below code shows how to generate FAST Search certificate (self signed) and apply it in the environment.

Script:


###################################
# Apply Certificate to FAST
###################################

Clear
Remove-PSSnapin AdminSnapIn -ErrorAction SilentlyContinue
Remove-PSSnapin Microsoft.FASTSearch.PowerShell -ErrorAction SilentlyContinue
Remove-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

Add-PSSnapin AdminSnapIn
Add-PSSnapin Microsoft.FASTSearch.PowerShell
Add-PSSnapin Microsoft.SharePoint.PowerShell

write-host "Applying Certificate to FAST" -ForegroundColor Green
#Release worker processess with IISRESET
iisreset

stop-service FAST*

$installerdir = $env:FASTSEARCH + "installer\scripts"
echo $installerdir
cd $installerdir
$pw = ConvertTo-SecureString -AsPlainText -force test
.\ReplaceDefaultCertificate.ps1 -generateNewCertificate $true -certificatePassword $pw
$cert = @(dir cert:\LocalMachine\My -recurse | ? { $_.Subject -eq 'CN=FASTSearchCert' })[0]
$thumb = $cert.Thumbprint

Start-service FAST*

.\SecureFASTSearchConnector.ps1 -certThumbprint $thumb -ssaName "FAST Content" -username "domain\FastSearchAccount"

Convert VHD file to VHDX - Hyper-V

2015-12-16T17:33:00.001-05:00

Requirement: Convert VHD to VHDX using Powershell

Script:

 PS C:\windows\system32> Convert-VHD –Path "C:\Me\IE10 - Win7.vhd" –DestinationPath "C:\ME\My Machines\Windows 7 IE 10\Virtual Hard Disks\IE10 - Win7.vhdx"  
 PS C:\windows\system32>