Selecting distinct values from a JSON

 

eData is the JSON array

var items = eData.map((d)=> {return d.year})

var uniq = items.filter(GetUnique)

function GetUnique(value, index, self) { 
    return self.indexOf(value) === index;
}

Replacing SharePoint Designer with VS Code

“Replacing SharePoint Designer with VS Code”

- install VS Code

- Add extension SPGO to your VS Code

- Execute following 2 thing

------ Connect to workspace

Press F1 : write > SPGO Configuration Workspace

put the URL and some relevant default inputs

-- new SPGO.json file will be created something like:

{

  "sourceDirectory": "src",

  "sharePointSiteUrl": "https://domain.sharepoint.com/itBudget",

  "workspaceRoot": "f:\\SPApps\\itBudget",

  "publishWorkspaceOptions": {

    "destinationFolder": "/",

    "globPattern": "f:\\SPApps\\itBudget\\src\\**\\*.*",

    "localRoot": "f:\\SPApps\\itBudget\\src"

  },

  "publishingScope": "SaveOnly",

  "authenticationType": "Digest",

  "remoteFolders": ["/SiteAssets/Custom/js", "/Pages", "/SitePages"]

}

In case if SiteAssets folder is not getting downloaded, try to add the pattern "/SiteAssets/**/*"

Press F1 again: write > SPGO Populate local workspace

enter : registered EMail and Password.

Source found at following URLs

1) Replacing SharePoint Designer with VS Code Part 1: Setting up the Environment

2) Replacing SharePoint Designer with VS Code Part 2: Configuring SPGo in VS Code

3) https://marketplace.visualstudio.com/items?itemName=SiteGo.spgo

Unable to open SharePoint Designer Site

Unable to open SharePoint Designer Site

Remove all the content from following folders to avoid issue

• %APPDATA%\Roaming\Microsoft\Web Server Extensions\Cache
• %APPDATA%\Microsoft\Web Server Extensions\Cache
• %APPDATA%\Microsoft\SharePoint Designer\ProxyAssemblyCache
• %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache
• %APPDATA%\Microsoft\SharePoint Designer

Create QR-Code with VBA

Function to add QR-Code as image in your file.

Function Insert_QR(codetext As String)
	Dim URL As String, MyCell As Range

	Set MyCell = Application.Caller
	URL = "https://chart.googleapis.com/chart?chs=125x125&cht=qr&chl=" & codetext
	On Error Resume Next
	  ActiveSheet.Pictures("My_QR_" & MyCell.Address(False, False)).Delete 'delete if there is prevoius one
	On Error GoTo 0
	ActiveSheet.Pictures.Insert(URL).Select
	With Selection.ShapeRange(1)
	 .PictureFormat.CropLeft = 10
	 .PictureFormat.CropRight = 10
	 .PictureFormat.CropTop = 10
	 .PictureFormat.CropBottom = 10
	 .Name = "My_QR_" & MyCell.Address(False, False)
	 .Left = MyCell.Left + 25
	 .Top = MyCell.Top + 5
	End With
	Insert_QR = "" ' or some text to be displayed behind code
End Function

Excel To PDF with VBA

 

Sub ConvertExcelToPDF()

'Export Single Sheets

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="TrainingDeo",      OpenAfterPublish:=True

'Export Multiple Sheets

Sheets(Array("RemovingDuplicates", "HideUnhide", "ExportToPDF")).Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="TrainingDemo2", OpenAfterPublish:=True

Sheets("ExportToPDF").Select

Range("A1").Select

End Sub

Reference Code at YouTube

SQL Query to find all tables in a Database containing specified column name

Following query will help to find field name available in any of the table in a database.

SELECT * from INFORMATION_SCHEMA.COLUMNS 
where COLUMN_NAME like '%ColumnName%' 
order by TABLE_NAME



SQL Server:

SELECT Table_Name, Column_Name 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'YOUR_DATABASE'
AND COLUMN_NAME LIKE '%YOUR_COLUMN%'


Oracle:

SELECT owner, table_name, column_name 
FROM all_tab_columns 
WHERE column_name LIKE '%YOUR_COLUMN_NAME%'

AND OWNER IN ('YOUR_SCHEMA_NAME');

Sort JSON object Array

Sort JSON object Array

var array = [{ "No": "12", "Name": "Sameer Patel", "Training": "SharePoint" }, { "No": "2", "Name": "Syam Shah", "Training": "ASP.NET" }, { "No": "11", "Name": "Sunil Shah", "Training": "JAVA" }, { "No": "8", "Name": "Arun Nair", "Training": "Sql Server" }, { "No": "6", "Name": "Anil Patel", "Training": "C#" }]; //Sorting Function function SortBy(prop) { return function(a, b) { if (a[prop] > b[prop]) { return 1; } else if (a[prop] < b[prop]) { return -1; } return 0; } } //array.sort(SortBy("KeyName")) array.sort(SortBy("No"))