Adding META Keyword Dynamically in Blogger

Hi,

Welcome back to our Blogger Tutorial series. Most of the blogger have good knowledge of SEO. They have used various blogging platform and use different plugin for SEO enhancement. Search Engine Optimization, commonly known as SEO is a method or way or process of effecting the visibility of your website among different Search Engines for better traffic and ranking. There are many paid advertisements among different Search engine but they are not considered part of SEO.

Whatever they do, coming back to our topic, we are talking about Keywords. META description and Keyword are the best approach for search engine. META description show the excerpt of your post or blog while searched. And Keywords are useful to match with the query text from user in search box. Lets illustrate using below graphical presentation.

But if you are using Blogger, there is no plugin for making your blogs SEO better, you have to do it yourself. If this article, I will tell you, how to add META Keywords dynamically according to post in your Blogger blog. You can set static keywords by modifying template code in simple steps but adding dynamic content is somehow tricky. 

Dynamic Meta Keywords

Lets move to work. Start with logging into blogger. Points are described step by step.

1. Click in Template Link in Left side.
2. Click on Backup / Restore button at right corner.
3. Click on Download Full Template and save at safe place. In case something goes wrong, you will need this before cursing me.
4. Now click in Edit HTML button just below snapshot preview of your blog template.
5. Search in Template using CTRL+F and find for keywords.
6. If there is already a link containing Meta Keyword, replace its value with below one or if there is no keyword then search for </title> and add below line just below that.

   <b:if cond='data:blog.metaDescription != ""'>
        <meta expr:content='data:blog.pageName + ", " + data:blog.title' name='Keywords'/>
   </b:if> 
   

7. Save your template.

If you have following all steps I mentioned, congratulation you have successfully set your post title as keyword in Blogger. You can check this by viewing source code in your browser.

In our next post in this series, we will be discussing about how to add Labels in Blogger Meta Keyword section dynamically? Till then, keep reading. Do not forget to share or provide feedback.

All the Best.

+John Bhatt 

Read More

Torrent : Disadvantages and Controversies

Hi,

In a previous post about Torrent, I have explained working mechanism and origin of BitTorrent protocol and its use. If you missed, you may want to read that post at http://www.pyarb.com/2014/01/introduction-to-torrent.html. We also learnt about the advantages of Torrent and shared some snapshots also.

Now on continuation of that series, lets talk about its dis-advantages.

Disadvantages:

Torrent has many advantages like saving of time, peer to peer distribution, advance download experience for slower connection, it has many disadvantages too. Some of its dis-advantages are as listed below.

1. No one can tell what is inside file until he finish downloading. Suppose creator told that it is Linux distribution with of Ubuntu's latest version and named file as resembling one. But no one can guaranty what is inside file actually until user finished downloading and open file. In case of illegal content or provider did not supplier any hash or MD5 sum over public, it can not predetermined. 
2. For the first time, seeder must be online and seeding until the torrent gets popular. Or he must be always online to serve file and that too with higher internet speed. If he left in between, no one will get the file and users who downloaded some part will stuck at that point.
3. Internet speed and computer performance is used by Bit-torrent protocol. Mostly upload speed of Internet is used to serve file and which may cause other services that depends on Internet to freeze.
4. If the distribution has started once, it is hard to stop. If file gets popular and seeder thinks of stopping the distribution, it is impossible to stop until all users downloading torrent stop. That does not remains the property of creator.
5. Un-authorized distribution has created a very big loss to most Software, Game, Movies and Music vendors. Some of users who paid for it distributed file over Internet using Torrent and that gets popular within minutes. Which caused loss in business. Many copyrighted materials are licked and distributed. Sometimes, the content is hijacked and distributed creating huge financial loss and reputation damage intentionally.
6. The speed can not be stable (in most cases it is slow) and predetermined, depends upon the number of Seeders but that can not guaranty the speed. 
7. File is served in pieces from different servers, so sometime result may be damaged or corrupted file.
8. You can not use Download Managers or Accelerators to increase speed. 
9. Source of media (file) is unrestricted. Illegal content hosting is very cheap and reliable using Torrent. If you own a website and host a copyrighted file, your web host may send you notice and if you do not stop your account may be suspended, but while using Torrent, no one is there is to stop except your ISP (Internet Service Provider).
10. Torrent has great role on increasing Pornographic content over internet.
11. If you are using Static IP to use Internet, there is privacy concern. Everybody downloading that torrent file can see your IP address and know what you are downloading.
12. You must have a good Antivirus program, because sometime the torrent comes with Virus.
13. The original content can not be altered once after serving started. For new versions or modified files you must create another torrent and share this While in case of direct download if the file changes in server, all users will get newer file automatically.

There are many other dis-advantages in case of Bit-Torrent system. You can add your own.

Controversies

Torrent has been always in Controversies since its early age. However it was created with a good motive, but it was being used to distribute copyrighted, paid, legal and sensitive data free of cost. Which caused lots of reputation and business loss to Software giants and specially Multimedia productions like Sony, Warner Bros, Universal and other many. The users uploaded the Paid Blue Ray discs or DVDs of movie and songs to torrent community causing birth to unstoppable piracy.

Some of the countries and authorities have declared Torrent safe and good while some other authorities put restrictions over torrent. Resulting many of the torrent site to legal threats and court cases. The most controversial website related to Torrent is ThePirateBay, TPB in short. TPB was founded by a Swedish group of members who are against copyright matters and want the content over internet to be shared free of cost. Which resulted them Lots of Penalty, many legal cases in different courts over globe, ban of their website on most countries. Instead of stopping their service, they started to display legal mails from Different high profile companies like Microsoft, Apple, Universal Studio and so many in their website publicly. Members who supported TPB including web hosting company and financier are also jailed for some month due to these controversies. Their server was attached multiple time by Internet authorities and other hackers who are against Torrent. But they are still stand and serving contents regularly. 

Other some top website examples are Supernova, TorrentSpy, Demonoid, etc which are on controversies due to serving Torrent file or indexing them.

If you have any suggestions of feedback about the post and our contents, do write us as comment or contact page. Till then keep visiting.

+John Bhatt 

Read More

Text Functions : Microsoft Excel Part-1

Hi,

After some gap, I am back with Excel Tutorials . Lets learn Microsoft Excel in depth and work with functions. In this post, I am going to discuss all of the text functions with examples.

Function

Some of the best and one line definitions of Function are as below.

• A function is a block of code that performs a calculation and returns a value.
• We define a function as a special type of binary relation.

In short, function is a piece of code that is programmed to perform specific task. There are also some functions in Microsoft excel which can be easily implemented to get better and correct output in timely manner. The most useful and important feature of Microsoft Excel function is, they update their value automatically if any of the parameter (cell value) changed. We need not to change or update the cell which contain formula. Even we can protect the cell which contain formula so that, no one can alter the formula in shared document. Functions in Excel are divided in many category according to their use and working nature. Some of them are Text, Date & Time, Logical, Maths & Trigonometry, Engineering etc.

Text Functions

We will be talking about text functions in this post.
Why we call these functions text function?

Clear, they work with text, they can manipulate text cells, they can process normal text. 

The complete list of all text functions is as below. The new functions are added as part of user requirement and improvement in newer version of Microsoft Office.This list is taken from Microsoft Office 2003, so all later versions of Microsoft Excel (2007, 2010, 2013) will work and procedure will be same for all.

1. BAHTTEXT()
2. CHAR()
3. CLEAN()
4. CODE()
5. CONCATENATE()
6. DOLLAR()
7. EXACT()
8. FIND()
9. FIXED()
10. LEFT()
11. LEN()
12. LOWER()
13. MID()
14. PROPER()
15. REPLACE()
16. RIGHT()
17. SEARCH()
18. SUBSTITUTE()
19. T()
20. TEXT()
21. TRIM()
22. UPPER()
23. VALUE()
    Functions added in Microsoft Office 2013.
24. NUMBERVALUE()
25. UNICHAR()
26. UNICODE()

I will be discussing the use of these function in detail on next post. Till then keep digging.

Do not forget to share if you find this post helpful. If you have any comment, please leave and let us know.
John Bhatt

Read More

[Solved] Music Library not showing in Music App (Windows 8)

Hi,

I have been using Windows 8 since its early release. I have downloaded Developer Preview in November 2011. I am not sure after that how many times I have installed Windows on my Computer and upgraded its version to Consumer Preview, Release Preview, Windows 8, Windows 8 Pro, Windows Blue Preview, Windows 8.1, Windows 8.1 Pro. Might be due to many installation and security (encryption and decryption, consequent owner-user change) there must be some loss in system volume information file of of hard disc partitions.

Problem

The actual problem has arise after last upgrade. Music App in Windows 8 has left showing songs that is stored in hard disc of computer. I have tried several methods that are suggested and logical.

Situation

Out of 500 GB hard disc, approx 250 GB is filled with Videos (movies) and approx 20 GB is filled with music. Rest of space is consumed by software and other documents. So the 50 GB partition is assigned to Windows and this is the partition which is formatted frequently.

Failed Trials

However, I love Windows Media player and use this as default but being a tester, I never gave up to find the reason behind not listing of library content. I have tried following tricks or methods to solve this problem. 

• Un-installed application and installed from Store.
• Cleared all temporary data for application and restored its setting.
• Changed location setting to United States or United Kingdom but none of them worked.
• Changed Microsoft Account to local account.
• Re-installed windows using Clean format.
• Many more tricks that are suitable as condition and found in various social sites or as suggested by Microsoft support personnels.

Actual Problem

While none of above trials worked, I got confused and search in depth about working mechanism of Music application. Then I opened Library setting in Media player and found a wired term, which got my attention. This is showing non responsive in front of library location. Then I searched and opened Search Indexing Options in windows 8. I tried to add the audio folder in indexing location but that drive is not showing there, so that did not worked too.

The Trick

When searching for that problem, somewhere over internet I found a solution. You want to know the trick huh....
Suggestion 1: Well solution is to delete your partition, format location and re-create the partition to get its state back as it was.
Suggestion 2: Reset permission, user from security settings in drive.
First is nearly impossible for me. After following many tricks, I finally came with some solution.

I did some trick, rather than deleting partition and formatting and getting its state back, 

I moved music data to another partition which was showing properly in Search Indexing option.

In Quick:

1. Check if you have added folder to music library. 
2. If first step is OK, then check the status in Windows Media Player> Right click on Music in left navigation (Library view) > Manage Music Library.
3. If this is showing non responsive then move files to other partition.
4. If showing OK or nothing special remark, type Indexing service in smart screen.
5. Open Indexing Service Options and click on modify to add your audio folder.
   
6. Close the Indexing Options screen once you finish selecting folders. This will solve your all problems.

Finally this solved the problem for now. 

But that was too hard when you have situation like mine.

Do not forget to leave comment.
+John Bhatt 

Read More

HTTP Error 500.23 - Internal Server Error in Visual Studio 2013

Hi,

I have installed Visual Studio 2013 in my system. Due to some problems, I got the release after few months. So I was excited to use it and taste its new features. One thing I like about Visual Studio 2013 is it has a theme which turns it like Visual Studio 2010, which was simply awesome.

HTTP Error 500.23

I opened a existing website and tried to run that website. The website was using ASP.NET framework 4.0. However, the website has no errors and working fine in previous version of Visual Studio. But when I started with debugging (F5), this produced following error.

HTTP Error 500.23 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Solution

I can not understand the problem in a single view, as it suggest to change some configuration different methods in things you can try section. While there is not handler configured in web.config system for Web Server. Instead there was no system.webServer node.
So I searched in Internet and found some suggestion to make changes in Application Pool setting in IIS Manager. I tried that too but that was also a failed trial. Then suddenly I got a click in my mind and tried a setting which worked immediately.
How can the change done in Internet Information Service (IIS) Manager reflect in Development server. When we run the website from Visual Studio it loads in development server instead of IIS. So we have to make change in Development server which will automatically solve all the problems.
I thought, some time you might have same situation and solution must be there before problem.
Step 1: Open visual studio and click in the name of Website Project currently opened. Click on Property pane

.
Step 2: Double click on Managed Pipeline Mode. This will toggle between Classic and Integrated Mode. You have to switch to Classic mode because the error was "An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode"

.
Now hit the F5 button, here goes output as usual.

You have solved the problem. If you find this post helpful, do not forget to share with friends or simply say thanks in comment below or you can share your feedback by leaving comment below.
+Prithvi Raj Bhatt 

Read More