Sunday, April 5, 2015

How to get Electricity Meter ownership / name change in Bangalore

This year, I took up the task to get my Electricity Meter changed from my builder's name to myself. Reason being its one the essentially government address proofs for your house which is used everywhere. Most folks in my apartment went the normal path of getting an agent to do it for a fees for Rs 1200 - 1500. One or two had given a try themselves and succeeded. As my friend Vinay and myself are practically free in the weekends so wanted to give it a try. If it worked then fine, else the agent is always there. It was our first Rendezvous with the famed Indian bureaucracy - and I wanted to have a feel of it in Bangalore. Even if we failed, we would have a experience and will know things how they are supposed to be done (and what not gets done).

So first went through online stuff like blogs and group mails to get as much information we can but later realized that there's more that not written anywhere hence this article. I stay close to Marathalli so most of the information is localized. There will be similar arrangements in other localities of Bangalore as well. So here is the story:

  1. Weekend 1 :: Information gathering
    We went to the local Bescom office at Chowdeshwari Temple Road, Marathalli (google map) and talked to the junior engineer about our request. Surprised to see that he was pretty courteous and explained the basic forms to fill up but they don't have the forms themselves. We had to get it from a shop nearby named Bhavani Electricals at Tulsi Theater Road (google map ) . From there we got:
    1. BESCOM Transfer of Electrical Connections (Form 1)
    2. BESCOM Power Supply Agreement for Low Tension Electrical Energy (eStamp Paper with a stamp of Rs 200)
    3. BESCOM Indemnity Bond (eStamp Paper with a stamp of Rs 100)
    For the 3 forms, the shopkeeper took a total of Rs 350 (Rs 50 as his fees)

  2. Weekend 2 :: File Preparation and visit to local BESCOM office We filled in the forms and along with it we took:
    1. NOC from our builder
    2. Latest electricity Bill
    3. Id Proof : Driving License copy will do
    4. Address Proof : Bank certified / Notarized copy of the Sale Deed (* this has a story described later)
    5. Photo of the electricity meter from outside and inside (else the engineer will ask to visit the premises to confirm the meter installed)
    With all this we went to the Marathalli office but bad luck. It was 2nd Saturday and government offices were closed on the day. We saw some folks in the office and went to talk to them. They were most likely agents themselves and they discouraged us a lot that so and so proofs are missing and it requires this and that and you will need a agent. Getting back home, we were almost ready to hand it over to the agent but as it goes - we could not get hold of the agent !!!

  3. Weekend 3 :: Junior Engineer's approval - To BESCOM S-7 officeThis weekend we made some nice progress and felt its almost done but had some more steps to go. We met with the Junior Engineer at the Marathalli office. He went through our forms and proofs and then signed on the backside of the "BESCOM Transfer of Electrical Connections (Form 1". He asked for the last meter reading and that was the only information required. With the first official step complete, we went to the BESCOM S-7 office and Old Airport Road (google map ). As it was end of month the workload was high, so the officials in there asked to come next Thursday. Hmm.. not sweet still we moved. The account manager Mr. Manohar asked us to put all document in a standard cardboard file as plastic files dont work in government offices - new learning.

  4. Weekend 4 :: Account Manager's approval and submission of fileInstead of Thursday, we went the next weekend. Initially the account manager asked us to wait. We waited for some 20 mins and then he took our file for review. Mine had a additional issue that I had the original sale deed and its photocopy and I though he will attest it. He first asked to get it done from the notary but later with some request, he finally agreed to do it himself and I thank Mr. Manohar for that. It kind of brought some belief in me - ki sarkaari kaam late hota hai magar hota hai aur sab chor nahi hain (government work takes time but it happens and not all are black sheep). With that, the file went to a clerk who said, that it for today, come on Monday to raise a demand of Rs 100 for the name change.

  5. Next Monday :: Demand Raised
    With no mood to delay things further, we went Monday sharp at 10 AM when offices open. Got hold of the clerk who had a lot of files with him. Had to search for our files and got them. He put it a request for Rs 100 which we paid standing in a line for another 20 mins. With the receipt in hand, we put it in the file and asked the clerk when will the name change show up in the BESCOM portal. The reply was around 2 weeks.

  6. Weekend :: Address CorrectionDuring the week, the name change happened in the BESCOM portal. Really fast but the address update was not there. The whole purpose was to have a address proof and we had just the name. So we went to the BESCOM office for address update. Luckily this happened from the helpdesk itself. The lady logged in to the portal and updated the address a put in the form. All good.
Now I have a critical government address proof which took around a month to get without any outside help.

Tuesday, October 7, 2014

Outlook Conversation Cleanup

Earlier there used to be a tool which will retain only the last thread of the email chain hence saving disk space for MS Outlook.
Just got to know that this feature is now available natively in Outlook. Just go through : https://support.office.com/en-US/Article/Use-Conversation-Clean-Up-to-eliminate-redundant-messages-4a0aa10b-8342-4f75-b78c-2b8ca23eca8d

Wednesday, September 24, 2014

Commandline to change firewal rules in Windows 7/8

I was looking for a commandline based approach to add new rules on Windows Firewall and it was simple to do:

  • First check if there are already some rules set:
    netsh advfirewall firewall show rule name=**App**
  • Then you add a separate rule for allowing input traffic (as required)
    netsh advfirewall firewall add rule name=**App** dir=in action=allow profile=public program=**App_Location** enable=yes
  • And a separate rule for allowing output traffic (as required)
    netsh advfirewall firewall add rule name=**App** dir=out action=allow profile=public program=**App_Location** enable=yes
  • Finally if required, the rule can be deleted
    netsh advfirewall firewall delete rule name=**App**

Tuesday, September 9, 2014

Automotic logon in to company intranet zone using Firefox

In AD based domain in company intranet, IE is the default browser and it does login automatically in to the intranet sites (in .NET it was Windows Authentication).

To do the same in firefox, do a "about:config" and the look for "network.negotiate-auth.trusted-uris". Add you company domains in there where you want automatic login like "bt.com"

Mozilla documentation : https://developer.mozilla.org/en-US/docs/Integrated_Authentication

Wednesday, May 28, 2014

Video Encoding Bitrates

NameResolutionLink
(Mbps)
Bitrate
(Mbps)
Video
(kbps)
Audio
(kbps)
240p424x2401.00.6457664
360p640x3601.50.9689664
432p768x4321.81.15108864
480p848x4802.01.28121664
480p HQ848x4802.51.60153664
576p1024x5763.01.92185664
576p HQ1024x5763.52.24217664
720p1280x7204.02.56249664
720p HQ1280x7205.03.203072128
1080p1920x10808.05.124992128
1080p HQ1920x108012.07.687552128
1080p Superbit1920x1080N/A20.3220000320
and for older, non-widescreen content (with only 75% as many pixels)...

NameResolutionLink
(Mbps)
Bitrate
(Mbps)
Video
(kbps)
Audio
(kbps)
240p320x2401.00.6457664
360p480x3601.20.7770464
480p640x4801.50.9689664
480p HQ640x4802.01.28121664
576p768x5762.31.47140864
576p HQ768x5762.51.60153664
720p960x7203.01.92185664
720p HQ960x7204.02.562432128
1080p1440x10806.03.843712128
1080p HQ1440x10809.05.765632128
1080p Superbit1440x1080N/A20.3220000320

Source : http://www.lighterra.com/papers/videoencodingh264/

Sunday, April 6, 2014

REST Standards

Just wanted to save these 2 links which very well explains the naming standards for REST services:
  1. The short one - https://github.com/WhiteHouse/api-standards 
  2. The long one (Martin Fowler) - http://martinfowler.com/articles/richardsonMaturityModel.html

Thursday, October 3, 2013

Picasa: Renaming File Names to Picasa Captions

Some 5 years back, I wrote on this blog on how to set the caption of a image as it file name. In those days, I used to change the filename first and then set the caption for picasa. Now things have moved online and today I set the caption first is Google + (which did not exist then) and then downloaded the album to my local picasa and tried to rename the file. How to do it?

With some Windows commandline revision and use of Exiv2 I was able to achieve it. So here it goes.
  1. I assume that you have downloaded the picasa web album to a local folder using picasa.
  2. Open command window and type in :
    forfiles /C "cmd /c ..\exiv2 -g Exif.File name -g Iptc.Application2.Caption  -Pv @file" > files.txt
  3. This will create a file "files.txt which will look like :
    100.jpg             1. My caption
    where the 1st column is the File Name and the 2nd column is the given caption.
  4. Open the files.txt in Notepad++ and edit it. Replace the huge space between the filename and caption with some deliminator like ';'. The result should look like:
    100.jpg;1. My caption
  5. Now in the command window type in:
    for /f "tokens=1,2  delims=;" %i in (files.txt) do ren "%i" "%j.jpg"
    This will take the filename as the first token and caption as the 2nd token as we have used the deliminator ';' and then do a rename. Note that I have use %j.jpg" to give it the correct extension.
  6. And the job is done :)