Posts: 115
Joined: Mar 2012
Reputation:
0
Hey people,
After getting some excellent help from the peeps who hang out in the hardware forum, I have started to turn my attention to the software package that is XBMC. In this case, I'm looking for some help with my music collection.
I'm wondering if anyone has written any scripts, or if there is a tool, or if it exists in the default, whereby I can have my FLAC library and MP3 library merged so that any instance of FLAC replaces any duplicate instance of mp3. I have looked into this matter independent of XBMC for the past few months and it looks like i'm resigned to have to come up with something myself to do this.
Though I'm not sure this will matter, my HTPC will be a windows based i7 and my data will be stored on a Netgear Ultra2 2x2TB NAS.
In the event that this would be better served in the Supplemental Tools section of the forum, please let me know.
The Mi7 (full specs)
HTPC: Antek ISK 300 | Pico 160 | ASRock z77E | i7 3770S | GSkill Ares 8GB | BigShuriken 2 | Crucial 64 SSD
TOYS: Panasonic TC-P58S2 | Onkyo TX-SR608 | Atlantic Tech 2400 | Harmony 1 | iPazzPort ProMini | Mohu 1000 | HomeRun Dual | 2x2TB NAS
Posts: 351
Joined: May 2011
Reputation:
1
2012-06-03, 03:38
(This post was last modified: 2012-06-03, 03:39 by digitaltomj.)
I dont think xbmc will prefer one file format over the other...i could be wrong...but im pretty sure if you tell XBMC to look for music in a specific folder...it will find it and put it in your library...i know my music library has both mp3s and flac in it...I think you would be better off going thru your music files in explorer, group by type, and any that are duplicates with versions of both flac and mp3s you can then either delete or move the unwanted duplicates from the folder and into another.
Posts: 115
Joined: Mar 2012
Reputation:
0
Thanks, that's what I was afraid of - not such a big deal if you only have a few thousands songs ... but kind of a pain if you have roughly 1/2 a terabyte!
Basically, I think i'm going to have to write a program that compares directory structure and ID3 tags that actually goes through and deletes the mp3 off the HDD. Not looking forward to it :-(
The Mi7 (full specs)
HTPC: Antek ISK 300 | Pico 160 | ASRock z77E | i7 3770S | GSkill Ares 8GB | BigShuriken 2 | Crucial 64 SSD
TOYS: Panasonic TC-P58S2 | Onkyo TX-SR608 | Atlantic Tech 2400 | Harmony 1 | iPazzPort ProMini | Mohu 1000 | HomeRun Dual | 2x2TB NAS
Posts: 351
Joined: May 2011
Reputation:
1
I bet there is some third party software out there that will help out...at the very least you can do a dir print just to see which files are redundant...give me some time to look and I might find something.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
Once scanned into XBMC you could then check for duplicates using a few sql commands on the database.
Posts: 351
Joined: May 2011
Reputation:
1
2012-06-03, 04:06
(This post was last modified: 2012-06-03, 04:14 by digitaltomj.)
lol, or do what jmarshall said
Edit...this was meant to be posted directly after jmarshall...lol, you guys post quick...but I dont know much about sql so I cant help you there
Posts: 115
Joined: Mar 2012
Reputation:
0
2012-06-03, 04:22
(This post was last modified: 2012-06-03, 05:04 by helpermonkey.)
haha digital - yeah i went to respond and y'all already hoped on that. I had no idea that XBMC involved SQL in any significant manner ... so his suggestion *might* be sufficent. Still, I appreciate your links as they might work too!!!!
*fixed for dumbassery*
The Mi7 (full specs)
HTPC: Antek ISK 300 | Pico 160 | ASRock z77E | i7 3770S | GSkill Ares 8GB | BigShuriken 2 | Crucial 64 SSD
TOYS: Panasonic TC-P58S2 | Onkyo TX-SR608 | Atlantic Tech 2400 | Harmony 1 | iPazzPort ProMini | Mohu 1000 | HomeRun Dual | 2x2TB NAS
Posts: 351
Joined: May 2011
Reputation:
1
btw, did you post in the mediamonkey forum? cause I found a post like yours in there while searching for you, lol
Posts: 26,215
Joined: Oct 2003
Reputation:
187
This has nothing to do with mysql.
My point was simply that once everything is in an sql database, you can do queries such as:
select * from song where strFileName like '%.flac';
From there, you could join two queries together (one for mp3, one for flac, joined on the tracknumber, albumid for example) and get all duplicates.