12.17.2009

Using MindManager? Export the selected topic and all sub topics to Excel

Tags: Microsoft Office Resources Mind Manager
0
Are you using MindJet's MindManager for your mind maps? Have you ever needed to export your mind map to Microsoft Excel? If so, read on, I have created a macro which traverse all sub-topics from the currently selected topic, and create a simple Excel spreadsheet with most data such a Duration, Start- and Due date etc. including the Topic Notes and a direct link to the topics in your map!

07.07.2009

Find and optionally correct erroneous file names on your drive

Tags: Resources
0
Today I am releasing another small tool, floating around the same concept as the previous article Find the long file names on your drives. In my endeavor to backup huge quantities of files to my NSA 220 Plus NAS, it turned out that the NSA 220 Plus had some problems with file names containing percent characters. The new tool is named FileAndFolderNameValidator and reads a XML configuration file looking like this;

A picture named M2
Basically the configuration file specifies which paths to scan (yes, it can scan more than one disk in one go), and contains a list of all invalid characters in file names and folders respectively, and what the erroneous character should be replaced with . As for other command line tools, this tool outputs its results to the console, and if you just issue the command FileAndFolderNameValidator, you will see a list of file names containing errors. If you want to save that result to a file, then redirect the console output to a file like this;

FileAndFolderNameValidator >C:\Results.txt

In order to make FileAndFolderNameValidator actually fix the file names for you, you must specify the parameter MODIFY, such as this;

FileAndFolderNameValidator MODIFY

Important!! Note that FileAndFolderNameValidator will then actually change your file names!!! I therefore use this tool only on my backup USB disk, and not on my original source disks.

Head over to this page to download the tool. Enjoy!

06.20.2009

Find the long file names on your drives

Tags: Resources
0
Have you ever wondered whether your drive contains files with very long file names? I experienced a problem with my Home Server backup, where some of the files turned out to have very long file names (close to 255 characters). When files with that long file names are copied to other directories with perhaps a long folder name, the total characters in the path and file name exceed 255 characters, and the copy operation fail. I therefore needed a small application to reveal those file names.

The result is FindVeryLongFileNames.exe which by default scans the specified drive and path for file names longer than 200 characters. It also scans all subfolders. For example;

FindVeryLongfileNames C:\   - will scan your C-drive and all subfolders for long file names
FindVeryLongfileNames \\SERVER\Music   - will scan your network share \\SERVER\Music and all subfolders for long file names.

If you want to look for file names with names longer than for example 240 characters, you may specify;

FindVeryLongFileNames \\SERVER\Music   240     - will scan your network share \\SERVER\Music and all subfolders for file names longer than 240 characters

Note that the tool just outputs the results to the console. This means that you can use standard redirect-operation (use >) to redirect the output to a file. for example;

FindVeryLongFileNames \\SERVER\Music >c:\Longfile namesMusic.txt

When FindVeryLongFileNames finishes, you may see the result in the file c:\Longfile namesMusic.txt.

Since the tool outputs the file names on the format xxx - file name, you may sort the file too, with the standard SORT command, such as;

SORT c:\Longfile namesMusic.txt >c:\Longfile namesMusicSORTED.txt

Remember you can add the /REVERSE parameter to the SORT command to reverse the sort order to descending.

You may download the tool here.

Tags

Calendar