Update multiple tracks with same album cover image

[Tony316]

Hello, I have multiple tracks and I would like to update their cover image according to their album (I have one cover image for every album).

I have updated their cover using mp3tag, but when I import them in RadioDJ the cover isn't imported in the database so I have to import it  manually for every track.

I have noticed that when importing a cover it is saved in C:\RadioDJv2\Album-Art with the same name as the track name.

So my question is can I update the cover of all tracks of the same album at once and not one by one?

I tried to run an SQL script something like this:

Code Select Expand

UPDATE SONGS SET IMAGE = [IMAGE NAME] WHERE ALBUM = [ALBUM NAME]

where [IMAGE NAME] is the name of an image in C:\RadioDJv2\Album-Art file, but it didn't work.

Any ideas how I could achieve this?

Thank you in advance.

P.S.: I didn't find any relevant topic, but if there is one please tell me.

[Vanlen]

but when I import them in RadioDJ the cover isn't imported in the database so I have to import it  manually for every track.

2 Things to check

1   Make sure under Options/other settings that the location of your Artwork storage location is correct and that ENABLED is ticked.


2. When you imported the Directory under options did you tick Use ID3 Stored Cue Tag if Present?

If not you can re-import the lot but make sure you also tick "Empty Subcat" which will delete the existing without covers and will import them hopefully with the covers intact.   Just remember to untick the Empty Subcat option when just loading new files from that directory so RadioDJ will only import NEWER songs.

Hope this helps
Cheers





[attachment deleted by admin]

[Tony316]

Well both solutions worked fine, but the 2nd one is definitely more convenient because adding cover image with mp3tag is easier.
(The first solution also worked using the SQL script I wrote, but would be useful if I want to edit cover image of tracks that I have already imported).

Thank you very much for your help.
Cheers!

[RFU]

If your tags are set properly, if the album name is properly set for every song on the album, then all you have to do is name the new album image the same as the image name in your album art folder and upload it to your server. It will not change the album art in the mp3 but it will display the new album art.

So if the old album art is named as joesband-joesalbum.jpg, then use the same name for the new album art.

However, for continuity and so there are no problems in the future it's better the delete the tracks from the database and delete the image from the album art folder, use something like Tag & Rename to import the new art into the mp3 files, and then import the tracks again. REMEMBER to delete the old album art before you reimport the tracks. Otherwise RadioDJ will see the old album art in the album art folder and will not extract or overwrite the old album art.

[Jonty]

I have had the same problem as Tony316.  I used the following SQL to do the job:

UPDATE songs
SET image= CONCAT(album,'.jpg')
WHERE album = "Freds Greatest Hits";

This does the job for the whole album!
For the next album just update the name of the album in Line 3.