Technology tips: 2014

Sunday, October 19, 2014

As you know xml sitemap is a file based on xml tags giving url information of your site to web crawler like googlebot or bing bot etc.
If your site is hosted on web server and ideally you can create xml file using any
 Online xml sitemap generator and you could upload that file in .htaccess file  and that’s it you are done. You are ready with xml sitemap which you have created online and now you have told web crawler that hey my entire list of urls are there uploaded once you crawl browse them and display them to audience based on keywords.
But problem occurs when you are not using complete web server or let’s say you are using free hosting space where you have limited access to web server and actually you can’t upload any .htacess file. There is another way to tell web crawler about your index pages that is atom feed which is supported in blogger.

Submitting xml sitemap to blogger using Google webmaster only:

Ideally you can work with atom.xml or actually you can create that file by specifying its name atom.xml in google webmaster in order to create complete sitemap for blogger– so you don’t need to create any extra xml sitemap from other online sources etc- means where you will see date, time and modified xml tags in it.
So now we are assuming you have created xml sitemap type atom inside your blogger blog and fortunately you are dealing with custom domain as well.

People go somewhere if they want to generate xml sitemap blogger – you don’t need to go somewhere to get xml sitemap and do something with blogger. It’s a process of generating xml site map type atom using Google web master tool.
You are going to configure and create xml sitemap and configure it inside blogger using robot.txt which is used for customized entries-stopping Google to crawl some url.
Why we are using custom robot.txt file- because we don’t want some url to be crawled by Google or we don’t want to keep them in Google index. First you will generate xml sitemap using Google webmaster tool by entering simple atom.xml parameter in Google webmaster tool.

XML SiteMap for Blogger with custom urls:                      
Ideally your output could be one of the following:
http://www.sqlservermanagementstudio.net/atom.xml?redirect=false&start-index=1&max-results=500
http://mctscertification.blogspot.com/atom.xml?redirect=false&start-index=1&max-results=500 blog hosted on blogger
What you have done actually you have added atom.xml parameter using webmaster interface- in the sitemap section and added further parameters for all your blog posts to be indexed like in  the case above- these parameters can be used to index 500 url entries if you have 1000 or more posts entries in your blog so you can add them too – just define start index 501 and so on.
Now you have to test this sitemap too, you will do it in the same section in webmaster tool and you can define some posts that you don’t want to be indexed by Google and copy the entire chunk from there and go back to blogger.
Once you define and test your sitemap in webmaster robot.txt section so you will end up with the following chunk:

User-agent: Mediapartners-Google
Disallow:
User-agent: *
Disallow: /search
Allow: /
Sitemap: http://www.sqlservermanagementstudio.net/atom.xml?redirect=false&start-index=1&max-results=500

It's clearly mentioned above that your xml sitemap added as xml with 500 posts on blogger. Now you can add some more post url that you don’t want to be indexed in Disallow section and copy that above snipped and past in the blogger.
You are ready with your xml sitemap for blogger without visiting any other site -only webmaster tool and go to blogger dashboard point to setting and search preferences and past that snipped into this section called custom robot.txt. You are telling Google this is my full xml sitemap crawl and index site and there are some custom url entries.
Hope you enjoyed learning here.

Wednesday, July 23, 2014

If you are facebooker and spend a lot of time on Facebook but what if you don’t have time to read the entire post published by someone on Facebook and you wanted to keep it as bookmark, or sometimes you find places, links movies or any item on Facebook and wanted to explore them later.
Facebook recently introduced a save button that act like a bookmark to save your Facebook item to explore later on.
You can easily view any item that you have saved using save button from left navigation. Your saved item list is organized by category like post, link, places etc and you can click them later on if you want to explore them or you can share them with your friends later on.

How to save and unsaved Facebook item:

Step 1: You need to enable or add favorites saved button on your left navigation of Facebook canvas.
For this you tap into more application section from left navigation you will find saved button add it to the favorites.
Now would see a saved button with the functionality to save Facebook item to explore them later on this area would show you list of all item available that you have saved them as bookmark.

Step 2: Now you can browse anywhere if you find any post, link, places, event or movie you can save them if you want to explore them later.

If you find any post click on the bottom right of a post or click on down arrow ▼ beside the post
Once you finished doing this you would see item saved in your saved item area on left navigation.
You can browse all items you have saved to explore later and if you want to unsaved the post then click on bottom right corner of a post or down arrow ▼ beside post you would see unsaved post option click on it if you want to unsave the post.

How to add Facebook bookmark save button easily- this picture is for learning purpose only- photograph-Facebook

 Picture depicting above showing steps how you can display Facebook bookmark button easily in two steps to bookmark item.
This picture is for learning purpose only - browse the picture and follow the steps if you want to bookmark item like post,link, music, movie item on Facebook, first display Facebook saved button by clicking on Facebook app more area you will find saved button in application section of Facebook add it to favorites and you are done. And after this browse any post and click down arrow beside post to save it.

Sunday, May 4, 2014

People are rushing towards the android store for downloading diversified applications now a days, if you are just doing editing and updating docs and sheets and you have android phone or ios so you can do these types of activities using newly released application by Google called Google docs and Google Sheet which are used for editing docs offline and online too which is obvious.
If you have tablet with android so you can download these application easily just tap into app store and download both application Google docs and Google sheet for android tablet.
Likewise if you have android phone so can download these fantastic applications for editing documents and sheet.There are number of Excel like formulas are supported in spread sheet.
Google may be releasing presentation app for such phones and devices in future.

Now if you are working in any organization and wanted to edit docs and spreadsheet  using your smartphone or tablet and wanted to perform some spreadsheet calculation as well so you can do it using Google spreadsheet -
These are ideal update by Google for people who are trying to edit and update docs and sheet online or off line anywhere.




Tuesday, April 15, 2014

If you want to cut the cost of IT in terms of licensing so one thing is highly recommended which is you can consider purchasing sql server 2012 developer edition license for your test environment.
Actually SQL server 2012 developer version is full feature version by Microsoft for development and testing purpose only, this release is not for production. And eventually you are cutting cost in terms of licensing otherwise you have to buy all licenses for development and test environment but please note this- databases can't be deployed on production, - let’s say you have developed application based on SQL server and you want to test it so you can consider buying development version. Whereas Express edition is basic model of free version people has been using it but you can consider developer edition for such kind of need.
 SQL Server Developer version will help you learning sql server or ideal for sql server training – having  full feature without paying any cost and build full fledge database driven business application test it once you are confident with the result then you can invest in licensing.
What developer version includes or sql server developer edition limitations are - let me elaborate,  it includes sql server management studio, sql profiler etc, whereas SQL Express edition does not include such tools, Microsoft has released Express version because people thinks that it’s a replacement of MSDE.
Whereas SQL express edition is coming with limited functionality for example high availability is not found in express edition anyways. 
There is a difference between express edition and sql server developer edition ,  it only can be used with production environment whereas Developer edition cannot be used in inside production.

For example feature wise, SQL Server 2012 developer edition has same feature as SQL server 2012 enterprise server has.

You can buy SQL Server developer edition from Microsoft site easily, it also supported with sharepoint this means if you have SharePoint farm with sharepoint 2013 and sql server 2012 so can do this by adding a sql server developer edition into your development environment and make a farm for testing purpose.

Sql Server Developer version has analysis services, integration services, and other feature as you find them in sql server 2012 full version or the enterprise version.

If you think you can deploy it on production and take full advantages because it’s more like you are working with toy.

Only thing which is important to understand you cannot deploy databases in your production farms using sql server developer edition.

Saturday, April 5, 2014

If you come across with customized views in SharePoint so they can help you to design different views for users to view SharePoint data differently.
But when it comes to survey and that survey should be like SharePoint custom survey views so you probably face some difficulty in that because as standard functionality you won’t be able to find survey views in the specified section as you find it standard list.
How you can customize the survey as different view. This means that you probably want to display survey data differently to your users.
Here are simple to procedure if you follow so you can customize survey views for your users in SharePoint. We have designed these views in SharePoint 2007.

Procedure for SharePoint Custom Survey Views:

Procedure is very simple and straight forward to create a custom view for SharePoint survey list as mention  given below.

How to find Survey List ID:
First step to know the survey List id, and to get the survey list id is simple there are different ways to do that what we have done was that – just inside the survey tap Action menu and tap View RSS Feed, if you look at the URL you will find Survey ID similar to the following.
Here is sample survey list id:
List=%7BF5348760%2D133A%2D400B%2D81CE%2D9ED16FD81C3E%7D





How to display customize column for survey views:
Second thing you need to change the URL as the following with the list ID, just add the question mark as mention in the example below and past your survey id after that. So final url would similar to the following:

http : //sharepointURLwithport/_layouts/ViewType.aspx? List=%7BF5348760%2D133A%2D400B%2D81CE%2D9ED16FD81C3E%7D

Then you will see the screen will change to SharePoint customize survey view . From there you can select other fields to be added in your custom survey views like group by so users can view survey as group by and as other fields.
You need to enter name of the custom views survey in this step.

I hope this has resolved your issue related to custom survey list according to your need please let us know if you need any help from us.