Music Collection to Excel Database

Posted by: Red Kite on 01 March 2018

I have searched and found a few queries but no solution.

I just want to have a list of all my albums so i dont buy duplicates when out shopping. Its would basically be an alphabetical list of all the folders in the UnityCore but i am at a loss on how to do it. I have tried exporting from my backup drive using mp3tag or TagScanner but just get gobblydygook.

Does anyone have a simple solution or indeed could Naim provide that function ?

Posted on: 03 March 2018 by Red Kite

OK, i'll google it .....

Posted on: 03 March 2018 by Eoink
ChrisR_EPL posted:

Things like this are interesting as there's always a million ways to do the same thing. Here's one that works.

Assume that your music is in a NAS drive and you've already mapped it to a drive letter. I use B: for no reason other than it isn't C:  **SNIP**

But B: is your second floppy drive!

Posted on: 03 March 2018 by docmark

Anything that would work with a Mac?

Posted on: 03 March 2018 by docbot

To keep track of my music collection on my server, when out of the house, I actually use Plex. I point Plex to the folders on my server and enable remote access. I don’t use Plex to play the music just movies (I use Asset for that). It works well and means I have an up to date view of my collection (4500 albums and growing!) on my iPhone. Plex is not brilliant with the metadata but works well enough. I don’t know if Plex can be used with the unity core though.

Posted on: 03 March 2018 by George H
docmark posted:

Anything that would work with a Mac?

Yep - easy, use Meta by Nightbirdsevolve - download from the App Store. look up your files on your NAS for example and export straight in to Excel, Notes etc in perfect format. It also manages meta tags and album artwork with ease. https://www.nightbirdsevolve.com/meta/

Posted on: 04 March 2018 by docmark

Hello George H - Well, I've installed Meta on my Mac, but when I aim it at my Core, select the files under "MQ" and select "Open," all I get is a whirling beachball.  So, I Force Quit and try it all over again - same result.  Any ideas?

Posted on: 04 March 2018 by George H
docmark posted:

Hello George H - Well, I've installed Meta on my Mac, but when I aim it at my Core, select the files under "MQ" and select "Open," all I get is a whirling beachball.  So, I Force Quit and try it all over again - same result.  Any ideas?

How many tracks do you have? It will take a while if you are reading over a network and if you have 100's of albums it could take a few minutes at first. Do you have the track backed up on a NAS or HDD? If so, I find that much quicker.

Posted on: 04 March 2018 by docmark

I have about 2300 albums ripped to my Core.  I'll try Meta again & give it some time.  I'm just a little concerned why the whirling beachball would appear - doesn't that mean that the application is unresponsive?

Posted on: 04 March 2018 by Innocent Bystander

I note Meta is not free, unlike the fixes hitherto discussed for Windows. Surely similar means of importing the file structure into Excel must exist/work on Mac?

 

Posted on: 04 March 2018 by Jan-Erik Nordoen
ChrisSU posted:
Jan-Erik Nordoen posted:

If the Naim app maintains a cache of ripped discs (as does the nServe app), then you'll always have an album list in your pocket when shopping.

Jan, how do you find cached info. in N-Serve? I’ve only been able to view albums when it’s connected to the server. 

Hi Chris,

It was automatic before the last nServe update, on my iphone at least, but not since. Currently, with my phone disconnected from wifi, I have access to full album list with cover images. Searching by genre or artist works down to the level of album name & image, while conductor or composer gets to them but no further.

The cache seems to 'stick' when I call up album search on nServe first before leaving the wifi zone. Worth a try.

Jan