Thursday, August 23, 2018

Clear Asp.Net Temp Folders and Files using bat file

Per best practices we should clean VS temp folders to speed up build/debug sessions for VS IDE. as noted e.g: here
Works on Win 7+

REM Files
del /f /q "C:\Users\%USERNAME%\AppData\Local\Microsoft\WebSiteCache\*.*"
del /f /q "C:\Users\%USERNAME%\AppData\Local\Temp\Temporary ASP.NET Files\*"

REM Folders
for /d %x in ("C:\Users\%USERNAME%\AppData\Local\Microsoft\WebSiteCache\*") do @rd /s /q "%x"
for /d %x in ("C:\Users\%USERNAME%\AppData\Local\Temp\Temporary ASP.NET Files\*") do @rd /s /q "%x"

Tuesday, August 21, 2018

SSRS SharePoint Integrated Mode Report Migration to Azure O365 SPO Options

References:

https://technet.microsoft.com/en-us/library/sharepoint-online-service-description.aspx#bkmk_tableo365

https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1

http://mitrai.com/tech-guide/ssrs-report-server-configuration-on-azure-virtual-machines/

http://www.axioworks.com/2018/08/display-sql-server-reporting-services-reports-in-sharepoint-online/?utm_source=collab365&utm_medium=collab365today&utm_campaign=daily_digest

Support Matrix

Summary of Options:

Option 1: Preserve SSRS Reports:

Migrate from On-Prem SSRS to O365 SSRS

Benefit: Preserve RDL’s, do not have to re-develop reports

Disadvantage: O365 SPO does not support SSRS Integrated Mode, Need new or add an SSRS app server instance, possible difficulties with SSO between O365 and SSRS

Option 2: Replace SSRS Reports :

Replace RDL Report with SharePoint Excel Services, PowerBI or equivalent.

Benefit: Implement reports using new technology, integrated with SPO, reduced migration strain of not needed addiitonal app server,

Disadvantage: Re-code from scratch each report, risky.

Details:

Option 1: Keep SSRS: Migrate from On-Prem SSRS to O365 SSRS

1. Document SSRS App Server Migration:

From
Product: SSRS
Environment: OnPrem
Mode: SharePoint Integrated Mode
Version: SQL Server 2012 SP1 : Detected on Report View Web Part: Version=11.0.3000.0

Product: SSRS
Environment: OnPrem
Mode: Native
Version: SQL 2016(?, TBD)

2. VM Hosting Environment Migration:

a. Create Azure SSRS VM

i. New Azure VM:

1. Install SQL Server

2. Install / Config SSRS per this ref

ii. Existing Azure VM with SQL Role:

1. Enable SSRS

2. Configure SSRS Instance per section Configure Sql Reporting Service

b. Azure SSRS Native instance is online!

i. https://[host]/ReportServer/

3. OMS Report Site and Report Migration : Migrate the OMS RDL from OnPrem SSRS Integrated to Azure SSRS Native

a. Publish Reports to Azure SSRS Native:

i. Migrate the RDL from OnPrem SSRS Integrated to Azure SSRS Native

ii. Download RDLs from https://iportal.seacorholdings.com/reports/OMS%20Reports
iii. Create VS.Net BI sln to enclose
iv. Upload the RDLs to Azure SSRS Native per this reference, section To Create and Publish Reports to the Azure Virtual Machine
b. OMS Report Site : Create OMS Reports in SharePoint Online :
i. Create “OMS Reports” sub site

4. Integrate Azure SSRS Native and O365 SPO

a. Integrate Reports from SSRS Azure into SPO
b. Add SharePoint Site Page with PageViewer per this ref

5. Concerns:

1. SSO from Azure SSRS to O365 SPO
2. Lack of SharePoint
Option 2: Replace SSRS Reports :
1. Develop New Reports to replace OMS
a. Convert to Excel
i. https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1
b. Rewrite RDLs as SPO Excel Services
c. Rewrite RDLs as Power BI Desktop
d. Publish Reports to SPO OMS Reports Site

Option 2: Replace SSRS Reports :
1. Develop New Reports to replace OMS
a. Convert to Excel
i. https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-show-ssrs-reports-in-sharepoint-online/1d94a167-6ac7-49f3-9201-c6d04df4ff9a?auth=1
b. Rewrite RDLs as SPO Excel Services
c. Rewrite RDLs as Power BI Desktop
d. Publish Reports to SPO OMS Reports Site

Monday, August 20, 2018

SharePointOnline Workflows: SharePoint Designer Workflows Send Email from 2013 and 2010 Platform Workflows

Some constraints to be aware of when sending emails from SPD WF’s:

1) SP2010 Platform can send email to outside domain recepients (e.g: @gmail.com)

2) SP2013 Workflows on SPO do not throw an error when sending email to outside domain recepient, while OnPrem does throw an error

Some rules to follow:

1) if email is to be sent outside domain recepient, use SP2010 Platform workflow, call that SP2010 WF from a 2013 WF.

2) Make Sure to use “As String” or “Email Address”, do NOT use “Email Address as Semi Colon Delim” unless all users are SP site users in the Email action.

In a SPD 2010 WF:

Wednesday, August 15, 2018

Disable Google Mic Listening : Phone and Chrome Browser Settings

1. Disable Phone Mic from Google

The first is to turn off the OK Google detection on your phone, which you can do by performing the following:

Android 7+

1. Open Google app on phone

2. Settings

3. Voice Match

4. Turn off “Access with Voice Match”

or (older phones)

Open Settings on your phone and enter the Google category.
Select Search under Services.
Next, tap Voice.
You’ll see a Voice Match entry; this may also be listed as “OK Google” detection. Tap that.
Disable the Say “Ok Google” any time slider. You may also want to disable While driving to prevent it in Google Maps and Android Auto, though it is convenient in those scenarios.

Once you do this, Google Assistant will only respond to OK Google when you have the Google app open (or when on the home screen of a Pixel or Nexus device). Your phone thus will no longer always be listening for the hotword.

2. Disbale Chrome Mic access (Desktop)

you can deny the Google app permission to access your microphone: (reverse this when U need Mic access from browser)