2016-10-09, 18:51
I don't think the export database for music does playcount, and more importantly I think export is only at the album level, so not good for people who primarily listen to songs or playlists rather than albums.
I'm afraid I don't have a painless strategy. I do have a painful one, which is quicker to do than to explain, though I imagine it breaks every rule of Kodi. My work around for these things is:
1. Open old database in sqlitebroswser
2. Export song table as a csv
3. Open new style database and export song table as a csv
4. Using your spreadsheet program open Do a vlookup on a unique field to populate the new table's Times Played and Date Played columns from the old table.
5. Import the new table csv as song_new to the database
6. Rename the existing song table in the database to song_old and rename your newly imported song_new to just song
7. Delete song_old and write changes to database.
Now who could possibly not follow that? Some Kodi programmers are probably screaming not to do this as well.
I'm sure someone else has a better idea, but for accountants the above method is quite easy.
I'm afraid I don't have a painless strategy. I do have a painful one, which is quicker to do than to explain, though I imagine it breaks every rule of Kodi. My work around for these things is:
1. Open old database in sqlitebroswser
2. Export song table as a csv
3. Open new style database and export song table as a csv
4. Using your spreadsheet program open Do a vlookup on a unique field to populate the new table's Times Played and Date Played columns from the old table.
5. Import the new table csv as song_new to the database
6. Rename the existing song table in the database to song_old and rename your newly imported song_new to just song
7. Delete song_old and write changes to database.
Now who could possibly not follow that? Some Kodi programmers are probably screaming not to do this as well.
I'm sure someone else has a better idea, but for accountants the above method is quite easy.
