LibreOffice Base - music cataloging

classic Classic list List threaded Threaded
7 messages Options
charles meyer charles meyer
Reply | Threaded
Open this post in threaded view
|

LibreOffice Base - music cataloging

Hi Libre Folks,

Happy New Year to you all.

I have many music files which appear as thus after creating a list of
file names using DOS command and saving in a word processor file:

12/31/2015  10:40 PM    File Size in MBs  1-25-2016 Bryan Ferry - Dont
Stop The Dance Art.mp3
01/09/2016  07:31 PM    File Size in MBs  1-9-2016 Talking Heads
Puzzlin Evidence.mp3
07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
People - Putting Out Fire.mp3

That’s just a short example of all the music to be cataloged.

It was suggested to me, so I could eventually sort alphabetically by
artist, that I search for a music cataloging application.

Then, I read Jack Wallen’s article
(http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/)
where he suggested one might consider LibreOffice Base for cataloging.

For those who’ve played around with LibreOffice Base (which I have not
yet) would it be labor intensive to use Base for this purpose?

It’s complicated to take this info and import it into Excel’s cells
and columns to then sort.

Thanks so much!

Charles.

--
To unsubscribe e-mail to: [hidden email]
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
Dries Feys-2 Dries Feys-2
Reply | Threaded
Open this post in threaded view
|

Re: LibreOffice Base - music cataloging

You can import your mp3's into iTunes, and from there you can export a
xml with all the necessary data, which you can import in base or calc.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv



Business Innovation
through
Information Technology
bi2t.tvh.com


On 21 January 2016 at 21:48, charles meyer <[hidden email]> wrote:

> Hi Libre Folks,
>
> Happy New Year to you all.
>
> I have many music files which appear as thus after creating a list of
> file names using DOS command and saving in a word processor file:
>
> 12/31/2015  10:40 PM    File Size in MBs  1-25-2016 Bryan Ferry - Dont
> Stop The Dance Art.mp3
> 01/09/2016  07:31 PM    File Size in MBs  1-9-2016 Talking Heads
> Puzzlin Evidence.mp3
> 07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
> People - Putting Out Fire.mp3
>
> That’s just a short example of all the music to be cataloged.
>
> It was suggested to me, so I could eventually sort alphabetically by
> artist, that I search for a music cataloging application.
>
> Then, I read Jack Wallen’s article
> (http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/)
> where he suggested one might consider LibreOffice Base for cataloging.
>
> For those who’ve played around with LibreOffice Base (which I have not
> yet) would it be labor intensive to use Base for this purpose?
>
> It’s complicated to take this info and import it into Excel’s cells
> and columns to then sort.
>
> Thanks so much!
>
> Charles.
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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

--


**** DISCLAIMER ****

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

--
To unsubscribe e-mail to: [hidden email]
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
anne-ology anne-ology
Reply | Threaded
Open this post in threaded view
|

Re: LibreOffice Base - music cataloging

In reply to this post by charles meyer
       There are numerous programs - commercial & free for the individual
user - which will probably do what you seek;
          here's a listing from Gizmo's of the ones they recommend -
         http://www.techsupportalert.com/search/node/music%20sorting

       Hope you locate one you enjoy using,



From: charles meyer <[hidden email]>
Date: Thu, Jan 21, 2016 at 2:48 PM
Subject: [libreoffice-users] LibreOffice Base - music cataloging
To: [hidden email]

Hi Libre Folks,

Happy New Year to you all.

I have many music files which appear as thus after creating a list of
file names using DOS command and saving in a word processor file:

12/31/2015  10:40 PM    File Size in MBs  1-25-2016 Bryan Ferry - Dont
Stop The Dance Art.mp3
01/09/2016  07:31 PM    File Size in MBs  1-9-2016 Talking Heads
Puzzlin Evidence.mp3
07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
People - Putting Out Fire.mp3

That’s just a short example of all the music to be cataloged.

It was suggested to me, so I could eventually sort alphabetically by
artist, that I search for a music cataloging application.

Then, I read Jack Wallen’s article
(
http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/
)
where he suggested one might consider LibreOffice Base for cataloging.

For those who’ve played around with LibreOffice Base (which I have not
yet) would it be labor intensive to use Base for this purpose?

It’s complicated to take this info and import it into Excel’s cells
and columns to then sort.

Thanks so much!

Charles.

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
This
email has been sent from a virus-free computer protected by Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

--
To unsubscribe e-mail to: [hidden email]
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
TomD TomD
Reply | Threaded
Open this post in threaded view
|

Re: LibreOffice Base - music cataloging

Hi :)
I think, there are a lot of apps that are purpose-built for
cataloguing and sorting music collections.  There are a couple of
hidden tags in music files to help sort them appropriately.  I think
id3v1 and id3v2.

If you are using any version of Linux then just use any of your
package manager's to search for "music" or something similar or be
more specific.  I think the default music/media-players tend to have
something that has a fairly good go at sorting music collections.
Mine used to use "Banshee" but now uses "Rhythmbox" by default.  Then
there are extra tools to help deal with pesky niggles where the 2
versions of tags seldom both get filled in.  I once tried copy&pasting
from one to the other but it quickly gets tedious and there are much
better tools for the job anyway, apparently.

I suspect that Base could probably be a good front-end for a good
range of such tools/apps.

If you are just trying to
Regards form
Tom :)







On 22 January 2016 at 00:39, anne-ology <[hidden email]> wrote:

>        There are numerous programs - commercial & free for the individual
> user - which will probably do what you seek;
>           here's a listing from Gizmo's of the ones they recommend -
>          http://www.techsupportalert.com/search/node/music%20sorting
>
>        Hope you locate one you enjoy using,
>
>
>
> From: charles meyer <[hidden email]>
> Date: Thu, Jan 21, 2016 at 2:48 PM
> Subject: [libreoffice-users] LibreOffice Base - music cataloging
> To: [hidden email]
>
> Hi Libre Folks,
>
> Happy New Year to you all.
>
> I have many music files which appear as thus after creating a list of
> file names using DOS command and saving in a word processor file:
>
> 12/31/2015  10:40 PM    File Size in MBs  1-25-2016 Bryan Ferry - Dont
> Stop The Dance Art.mp3
> 01/09/2016  07:31 PM    File Size in MBs  1-9-2016 Talking Heads
> Puzzlin Evidence.mp3
> 07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
> People - Putting Out Fire.mp3
>
> That’s just a short example of all the music to be cataloged.
>
> It was suggested to me, so I could eventually sort alphabetically by
> artist, that I search for a music cataloging application.
>
> Then, I read Jack Wallen’s article
> (
> http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/
> )
> where he suggested one might consider LibreOffice Base for cataloging.
>
> For those who’ve played around with LibreOffice Base (which I have not
> yet) would it be labor intensive to use Base for this purpose?
>
> It’s complicated to take this info and import it into Excel’s cells
> and columns to then sort.
>
> Thanks so much!
>
> Charles.
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> This
> email has been sent from a virus-free computer protected by Avast.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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

--
To unsubscribe e-mail to: [hidden email]
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
charles meyer charles meyer
Reply | Threaded
Open this post in threaded view
|

re: LibreOffice Base - music cataloging

In reply to this post by charles meyer
That data ended up in that fashion because I was trying to create a
simple list of file names of files located on a flash drive and the
only way I recall doing that in Windows XP - now 7 - is to use the DOS
command which then generates that info as I shared.

I was just trying to generate a list of file names alphabetically by
artist/file name for each .mp3 but Windows doesn't seem to do that
easily.


LibreOffice Base - music cataloging
-       48039 - Dries Feys <[hidden email]>
-

--
To unsubscribe e-mail to: [hidden email]
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
charles meyer charles meyer
Reply | Threaded
Open this post in threaded view
|

Re: LibreOffice Base - music cataloging

In reply to this post by charles meyer
Hi Dries,

Thank you for sharing that it could be imported to iTunes.

I’d prefer not to do this online but I do appreciate you sharing that.

That data ended up in that fashion because I was trying to create a
simple list of file names of files located on a flash drive and the
only way I recall doing that in Windows XP - now 7 - is to use the DOS
command which then generates that info as I shared.

I was just trying to generate a list of file names alphabetically by
artist/file name for each .mp3 but Windows doesn't seem to do that
easily.

Charles.

--
To unsubscribe e-mail to: [hidden email]
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
libreoffice-ml.mbourne libreoffice-ml.mbourne
Reply | Threaded
Open this post in threaded view
|

Re: LibreOffice Base - music cataloging

In reply to this post by charles meyer
charles meyer wrote:
> That data ended up in that fashion because I was trying to create a
> simple list of file names of files located on a flash drive and the
> only way I recall doing that in Windows XP - now 7 - is to use the DOS
> command which then generates that info as I shared.
>
> I was just trying to generate a list of file names alphabetically by
> artist/file name for each .mp3 but Windows doesn't seem to do that
> easily.

If you just want a listing of the files sorted by name, from Window's
command prompt:
 > dir /on
If you just want the file names without the other metadata (file size,
date, etc.), add /b:
 > dir /b /on
You can even redirect the output from that command into a file, which
avoids line wraps on long file names:
 > dir /b /on > filename.txt

For other options on the dir command:
 > dir /?

Mark.


--
To unsubscribe e-mail to: [hidden email]
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