Log Number 6: Save the list of files and the spreadsheet as xls format

Manager Steve Culleton want to archive the files onto backup tapes that are older than 6 months in 2 weeks time because of concerment about the amount of filespace being used on the server.
Before that happens, Staffs need to know which data they have using xls file which include the list of files on directories.


Remedial Action taken:

To save the list of files, I have used MS-DOS commands in Command Prompt.

1. Change the drive types in "C" or "L"

2. Change the directory type in " cd directory-name"

3. Save file lists in directory type in "dir > file-name.txt"
(redirect) can use to change the output

4. To save the spreadsheet as xls format, I have imported the txt file in Excel and then save xls format in save as.

5. Open the file in file >> open in menu

6. Change directory which include the txt file and change files of type to all flies

7. Click and open txt file using text import wizard.

Reference: Here is a link to a website with a list of MS-DOS Commands

http://www.computerhope.com/overview.htm

*You can also find the all command lists when you type in "help" in the command prompt or for more details and options about each command, type in "command-name /?" in the command prompt for example "dir /?" will show the all options for dir command in the Command Prompt.