Show/Hide Hidden Files on macOS

Show/Hide Hidden Files the Long Way

The long way to show hidden Mac OS X files is as follows:

  • Open Terminal found in Finder > Applications > Utilities
  • In Terminal, paste the following:

    defaults write com.apple.finder AppleShowAllFiles YES
    
  • Press return
  • Restart your Mac

This will show all hidden files. To hide them again, follow the same steps but replace the Terminal command with:

defaults write com.apple.finder AppleShowAllFiles NO

It’s not the longest set of instructions or the biggest command to commit to memory but if you’re doing this a lot, it’s worth spending a few minutes now to save yourself a lot more time in the future.

The Essential Meta Tags for Social Media

These days, almost every website encourages visitors to share its pages on social media. We’ve all seen the ubiquitous Facebook and Twitter icons, among others, just begging to be clicked. This comes as no surprise as sharing via social media, the internet incarnation of word-of-mouth, is one of the most effective ways for businesses and individuals to gain awareness.

When users choose to share these links, it is tasked to the web developer to make sure that the associated web pages are properly prepared, which is what we’ll look at now. Facebook and Twitter are, by far, the most popular social media platforms, so let’s focus on those two.

Sharing on Facebook and Twitter

Facebook offers developers various options on how a shared web page appears in its timeline depending on the website’s content. Unless otherwise specified, every website defaults to the type called, appropriately, “website”, which is the example we’ll use.

Let’s say someone has shared the home page of a fictional travel company – Facebook displays it like this:

facebook-card

Twitter, as well, has multiple ways to format shared web pages that appear in its feed, but we’ll look at the one that’s quite similar to the above example from Facebook, which Twitter calls the “Summary Card with Large Image”:

twitter-card

As we can see, each features multiple attributes of the shared Web page:

  • a prominent image and title
  • a description
  • the domain name

Proprietary <meta> Tags

How do we specify these attributes? With <meta> tags. When a link is shared, both Facebook and Twitter scrape the associated web page and read its <meta> tags to display the appropriate information.

Facebook uses <meta> tags leveraging the Open Graph protocol, a classification system for Web pages that extends beyond those <meta> tags already defined in HTML5. A complete list of <meta> tags available can be found at the Open Graph Web site. There are so many from which to choose that it can be somewhat intimidating, but only four are actually required:

<meta property="og:title" 
      content="European Travel Destinations">
<meta property="og:description" 
      content="Offering tour packages for individuals or groups.">
<meta property="og:image" 
      content="http://euro-travel-example.com/thumbnail.jpg">
<meta property="og:url" 
      content="http://euro-travel-example.com/index.htm">

Twitter has its own <meta> tags that are similar to the Open Graph protocol, but uses the “twitter” prefix instead of “og”. As with Facebook, only a few are required. The type of display format we’re requesting from Twitter is also specified:

<meta name="twitter:title" 
      content="European Travel Destinations ">
<meta name="twitter:description" 
      content=" Offering tour packages for individuals or groups.">
<meta name="twitter:image" content=" 
      http://euro-travel-example.com/thumbnail.jpg">
<meta name="twitter:card" 
      content="summary_large_image">

Reconciling <meta> Tags

There’s no harm with having multiple tags that appear redundant. Too much information never hurt anyone except by adding a few extra bytes to the HTML file.

But for our purposes, and for the sake of brevity, we can leverage the fact that Twitter allows us to substitute Open Graph <<meta> tags for its own. In the end, except for the necessity of specifying a display format, none of the custom Twitter <meta> tags are needed. This gives us the following, which could be considered the bare minimum of tags necessary to make a web page amenable for sharing on social media:

<meta property="og:title" 
      content="European Travel Destinations">
<meta property="og:description" 
      content="Offering tour packages for individuals or groups.">
<meta property="og:image" 
      content="http://euro-travel-example.com/thumbnail.jpg">
<meta property="og:url" 
      content="http://euro-travel-example.com/index.htm">
<meta name="twitter:card" 
      content="summary_large_image">

Reconciling the guidelines for the image is simple: follow Facebook's recommendation of a minimum dimension of 1200x630 pixels and an aspect ratio of 1.91:1, but adhere to Twitter's file size requirement of less than 1MB.

Validating <meta> Tags

If there are any doubts about the legitimacy of paring down to these five tags, we can use the helpful Facebook Sharing Debugger and Twitter Card Validator. Both these tools will scrape any Web page hosted on a public server for relevant <meta> tags and display how it would look when shared. It will also list any errors and provide suggestions. So how did we do with our particular example? Twitter seems fine with things, but Facebook, on the other hand, lists one item as a warning:

facebook-warning

Social Media Analytics

What Facebook is indicating is that if you’re going to use their analytics tool, which they call Domain Insights, you must provide the unique ID number associated with your account. The <meta> tag would then look something like this:

<meta property="fb:app_id" content="your_app_id" />

Twitter has something similar that they call Twitter Card Analytics. To get the most out of this tool, Twitter recommends using the following <meta> tag that contains the Twitter username that you want associated with the shared Web page:

<meta name="twitter:site" content="@website-username">

Keep in mind, though, that if you have no particular interest in using these analytic tools, then omitting the above two <meta> tags has no effect on how a shared Web page appears on a Facebook timeline or Twitter feed.

What else?

Facebook documentation recommends one additional <meta> tag, though it’s not required. A <meta> tag that denotes the name of the Web site in which the shared page resides:

<meta property="og:site_name" content="European Travel, Inc.">

Twitter suggests one other <meta> tag as well that is recommended, but not required:

<meta name="twitter:image:alt" content="Alt text for image">

This provides an alternative image description for those who are visually impaired.

Final Markup

That should do it. To reiterate, when you look at documentation from Facebook and Twitter for sharing Web pages, there are many other <meta> tags available that can be used to specify different types of content. But, in general, the following will suffice:

<!--  Essential META Tags -->
<meta property="og:title" 
      content="European Travel Destinations">
<meta property="og:description" 
      content="Offering tour packages for individuals or groups.">
<meta property="og:image" 
      content="http://euro-travel-example.com/thumbnail.jpg">
<meta property="og:url" 
      content="http://euro-travel-example.com/index.htm">
<meta name="twitter:card" 
      content="summary_large_image">

<!--  Non-Essential, But Recommended -->
<meta property="og:site_name" 
      content="European Travel, Inc.">
<meta name="twitter:image:alt" 
      content="Alt text for image">

<!--  Non-Essential, But Required for Analytics -->
<meta property="fb:app_id" content="your_app_id" />
<meta name="twitter:site" content="@website-username">

Happy coding!

How to capitalize the first letter in a cell in Excel

If you’d like to capitalize all letters in a cell, it’s easy – just use the following formula (assuming cell A1 has the text you want to capitalize).

=PROPER(A1)

But what if you just want to capitalize the first word in the cell “A1”? For example, you have the following  text in a cell “A1” and you’d like to capitalize just the first letter:

How to have the First Letter of a sentence Capitalize

To capitalize “How” in cell “A1”, use one of the following formula:

=REPLACE(A1,1,1,UPPER(LEFT(A1,1)))

or

=CONCATENATE(UPPER(LEFT(A1,1)),RIGHT(A1,LEN(A1)-1))

The result:

How to have the first letter of a sentence capitalize

Not working for you?

Remember to replace A1 with the cell that contains the string of words you want to parse out.

Howto: Generate many files of a particular size in Windows

I shoud find a simple way to generate a file of exact size. Finally I found this command in the Prompt of Windows (Windows10 in my case but it presents in the previous version of Windows)

fsutil

The syntax for using for this purpose fsutil is:

fsutil file createnew filename filesize

I used a simple loop to create files of a particular size using fsutil. Running from a command prompt:

For creating a file of 1 Mb you can type

fsutil file createnew C:\Users\e.rossini\1024kb.txt 1048276

Happy coding!

How to Get Access to WindowsApps Folder in Windows 10

Just like almost all the programs, Windows App installation files are also stored in the Program Files folder in your C drive.

windowsapps-folder-programfiles

However, the folder is hidden from plain sight. To see the folder, head over to the Program Files folder, click on the “View” tab and then select the “Hidden Items” checkbox.

windowsapps-folder-check-hidden-files

This action will show you all the hidden folders including the “WindowsApps” folder.

windowsapps-folder-windowsapps

Though you can see the folder, you cannot open the folder to see the files in it. If you try to open it, your access will be denied even if you are the administrator.

windowsapps-folder-access-denied

To get access to the WindowsApps folder, right-click on the folder and then select the “Properties” option from the list of context menu options.

windowsapps-folder-select-properties

The above action will open the Properties window. Here, navigate to the Security tab and click on the “Advanced” button appearing at the bottom of the Window.

windowsapps-folder-select-advanced

Once the Advanced Security Settings window has been opened, click on the “Change” link. You will receive a UAC (User Access Control) prompt. Simply click on the button “Yes” to continue.

windowsapps-folder-click-change

Now the window will show you all the permissions of the WindowsApps folder. As you can see, this folder belongs to the system, thus you are not able to access it. To change it, click on the “Change” link appearing next to “TustedInstaller.”

windowsapps-folder-click-change-again

The above action will open the “Select User or Group” window. Here enter your administrator username and click on the button “Check Names.’ This action will automatically fill in the object name. Now, click on the “Ok” button to continue.

windowsapps-folder-enter-username

Here in the main window you can see the that the owner of the folder has been changed to your specified administrator account. Before applying the change, make sure that the “Replace owner on sub containers and objects” checkbox is selected. Otherwise you won’t be able to interact with other files and folders inside the WindowsApps folder.

After you’ve done everything, click on “Ok” button to save the changes.

windowsapps-folder-apply-permission-changes

As soon as you click on the Ok button, Windows starts to change the file and folder permissions. This process may take some time, so sit back and wait until the process is completed.

WIndows_Security

Once the file and folder permissions have been changed, you can easily access it like any other folder in the Program Files folder as long as you are an administrator or have administrator rights.

windowsapps-folder

Do comment below sharing your thoughts and experiences about using the above method to get access to WindowsApps folder in Windows 10.

How To Setup Native Bash On Ubuntu On Windows 10

Alright, this post is for our developer friends only: the latest Windows 10 Insider Preview Build – build 14316 – includes the much-hyped Bash shell from Ubuntu. What’s the Bash shell, and how can you start using it in Windows 10? Find out after the bump.

Start Using Bash In Windows 10

bash-cmd

As of typing this post, you need to be a Windows Insider running Insider Preview Build 14316 on your Windows 10 PC to be able to execute Bash commands and scripts. If you’ve met these requirements, you’re good to go.

Here’s what you need to setup Bash on Ubuntu Linux on Windows 10: first, go to Settings > Update & security > For developers and enable Developer Mode; second, search for Windows Features, and from Turn Windows features on or off  go ahead and enable Windows subsystem for Linux (beta); third and final, open the Command Prompt and type bash to install it. That’s it!

We will update this post later on when Microsoft releases this feature to the general public as part of the Anniversary Update later this year. Until then, happy scripting!

What is Bash, and why is it on Windows 10?

Bash_screenshot

Bash is a hugely popular shell and command language that runs just below the Command Prompt, and it accepts a different, and much more accepted set of commands and scripts. Bash is popular on Linux and OSX where it serves as the primary command line language.

Windows is quite late to the party, but developers are happy because this means they’ll be able to use all their favorite, powerful Bash commands and scripts in Windows 10.

People have made a big deal out of Bash on Windows 10 because in order to bring Bash to their operating system, Microsoft had to develop a Linux subsystem just for Windows. So, in running Bash natively on Windows 10, you are – in a way – running Linux on Windows 10. That’s a big deal!

How to reinstall Office 2010 without the installation DVD

If you need to reinstall your Microsoft Office 2010 software but do not have the installation discs, you can download the software or order a backup DVD from the Microsoft Office 2010 website.

To download a backup copy of Office 2010

  1. Locate your 25-character Microsoft Office Product Key. You will find the product key on the original product package, on a Product Key Card sent with your computer or in your Order Confirmation email.
  2. Go to the Get a backup of Office 2010 web page and click the Download button.
  3. Enter your Office 2010 product key. You will be given the choice to download the software or order a DVD copy for a fee.
  4. Once the software is downloaded, double-click the downloaded file and follow the on-screen instructions to install and activate your software.

Check if URL exists, is so then return true

Hi everyone, I'm hoping someone can help with this function. it will check if a URL exists. If it does, would like it to return true and if it does not, then false.

Function Test_URLExists()
  Dim url As String
  
  url = "http://www.puresourcecode.com/"
  MsgBox url, vbInformation, URLExists(url)
  
  url = "http://www.puresourcecode.com/showthread.apx?t=1"
  MsgBox url, vbInformation, URLExists(url)
End Function

Function URLExists(url As String) As Boolean
    Dim Request As Object
    Dim ff As Integer
    Dim rc As Variant
    
    On Error GoTo EndNow
    Set Request = CreateObject("WinHttp.WinHttpRequest.5.1")
    
    With Request
      .Open "GET", url, False
      .Send
      rc = .StatusText
    End With
    Set Request = Nothing
    If rc = "OK" Then URLExists = True
    
    Exit Function
EndNow:
End Function

Happy coding!

Skype tag

<meta name="format-detection" content="telephone=no">

<meta name="SKYPE_TOOLBAR" content="SKYPE_TOOLBAR_PARSER_COMPATIBLE">

Twitter tag

<meta name="twitter:site" content="@erossinits">

<meta name="twitter:creator" content="@erossinits">
<meta name="twitter:card" content="summary">

<meta name="twitter:domain" content="http://www.puresourcecode.com/">

<meta name="twitter:title" content="PureSourceCode">

<meta name="twitter:description" content="Only pure source code for you">

Advertsing

125X125_06

Calendar

<<  November 2017  >>
MonTueWedThuFriSatSun
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar