m27315's dashboard

Hi Ivan,

Thanks for the quick turnaround!!! Unfortunately, I am still hitting some bugs.

If I use the "--ignore" switch, I get this stack trace:

java .:sqlitejdbc-v054.jar iTunesRatingsToSongbirdCollisions --ignore -i "/winxp/Documents and Settings/Bowen/My Documents/My Music/iTunes/iTunes Music Library.xml" -s "/home/tbowen/.songbird2/kv8vzrn2.default/db/main@library.songbirdnest.com.db"
Exception in thread "main" java.lang.NoClassDefFoundError: /:sqlitejdbc-v054/jar
Caused by: java.lang.ClassNotFoundException: .:sqlitejdbc-v054.jar
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
Could not find the main class: .:sqlitejdbc-v054.jar. Program will exit.

If I omit the "--ignore" switch, I am able to complete successfully; however, if I accidentally enter the wrong number during a collision (for example, valid choices are 0, 1, and 2, but I enter "11" by fat-finger), then the program crashes. Could you add some error handling to ensure that an entered number is 0 or one of the available choices?

Also, I think you could cut the number of queries in half. Think of it this way, you have 2 similar files that match 2 other similar files. It could be either (A1=X1,A2=X2) or (A1=X2, A2=X1). Once I tell you one of the matches, you should know the other. ... This would help avoid "unmatched songs".

Also, in the above case, it would be nice to have an automatic "don't care" switch to apply for cases where the song names matched exactly. This usually occurs during a weird import (for example, same album imported twice, with slightly different album name but same song name). Most of my 154 conflicts, I did not really care.

Now for the worst bug... If I omit the "--ignore" option, the program ran to completion, but nothing changed! (I make sure Songbird is off when I run.)

I only have one profile, and I keep Songbird off, so I don't know what else it could be.

Any thoughts?

Thanks for all your hard work!!!

I got further using the --ignore switch, but it still crashes with:

Searching. . .
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 9, Size: 9
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at biTunesRatingsToSongbirdratings1210.searchSql(biTunesRatingsToSongbirdratings1210.java:480)
at biTunesRatingsToSongbirdratings1210.main(biTunesRatingsToSongbirdratings1210.java:210)

It seemed to have many more collisions than I expected, but I am not sure. Would it be possible to print out more info for each collision? Filenames, album and artists names? Also, would it be possible to print a collision index, like (1 of 213), for example? That way I would know how many collisions I have left to work through...

If I don't use the --ignore switch, it dies immediately still:

java -cp .:sqlitejdbc-v054.jar iTunesRatingsToSongbird -i "/winxp/Documents and Settings/myuser/My Documents/My Music/iTunes/iTunes Music Library.xml" -s "/home/myuser/.songbird2/ekchz4wy.default/db/main@library.songbirdnest.com.db"

Here's the ratingsLog:

http://www.trevorbowen.com/ratingLog.txt.bz2

Also, would it be possible to update songs as it finds them, instead of waiting at the end? That way, I would have something when it crashed. ... Thanks!!!

Ivan, thanks for all the work you are doing on this.

BTW, I reran with the "--ignore" option, and it ran for a while. It asked me about several name collisions, but it eventually crashed too:

Searching. . .
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 9, Size: 9
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at iTunesRatingsToSongbird.searchSql(iTunesRatingsToSongbird.java:482)
at iTunesRatingsToSongbird.main(iTunesRatingsToSongbird.java:210)

Thanks!!! – m27315, on December 11, 2008 19:02

Hi Ivan,

I tried running your program on my Gentoo Linux box, like so:

java -cp .:sqlitejdbc-v054.jar iTunesRatingsToSongbird -i "/winxp/Documents and Settings/myuser/My Documents/My Music/iTunes/iTunes Music Library.xml" -s "/home/myuser/.songbird2/ekchz4wy.default/db/main@library.songbirdnest.com.db"

But, I get the following error:

ERROR: no such column: media_iten_id
Exception in thread "main" java.lang.NullPointerException
at iTunesRatingsToSongbird.searchSql(iTunesRatingsToSongbird.java:356)
at iTunesRatingsToSongbird.main(iTunesRatingsToSongbird.java:210)

Any ideas?

I am using Songbird 1.0. I can send you the two files, if it will help debug.

Thanks!