Dish & Cable Channel Planner for India

TRAI has changed the rule for dish and cable channel tariffs so that consumer has the option of choosing channels which they view instead of the service providers forcing to choose the bundle.

The following excel will help you in planning.
You can click on “view full size workbook” button at the bottom right of the embedded excel or view the excel in full view at https://kannan.page.link/c6wA

  1. Go to “List of channels” sheet.
  2. Set values in column “Selection Order” as 1 or 2 or 3 etc. per channel based on your viewing priority.
  3. Go to “Pivot” sheet.
  4. Right click in the table area and press refresh.
  5. In “Selection Order” choose 1 and/or 2 and/or 3 instead of “All” based on your viewing priority.
  6. Scroll down and view the “Grand Total” to know the total price.

For latest pricing visit https://www.channeltariff.trai.gov.in/

EDIT: I just found out that TRAI itself has an web app which helps in determining the price using various choices. I urge you to visit the site https://channel.trai.gov.in/ and don’t forget to click that “Optimize” button at the top of the final pricing page.

Alternatives to “You are Welcome”

In my many years of IT service, one of the constant response I get from my customers are the “Thank You” note . Generally we respond back to them by writing “You are welcome”. But there are other few ways we can respond as well.

Positive:

  1. My pleasure
  2. I’m happy to help
  3. Anytime
  4. Don’t mention it

Neutral:

  1. You got it
  2. No worries
  3. Not a problem
  4. It was nothing
  5. Sure
Sharepoint 2013

SharePoint Online Data Restoration Timeline

SharePoint online has a data backup and restoration policy which for some users might be confusing. The following article will provide you a clarity to an extent.

In short a data can be restored within 108 days until unless it’s prematurely deleted by admin, in which case the data can be restore 14 days from premature deletion by admin.

User deleting a data:
When a user deletes a list item, or document library item or any site object, that deleted data is moved to a site’s recycle bin and stays there for 93 days or till user deletes it or site collection recycle bin quota exceeds.

User deleting a site recycle bin item:
When a user deletes an item from site recycle bin, that item is moved to site collections recycle bin. Only the site collection administrator will have access to this recycle bin. Here too the item stays there for 93 days from the date the user deleted it originally or till admin deletes it or site collection recycle bin quota exceeds.

Note:
Make a note that an item deleted by user will stay for 93 days regardless of it being there in site recycle bin (can be restored by user) or site collection recycle bin (can be restored by admin).

Admin deleting an item from site collection recycle bin/auto deletion:
Once an item is deleted from site collection recycle bin, it still can be restored if it’s available in the data backup by Microsoft
taken twice daily. Again this backup is available only for 14 days and SharePoint admin has to raise a support ticket.

Note:
When Microsoft restores the data, they will restore it as a whole site collection and not as individual item.

Pictorial Representation:

SharePoint Online Data Restoration Timeline
SharePoint Online Data Restoration Timeline

Source:https://kannan.page.link/XQFV


Get folder and files recursively in SharePoint using REST call

There was a simple requirement I came across for which a page should list all the files and folders in a SharePoint document library.

I came up with a solution using ODATA call. Following is the REST call I made to get the list of all folder and files.

/_api/web/Lists/GetByTitle(‘Documents’)/Items?$select=FileLeafRef,FileRef&$orderby=FileRef asc
Following is the code which quickly prints them out in a table. Just add this code to a script editor web-part.
Please make sure the URL is updated based on your site URL.

 

Enable tree view in current navigation within SharePoint

Sometime we need to enable tree view in current navigation to help navigate within document libraries.

Traditional Way:

Site Settings -> Look and Feel: Navigation Elements -> Check ‘Enable Tree View’

Programmatic way using PnP Powershell:

Disable ‘Allow items from this site to be downloaded to offline clients’ in SharePoint

Sometime we need to disable the “Sync” button in SharePoint document libraries and that can be done by the following methods.

Traditional Way:

Site Settings -> Search: Search and offline availability -> Set ‘Allow items from this site to be downloaded to offline clients?’ to “No”

Programmatic way using PnP Powershell:

Sharepoint disable drag and drop

In some scenarios we might need to disabled drag and drop in SharePoint sites.

The following code works when we need to disable a page with one document view.

Add the html code in content editor web part where the document view is there.

For pages with multiple document libraries when you want to target a specific library prepend the id of the web part div and an underscore e.g. WebPartWPQ4_

Source: https://sharepoint.stackexchange.com/questions/82805/how-can-i-disable-the-document-library-drag-and-drop-function

Open SharePoint Office documents in modal dialog

Sometimes we need Microsoft Office documents to be opened in dialogs instead of SharePoint’s default behavior which is opening the document in the same window or tab.

The following code helps in implementing this.

Note: This code only works for office documents. For pdf documents look at the previous article.

 

Open SharePoint PDF documents in modal dialog

Sometimes we need PDF documents to be opened in dialogs instead of SharePoint’s default behavior which is opening the document in the same window or tab.

The following code helps in implementing this.

Note: This code only works for PDF documents. For office documents look at the next article.

 

Displaying SharePoint’s “Please wait…” or “Working on it…” dialog box

The following code helps in displaying the “Working on it…” dialog box available in SharePoint 2013 or SharePoint Online.

Before you being the background operation, call the function “RequestStarted“. Once the background operation has been completed, call the function “RequestEnded“.

Source: Sharepoint Stackexchange

Get query string parameter using JavaScript

Following code will help in fetching the value of a query string parameter.

Usage:

If URL is http://server/page.html?id=1

Then usage would be GetQueryStringParameters(“id”) which would return 1