Export covers from amarok to album dirs (to ipod)

[otey]

Hi to all

I'm using amarok for my music, and gtkpod for my iPod. My iPod is 5th generation, and supports coverimages. But my coverimages is stored via amarok, in the folder ~/.kde/share/apps/amarok/albumcovers/large using names like 0a04f8d1a982b56a6ac8950abaab78a0. (some md5-hash, i guess)

I would like to export the pictures from the amarok folder to the album dir. I only know a tiny bit of shell script, but i was hoping that somebody would help me.

My idea was to access the ~/.kde/share/apps/amarok/collection.db to get information on which cover belong to which album. And where the album is located. Then copy it to "album_folder_path/cover.png".

Then I can use gtkpod to upload the covers..

If somebody would give me a clue how to get going, maybe how to view the content of the collection.db, i would apreciate it.

Thanks in advance

[otey]

after looking at the amarok wiki pages I wrote a script to copy the coverimage (set in amarok) to the direktory of the playing song (in amarok)

#/bin/bash

## Settings
cover_filename="cover.png"

## script
if [ "$(dcop amarok player status)" == "2" ]; then

	current_song="$(dcop amarok player path)"
	album_dir=${current_song%/*.mp3}
	picture_source="$(dcop amarok player coverImage)"
	picture_target=$album_dir"/"$cover_filename
	album_name="$(dcop amarok player album)"
	artist_name="$(dcop amarok player artist)"

	if [ "$picture_source" != "$picture_target" ]; then 
		if [ "${picture_source%%/*nocover.png}" != "" ]; then
			cp "$picture_source" "$picture_target"
			echo -e "Cover copied: $artist_name - $album_name"
		else
			echo "No cover set!"	
		fi
	fi
fi

[otey]

Ok.. Made the script go trough the whole playlist, copy covers.

Don't run it, with all files in the playlist. What i did was to add all my albums, then mark them all, and while holding ctrl I picked one song from every album. Then removed the other songs from the playlist.

the script:

#/bin/bash

## Settings
cover_filename="cover.png"


## script
while [ "$(dcop amarok player status)" == "2" ]; do
	current_song="$(dcop amarok player path)"
	album_dir=${current_song%/*.mp3}
	picture_source="$(dcop amarok player coverImage)"
	picture_target=$album_dir"/"$cover_filename
	album_name="$(dcop amarok player album)"
	
	if [ -f "$picture_target" ]; then
	  dcop amarok player next
	else
		if [ ${picture_source%%/*nocover.png} != "" ]; then
			cp "$picture_source" "$picture_target"
			echo "Cover copied: \"$album_name\""
		fi
	fi
done

[TheIrishGuy]

nice script guys, thumbs up here

i made a few minor changes

first off i have a hell of a lot of mp3s(50k+), and i dont really want to click anything other than "go" and walk away.

At the same time i want to be able to see some sort of progress so i added a number increment so i can actually see its doing something.
Number increment may seem unnecessary but is kinda handy. kind of like a progress bar as amarok will be left minimized

also added some inverted commas to avoid any dirty things like

line 21: [: !=: unary operator expected

#/bin/bash


## Settings
cover_filename="cover.png"
cover_number=0



## script
while [ "$(dcop amarok player status)" == "2" ]; do
	current_song="$(dcop amarok player path)"
	album_dir=${current_song%/*.mp3}
	picture_source="$(dcop amarok player coverImage)"
	picture_target=$album_dir"/"$cover_filename
	album_name="$(dcop amarok player album)"
	cover_number=$((cover_number+1))
	
	if [ -f "$picture_target" ]; then
	  	dcop amarok player next
	else
		if [ "${picture_source%%/*nocover.png}" != "" ]; then
			cp "$picture_source" "$picture_target"
			echo $cover_number " Cover copied: \"$album_name\""
			dcop amarok player next
		else
			echo $cover_number " No cover set!"
			dcop amarok player next	
		fi
		
	fi
done

i wreckon it will take a couple of hours, but its worth it!

[smartbei]

Many thanks guys! I was looking for something just like this.

[geirha]

I made a script to do this myself, but I can't seem to find it again. I managed to put together the query I used to query the amarok database with though:

SELECT DISTINCT CONCAT('~/.kde/share/apps/amarok/albumcovers/large/',MD5(LOWER(CONCAT(artist.name,album.name)))), tags.dir
FROM album, artist, tags WHERE album.id=tags.album AND artist.id=tags.artist

while amarok is running, you can run the query through dcop:

 dcop amarok collection query "SELECT DISTINCT CONCAT('~/.kde/share/apps/amarok/albumcovers/large/',MD5(LOWER(CONCAT(artist.name,album.name)))), tags.dir
FROM album, artist, tags WHERE album.id=tags.album AND artist.id=tags.artist"

As you probably see, if you know a little sql, the covers are stored to a file in ~/.kde/share/apps/amarok/albumcovers/large/ with the md5sum of artist name+album name in lower case. So if you have the album David Bowie - Aladdin Sane, the cover will be stored as

$ echo -n "david bowiealaddin sane"|md5sum
f73bc66afee49e43fffdea0e194cc2fc  -

There's a special case for albums which have several (various) artists though, if I remember correctly, the cover names are only made from the md5sum of the album name in such cases.

Hope this helps.

[TheIrishGuy]

latest copycover script now works

you can download it from here

http://www.kde-apps.org/content/show...?content=22517

once it has copied the images into the destination folders you can use the below script to apply album covers to the folders in Nautilus


http://ubuntuforums.org/showpost.php...6&postcount=18

in order to use this script you need to either change the script or rename the png files to folder.png

i got this from a nice person in #bash in irc.ubuntu.com

test it first (echo)

find . -name "*.png" | while read file; do echo mv "$file" "${file%/*}/cover.png"; done

once your sure

find . -name "*.png" | while read file; do mv "$file" "${file%/*}/cover.png"; done

[dannyboy79]

Originally Posted by TheIrishGuy latest copycover script now works you can download it from here http://www.kde-apps.org/content/show...?content=22517 once it has copied the images into the destination folders you can use the below script to apply album covers to the folders in Nautilus http://ubuntuforums.org/showpost.php...6&postcount=18 in order to use this script you need to either change the script or rename the png files to folder.png i got this from a nice person in #bash in irc.ubuntu.com test it first (echo) find . -name "*.png" | while read file; do echo mv "$file" "${file%/*}/cover.png"; done once your sure find . -name "*.png" | while read file; do mv "$file" "${file%/*}/cover.png"; done

i had luck with this website instruction here: http://www.64bitjungle.com/ubuntu/ba...ing-directory/