Support for SQLITE scripting

Hi,

I’m using MediaMonkey for library management and PMS for broadcasting music (not interested in movies)
I have noticed on many albums that the metadata stored in the mp3 files was different from what the PMS agents have found
In order to fix this, I wanted to export metadata from both MM & PMS to identify and fix the differences (either on MM or on PMS)
Exporting metadata from MM is really a piece of cake, but…

This seems to be a big deal with PMS: the ExportTools plugin does not allow exporting the Release Year
I tried Tautulli as well, but the structure of the export file is way too complex to be practically usable on regular basis

Now, I’m considering running a simple SQLite script to export the data to CSV, but this is where I’m stuck: I have ZERO knowledge about SQLite
So, could someone explain me how to write that script?

What I need is a simple CSV file with all possibly the following data:

  • Album Artist (*)
  • Release year (*)
  • Album title (*)
  • Track nr
  • Track Artist
  • Track title

The first 3 field are required, but anything else that comes along is welcome

Any help would be MUCH appreciated

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.