• Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    New extract SQL from Media Monkey

    Scheduled Pinned Locked Moved
    Technical Help
    1
    1
    268
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • O
      OriNOVet
      last edited by

      I have reworked my initial SQL to extract the data from Media Monkey database for importing to Strawberry a little bit:

      This ne one, extracts also filesize (can be used to identify the song in strawberry), mtime and ctime, where the 2 additional date fields are used for date added to database and modified last time. You can use filesize to identify easier the song in Strawberry. Mostly this can be unique, but sometimes you will have multiple files with the same filesize. In this case, you should use additional conditions to find the right entries.

      To find if filesize is unique across your database, you can use:

      SELECT FileLength, Count(FileLength)
      FROM Songs
      GROUP BY FileLength
      HAVING Count(FileLength) > 1;
      

      If the result is empty, FileLength is unique across the database. If the result contains entries, you should use additionally markers to find the right song, but all you need is in the next SQL:

      SELECT 
      	Artist as artist, 
      	Album as album, 
      	AlbumArtist as albumartist, 
      	TrackNumber as track, 
      	DiscNumber as  disc, 
      	SongTitle as title, 
      	PlayCounter as playcount, 
      	IIF(LastTimePlayed > 1, strftime('%s', datetime(LastTimePlayed + 2415019.0)), -1) as lastplayed,
      	FileLength as filesize, 
      	strftime('%s', datetime(FileModified + 2415019.0)) as mtime, 
      	strftime('%s', datetime(DateAdded + 2415019.0)) as ctime
      FROM Songs
      ;
      

      This extracts the whole database, the last SQL extracted only songs with playcount > 0, because now i include also mtime and ctime.

      Have fun with migrating.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Powered by NodeBB | Contributors