MediaMonkey forum

wdp wrote: ↑Mon Nov 23, 2020 12:45 pm There is nothing to paste but there is an extra line.

I told you, I wanted that you copy/paste the Comment field as it was "before applying the preset" when it still "contained iTunes info". I wanted the original sample to see how it looks like and to try to reproduce the problem with it, but I cannot do that with what you got as the result of the preset. You confused me with that "0x" thing and an extra empty line on the beginning of the Comment, when in fact it was you who added that to the existing iTunes info. Anyway, I am glad that you don't have issues any more.

I just don't know how to do that. I have converted the field so I can't show you what it was before I converted it. So I tried to show what is in the iTunes database. I didn't point MM to that database. I pointed it to a copy of that database and it has now been converted using the find and replace addon.

I did not insert the extra line. I inserted an X in one record as I was using the addon. As it didn't yield a good outcome, I didn't do that again. Following your direction, I was able to ascertain that your theory was correct. There is an extra line.

I've been driving myself a little mad trying to figure this out and I can't find anything in the search (perhaps I'm not searching the right thing); so I wonder if those well-versed in this stuff can help me.

Is there a way to alphabetise the artists field? I currently have them stored with ";" separators.

e.g.: "Bomb the Bass; Sinéad O'Connor; Benjamin Zephaniah".

But I would want to be able to alphabetise that field, so it would appear:

"Benjamin Zephaniah; Bomb The Bass; Sineád O'Connor".

The closest I managed to find here was:
- But that gets ALL of the artist values for the ENTIRE album the track is on, rather than just that one track on its own and nothing I seem to change will make it just fetch the artists for that ONE song, rather than ALL the artists featured on the album for which the song appears.

Many thanks,
cokehearth

cokehearth wrote: ↑Fri Dec 04, 2020 4:53 am Is there a way to alphabetise the artists field?

Maybe you could try this:

ZvezdanD wrote: ↑Fri Dec 04, 2020 3:57 pm

cokehearth wrote: ↑Fri Dec 04, 2020 4:53 am Is there a way to alphabetise the artists field?

Maybe you could try this:

Code: Select all

SQLQuery("SELECT group_concat(AA, '; ') FROM (SELECT DISTINCT Artists.Artist AS AA FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID WHERE Songs.ID = " & oSongData.ID & ")")

It appears to work! Thank you VERY much for that, you've made my music collection work a lot better.

It really is genuinely appreciated!

Can't believe I can't figure this out or find a simple script ...

How do I prepend the disc # on to the track #?

For example, I have a bunch of songs with disc # set to 2, and track #'s running 01, 02, 03 ...

I want to keep the disc # tag as is, and change the track # tags to 201, 202, 203 ...

RegExp should be able to do this: viewtopic.php?f=2&t=28510&hilit=regexp

Ooooooh. Don't say that.

I just spent an hour trying to figure out the interface of that script, and I got nowhere. And I use things like that all the time, and I'm pretty good with regex.

Is there a tutorial out there somewhere?

If you have any constructive suggestion how the user interface could be improved to be easier and more intuitive, but keeping the same level of flexibility and functionality, I will definitely consider it. It is easy to criticize someone's hard work, being creative is much harder.

The tutorial for the add-on could be found in the Usage section on the very same web page from which you downloaded the add-on. You could get that page loaded in your default web browser if you click the version number of the add-on displayed in the top-right corner of its Options dialog box.

Hello, I have scanned my files and see like 500 albums with "unknown" album artists in art view, although the artist field is correct. I have downloaded REGEXP but this does not help: I want the artist tag copied into the album artist field only if "unknown" in shown in the album artist field. Don't want to use the function manually on 500 albums. Please advise how to change automatically, thank you

achimv wrote: ↑Sat Jan 16, 2021 7:37 am I want the artist tag copied into the album artist field only if "unknown" in shown in the album artist field.

By "unknown" you mean empty, right? Did you try the predefined preset "Copy <From Field> to <Into Field> only if it is empty..."?

no, not empty , I have seen that RegExp rule. It is written "unknown" in the field, that is not empty, right?

OK, this works on a single album, great! But how can I apply this o all 500 albums with the same problem? I tried o mark them all, but does not work. If I use function from EDIT-Menu, nothing happens....

works fine now, thanks!

Hello Zvezdan,

a user suggested i should ask you directly: https://www.mediamonkey.com/forum/viewt ... 95#p481695

My case is, I want achieve a special thing and I should use your addon RegExp, but how you can read, I have some special needs, that the addon actually don't fit.

I want mass copy the "Last Modified" property of video files (but only the date not the timestamp) for the "date" value in Media Monkey. I've found a preset for the creation date, but the files are copies so the creation date of the files isn't when the clips are taken, but the modified date is it. So I need this.

other Problem: I can't automatically copy this value in the "date" field directly. I get an error-message, I think because the preset includes the timestamp and the "date" value-field can't process this.

So I would ask if their is there another way to obtain, what I want?