
	KDE-Apps.org Applications for the KDE-Desktop GTK-Apps.org Applications using the GTK Toolkit CLI-Apps.org Command Line Applications Qt-Apps.org Free Qt Applications Qt-Prop.org Proprietary Qt Applications Maemo-Apps.org Applications for the Maemo Plattform Java-Apps.org Free Java Applications eyeOS-Apps.org Free eyeOS Applications Wine-Apps.org Wine Applications Server-Apps.org Server Applications


	KDE-Look.org Artwork for the KDE-Desktop GNOME-Look.org Artwork for the GNOME-Desktop Xfce-Look.org Artwork for the Xfce-Desktop Box-Look.org Artwork for your Windowmanager E17-Stuff.org Artwork for Enlightenment Beryl-Themes.org Artwork for the Beryl Windowmanager Compiz-Themes.org Artwork for the Compiz Windowmanager EDE-Look.org Themes for your EDE Desktop


	Debian-Art.org Stuff for Debian Gentoo-Art.org Artwork for Gentoo Linux SUSE-Art.org Artwork for openSUSE Ubuntu-Art.org Artwork for Ubuntu Kubuntu-Art.org Artwork for Kubuntu LinuxMint-Art.org Artwork for Linux Mint Arch-Stuff.org Art And Stuff for Arch Linux Frugalware-Art.org Themes for Frugalware


	KDE-Files.org Files for KDE Applications OpenTemplate.org Documents for OpenOffice.org GIMPStuff.org Files for GIMP InkscapeStuff.org Files for Inkscape ScribusStuff.org Files for Scribus BlenderStuff.org Textures and Objects for Blender


	KDE-Help.org Support for your KDE Desktop GNOME-Help.org Support for your GNOME Desktop Xfce-Help.org Support for your Xfce Desktop

openDesktop.org: Applications Artwork Linux Distributions Documents Open-PC.com

collection2html

0.1.3

Amarok Script

drnoone

Marcelo Bovo
Argentina, Buenos Aires
last visit Jan 8 2009
0 friends
0 groups

other contents
send a message
add as friend
more info

Link:  http://
Depends on:  KDE 3.0.x
Downloads:  1191

Submitted: Jul 2 2007
Updated: Jan 5 2009

Score:

80% good

bad

good

Description:

Version 0.1.3

amaroK collection2html
License: GPL v2

This script will create a html page containing your mp3 collection ordered by Artist and Album. No customizations are available at this time with the execption of the ouput file selection at runtime.
Heavily based on playlist2html from André Kelpe (fs111 at web dot de).

Requeriments:
Python 2.3
KDE 3.x (for dialog window)

Known problems:

* If the album title is NULL then the script will skip it. This is a constraint due to an unsolved dcop bug wich causes null fields to be skipped on an sql query output.
* The author doesn't knows nothing about Python.

Author:
Marcelo Bovo
mdbovo at gmail dot com

Changelog:

0.1 Initial release
0.1.1 Minor typo fixes
Converted album length to HH:MM:SS format.
0.1.2 Fixed issue with albums with the same name and compilations.
0.1.3 Fixed sql query error on some systems (thanks sputnik73!)

License: GPL

(collection2html)

send to a friend
subscription
other apps from drnoone

Wonderful!

by BorgQueen on: Jul 3 2007

BorgQueen

Kate Draven
last visit Feb 5 2010
4 friends
2 groups

other contents
send a message
add as friend
more info

I just tried out your amarok script and it works GREAT! This is very useful for parties and DJ events. You can just leave the list up for people to make requests.

Thank you very much.

reply to this

Re: Wonderful!

by drnoone on: Jul 5 2007

drnoone

Marcelo Bovo
Argentina, Buenos Aires
last visit Jan 8 2009
0 friends
0 groups

other contents
send a message
add as friend
more info

Thanks! I'm glad you've found it useful.
I've detected some problems with albums with the same name ("The Best of" for example). I'm releasing a new version before the end of the weeks.

Regards
drnoone

reply to this

Re: Re: Wonderful!

by BorgQueen on: Jul 5 2007

BorgQueen

Kate Draven
last visit Feb 5 2010
4 friends
2 groups

other contents
send a message
add as friend
more info

Thanks, its greatly appreciated.

reply to this

Not working for me

by gerardolm on: Aug 8 2007

gerardolm

Gerardo Lastra
last visit Aug 9 2007
0 friends
0 groups

other contents
send a message
add as friend
more info

[code]File "/home/gerardo/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list[/code]

Am I supposed to do anything before running it?

Thanks

reply to this

Re: Not working for

by jayenell on: Aug 18 2007

jayenell

Jayenell Jayenell
last visit Dec 10 2008
0 friends
0 groups

other contents
send a message
add as friend
more info

Same for me or does it only work with sqllite and not with mysql?

reply to this

Re: Re: Not working

by drnoone on: Aug 24 2007

drnoone

Marcelo Bovo
Argentina, Buenos Aires
last visit Jan 8 2009
0 friends
0 groups

other contents
send a message
add as friend
more info

jayenell: It should work with both mysql and sql-lite. All database querys are made through amarok dcop interface so wich database is on the backend is transparent to my script.

gerardolm: It seems as if your music collection were empty (no records were returned from your query). Could you send me more information about the error?.

Regards,
Marcelo

reply to this

Re: Re: Re: Not work

by gmhafiz on: Sep 11 2007

gmhafiz

Hafiz Shafruddin
India, Bangalore
last visit Sep 8 2009
0 friends
0 groups

other contents
send a message
add as friend
more info

Same here. I'm using mySql

This is the error message:

Traceback (most recent call last):
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 25, in ?
main()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 12, in main
collect = Collection()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 73, in init
self._buildDoc()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 95, in _buildDoc
self._extractTracks()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list
Traceback (most recent call last):
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 25, in ?
main()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 12, in main
collect = Collection()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 73, in init
self._buildDoc()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 95, in _buildDoc
self._extractTracks()
File "/home/gmhafiz/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list

reply to this

Fails with MySQL

by marcelpaulo on: Oct 8 2007

marcelpaulo

Paulo Marcel Coelho Aragão
last visit Nov 12 2007
0 friends
0 groups

other contents
send a message
add as friend
more info

I have just converted my amarok database from SQLite to MySQL, and collection2html also fails with the same error backtrace as was previously shown.

reply to this

Re: Fails with MySQL

by mierdaman on: Apr 29 2008

mierdaman

Armando Guerra Segura
last visit Apr 29 2008
0 friends
0 groups

other contents
send a message
add as friend
more info

I also have this problem. I paste the error log:

Traceback (most recent call last):
File "/home/javi/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 25, in <module>
main()
File "/home/javi/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 12, in main
collect = Collection()
File "/home/javi/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 73, in init
self._buildDoc()
File "/home/javi/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 95, in _buildDoc
self._extractTracks()
File "/home/javi/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list

reply to this

PgSQL

by JohnNy64 on: Jun 15 2008

JohnNy64
Home

Michal Petrucha
Slovak Republic, Šamorín
last visit Jun 15 2008
0 friends
0 groups

other contents
send a message
add as friend
more info

Seems like the same problem that I ran into with PostgreSQL:

Traceback (most recent call last):
File "/home/JohnNy64/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 25, in <module>
main()
File "/home/JohnNy64/.kde/share/apps/amarok/scripts/collection2html/collection2html.py", line 12, in main
collect = Collection()
File "/home/JohnNy64/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 73, in init
self._buildDoc()
File "/home/JohnNy64/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 95, in _buildDoc
self._extractTracks()
File "/home/JohnNy64/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list

The query

select artist.name, album.name,sum(length),count(track),year.name from tags, album, artist, year where tags.album = album.id and tags.artist = artist.id and tags.year = year.id and album.name <> "" and tags.sampler = 0 group by tags.artist, tags.album, tags.year union select "Various Artists", album.name,sum(length),count(tags.track),year.name from tags, album, year where tags.album = album.id and tags.year = year.id and album.name <> "" and tags.sampler = 1 group by tags.album, tags. year

doesn't return anything. But I don't know much about the SQL language, so I don't understand what it is supposed to do...

reply to this

Fix for MySQL

by sputnik73 on: Jun 16 2008

sputnik73

Oliver Jusinger
last visit Dec 30 2008
0 friends
0 groups

other contents
send a message
add as friend
more info

To work with mySQL, line 103 must be replaced by:

doc = os.popen('dcop amarok collection query \'select artist.name AS Artist, album.name AS Album,sum(length) AS Length,count(track) AS Tracknr,year.name AS Year from tags, album, artist, year where tags.album = album.id and tags.artist = artist.id and tags.year = year.id and album.name <> "" and tags.sampler = 0 group by tags.artist, tags.album, tags.year union select "Various Artists", album.name,sum(length),count(tags.track),year.name from tags, album, year where tags.album = album.id and tags.year = year.id and album.name <> "" and tags.sampler = 1 group by tags.album, tags. year\'').readlines()

Reason:
1) Subquery must be named, but is obsolete anyway
2) "Name" fields must be named unique

add commentback

anti windows lookalike themes

Desktop Screenshots

THE ULTIMATE EDITION GROUP

Newest Groups

anti windows lookalike themes

Semantic CLI framework

Zagaia

Gaming - Classic to Current

GULCAT

Markus der Liebe

FOSS Economy

FORUM

Partners
Place Your Link Here!
online casino bonus

Cool Sites
iPhone Hintergrundbilder

Who we are
Contact
More about us
Frequently Asked Questions
Register
Twitter
Blog

Explore
Apps
Jobs
Knowledge Base
Events
People
Updates on identi.ca
Updates on Twitter
Facebook App
Content RSS
Events RSS

Participate
Groups
Forum
Add App
Public API

About KDE-Apps.org
Legal Notice
Spreadshirt Shop
CafePress Shop
Advertising
Sponsor us
Report Abuse

Copyright 2003-2010 KDE-Apps.org Team
All rights reserved. KDE-Apps.org is not liable for any content or goods on this site.
All contributors are responsible for the lawfulness of their uploads.
KDE and K Desktop Environment are trademarks of KDE e.V.

collection2html

Amarok Script

0.1 Initial release 0.1.1 Minor typo fixes Converted album length to HH:MM:SS format. 0.1.2 Fixed issue with albums with the same name and compilations. 0.1.3 Fixed sql query error on some systems (thanks sputnik73!)

Wonderful!

I just tried out your amarok script and it works GREAT! This is very useful for parties and DJ events. You can just leave the list up for people to make requests. Thank you very much.

Re: Wonderful!

Thanks! I'm glad you've found it useful. I've detected some problems with albums with the same name ("The Best of" for example). I'm releasing a new version before the end of the weeks. Regards drnoone

Re: Re: Wonderful!

Thanks, its greatly appreciated.

Not working for me

[code]File "/home/gerardo/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks value = doc.pop() IndexError: pop from empty list[/code] Am I supposed to do anything before running it? Thanks

Re: Not working for

Same for me or does it only work with sqllite and not with mysql?

Re: Re: Not working

Re: Re: Re: Not work

Fails with MySQL

I have just converted my amarok database from SQLite to MySQL, and collection2html also fails with the same error backtrace as was previously shown.

Re: Fails with MySQL

PgSQL

Fix for MySQL

0.1 Initial release
0.1.1 Minor typo fixes
Converted album length to HH:MM:SS format.
0.1.2 Fixed issue with albums with the same name and compilations.
0.1.3 Fixed sql query error on some systems (thanks sputnik73!)

I just tried out your amarok script and it works GREAT! This is very useful for parties and DJ events. You can just leave the list up for people to make requests.

Thank you very much.

Thanks! I'm glad you've found it useful.
I've detected some problems with albums with the same name ("The Best of" for example). I'm releasing a new version before the end of the weeks.

Regards
drnoone

[code]File "/home/gerardo/.kde/share/apps/amarok/scripts/collection2html/Collection.py", line 111, in _extractTracks
value = doc.pop()
IndexError: pop from empty list[/code]

Am I supposed to do anything before running it?

Thanks