Rockbox.org home
Downloads
Release release
Dev builds dev builds
Extras extras
themes themes
Documentation
Manual manual
Wiki wiki
Device Status device status
Support
Forums forums
Mailing lists mailing lists
IRC IRC
Development
Bugs bugs
Patches patches
Dev Guide dev guide
Search



Donate

Rockbox Technical Forums


Login with username, password and session length
Home Help Search Staff List Login Register
News:

Welcome to the Rockbox Technical Forums!

+  Rockbox Technical Forums
|-+  Support and General Use
| |-+  Audio Playback, Database and Playlists
| | |-+  Is there a way to convert a database_changelog.txt into a spreadsheet?
« previous next »
  • Print
Pages: [1]

Author Topic: Is there a way to convert a database_changelog.txt into a spreadsheet?  (Read 589 times)

Offline DuffelDisrupt2

  • Member
  • *
  • Posts: 10
Is there a way to convert a database_changelog.txt into a spreadsheet?
« on: February 24, 2022, 06:01:18 PM »
Like the title says, is there a way to convert a database_changelog.txt into a spreadsheet? Obviously, the information can just be manually copied, but I want to know if there's any way I can automate the process. The reason for me doing this is replacing my albums with deluxe editions, without losing ratings data. If this isn't the correct place to post this, let me know, and I can but it somewhere else.

Thanks!

Sidenote: I've stumbled upon SansaMonkey (https://www.mediamonkey.com/forum/viewtopic.php?p=87677#87677) which promises to "export ratings to *.csv". But alas, I have an iPod.
« Last Edit: February 24, 2022, 09:27:34 PM by DuffelDisrupt2 »
Logged

Offline Bilgus

  • Developer
  • Member
  • *
  • Posts: 880
Re: Is there a way to convert a database_changelog.txt into a spreadsheet?
« Reply #1 on: February 25, 2022, 09:19:17 AM »
it says it works with rockbox

SansaMonkey is a small Tool to Sync Ratings between a Sandisk Sansa OR Rockbox and MediaMonkey

that said it is pretty old so YMMV
Logged

Offline DuffelDisrupt2

  • Member
  • *
  • Posts: 10
Re: Is there a way to convert a database_changelog.txt into a spreadsheet?
« Reply #2 on: February 25, 2022, 01:16:05 PM »
Yeah, when I tried it it kept giving me errors along the lines of: "not enough memory" (with 12gb RAM installed) or "restart SansaMonkey and try again". So that's unfortunate :/
Logged

Offline DuffelDisrupt2

  • Member
  • *
  • Posts: 10
Re: Is there a way to convert a database_changelog.txt into a spreadsheet?
« Reply #3 on: April 03, 2022, 04:20:25 PM »
Alright! Well I just imported the database_changelog into an OnlyOffice spreadsheet with the delimeter as ". It's not perfect, however; for the most part the data is organized into appropriate columns.
Logged

  • Print
Pages: [1]
« previous next »
+  Rockbox Technical Forums
|-+  Support and General Use
| |-+  Audio Playback, Database and Playlists
| | |-+  Is there a way to convert a database_changelog.txt into a spreadsheet?
 

  • SMF 2.0.19 | SMF © 2021, Simple Machines
  • Rockbox Privacy Policy
  • XHTML
  • RSS
  • WAP2

Page created in 0.051 seconds with 22 queries.