Libre Writer or Excel - File Name List - Pritning

users
#1

Hi Paul,

I'm trying to keep this as simple as possible.

In Windows 7, opening Windows Explorer to my Music folder I can see all the
artists names and their respective sub-folders.

When I l click on each artist's sub-folder I can then see either their
album name(s) in their sub-folders and then when I open the album
sub-folders I can see all the songs listed under that album (in .mp3 or
.wav format).

Ex, First folder - Abba - last folder - ZZ Top.

Since there are no albums under some of the artists there will just be song
titles,

But for those with albums - ex. Sinatra > Album titled Capitol Years (as a
sub-folder under Sinatra) there wil then be songs listed by tile under the
sub-folder (album).

This info is not stored in a Libre Calc or Excel file not in a Libre Writer
nor MS Word file.

They are just listed in Windows Explorer.

I simply want to print a list of every artist (by name, alphabetically)
with each of their respective albums (by name, if applicable) and then all
of each artist's songs (by name, alphabetically).

Will MusicBrainz Picard <http://picard.musicbrainz.org do that or is that
application not designed for what I'm trying to accomplish?

Thanks much.

Charles.

#2

The easiest way I can think of is:

Do <Start Menu><All Programs><"Accessories"> and left-click on <Command

Change to the directory that includes the "Music" folder using CD command.
Enter this command..
dir Music /S /B >"C:\Users\your-name-here\Desktop\Music-file-list.txt"

It should output a file on your Desktop named Music-file-list.txt

Open Music-file-list.txt with LibreOffice Writer.
Highlight "C:\Users\your-name-here\Music\" and -Find and Replace- With blank Replace line and no "Other Options".
Since I don't know where you "Music" folder is, the highlighted text maybe different, but will begin with C: and end with Music\.

This should leave you with something like...

Sinatra\CapitolYears\MyWay

Now -Find and Replace-
Find \
Replace ;

If we're lucky and there are no semi-colons in your Song names, we should be safe.

This should leave you with something like...

Sinatra;CapitolYears;MyWay

Insert a blank line on the very first line and type...
"Artist";"Album";"Song"

Do <File><Save As> Music-file-list-processed.txt
Make sure "Save as type:" is set to "Text (.txt) (*.txt)"
Do not overwrite your original file as a safety precaution.

Close Writer.

Right click on "Music-file-list-processed.txt" from your Desktop.
Open with LibreOffice Calc.
When Text Import screen comes up, make sure "Separator Options" has a check-mark next to Semicolon.

Save as a Calc file.

Now you can play with ways to display data, make corrections data in wrong column and format printing.

Hope this helps
Paul