#Excel text import wizard over 1 million serial number

Note:В You may need to scroll down a little as the preview starts at the top of the file, rather than the header line set in Step 12.

Ensure the 'Tab' delimiter box is ticked and the others are unticked, check the preview to see filenames in the first column, and numbers in the remaining columns.

Set the 'Start import at row' value to this number. This line is the header for the sfs_dump data and is the first line we wish to import.

Scroll through the preview, looking for a line which starts with 'namemtimefileidsizeseg_bytes' and note the row number.

Choose ' Delimited' to describe the data.

Excel will start the 'Text Import Wizard'.

You may need to set the dialog to show 'All files', depending on the suffix of the log file you created.

Open the file created by your ssh client's logging, using File -> Open.

Any redundant information above the actual data will be removed.

Excel's 'Text Import Wizard' will be configured to split the data into individual columns. In this section the previously created log file will be opened inside Excel, and the data imported into a spreadsheet. If Excel is not installed on the same machine as the log file just created then you will need to copy it across. When the command has completed, switch off logging.Type se sfs_dump -c (you can specify a path if you want to limit to a particular dir or mtree, eg se sfs_dump -c /data/col1/mymtree.).You may need to check the manual if you are using a different ssh client. For PuTTY, this is under the SessionВ -> LoggingВ tab of the configuration screen. Switch on logging within your ssh client, ensure 'all session output' is enabled, the output file is named logically and will be placed in a suitable directory where you can find it.If your system uses retention-lock compliance then you will need to authenticate using a user with the 'security' role first.

#Excel text import wizard over 1 million serial number

Authenticate using the serial number from Step 2.200 MB for systems with 1 million files).