Speed, and Cataloguing CDs and ISO 9001

Speed (1’14”)

Filecats is fast.
It can catalogue hundreds of files a second, if not thousands, and import file names, file paths, file sizes, dates and attributes into Excel. It can scoop up the entire contents of a hard drive and put them into a spreadsheet with ease. It allows you to investigate new data that you have received very quickly.
Filecats can catalogue a hundred thousand files in a couple of minutes. Its speed depends on factors such as the computer’s processing power and its speed at reading the files.
Cataloguing metadata reduces the speed and it does depends on how much metadata you want capturing, but Filecats Professional can also catalogue up to 100,000 files with metadata in an hour.

Cataloguing CDs and ISO 9001 (3’54”)

Filecats makes creating cataloguing of CDs very easy, and I do this every time I send out a CD or USB memory stick. This way I have a permanent record of what I am sending out, there can be no dispute about it as far as I’m concerned, and the recipient doesn’t need the Filecats programme in order to use it. This has saved me on more than one occasion in the past, when the recipient swears that he has loaded all of my data onto his computer, and because he has found a problem, therefore there would have been a problem with my data. However, because I had this record, I was able to ascertain that he had not loaded over a thousand files onto his computer, and therefore he should re-load the data. It solved the problem.
However, when you create a CD, you will find that what your CD drive might be the “D” drive, but their CD drive might be the “E” drive. Also, they might want to load the contents of your CD onto their network, and therefore these hyperlinks need to be updated.

In cell G1 you can see the original path where the files were catalogued from. If I was to save this in a different location, say the “L” drive, you can see that my hyperlinks are unchanged. They are fixed as being based on the original path.
However, if I go cell F1, a drop-down box appears. If I click that, I can change from the “Original Path” to the location where the spreadsheet is saved. Now cell G1 changes to the L drive, and all of the hyperlinks refer to the new path. This is very useful if you save the spreadsheet in the root of the catalogued data, for instance on a CD. If someone loads the CD using a different drive letter, the path will be automatically updated.
You can also put in a custom path, and type in your custom path in the “Input” spreadsheet in cell B5. Now all of the hyperlinks use the custom path.
This is how you can use Filecats for CDs: catalogue the files, change the path to the “spreadsheet path”, and burn the catalogue into the root of the CD. The path will then change to your recipient’s CD drive. He can also upload the entirety of the CD to his computer, and the hyperlinks will still have the right relative path.
It also helps you with your I/S/O 9001 requirements, keeping a permanent record of what has been sent. The danger of saying “I sent this folder” is that folders get updated, whether it be in a week’s time or a month’s time, and so you no longer have the certainty of knowing what you sent.

Leave a Reply

Your email address will not be published. Required fields are marked *