I sometimes have fun just figuring out how to make my computer do what I want it to do. LOL
I recently discovered that some of my music collection had disappeared! Odd tracks of various albums were gone, and in one case a whole album. I looked at my backups and they were there. I have a feeling it has to do with Groove Music.
Anyway, I went through all of my nearly 500 artist folders in my Music folder and compared their size to the one on the backup drive. (My music collection on my computer is around 78 GBs.) I dug down and fixed where there were discrepancies. I compared the size on my hard drive, the size on my external backup drive, what I had on OneDrive, and what was on the SD card on my phone. (Got a 200 GB SD card for my phone so I could put all of my music on it.)
When all was compared and equal, I decided I wanted to make a spreadsheet of all the folders and their sizes. How to do this?
Well OneNote has a fabulous feature wherein you can pull the text out of a picture. I went through Windows Explorer and grabbed screen shots of all the folders and pasted them into OneNote. Then I had OneNote grab the text from each of the screen shots. It gave a long list of all the folders in the screen shot. I then pasted these into Excel, where they pasted a single folder name per row. (Very nice!) All I had to do in terms of hand data entry was to then type in the size of the folders, which I had written on a printout of the screen shots.
I can now edit the collection when I add new music, and should anything appear corrupted or missing in the future, I can more easily track it down.
What was fun was the satisfaction of being able to do it.
Looks like so:
Attachment:
Folder sizes.jpg [ 94.73 KiB | Viewed 5098 times ]