Known Album Unknown Tracknr

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Hixbb

Known Album Unknown Tracknr

Post by Hixbb » Mon Oct 06, 2003 4:41 pm

I have many MP3 albums that don't contain tracknrs. To identify these there is currently no option in MM. Since I only know about Access-Programming i wrote this quick'n'dirty Access-script that creates a new playlist containing files with album but without tracknr.
I don't know if it helps somebody, but here it is:
To use it, you have link the DAO-library in MediaMonkey.mdb.
It accesses the Database directly, so maybe you want to make a backup of it before using it.
Using at own risk.



Function CreatePlaylist()
Dim dbs As DAO.Database
Set dbs = CurrentDb
Dim rst, rst2 As DAO.Recordset
Set rst = dbs.OpenRecordset("playlists")
Dim id, order As Long
order = 0
'add new Playlist
With rst
.AddNew
.Fields(1) = "missing Tracknr."
.Fields(2) = 0
id = .Fields(0)
.Update
End With
Dim strSQL As String
strSQL = "SELECT ID FROM Songs WHERE IDAlbum > 0 AND SongOrder < 0"
Set rst = dbs.OpenRecordset(strSQL)
Set rst2 = dbs.OpenRecordset("PlaylistSongs")

With rst
If Not .EOF Then
Do Until .EOF
With rst2
.AddNew
.Fields(1) = id
.Fields(2) = rst.Fields(0)
.Fields(3) = order
.Update
order = order + 1
End With
.MoveNext
Loop
End If
End With



End Function

Hixbb

Lowlander
Posts: 46102
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Track# field missing in search

Post by Lowlander » Thu Feb 05, 2004 4:52 pm

Well it seems MM would be able to this with the advanced search if the track # field would be searchable.
Lowlander (MediaMonkey user since 2003)

Post Reply