Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

[Paul D. Mirowsky]

Have you added the metadata from C:\Music\Sinatra\CapitolYears\MyWay to 
your files?




On 4/24/2017 1:10 PM, charles meyer wrote:

My learned and esteemed listmates,

I wish to print the names of every artist with their respective album names
and with each respective song tile (file named as such – e.g. My Way) under
that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
  Love and Marriage
  New York New York
 Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
   Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on it. I
want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it prompted
that for an install) I get the error message - ”Installer integrity check
has failed. Common causes include an incomplete download and damaged media.
Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - and it
only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

[Paul D. Mirowsky]

Two programs to help fill and export metadata.


MusicBrainz Picard  is a cross-platform 
(Linux/Mac OS X/Windows) application written in Python and is the 
official MusicBrainz  tagger.


https://picard.musicbrainz.org/


With *Mp3tag* you can export file and tag information of your audio 
collection to files with user-defined file formats. You can either use 
one of the predefined export configurations to export file information 
to Excel via the CSV export configuration, let Mp3tag create a nicely 
looking HTML playlist with one of the html export configurations or you 
create an export configuration by yourself where you can freely decided 
on the file format and the layout.


An export configuration consists of a unique name, a filename for the 
exported file and the definition of the file format. The file format is 
defined by you, so it's possible to create, e.g., HTML, XML, CSV, batch 
file or LaTeX output.


Mp3tag features a simple template language which can be used to loop 
over artists, albums and arbitrary other tag fields. The tag and file 
informations are represented by placeholders, which are replaced when 
doing the export. You can find an overview of all valid placeholders and 
an example at /Configuration, Export/ 
.


http://help.mp3tag.de/main_export.html

I have not used Mp3tag, but it should work as claimed.

Picard is excellent, but a bit of patience is greatly rewarded.

Donate if you can.

Hope this helps.

Paul



On 4/24/2017 1:32 PM, Paul D. Mirowsky wrote:
Have you added the metadata from C:\Music\Sinatra\CapitolYears\MyWay 
to your files?




On 4/24/2017 1:10 PM, charles meyer wrote:

My learned and esteemed listmates,

I wish to print the names of every artist with their respective album 
names
and with each respective song tile (file named as such – e.g. My Way) 
under

that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
  Love and Marriage
  New York New York
 Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
   Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on 
it. I

want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it 
prompted
that for an install) I get the error message - ”Installer integrity 
check
has failed. Common causes include an incomplete download and damaged 
media.

Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - 
and it

only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

[Paul D. Mirowsky]

The easiest way I can think of is:

Do <"Accessories"> and left-click on Prompt>

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  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


On 4/27/2017 4:13 PM, charles meyer wrote:

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.

From: "Paul D. Mirowsky" 
To: users@global.libreoffice.org
Date: Tue, 25 Apr 2017 10:46:45 -0400
Subject: Re: [libreoffice-users] Libre Writer or Excel - File Name List -
Pritning
Two programs to help fill and export metadata.


MusicBrainz Picard <http://picard.musicbrainz.org> is a cross-platform
(Linux/Mac OS X/Windows) application written in Python and is the official
MusicBrainz <http://musicbrainz.org> tagger.

https://picard.musicbrainz.org/






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted