Issues•Removing scrobbles from zenses

  • 0 points-+

    This is not currently supported and probably won't be any time soon since both me and Adam have very little time to put on zenses. However, if you're absolutely desperate to get some tracks out (like: you've just lost a weeks worth of listening because you've picked wrong start date....) - fear not. If you have a bit of hacker in you, you may be able to fix it for yourself.

    First, let me stress this out: please, please, PLEASE make a backup (copy) of the file that you're going to change. This way if things go very wrong, you'll be able to recover. And second - NEVER have both zenses running and try reading/modifying the db file at the same time. It's safe to open and change the file if zenses is closed, but if you want to run zenses - first save and close the file. And vice-versa, don't try peaking at its contents when zenses is running. Notepad or zenses - never both.

    After this lengthy introduction - here is the procedure itself.

  • 0 points-+

    Basically, everything that zenses is storing is in zenses.data.script file in your user_profile/Application Data/zenses folder. There are 3 types of lines in this file: - initial setup, about 20-30 lines between "CREATE SCHEMA..." until ""SET SCHEMA PUBLIC", that can be ignored - lines starting with INSERT INTO DEVICE_TRACKS which represent tracks - lines starting with INSERT INTO LASTFM_SUBMISSIONS which represent scrobbles

    When zenses decides whether it should show something to scrobble depends on 2 things: - 3rd from the end value of lines with tracks (that's the playcount) - how many submission lines does it find with a given id. Id of the song is first value in track line and it has to match the last value in the scrobble line.

  • 0 points-+

    In the following example:

    INSERT INTO DEVICE_TRACKS VALUES(24,'Thriller','Michael Jackson','FAKE_DEVICE2','Michael Jackson - Bad','2009-11-04 22:06:09.171000000',300234,'098-3434-3425',3,'Bad','{12345}')

    INSERT INTO DEVICE_TRACKS VALUES(25,'Thriller','Michael Jackson','FAKE_DEVICE2','Michael Jackson - Bad','2009-11-04 22:06:17.968000000',300234,'098-3434-3424',3,'Bad2','{12345}')

    INSERT INTO LASTFM_SUBMISSIONS VALUES(13,'2009-11-04 22:06:09.203000000',24)

    INSERT INTO LASTFM_SUBMISSIONS VALUES(14,'2009-11-04 22:06:18.015000000',25)

    Zenses would report 2 scrobbles of Bad and 2 of Bad2 (because the playcount is 3, and for each of the songs there is one line that says that song with particular id has been scrobbled). If you wanted it to report 3 scrobbles of Bad, all you'd have to do is to remove the line

    INSERT INTO LASTFM_SUBMISSIONS VALUES(13,'2009-11-04 22:06:09.203000000',24).

    You HAVE to do it when zenses is closed. And again - please, do make a copy of this file. If it doesn't work the way you expect it, you just need to close zenses, put the original file back and restart.

Want to take part in this discussion? Click one of these: Sign In Register For Membership
Back to Discussions

Howdy, Stranger!

It looks like you're new here. If you want to take part in the discussions, click one of these buttons!

Sign In Register For Membership

Categories

In this Discussion