Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[FenceFurniture]

I know the size of each folder (album) that I select displays at the bottom, but is there a way of exporting to a csv the sizes of each album folder? Or at least a way of displaying them all at the same time in the window?

(it would be very convenient if Windows displayed the folder sizes, as it suggests it can, but it doesn't put a value in. Nor does hovering over each folder work each time)

Technically I could export the data for all the files in each of the folders and then put in a sum for each one, but that would be slower than just reading each one and manually entering it into my spreadsheet (because there are 495 albums).

[wer]

There are lots of Windows utilities that do exactly what you want.  Google "folder sizes" and you'll see them.

[FenceFurniture]

Ok, thanks wer.

[RoderickGI]

Simple.
In MC for Audio files only for each Album, as an example;

Under the Audio group in the Navigation Pane at the left of Standard View, make a Category View with one Category of "Album", save that, then change the List Style to "Details".
    If you just want to see the total in Excel, add a Column to the View for the field [File Size]. That will show values such as "295 MB total".
    If you want to do calculations in the spreadsheet after collecting the data, add an Expression Column to the View and enter the expression [file size,0]. That will show the total size of all files for the Album in Bytes.
    If you want to do calculations in the spreadsheet after collecting the data, but want the size in Megabytes (MB), then use the expression;
        Math([file size,0] / (1024*1024))
    If you want that size in MB, but rounded to a whole number, then use the expression;
        Math(round([file size,0] / (1024*1024)))
    See https://wiki.jriver.com/index.php/Miscellaneous_Functions#Math for more options in rounding, truncation, etc.
Remove any Columns from the View that you don't want, or add any extras that you do want.
Select all items in the View (Ctrl-A).
Copy all items in the View (Ctrl-C)
Open your spreadsheet and select the cell that you wish to start the paste into. i.e. The top left corner. Paste the contents of the View into your spreadsheet (Ctrl-V)

Done.

If you actually wanted the folder size for all folders that audio files are in, for example if you have sub-folders for CD Discs as I do, then just make the Category View above for "Filename (path)" instead of "Album".

Once you have one or both of the above Views created you can sort and filter them as you desire. The Copy and Paste will use those settings, so that is what you will get in the spreadsheet.


The key to the above, other than the Copy and Paste functionality, is that the [File size] field will show the total of all files for the group of items being listed in a Category. No need to do any fancy processing.

All done in MC, so it works only on files imported into MC, and does not include ancillary files such as Cover Art, Extras, Sidecar files, or any other files in the folder. Just the files in the MC Library.

So if you want the total size of all files in a folder, including ancillary files, then use Wer's solution.

[wer]

Simple.

If that's simple, what do you call complicated?   

[RoderickGI]

Cheeky.

I used a lot of words. It really is simple. I could have said;

Add the [Files size] column to your Album View.
Ctrl-A, Ctrl-C
Switch to your spreadsheet
Ctrl-V

Done. 

[wer]

Squirrels have to be cheeky.  Need a place to stash those walnuts.

I suggest we let Mr. FenceFurniture pass judgement.  Fence knows a simple solution when he sees one.  Fence LIKES simple solutions.  If he considers your solution simple, I will stop twitching my tail.

[RoderickGI]

True, but I don't write answers just for the person who asked the question.

I write them for all readers who are searching for answers, now or in future.

[wer]

Truly, you're a credit to all mankind, and a gift to the generations.

Is there somewhere I can get a coffee mug with your likeness on it?   

[FenceFurniture]

Thank you for all that detail Roderick. The first part produced exactly what I wanted, and can now export it, then merge it into the current sheet. (believe it or not I am quite proficient with higher level Excel and VB, although these days it is sometimes a while between so I get a little rusty with formulae and code)

All done in MC, so it works only on files imported into MC, and does not include ancillary files such as Cover Art, Extras, Sidecar files, or any other files in the folder. Just the files in the MC Library.

Yep, just want the music sizes.

[FenceFurniture]

Fence knows a simple solution when he sees one.  Fence LIKES simple solutions.

I do indeed, on both counts. Simple problems need simple solutions. Complex problems do too, but that's not always possible.

Be still thy twitching tail! 

(I was going to check your suggestion, but other stuff got in the way before Roderick's "inhouse" solution came up)

[RoderickGI]

Should I set up a Patreon account so you can start sending me money Wer? 

Judgement has been passed. Well done FenceFurniture. 

[FenceFurniture]

    If you want to do calculations in the spreadsheet after collecting the data, add an Expression Column to the View and enter the expression [file size,0]. That will show the total size of all files for the Album in Bytes.
    If you want that size in MB, but rounded to a whole number, then use the expression;
        Math(round([file size,0] / (1024*1024)))

    See https://wiki.jriver.com/index.php/Miscellaneous_Functions#Math for more options in rounding, truncation, etc.

I don't seem to be able to get the Expression part of this working. I've got File Size, showing 89.0MB (for example), and some other columns. This particular view is called Album Size. When I right click on it, Customise View, Add, Expression and paste that Math expression above, it just wipes out all the data and says "varies" for Album Artist and Album.

I'm clearly not doing it correctly - have tried different permutations, but.....no luck.

[FenceFurniture]

Ok, so that Expression routine can be somewhat confusing - you have to be adding an Expression to the right thing. I subsequently stumbled across it by not clicking customise View, but by clicking Columns.

Problem solved.

[RoderickGI]

Well, I did say Expression Column, not Expression Category. The devil is always in the details.

But it sounds like you have found the right spot to add the Expression Column.