Skip to main content

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Recent Posts
91
General - (fb2k) / Re: Filtering Duplicate FLACs Using MD5 Hash
Last post by SimBun -
foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available? Repeat for 'Playlist table'.
Did you also 'Add defaults' to the 'Playlist table' too?
92
General - (fb2k) / Re: How can I create a genre hierarchy?
Last post by Theboombringer1 -
First off, this is using a CUI component (library tree) so you need to be using a CUI (colums ui) config. You'd also need to familiarize yourself with using masstagger. There is a learning curve.

It's kinda useless to start explaining if you're not even using CUI. My post is to merely show you the idea and principles for you to work on.

Hello, I'm now gradually starting to learn mass tagger. But I wanted to ask you one thing just to be sure:

In Default UI I used Spider Monkey Panel to add the advanced Library Tree plugin, and it's really helpful, as far as I have tested it has all the features that the Columns UI version has. Do I really need to switch to Columns UI to start implementing your genre tagging techniques? Maybe I'm overlooking something here, I'd really appreciate your help.

Thanks
93
General - (fb2k) / Re: Filtering Duplicate FLACs Using MD5 Hash
Last post by VivinCels -
foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available?
Yes, now there are tags in the MediaLibrary table, including md5. I executed this script:
Quote
insert into Playlist_Updatable (path, playlist_name)
  select path,
         'Duplicate Tracks'
  from mediaLibrary
  where md5 in (select md5
                  from mediaLibrary
                  group by md5
                  having count(*)>1
               );
Now I understand, that SQLite takes the list of tracks from medialibrary, I configured it too, it has status monitoring folders wich have duplicates.
Spoiler (click to show/hide)
Result can see:
Spoiler (click to show/hide)
Thank you very much for help, plugin and scripts  :)

P.S. I also tried execute this script:
Quote
insert into Playlist_Updatable (path, playlist_name)
  select path,
         'Duplicate Tracks'
  from Playlist
  where playlist_index = active_playlist()
            and md5 in (select md5
                  from Playlist
                  where playlist_index = active_playlist()
                  group by md5
                  having count(*)>1
               );
But it still says "no such column: md5":
Spoiler (click to show/hide)
94
General - (fb2k) / Re: Filtering Duplicate FLACs Using MD5 Hash
Last post by SimBun -
Thank you. I tried execute both commands, but SQLite console says "SQLite Error:(1) no such column: md5"
foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available? Repeat for 'Playlist table'.

If that doesn't add it, can you let me know which version of foobar you're using, and if you have foobar configured with a media library of if you're just adding files to foobar via playlists?

I'm out for a few hours now, but will take a look when I'm back later if that doesn't work.
97
General - (fb2k) / Re: Filtering Duplicate FLACs Using MD5 Hash
Last post by fbuser -
With the latest version of foo_sqlite you should omit
Code: [Select]
drop table if exists Playlist_Updatable;
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);
at the beginning and
Code: [Select]
drop table Playlist_Updatable;
at the end of your scripts and use PlaylistUpdatable instead of Playlist_Updatable. PlaylistUpdatable is now automatically created.
98
3rd Party Plugins - (fb2k) / Re: Biography Discussion
Last post by paregistrase -
New Version: Biography v1.3.1

Enhancement and optimization of new features.

Thanks for the new features and bug fixes (that Wikipedia bug was an elusive m*f*  ;) )

Said that, I think I need a little help configuring the image sources the way I like.

I have two sources for cover and artists photo, discogs_tagger and biography panel.

discogs_tagger download cover images to $directory_path(%path%) as album art_[number] and artist photo to Musica\Data\artist_art\%DISCOGS_ARTIST_ID%\%DISCOGS_ARTIST_ID%_[number]

I would like to download all the possible images that biography can download to Musica\Data\art_img and  Musica\Data\rev_img even if there is already a valid cover in $directory_path(%path%)

And display
In cycle bio artist the images of Musica\Data\artist_art\%DISCOGS_ARTIST_ID% + Musica\Data\art_img
In cycle bio review the images of Musica\Data\rev_img + $directory_path(%path%)

But I'm not able to achieve it.

what would be the correct combination of folders and custom folders for that?






99
General - (fb2k) / Re: Filtering Duplicate FLACs Using MD5 Hash
Last post by SimBun -
That's what facets as described above will give you.

If it were me, I'd be using foo_sqlite. Using this you can run sql against your media library/playlist to identify duplicates (based on md5) and then push the resulting tracks out to a playlist.

Code: [Select]
drop table if exists Playlist_Updatable;
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);

insert into Playlist_Updatable (path, playlist_name)
  select path,
         'Duplicate Tracks'
  from Playlist
  where playlist_index = active_playlist()
            and md5 in (select md5
                  from Playlist
                  where playlist_index = active_playlist()
                  group by md5
                  having count(*)>1
               );

drop table Playlist_Updatable;

If you want to run it against your entire media library, just use
Code: [Select]
drop table if exists Playlist_Updatable;
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);

insert into Playlist_Updatable (path, playlist_name)
  select path,
         'Duplicate Tracks'
  from mediaLibrary
  where md5 in (select md5
                  from mediaLibrary
                  group by md5
                  having count(*)>1
               );

drop table Playlist_Updatable;