Personal timeline for Asif Anwar.
Created by seoexpertbd on 03/11/2010
Last updated: 03/11/10 at 16:23
Tags: asif anwar SEO
A few years back, when you landed on your friend’s profile on Facebook, you could see only the mutual friends you have. Then in recent change, Facebook also introduced the common “Likes” you have with your friend.
But, at the day of Halloween, Facebook brought in a new feature that highlights almost all the mutual activities, events, and interaction with your friend in a nice looking separate page. Just visit any friend in Facebook and you will find the link saying “View You and Your-Friend’s-Name”.
After you click the “View You and Your Friend” link, you end up in a separate page that includes the recent activities you had with your friend.
Here is a list of information available in the page:
Duo Profile Image
If you and your friend were tagged in any photo in Facebook, then one of them will end up as the page picture or profile picture of the You-and-Your-Friend-Activity page.
In the middle of the page you will see many feed updates that involves you and your friend. You will also find links to filter these updates just below the Duo Profile Image for seeing the feeds that are only Wall Posts, Photos, Events or Likes.
This is probably the oldest piece of information that was already available for your when you went to your friend’s profile. In the activity page, this eats up most of the space at left.
News Feed Updates
The mid-portion of the page is occupied with news feed updates that involves you and your friend. They are also categorized into Wall Posts, Photos, Events, and Likes.
In 3rd column at top-right, you will find links to other friends that are also mutual friends. From there you can see what are your friend’s interaction with other mutual friends.
Custom Friend Activity View
But, this is not all, Facebook is not only allowing you to see activities on You vs. Your Friend. They are also allowing you to see the activity of Your Friend vs. Another Friend. The interface to view the activity of two friends is available just below the Browse Friendship links.
Enjoy the new feature and Facebooking!!
This article is about generating QR Codes automatically in bulk from Google Chart API. But, I think a lot of people want to have more introduction about some terms. So here they go:
What is QR Code?
QR Code is 2-dimensional or 2D barcode (unlike the traditional 1D barcode) that looks like the black pixilated image below:
Came from some innovative Japanese mind, who invented the code to make contents decoded at high speed. This 2D Barcode now readable by QR scanners, smartphones or mobile phones attached with cameras.
For iPhone (Semacode), Android Phones (QuickMark), Blackberry (ScanLife), and Symbian Phones or Nokia (UpCode) there are many competing apps that can read QR Codes from any printed media.
The utility of QR Code is simple, transfer a whole chunk of text or information from any printed media to your mobile phone (through QR reader) or computer (through QR scanner). So, this is the best way for you to make people go directly to your site from the printed QR Code or have people save your business card in their mobile phone in a snap.
What Does QR Codes Have to do with Web Marketing?
QR Codes are fastest way to transfer text and information from print to mobile phones. Therefore, it has good implications on increasing your site traffic from alternative media by referring the URL to your site. e.g. if you sell a specific product; by using mobile phone, the printed QR Code on your product can make the friends or colleagues of the buyer go to the page where he/she can also buy it. For any type of contact request, a visitor can save your contact information from web, product, brochure, coupons, etc. and might convert later.
Calvin Klein recently made an innovative adult advertisement on billboard with QR codes, without even showing the nude models. The title of the advertisement was “Get It Uncensored”. This triggered many people to go to their website and view the uncensored image. Please read more about this news here.
What is Google Chart API?
According to the Google chart API site:
The Google Chart API lets you dynamically generate charts with a URL string. You can embed these charts on your web page, or download the image for local or offline use.
Interesting fact is that Google Chart API is also currently the most reliable and free source for generating 2D QR Codes.
How can you Generate QR Codes with Google Chart API?
If you look at the URL of the above image, you’ll see that there are many information avalable in the URL:
So, by just inputting the information in the right place in the right format, you also can generate the desired QR codes.
Interpreting the Google Chart API URL
From the URL, you will find several parameters that can be customized. Here is the list of the parameters and their description:
If you go to the Google Chat API site, then you can see that Google arranges many types of charts. So, by using cht=qr, you are telling Google that the chart type should be QR.
This is where you mention what would be the chart size.
CHL is the Chart Label parameter. This actually states what type of content you have and based on that, your device will create certain action. You can have content as vCard (make an Phonebook Entry), URL (go to the referred site), Text (read the contents of the QR), Phone (call the referred number), SMS (Get info saved on your mobile), etc.
Usually, MECARD is used to tell that, the content is for Mobile vCard. According to ServletSuite.com, the definition of
MECARD is a text format lets you present address information for phonebook registration.
It is then followed by other heads with your custom values, like:
N: Full NameORG: Company NameTEL: The Telephone NumberEMAIL: The Email AddressADR: The AddressURL: The URLNOTE: Any note or comment.
Each of the heads should be separated with semicolon. If you are using the Chart API for generating URL only, then the custom URL is the label. You don’t need separate label for that.
More information on Google Chat API Parameters are on: http://code.google.com/apis/chart/docs/gallery/qr_codes.html
How to Generate QR Codes in Bulk from Excel Worksheet?
Well, this is what this article is about. In excel worksheet or any other sort of database, you might have information or record like this:
A2. Name: Asif AnwarB2. Company: Blueliner Marketing, LLC.C2. Phone Number: 008801712181761D2. Email: ɯoɔ˙ןıɐɯb@ʇuɐʇןnsuoɔǝpɐɹʇ (upside-down text)E2. Address: 55 Broad Street, 17th Floor, New York, NY 10004, USA. F2. Website: http://asifanwar.tumblr.com G2. Note: Company site: http://www.bluelinerny.com
[A2 to G2 are cell reference]
In terms of QR Code generation, these information is best for website/URL reference or business card transfer from print to mobile. And with all these information, you get this URL again:
Now, if you look at the URL that generates the QR Codes, you will find a pattern. e.g.:
http://chart.apis.google.com/chart?cht=qr&chs=[THE-CHART-SIZE-YOU-WANT]&chl=MECARD:N:[FIRST-NAME]%20[LAST-NAME];ORG:[COMPANY%20NAME];TEL:[YOUR-TELEPHONE-NUMBER];EMAIL:[YOUR-EMAIL-ADDRESS];ADR:[YOUR-ADDRESS];URL:[YOUR-URL];NOTE:[YOUR-NOTE]; ;In other analogy with cell reference:http://chart.apis.google.com/chart?cht=qr&chs=[THE-CHART-SIZE-YOU-WANT]&chl=MECARD:N:[A2];ORG:[B2];TEL:[C2];EMAIL:[D2];ADR:[E2];URL:[F2];NOTE:[G2]; ;
So, it is possible the join these information from excel worsheet to generate the URL and finally generate the QR Codes. But, there is one problem, the information you have, has spaces and @ sign that are not allowed in the URL. So, you have to replace them with “%20” and “%40” respectively.
In Excel Worksheet, you can use the following formulas to replace the spaces and @ signs and create a new text that can be easily joined:
H2. =SUBSTITUTE(TRIM(A1),” “,”%20”)I2. =SUBSTITUTE(TRIM(B1),” “,”%20”)J2. =SUBSTITUTE(TRIM(C1),” “,”%20”)K2. =SUBSTITUTE(TRIM(D1),”@”,”%40”)L2. =SUBSTITUTE(TRIM(E1),” “,”%20”)M2. =SUBSTITUTE(TRIM(F1),” “,”%20”)N2. =SUBSTITUTE(TRIM(G1),” “,”%20”)
[Assuming that you are placing the replaced texts in single row that starts after G column]
Since you have all the spaces and @ replaced, you now can join the texts with =CONCATENATE() formula. e.g.
The strategy for generating the URLs for QR Codes may vary in case if you are using separate form of database.
Once you have created the URLs, you can easily embed them in the site or print them by visiting the file on browser.