Feb 19, 2013

File checksum utility for windows Xp

File checksum utility for windows Xp






Refer -  http://support.microsoft.com/kb/841290

Feb 18, 2013

This e-mail address is associated with a Nokia Messaging account

Problem
This e-mail address is associated with a Nokia Messaging account


Solution
If you configure mails in Nokia mobiles, your mail address will be linked with your nokia accout. The same email address cannot be configured in another nokia mobile. The solution is to call Nokia customer care and request them to remove the linking for your mail address.

Feb 17, 2013

How to count occurrences of a number or text in Excel

To count occurances of a particular number or words in a range of excel cells use formula

=COUNTIF(range,"pattern")
where range is the excel cells range where you want to search for the pattern. pattern can be numbers or words but it should be within double quotes "".

Example - To count number of occurance of word "present" in cells between A1 to A10. frame the formula like below

ex - COUNTIF(A1:A10,"Present")

also you can wildcard characters in the pattern.
Example   =COUNTIF(A1:A9,"*sent")

Feb 16, 2013

How to find filetype in windows


There is a utility called "file" in unix which determines filetype  of a file. There is no default similar utility available in windows.  After trying few utilities available online, I found this one more helpful.

http://home.fnal.gov/~jklemenc/dl/filetype.zip

Find more description about the tool at http://home.fnal.gov/~jklemenc/filetype.html

I have posted screenshot of an example

C:\Documents and Settings\tig\Desktop>filetype.exe
FileType.exe
  by: Joe Klemencic
  Copyright 2004

Usage:
   FILETYPE.EXE -i [-r] [-o ] [-v] [-?]

                -i - Inspect a single file or all files in a directory
                -r  - Rename the file with the correct extension (-o ignored)
                -o  - Output path for file copies (creates if not exist)
                -v  - Verbose output
                -?  - This help text


C:\Documents and Settings\tig\Desktop>filetype.exe -i  "Reach Out-participants.pdf"
Reach Out-participants.pdf (.pdf) "Adobe PDF File"

C:\Documents and Settings\tig\Desktop>filetype.exe -i  "Perl One Liners.htm"
Perl One Liners.htm (.txt) "Text file"

C:\Documents and Settings\tig\Desktop>filetype.exe -i  SyncToySetupPackage_v21_x86.exe
SyncToySetupPackage_v21_x86.exe (.exe) "Executable File"

C:\Documents and Settings\tig\Desktop>filetype.exe -i  toolsmanual.dvi
Could not identify toolsmanual.dvi, skipping....

C:\Documents and Settings\tig\Desktop>filetype.exe -i  quickCooking.do
quickCooking.do (.pdf) "Adobe PDF File"

Feb 15, 2013

mount error: can not change directory into mount target /mnt/server/


Problem:
mount error: can not change directory into mount target /mnt/server/

Reason:
Either you didn't create your /mnt/server directory or specified it wrong in your mount command.
check the existence of the directory and try the mount command again

Example:
[root@library 20100813143931]# mount -t cifs //192.168.1.2/Release -o username=mohan,domain=priv  /mnt/server/
mount error: can not change directory into mount target /mnt/server/
[root@library 20100813143931]# cd /mnt/server
-bash: cd: /mnt/server: No such file or directory
[root@library 20100813143931]# ls /mnt/
[root@library 20100813143931]# mkdir /mnt/server
[root@library 20100813143931]# mount -t cifs //192.168.1.2/Release -o username=mohan,domain=priv  /mnt/server/
Password:

Feb 14, 2013

Maximum length for naming a file in windows


In the Windows explorer the maximum length for naming a file is 260 characters including the drive letter and folders name.
Because windows has a predefined variable called MAX_PATH and its value is set to 260.


So when you try to create or copy a file it will return below error

cp: cannot create regular file    File name too long

sample filename :
C:\hudson\workspace\dev-project-eventsourcelibrary\project\initial\eventsourcelibrary\tmp\normaliser\etc\devices\nsm\reports\Network\Configuration and Policy Management\viewScreen-Security Management\NetScreen-Security Manager - Authentication and Login Events.xml 

So to avoid either you can reduce the characters by trimming the directories name length or use the "\\?\" prefix so that it will allow upto 32,767 characters.

To know more about this, refer microsoft's naming guide.
url-
http://msdn.microsoft.com/en-us/library/windows/desktop/aa365247%28v=vs.85%29.aspx#maxpath
----------------

Unicode clients require a unicode enabled server.

Problem: Unicode clients require a unicode enabled server.

If P4CHARSET is set in the client , but the service is not operating in internationalized mode, the service returns the following error message:

Unicode clients require a unicode enabled server.

Solution:
For Perforce services operating in the default (non-Unicode mode), P4CHARSET must be left unset (or set to none) on user workstations.P4CHARSET only affects files of type unicode and utf16; non-unicode files are never translated.

Example:

c:\p4\project\>p4 edit startbuild
Unicode clients require a unicode enabled server.

c:\p4\project>set P4CHARSET=none
c:\p4\project>p4 edit startbuild
//project/startbuild#1 - opened for edit



For Perforce services operating in Unicode mode, P4CHARSET must be set on user machines. If P4CHARSET is unset, but the service is operating in Unicode mode, Perforce applications return the following error message:
Unicode server permits only unicode enabled clients.

c:\p4\project\>set P4CHARSET=UTF-8
c:\p4\project\>p4 edit startbuild
Character set must be one of:
none, utf8, utf8-bom, iso8859-1, shiftjis, eucjp, iso8859-15,
iso8859-5, macosroman, winansi, koi8-r, cp949, cp1251,
utf16, utf16-nobom, utf16le, utf16le-bom, utf16be,
utf16be-bom, utf32, utf32-nobom, utf32le, utf32le-bom, utf32be,
or utf32be-bom
Check P4CHARSET and your '-C' option.

c:\p4\project\>set P4CHARSET=utf8

For further information refer http://www.perforce.com/perforce/r12.2/manuals/cmdref/env.P4CHARSET.html