Sunday, June 12, 2011

How to Export the list of files from a directory to an Excel sheet.

If you need to export a list of the files contained in any folder in your hard-drive to any file format like text file(.txt) or excel sheet(.xls or .xlsx) this article will be useful.
For instance you want to save the list of all the movies contained in your drive's particular folder to an Excel sheet you can follow the following instructions:

  1. Go to cmd prompt (shortcut: windows button+r).
  2. Reach the known directory which contains all the required files. For this you can use the 'cd' command,i.e, change directory and reach the folder.
  3. Now you can use the pipe commands in cmd prompt to export a given list. In windows cmd prompt the '>' is acts as the pipe command. Now I'll teach you how to write this export command:
    type:
    dir \s \b> c:\newFile.txt
  4. (optional) Further many possible options are there to customize your exported file format and contents. I'll tell you more

    If you type '\dir?'
    This Displays a list of files and subdirectories in a directory.

    DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]
    [/O[[:]sortorder]] [/P] [/Q] [/R] [/S] [/T[[:]timefield]] [/W] [/X] [/4]

    [drive:][path][filename]
    Specifies drive, directory, and/or files to list.

    /A Displays files with specified attributes.
    attributes D Directories R Read-only files
    H Hidden files A Files ready for archiving
    S System files I Not content indexed files
    L Reparse Points - Prefix meaning not
    /B Uses bare format (no heading information or summary).
    /C Display the thousand separator in file sizes. This is the
    default. Use /-C to disable display of separator.
    /D Same as wide but files are list sorted by column.
    /L Uses lowercase.
    /N New long list format where filenames are on the far right.
    /O List by files in sorted order.
    sortorder N By name (alphabetic) S By size (smallest first)
    E By extension (alphabetic) D By date/time (oldest first)
    G Group directories first - Prefix to reverse order
    /P Pauses after each screenful of information.
    /Q Display the owner of the file.
    /R Display alternate data streams of the file.
    /S Displays files in specified directory and all subdirectories.
    /T Controls which time field displayed or used for sorting
    timefield C Creation
    A Last Access
    W Last Written
    /W Uses wide list format.
    /X This displays the short names generated for non-8dot3 file
    names. The format is that of /N with the short name inserted
    before the long name. If no short name is present, blanks are
    displayed in its place.
    /4 Displays four-digit years

    Switches may be preset in the DIRCMD environment variable. Override
    preset switches by prefixing any switch with - (hyphen)--for example, /-W.
  5. Now open Microsoft Excel, and import the exported file named 'newFile.txt' into a new sheet.
This is how you can export files using command prompt in windows OS, and create Excel sheets of required file directories.

Monday, June 15, 2009

NIT B: First Year IT:2nd Sem Results

Institute
INFORMATION ENGG B.Tech-II Sem


B.Tech-II Sem INFORMATION ENGG. SGPA
1 081115003 ASTHA JAIN Pass 7.75 7.95
2 081115004 ANAND PRAKSH SINGORE Pass 7.34 7.68
3 081115008 SHILPESH MISHRA Pass 7.06 7.25
4 081115009 NAVEEN MAKWANA Pass 8.22 8.08
5 081115012 KHUSHBU MITTAL Pass 7.38 7.50
6 081115013 AMAN BADJATYA Not cl 5.56 6.45 M-151
7 081115014 AAYUSH AGRAWAL Pass 6.59 7.07
8 081115015 PRATEEK GUPTA Pass 7.66 7.90
9 081115016 ANUP VERMA Pass 8.00 7.93
10 081115020 HIMANSHU ARORA Pass 7.66 7.68
11 081115021 ANIL AHIRWAR Not cl 4.28 4.58 "PHY151,CHM151"
12 081115023 PANKAJ SINGH Pass 7.28 7.37
13 081115028 GOVIND MINJ Pass 6.16 6.33
14 081115032 BALLA VAMSHI KRISHNA Pass 7.44 7.70
15 081115035 ANKIT TRIPATHI Pass 7.00 6.87
16 081115037 ARPIT PANWAR Pass 5.91 5.95
17 081115038 PRAVEEN RANGHERA Pass 7.50 7.42
18 081115039 RAVI KUMAR Pass 6.41 6.68
19 081115040 SATYENDRA VISHNOI Pass 6.75 6.95
20 081115042 HEMRAJ PARMAR Not cl 5.47 5.95 M-151
21 081115043 VISHNU PRASAD DANGI Not cl 5.19 6.17 "M-151,E-199"
22 081115045 SHASHANK DONGRE Pass 6.91 6.95
23 081115047 VISHWANATH ARESHWAR Pass 6.56 6.63
24 081115048 NIDHI BARAIYA Pass 6.66 6.88
25 081115049 ANAMIKA GAUTAM Pass 8.03 8.07
26 081115052 RAMESNDRA KUMAR Pass 7.31 7.52
27 081115053 PAWAN KUMAR MEENA Not cl 4.72 5.00 "PHY151,M-151"
28 081115056 NISHANT MALOO Pass 6.81 7.18
29 081115057 RAVINEESH GOUD Pass 5.97 6.03
30 081115059 SWASTI GUPTA Pass 7.44 7.23
31 081115061 ANSHU AGRAWAL Pass 7.34 7.65
32 081115062 AMIT VARSHNEY Pass 7.56 7.68
33 081115063 SHRASHANK GUPTA Pass 7.22 7.60
34 081115064 RASHMI TIWARI Pass 7.28 7.65
35 081115065 PAYAL MAHAESHWARI Pass 8.66 8.58
36 081115066 BHARTI Pass 6.81 7.02
37 081115067 GARIMA NEMA Pass 7.75 8.08
38 081115068 MOHIT KUMAR GUPTA Pass 7.50 7.53
39 081115069 VOOTUKURU VAMSHIDHAR Not cl 5.50 5.92 M-151
40 081115070 VIBHOOTI KAYASTHA Not cl 4.03 6.00 "PHY151,CHM151,M-151"
41 081115072 ADWITIYA TIWARI Pass 7.38 7.48
42 081115073 AKASH VERMA Pass 7.34 7.42
43 081115075 ABHAY RANA Pass 6.22 6.72
44 081115076 APARA NAGAR Pass 7.75 7.83
45 081115077 VASUDHA JAIN Pass 9.19 9.12
46 081115078 AMIT NANWANI Pass 7.25 7.52
47 081115079 YUVRAJ SINGH CHAWDA Pass 7.00 7.30
48 081115080 DEEPALI KOSE Pass 8.09 8.02
49 081115081 HEMANT KUMAR PATEL Pass 6.88 7.42
50 081115082 ANIRUDH PRATAP SINGH Pass 7.09 7.38
51 081115083 SOURABH MEHTA Pass 7.25 7.77
52 081115084 SHRUTI MISHRA Pass 7.19 7.30
53 081115085 SHAILLY PALOD Pass 8.31 8.37
54 081115086 SWAPNIL VADNERE Pass 7.72 8.12
55 081115087 GIRISH KOSHTI Pass 6.69 7.40
56 081115088 DIVYANSHU JAIN Pass 7.50 7.75
57 081115089 REEMA CHOUREY Pass 6.88 6.97
58 081115090 GAURAV KUMAR Pass 7.19 7.38
59 081115091 LOKESH NANDAN WAR Not cl 5.78 6.28 M-151
60 081115092 RESHMA SALIM Pass 8.41 8.55
61 081115093 NAMAN BAGGA Pass 6.75 7.05
62 081115094 TANUJA KUNTAL Pass 7.13 7.33
63 081115095 JAL SINGH MEENA Pass 7.03 7.05
64 081115096 VIKASH KUMAR MEENA Pass 6.81 6.73
65 081115097 SHARIQ ZAHEER Pass 6.91 6.78
66 081115098 K.S.KOTHILPHUN MARING Pass 6.63 6.30
67 081115099 MOHAMMED ANSHAD P. Not cl 5.41 5.18 PHY151
68 081115100 PUNAM Pass 7.38 6.98
69 081115101 VASANTHAN A. Not cl 4.50 4.43 "PHY151,M-151"
70 081115102 AMIT KUMAR GUPTA Pass 7.28 7.23
71 081115103 PRACHI BANSAL Pass 7.56 7.55
72 081115104 VINAY PRAKASH KAUSHAL Pass 6.88 6.90
73 081115105 PAYAL R. KHOBRAGADE Pass 8.00 7.78
74 081115106 SWAPNIL SHRIVASTAVA Pass 6.88 6.93

Saturday, June 13, 2009

America- top stories

Airline Capacity Cuts May Mean Higher Fares

Plans by major US airlines to reduce the number of seats they sell may bolster fares later this year, further propping up prices that dropped this year as economic weakness drained travel demand.


Paris Airshow Underscores Bleak Times For Industry

The world's biggest airshow next week may see more soul-searching than orders as the industry wades through an economic crisis overshadowed by the worst crash in eight years.


Boeing, Airbus Struggle For Orders

Airbus and Boeing are headed for their worst annual order tally in at least 15 years as struggling airlines cancel almost as many planes as they are buying.

Aer Lingus To Cut Long-Haul Capacity By Quarter

Irish airline Aer Lingus said on Friday it will cut seat capacity on its winter long-haul services by a quarter compared to 2008 in response to low demand and significant losses in the first quarter.

SAS May Slash Overseas Routes - Report

SAS could scale back overseas flights if the Scandinavian airline is unable to persuade unions to cut costs or enter a joint venture, its chief executive said in a newspaper interview on Friday.


Friday, June 12, 2009

breaking of admin password in Windows XP

breaking of admin password in Windows XP

There is an easy way to change the password, if you have an guest user in the PC.

If you have an guest account then you can hack the admin password (without knowing the previous password, not only admin account but all user accounts in XP 
) from your guest account, Let me explain how to do that.....


Enter into the guest account, then do the following:

1) Open the command prompt ( start -> run -> type "cmd" and press enter)

2) Then type " net user * " and press enter, You will find all the user names in the PC

3) Then type " net user admin * " then press enter, it will prompt you with the new password for the user name you mentioned, then type in the desired password thats it you hacked the user name (The admin is the user name , you can use any name you want to hack)


Yes you can do that by using a tool, here is how you do it.........

1. Get physical access to the machine. Remember that it must have a CD or DVD drive.
2. Download DreamPackPL HERE: 
RapidShare: Easy Filehosting
3. Unzip the downloaded dpl.zip and you’ll get dpl.ISO.
4. Use any burning program that can burn ISO images.
5. After you have the disk, boot from the CD or DVD drive. You will see Windows 2000 Setup and it will load some files.
6. Press “R” to install DreamPackPL.
7. Press “C” to install DreamPackPL by using the recovery console.
8. Select the Windows installation that is currently on the computer (Normally is “1″ if you only have one Windows installed)
9. Backup your original sfcfiles.dll by typing:
“ren C:\Windows\System32\sfcfiles.dll sfcfiles.lld” (without quotes)
10. Copy the hacked file from CD to system32 folder. Type:
“copy D:\i386\pinball.ex_ C:\Windows\System32\sfcfiles.dll” (without quotes and assuming your CD drive is D: drive ) 
11. Type “exit”, take out disk and reboot.
12. In the password field, type “dreamon” (without quotes) and DreamPack menu will appear.
13. Click the top graphic on the DreamPack menu and you will get a menu popup.
14. Go to commands and enable the options and enable the god command.
15. Type “god” in the password field to get in Windows.

You can also go to Passwords and select “Logon with wrong password and hash”. This option allows you to login with ANY password.

Note: I was unable to bring up the DreamPackPL for the first time because I have Kaspersky Anti-Virus already running in background. I believe most antivirus already labelled this tool as a Hack-Tool. A Hack-Tool is NOT a virus. DreamPackPL helps you bypass the Windows Login screen and it is not destructive.

What is the difference between DDR1 and DDR2 ram?can v put DDR2 into DDR1 m/board?

we DDR2 is faster than DDR1.
Yes ofcourse it will create problem .
DDR2 will not fit in DDR1 notch in the first place  (DDR2 will physically not insert into the socket of DDR1).

The difference between DDr1 and DDR2 is, On the physical side, DDR has a 184-pin interface and DDR2 has 240-pin and they also differ in the voltage they use, DDR1 uses 2.5 Volts DDR2 uses 1.8 Volts. As you have mentioned speed also differs DDR1 has 200 MHz, 266 MHz, 333 MHz, 400 MHz and DDR2 has 400 MHz, 533 MHz, 667 MHz, 800 MHz. 

Apple digs into Microsoft at WWDC

 Apple digs into Microsoft at WWDC


Apple may have plenty of announcements of its own to make at this year's WWDC, but it looks like it just couldn't help itself from taking a few jabs at Microsoft as well. Doing the honors was Bertrand Serlet, who took the stage by saying "what a sharp contrast with Vista our OS is," and only got rolling from there, pointing out "what a big hole Microsoft has dug," and adding that "they're trying to get out of it withWindows 7." Of course, Serlet didn't have many good things to say about Windows 7 either, which he says has "even more complexity" than Vista because it's just based on the "same old tech as Vista."
Filed under: DesktopsLaptops

Apple digs into Microsoft at WWDC originally appeared on Engadget on Mon, 08 Jun 2009 12:31:00 EST. 


any further feedbacks are wellcomed...

Amit
-"enlightening the world..."

Fedora 11 packs a next-gen file system, faster boot times, all the joys and pitfalls

 Fedora 11 packs a next-gen file system, faster boot times, all the joys and pitfalls


Linux just gets sexier and sexier, and Fedora 11 just joined Ubuntu 9.04 in the ranks of super modern Linux distros released this year. Fedora doesn't have all the desktop refinements of Ubuntu, or the wild popularity, but it does act as the underpinnings of Intel's Moblin, and the Sugar OS, and doesn't shy away from the future. Fedora 11 makes the bleeding edge ext4 filesystem the default for installs, which speeds performance and improves data integrity -- Ubuntu offers ext4 as an option, but some application incompatibilities have caused data loss problems, so hopefully Fedora has overcome that. Fedora 11 also has boot times in its sights, with a goal to be at the login screen in 20 seconds, new versions of GNOME and KDE desktop environments (GNOME is default, but KDE 4.2 is looking great) and plenty of other minor and major tweaks. Sure, it's still Linux: most folks who expect to just swap out their Windows environment wholesale are sure to be sorely disappointed, but it's clear the steady march of progress continues unabated -- and hey, it's good enough for Intel and the children.Filed under: DesktopsLaptops

Fedora 11 packs a next-gen file system, faster boot times, all the joys and pitfalls of Linux originally appeared on Engadget on Tue, 09 Jun 2009 20:20:00 EST. 

KSET quest demonstration