MediaMonkey Wiki - User contributions [en]

Moving MM to a new computer

2010-03-01T23:15:39Z

Teknojnky: /* Copying your database */

==Introduction==
If you want to move MM to a new computer (or hard drive) but retain your database, follow these steps. If these steps are followed correctly, all information that is maintained by your database will be retained, including PlayHistory, PlayCounts, Dates Added, PlayLists and all other fields within MM.

==Copying your database==
Your database is located at:

'''Windows XP''': C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey

or

'''Windows Vista''': C:\Users\<USERNAME>\AppData\Local\Mediamonkey

and is called MM.DB (note that you will have to enable viewing of hidden Files and Folders to find this file).

After installing MM on the new computer, put your database in the correct location (as noted above) on the new computer.

Optionally, you may also want to save your registry info as well, @ HKey_Current_ User\Software\Mediamonkey

==Moving your music to the new PC==
Next, you'll have to move all the music from the old PC onto the new one, making sure that the file directory for each track stays the same as on the old PC (with the exception of drive letter, though that can remain the same.)

==Installing the update drive-ID script==
After you do all of that, install [http://www.mediamonkey.com/forum/viewtopic.php?t=8975 this script] to your new PC. To install this script, first shut down MM. Next, copy the contents in the 'Code:' box at the link provided into notepad. Save the file as 'MM_HDDSerial.vbs' (without the quotes) in your C:\Program Files\MediaMonkey\Scripts folder. Next, within that same folder, find 'Scripts.ini'. Open this file with notepad and copy the following lines and paste them onto the end of the file, then save.

Copy these lines into Scripts.ini:

[HDDSerial]
 FileName=MM_HDDSerial.vbs
 ProcName=Change_HDD_Serial
 Order=99
 DisplayName=Move Device Content
 Description=Corrects broken links after exchanged harddrive
 Language=VBScript
 ScriptType=0

==Running the script==
Now you're ready to run the script. Open MM (if you are using Windows Vista or Windows 7, right click on the MM icon and choose "Run as administrator" even if your Windows user account has administrative rights) and run the script at Tools -> Scripts -> Move Device Content. If you receive any errors or the script doesn't appear under Tools -> Scripts, check that you have installed the script correctly, and/or try restarting MM.

Running the script will change the drive-ID within the MediaMonkey database to recognize your new drive, and all your database information will be retained. If you can play your music from MM, and tracks do not 'grey out', then you have successfully moved your MM installation to a new computer.

Database Structure

2009-12-03T21:58:51Z

Teknojnky: /* Default Mediamonkey 3 Database location */

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista and Windows 7:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

'''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Portable Mediamonkey

2009-12-03T21:56:49Z

Teknojnky:

== This is an overview of how to setup MediaMonkey for USB stick, external drive, or shared network install. ==

First, read the FAQs for [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=49&nav=0,2 Shared Settings] and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 Changing the location of the library database].

These 2 articles provide the background necessary to understand what needs to be done.

Once you understand the FAQs, then you will also understand that the process outlined below requires your device to always have the same drive letter (or UNC network path if you are using a NAS or server). You can manually assign a letter in the Windows Control Panel > Computer Management > Disk Manager. For Shared Network drives, even if you have created a mapped drive shortcut, you should use the UNC path. For example, if your shared network drive is named NETDRIVE and is mapped to drive letter z:, use \\NETDRIVE\<folder>\<filename> for any references in the ini file, do not use z:\<folder>\<filename>. By using the UNC network path you are protected from problems from having the drive mapped to a different letter on other computers on the network.

Another important point is that MediaMonkey also stores some settings in the registry. These settings are generally the UI settings/positions and 'Gold' key if you have one, among other things. These settings will not be portable between computers, but normally you won't need them to be once you're all set up. You will likely have to activate your gold license the first time you access MediaMonkey on the device from a new computer.

Finally, you should understand that both articles can be done independently. You can have shared settings while still having independent databases, or you can have independent settings while having a shared database.

What we are going to do, is combine both functions so that both settings and library are stored in one location (your USB stick/external drive/network folder).

----

==='''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.===

----

* '''Move''' your existing MediaMonkey program folder or install a fresh copy to your destination device (USB stick, external drive, network share). Installing a fresh copy works better.

----
* '''Move''' your Mediamonkey.ini from the [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 default user location] to the program location you moved or installed MM to on your destination device. Your user Mediamonkey.ini should reside in the same location as the Mediamonkey.exe (rename or overwrite any existing Mediamonkey.ini in the program folder). If you are using a network share drive as the "Device", and you are moving an existing ini file from the c:\users\<username>\appdata\local\MediaMonkey directory, it is important to edit the following lines of the ini file so that they have paths that are accessable from all computers on the network.

From:

TempDir=c:\users\<username>\appdata\local\Temp\

CacheDir=c:\users\<username>\appdata\local\MediaMonkey\VirtualCD\

PreviewDir=c:\users\<username>\appdata\local\MediaMonkey\Previews\

To, for example,:

TempDir=\\<shared network folder>\<MediaMonkey Program Folder>\Temp\

CacheDir=\\<shared network folder>\<MediaMonkey Program Folder>\VirtualCD\

PreviewDir=\\<shared network folder>\<MediaMonkey Program Folder>\Previews\

Without this change, you will get an error saying there is a problem creating the Temp, Virtual CD and Previews folders upon start-up on any computers other than the computer which had the original ini file. If you want to retain your existing versions of these files, you can move them from the original locations to the new locations in the shared network folder.

----
* To have a shared database, you must now edit the Mediamonkey.ini and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 follow the directions in the FAQ] by adding the appropriate entry and path. You can let MM create a new database there or [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 move your existing database] to the new location on the destination device. Once again, if you are using a shared network folder, use the UNC path, not the mapped drive letter.

Now, you should have a MM install on your device, your MediaMonkey folder should contain your existing Mediamonkey.ini, and your Mediamonkey.ini should point to your database also located somewhere on the device.

If your music is also on the device, then you should be able to access everything as one package. If your music is located elsewhere, then you must also have access to that location in order to play the music from that location. If you plan on running MM from a shared network drive and the music is also on the shared network drive, then once again, it is important that the path for the location of the music be the UNC name, not a mapped drive letter. If you don't make this conversion, the network version of MM won't work on any computer which has the network drive mapped to a different letter than the computer from which the music on the network drive was added to the DB. This topic explains how to make the change to the UNC name from a mapped drive letter http://mediamonkey.com/forum/viewtopic.php?f=3&t=33788&start=0&st=0&sk=t&sd=a. Another more manual way to accomplish this is to start with a new DB and add the music to your DB by using the network path in the add/rescan dialog window rather than the mapped drive path. However, this method causes you to lose everything else in you DB other than you music.
----

For example, I have all of my music, my MediaMonkey program folder, Mediamonkey.ini and MM3.db all located on my external drive J: and I can run MM and access my music from there as long as I make sure that the drive always gets J: when connected to any computer.

Hopefully this information is helpful in getting your portable or network monkey working. Here is a thread which discusses setting up MM on a shared network drive http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=34083.

Last.FM Scrobbler Plugin Info

2009-01-29T23:51:55Z

Teknojnky:

= About Last.FM Scrobbler Support =

Mediamonkey supports the Last.FM 'scrobbler' plugins to submit played tracks within MediaMonkey itself (portable player sync'd played tracks are not supported).

Currently there are 3 main plugins available, only ONE of which should reside in the "<MediaMonkey program folder>\Plugins" folder.

== Version 1: gen_audioscrobbler.dll (v 1.1.10) ==

This is the last 'old style' plugin for winamp 2 compatible clients. This plugin uses a config panel normally accessed via Tool > Options > Player > General Plugins > Plugin Config.

You can download this from the links @ http://www.last.fm/forum/34905/_/135053

Occasionally the config panel will get hidden behind the MM app window, if the MM window is made smaller you can usually then click on the config panel to bring it to the front where you can change and save your settings. Alternative way is to use ALT+TAB to bring back focus to config panel.

This plugin does not support last.fm profile "Now Playing" updates, and some unicode characters can cause a track to not be submitted.

== Version 2: gen_wa2_scrobbler.dll (v 2.x.x) ==

This is the offical current style of last.fm plugins. This plugin utilizes a 'tray application' which gives some additional metadata info and includes the last.fm radio player for streaming radio.

The last compatible version for v2 plugins is [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], newer plugins are currently incompatible with MediaMonkey.

To configure the version 2 style, you must open the tray application and configure through it's options. The plugin does not have any self configure, nor will it function without the tray application installed and running (normally the plugin will start the tray app automatically).

The latest official plugins are always available at Last.FM http://www.last.fm/download/ keeping in mind that while the latest tray app should work, plugins newer than [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45] will not.

To install, make sure you have the [http://www.last.fm/download/ TRAY APP] already installed, then run the plugin installer [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], simply point the installer to the mediamonkey folder instead of the winamp folder.

== Version 3: gen_LastFMScrobbler.dll [http://www.mediamonkey.com/forum/viewtopic.php?t=26404 Native Last.FM Scrobbler Plugin] (beta) ==

See forum thread for details and download

ISDBTreeNode::NodeType

2009-01-22T18:37:24Z

Teknojnky:

{{MethodDeclaration|SDBTreeNode|ISDBTreeNode|Property Get/Let NodeType As Long}}

===Property description===

Returns the type of node. Mainly for internal usage.

[[MediaMonkey Tree structure]]

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTreeNode|{{PAGENAME}}]]
[[Category:Interface ISDBTreeNode|{{PAGENAME}}]]

ISDBScriptControl::Reload

2009-01-21T05:23:39Z

Teknojnky:

{{MethodDeclaration|SDBScriptControl|ISDBScriptControl|Sub Reload(ScriptPath As String)}}

===Parameters===

{{MethodParameters
|ScriptPath |String |Script file to be reloaded.}}

===Method description===

This method is for script development only. When called with a full script path, the script will be reloaded from disk before the its next event is called and so updated source from disk is used instead of the already loaded code from memory.

In case the ScriptPath parameter is an empty string, all strings in memory will be reloaded.

Note that by calling this method you lose all global variables of the reloaded script, their content can't be preserved. On the other hand, all registered events and SDB.Objects are preserved.

Introduced in MediaMonkey 3.1.0.1212.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBScriptControl|{{PAGENAME}}]]
[[Category:Interface ISDBScriptControl|{{PAGENAME}}]]

ISDBTree::Refresh

2009-01-21T05:21:12Z

Teknojnky:

{{MethodDeclaration|SDBTree|ISDBTree|Sub Refresh}}

===Method description===

Causes the tree to be repainted. It's useful after some actions, e.g. changing tree node Caption doesn't repaint the node automatically and so this method might be needed.

Example: SDB.MainTree.Refresh

Introduced in MediaMonkey 3.1.0.1216.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTree|{{PAGENAME}}]]
[[Category:Interface ISDBTree|{{PAGENAME}}]]

Talk:ISDBApplication::WebControl

2009-01-20T20:18:06Z

Teknojnky:

What are the full properties and methods available with this web control?

Talk:ISDBTreeNode::CustomObject

2009-01-19T23:22:25Z

Teknojnky:

Why would this be used, and how?

Talk:ISDBTracksWindow::AddTrackEx

2009-01-14T20:45:24Z

Teknojnky:

What would be an example use of this or why it would be better than .addtrack instead?

ISDBUIButtonEvents::OnClick

2009-01-12T21:13:29Z

Teknojnky: /* Event description */

{{MethodDeclaration|SDBUIButton|ISDBUIButtonEvents|Sub OnClick}}

===Event description===

This event is called when button is clicked. You must use btn.Common.OnClick for the event to work properly.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIButton|{{PAGENAME}}]]
[[Category:Interface ISDBUIButtonEvents|{{PAGENAME}}]]

SDBUIButton

2009-01-12T21:12:22Z

Teknojnky:

{{AutomationObjectsList}}
== CoClass SDBUIButton ==

Button (UI element).

=== ISDBUIButton members ===

{{MethodsList
|[[ISDBUIButton::Cancel|Cancel]] |Property Get/Let |
|[[ISDBUIButton::Caption|Caption]] |Property Get/Let |
|[[ISDBUIButton::Common|Common]] |Property Get |
|[[ISDBUIButton::Default|Default]] |Property Get/Let |
|[[ISDBUIButton::ModalResult|ModalResult]] |Property Get/Let |
|[[ISDBUIButton::OnClickFunc|OnClickFunc]] |Property Get/Let |
|[[ISDBUIButton::UseScript|UseScript]] |Property Get/Let |
}}

=== ISDBUIButtonEvents members ===

{{MethodsList
|[[ISDBUIButtonEvents::OnClick|OnClick]] |Event | Use Common.OnClick
}}

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIButton|{{PAGENAME}}]]

Video for Mediamonkey

2008-04-24T22:42:28Z

Teknojnky:

=About=
Help, info and links to get Mediamonkey to play/manage video's.

=FAQ=

=Working Video Input Plugins=
[http://www.winamp.com/plugins/details/22629 VidAmp]
[http://www.winamp.com/plugins/details/109518 VideoObject]

=Scripts Related to Videos=
[http://www.mediamonkey.com/forum/viewtopic.php?t=6397 Video Node]

Video for Mediamonkey

2008-04-24T22:36:50Z

Teknojnky:

Help, info and links to get Mediamonkey to play/manage video's.

User:Teknojnky

2008-04-24T22:35:50Z

Teknojnky:

Hi!

[[Video for Mediamonkey]]

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

[[Portable Mediamonkey]]

Current Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</source>

Previous Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist@1>,$if(<Album Artist>=various,_Various\$if(<Year>,<Year> - )<Album>,$if(<Album Artist>=soundtrack,_Soundtrack\$if(<Year>,)<Album>,$if(<Album Artist>=Techno,_Techno\$if(<Year>,<Year> - )<Album>,<Album Artist@1>\<Album Artist>)))),<Artist@1>)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>\,),<Artist>\)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>,<Album Artist>),<Artist>)$if(<Album>,$if(<Year>, - <Year>) - <Album>$if(<Track#>, - <Track#>,),)$if(<Album Artist>,$if(<Album Artist>=<Artist>, - <Title>, - <Artist> - <Title>), - <Title>),240)</source>

Talk:Podcast FAQ

2008-04-24T21:44:08Z

Teknojnky:

Good info--[[User:Teknojnky|Teknojnky]] 17:44, 24 April 2008 (EDT)

Database Structure

2008-04-22T01:12:16Z

Teknojnky:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* hassubfolders(string) - Used internally by MediaMonkey.
* instr(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* like(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings.
* nextpathpart(string) - Used internally by MediaMonkey.
* sin(number) - Mathematical sinus function.
* stricompw(string1, string2) - Compares two Unicode strings, case insensitive.
* upperw(string) - Unicode string upper case.

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Talk:Moving MM to a new computer

2008-04-19T18:59:36Z

Teknojnky:

Great article. It might be wise to make a note somewhere to disable any startup scan options if the user decides to move the MM installation and mediamonkey.ini files. A startup scan run before updating the device id's will add a bunch of dupes. But I am not sure where would be the best spot to mention it.--[[User:Teknojnky|Teknojnky]] 14:59, 19 April 2008 (EDT)

Talk:ISDBDatabase::BeginTransaction

2008-04-18T05:07:49Z

Teknojnky:

When/why should this be used, and even more importantly, when should it NOT be used?

What happens if you are unable to 'commit' the transaction (due to script error or crash, etc) and MM keeps running? or when the whole app crashes?

: From what I've read on the forum you should use it when you want to do different database queries at once (for better performance). If you have only one query at a time to do, you certainly don't need this. If the transaction isn't committed (e.g. due to MM crash), then the query won't be executed (I think). When the script crashes, the queries will only be committed when another action does the commit. However, in practice there will always first be a normal query, or a BeginTransaction command, which will probably void the command you started in your own script, or even result in an error. Anyone else has more info on this? -- [[User:Steegy|Steegy]] 15:28, 15 April 2008 (EDT)

:: here is an example of how I've started using transaction/commit

<source lang="vb">
SDB.Database.Commit
SDB.Database.BeginTransaction
Set Iter = SDB.Database.OpenSQL(Qry)
SDB.ProcessMessages
Do While NOT Iter.EOF
' do whatever processing you need to do
Iter.Next
SDB.ProcessMessages
Loop
SDB.Database.Commit
</source>

:: I do this to avoid those sql errors 'can not open tranaction while another is in progress' or whatever it was. I commit any pending transactions, open my transaction, then commmit it after the loop. Note however, I am not really making database changes, but I think the above is sequence is even more important for when doing actual db updates.

:: I don't know if the above is the right way or not, but it seems to prevent the transaction errors and I have not seen any evidence it hurts anything. It seems to let multiple scripts and/or tag updates happen together without causing errors. --[[User:Teknojnky|Teknojnky]] 13:47, 17 April 2008 (EDT)

::: Notice though that calling SDB.ProcessMessages too much (certainly in a fast small loop) can do more harm than good. If you *really really* need to use it in a fast loop, then only do it each X iterations (e.g. by using a counter and a conditional SDB.ProcessMessages that also resets your counter).
<source lang="vb">
Dim Cnt : Cnt = 0
Do While SomethingIsTrue
' do whatever short processing you need to do
If Cnt = 300 Then
SDB.ProcessMessages
Cnt = 0
Else
Cnt = Cnt + 1
End If
Loop
</source>
That way (depending on X), SDB.ProcessMessages is only called e.g. each 500 ms instead of each 10 ms. -- [[User:Steegy|Steegy]] 19:12, 17 April 2008 (EDT)

:::: Hmm, I am a big advocate of plenty of SDB.ProcessMessages, and while this may slow down the script somewhat, it keeps the UI and other tasks moving as smoothly as possible. This is really evident with the spectrum displays, without SDB.ProcessMessages, the display freezes and/or gets really jerky. I consider MM like how windows 3.1 was, in that it is a 'cooperative' multi-tasking system instead of a 'premptive' one.. ProcMess gives control back to allow other processing making scripts appear to run much smoother. I do agree that you don't need or want them everywhere, but they are particularly effective in loops and near queries (which also freeze up the ui, but can't do much about that other than giving ProcMess a chance to process anything that got blocked during the query).

Talk:ISDBDatabase::BeginTransaction

2008-04-17T17:47:27Z

Teknojnky:

Last.FM Scrobbler Plugin Info

2008-04-08T15:28:07Z

Teknojnky: /* About Last.FM Scrobbler Support */

= About Last.FM Scrobbler Support =

Mediamonkey supports the Last.FM 'scrobbler' plugins to submit played tracks within MediaMonkey itself (portable player sync'd played tracks are not supported).

Currently there are 3 main plugins available, only ONE of which should reside in the "<MediaMonkey program folder>\Plugins" folder.

== Version 1: gen_audioscrobbler.dll (v 1.1.10) ==

This is the last 'old style' plugin for winamp 2 compatible clients. This plugin uses a config panel normally accessed via Tool > Options > Player > General Plugins > Plugin Config.

You can download this from the links @ http://www.last.fm/forum/34905/_/135053

Occasionally the config panel will get hidden behind the MM app window, if the MM window is made smaller you can usually then click on the config panel to bring it to the front where you can change and save your settings. Alternative way is to use ALT+TAB to bring back focus to config panel.

== Version 2: gen_wa2_scrobbler.dll (v 2.x.x) ==

This is the offical current style of last.fm plugins. This plugin utilizes a 'tray application' which gives some additional metadata info and includes the last.fm radio player for streaming radio.

The last compatible version for v2 plugins is [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], newer plugins are currently incompatible with MediaMonkey.

To configure the version 2 style, you must open the tray application and configure through it's options. The plugin does not have any self configure, nor will it function without the tray application installed and running (normally the plugin will start the tray app automatically).

The latest official plugins are always available at Last.FM http://www.last.fm/download/ keeping in mind that while the latest tray app should work, plugins newer than [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45] will not.

To install, make sure you have the [http://www.last.fm/download/ TRAY APP] already installed, then run the plugin installer [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], simply point the installer to the mediamonkey folder instead of the winamp folder.

== Version 3: gen_LastFMScrobbler.dll [http://www.mediamonkey.com/forum/viewtopic.php?t=26404 Peke's Last.FM Scrobbler Plugin] (beta) ==

See forum thread for details and download

Talk:Main Page

2008-03-28T19:35:43Z

Teknojnky:

I see this page is locked, what is the best way to go abou getting a link added? I don't have anything I want to link at this time, I am just curious. -- [[User:Teknojnky|Teknojnky]] 12:52, 28 August 2007 (EDT)
: You can ask here (on the talk page) to add some link or to temporarily unprotect the page (e.g. for bigger changes). Of course keep in mind the reason why the page (as façade of the wiki) is protected. -- [[User:Steegy|Steegy]] 07:07, 31 August 2007 (EDT)

I refreshed the main page, mainly to draw a clear line between users content (which for now isn't really existing) and content for "developers" (scripters, skinners, translators, ...). If you don't really like the layout or have suggestions, feel free to post here. -- [[User:Steegy|Steegy]] 21:18, 7 September 2007 (EDT)

: I'd like to see a link to the [[MediaMonkey_Automation_objects]] page directly in either the navigation block or the toolbox block, so its easier to navigate to the objects reference list. --[[User:Teknojnky|Teknojnky]] 13:54, 6 February 2008 (EST)

I've significantly updated the Intro for New Users section. It seemed silly that the only way to find skins was to navigate under the "Developers" section for skinning. I think it may be even better to put a direct link to skins for MM 3.0 and higher on the front page, but this change can do for now as I don't want to alter the front page without an opinion from some other users. Let me know what you think about this. --[[User:Nohitter151|Steve]] 00:20, 5 March 2008 (EST)

: Really a great job you guys have been doing!
: @Teknojnky: I've been having the same issue (and I guess were not the only 2) so I added 3 reference links.
: @Steve/Nohitter151: sorry but I couldn't wait :p (I simply forgot to add a Skins link the first time and to split it from the developers skin page). -- [[User:Steegy|Steegy]] 16:34, 5 March 2008 (EST)

: Not a problem Steegy, I'm very happy with the front page now! --[[User:Nohitter151|Steve]] 18:34, 5 March 2008 (EST)

: Yea page looks great, thanks Steegy! --[[User:Teknojnky|Teknojnky]] 15:35, 28 March 2008 (EDT)

Portable Mediamonkey

2008-03-26T22:28:45Z

Teknojnky:

This is an overview of how to setup mediamonkey for usb stick, external drive, or shared network install.

First, read the FAQ's for [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=49&nav=0,2 Shared Settings] and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 changing the location of the library database].

These 2 articles provide the background necessary to understand what needs to be done.

Once you understand the FAQ's, then you must also understand that the below requires that your device always have the same drive letter or UNC network path if you are using a NAS or server. You can manually assign a letter in the windows control panel > computer management > disk mananger

The other thing you should understand, is that mediamonkey also stores some settings in the registry. These settings are generally the UI settings/positions and 'gold' key if you have one, among other stuff. These settings will not be portable between computers, but normally you won't need them to be once your all set up.

And finally, you should understand that both articles can be done independantly. You can have shared settings while still having independent databases, or you can have independant settings while having a shared database.

What we are going to do, is combine both functions so that both settings and library are stored in one location... your usb stick/external drive/network folder.

* Move your existing Mediamonkey program folder or install a fresh copy to your destination device (usb stick, ext drive, network share)

* '''Move''' your mediamonkey.ini from the [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 default user location] to the program location you moved or installed MM to on your destination device. Your user mediamonkey.ini should reside in the same location as the mediamonkey.exe (rename or overwrite any existing mediamonkey.ini in the program folder)

* To have a shared database, you must now edit the mediamonkey.ini and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 follow the directions in the faq] by adding the appropriate entry and path. You can let MM create a new database there or [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 move your existing database] to the new location on the destination device.

Now, you should have a MM install on your device, your mediamonkey folder should contain your existing mediamonkey.ini, and your mediamonkey.in should point to your database also located somewhere on the device.

If your music is also on the device, then you should be able to access everything as one package. If your music is located elsewhere, then you must also have access to that location in order to play the music from that location.

For example, I have all of my music, my mediamonkey program folder, mediamonkey.ini and mm3.db all located on my external drive J: and I can run MM and access my music from there as long as I make sure that the drive always gets J: when connected to any computer.

Hopefully this information is helpful in getting your portable monkey working.

Tips & Tricks

2008-03-26T22:23:14Z

Teknojnky:

==About Tips & Tricks==
This page is for tips that make things easy or that are not known by new users.

==Portable Mediamonkey==
[http://www.mediamonkey.com/wiki/index.php/Portable_Mediamonkey Take your Mediamonkey with you]

==Skin/GUI==
[[ Icons tips ]]
 [[ MISC... Tips ]]

==Recording/Editing==
[[ Song Recording Tips ]] and Cdrom ripping
 [[ Song Editing Tips ]]

==Hardware==
[[ System Hardware Tips]]

==Miscellaneous==
[[Not So Frequently Asked Questions]]

==Tagging/MediaMonkey Functionality==
[[ Using MusicBrainz for CD Lookup ]]
 [[Tagging Search Sites]]
 [[User Auto-Organize File Masks Examples]]

==Portable devices==
[[Sync MediaMonkey with a Zune]]

==User Pages==
More user-to-user information on these [[User pages]].

Portable Mediamonkey

2008-03-26T22:18:14Z

Teknojnky:

This is an overview of how to setup mediamonkey for usb stick, external drive, or shared network install.

First, read the FAQ's for [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=49&nav=0,2 Shared Settings] and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 changing the location of the library database].

These 2 articles provide the background necessary to understand what needs to be done.

Once you understand the FAQ's, then you must also understand that the below requires that your device always have the same drive letter. You can manually assign a letter in the windows control panel > computer management > disk mananger

The other thing you should understand, is that mediamonkey also stores some settings in the registry. These settings are generally the UI settings/positions and 'gold' key if you have one, among other stuff. These settings will not be portable between computers, but normally you won't need them to be once your all set up.

And finally, you should understand that both articles can be done independantly. You can have shared settings while still having independent databases, or you can have independant settings while having a shared database.

What we are going to do, is combine both functions so that both settings and library are stored in one location... your usb stick/external drive/network folder.

* Move your existing Mediamonkey program folder or install a fresh copy to your destination device (usb stick, ext drive, network share)

* '''Move''' your mediamonkey.ini from the [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 default user location] to the program location you moved or installed MM to on your destination device. Your user mediamonkey.ini should reside in the same location as the mediamonkey.exe (rename or overwrite any existing mediamonkey.ini in the program folder)

* To have a shared database, you must now edit the mediamonkey.ini and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 follow the directions in the faq] by adding the appropriate entry and path. You can let MM create a new database there or [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 move your existing database] to the new location on the destination device.

Now, you should have a MM install on your device, your mediamonkey folder should contain your existing mediamonkey.ini, and your mediamonkey.in should point to your database also located somewhere on the device.

If your music is also on the device, then you should be able to access everything as one package. If your music is located elsewhere, then you must also have access to that location in order to play the music from that location.

For example, I have all of my music, my mediamonkey program folder, mediamonkey.ini and mm3.db all located on my external drive J: and I can run MM and access my music from there as long as I make sure that the drive always gets J: when connected to any computer.

Hopefully this information is helpful in getting your portable monkey working.

Portable Mediamonkey

2008-03-26T22:13:16Z

Teknojnky:

This is an overview of how to setup mediamonkey for usb stick, external drive, or shared network install.

First, read the FAQ's for [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=49&nav=0,2 Shared Settings] and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 changing the location of the library database].

These 2 articles provide the background necessary to understand what needs to be done.

Once you understand the FAQ's, then you must also understand that the below requires that your device always have the same drive letter. You can manually assign a letter in the windows control panel > computer management > disk mananger

The other thing you should understand, is that mediamonkey also stores some settings in the registry. These settings are generally the UI settings/positions and 'gold' key if you have one, among other stuff. These settings will not be portable between computers, but normally you won't need them to be once your all set up.

And finally, you should understand that both articles can be done independantly. You can have shared settings while still having independent databases, or you can have independant settings while having a shared database.

What we are going to do, is combine both functions so that both settings and library are stored in one location... your usb stick/external drive/network folder.

* Move your existing Mediamonkey program folder or install a fresh copy to your destination device (usb stick, ext drive, network share)

* '''Move''' your mediamonkey.ini from the [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=17&nav=0,2 default user location] to the program location you moved or installed MM to on your destination device. Your user mediamonkey.ini should reside in the same location as the mediamonkey.exe (rename or overwrite any existing mediamonkey.ini in the program folder)

* To have a shared database, you must now edit the mediamonkey.ini and [http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,2 follow the directions in the faq] by adding the appropriate entry and path. You can create a new database or move your existing database to the new location on the destination device.

Now, you should have a MM install on your device, your mediamonkey folder should contain your existing mediamonkey.ini, and your mediamonkey.in should point to your database also located somewhere on the device.

If your music is also on the device, then you should be able to access everything as one package. If your music is located elsewhere, then you must also have access to that location in order to play the music from that location.

For example, I have all of my music, my mediamonkey program folder, mediamonkey.ini and mm3.db all located on my external drive J: and I can run MM and access my music from there as long as I make sure that the drive always gets J: when connected to any computer.

Hopefully this information is helpful in getting your portable monkey working.

User:Teknojnky

2008-03-26T21:51:39Z

Teknojnky:

Hi!

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

[[Portable Mediamonkey]]

Current Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</source>

Previous Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist@1>,$if(<Album Artist>=various,_Various\$if(<Year>,<Year> - )<Album>,$if(<Album Artist>=soundtrack,_Soundtrack\$if(<Year>,)<Album>,$if(<Album Artist>=Techno,_Techno\$if(<Year>,<Year> - )<Album>,<Album Artist@1>\<Album Artist>)))),<Artist@1>)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>\,),<Artist>\)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>,<Album Artist>),<Artist>)$if(<Album>,$if(<Year>, - <Year>) - <Album>$if(<Track#>, - <Track#>,),)$if(<Album Artist>,$if(<Album Artist>=<Artist>, - <Title>, - <Artist> - <Title>), - <Title>),240)</source>

Database Structure

2008-03-22T22:01:08Z

Teknojnky: /* Database location */

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive ([http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 Post] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* hassubfolders(string) - Used internally by MediaMonkey.
* instr(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* like(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings.
* nextpathpart(string) - Used internally by MediaMonkey.
* sin(number) - Mathematical sinus function.
* stricompw(string1, string2) - Compares two Unicode strings, case insensitive.
* upperw(string) - Unicode string upper case.

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

User:Teknojnky

2008-03-12T20:20:27Z

Teknojnky:

Hi!

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

Current Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</source>

Previous Auto-Organize mask

<source lang="vb">$left(\Music\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist@1>,$if(<Album Artist>=various,_Various\$if(<Year>,<Year> - )<Album>,$if(<Album Artist>=soundtrack,_Soundtrack\$if(<Year>,)<Album>,$if(<Album Artist>=Techno,_Techno\$if(<Year>,<Year> - )<Album>,<Album Artist@1>\<Album Artist>)))),<Artist@1>)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>\,),<Artist>\)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>,<Album Artist>),<Artist>)$if(<Album>,$if(<Year>, - <Year>) - <Album>$if(<Track#>, - <Track#>,),)$if(<Album Artist>,$if(<Album Artist>=<Artist>, - <Title>, - <Artist> - <Title>), - <Title>),240)</source>

ISDBTree::CurrentNode

2008-03-12T18:53:25Z

Teknojnky:

{{MethodDeclaration|SDBTree|ISDBTree|Property Get/Let CurrentNode As ISDBTreeNode}}

===Property description===

Gets or sets the current tree node.

To avoid object errors during runtime, you should always verify the object is valid before using or referencing it.

<code>
Function Foo
If Not (SDB.MainTree.CurrentNode Is Nothing) Then
'do whatever here
End If
End Function
</code>

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTree|{{PAGENAME}}]]
[[Category:Interface ISDBTree|{{PAGENAME}}]]

Last.FM Scrobbler Plugin Info

2008-03-07T18:12:33Z

Teknojnky:

== About Last.FM Scrobbler Support ==

Mediamonkey supports the Last.FM 'scrobbler' plugins to submit played tracks within MediaMonkey itself (portable player sync'd played tracks are not supported).

Currently there are 3 main plugins available, only ONE of which should reside in the "<MediaMonkey program folder>\Plugins" folder.

----

'''Version 1: gen_audioscrobbler.dll (v 1.1.10)'''

This is the last 'old style' plugin for winamp 2 compatible clients. This plugin uses a config panel normally accessed via Tool > Options > Player > General Plugins > Plugin Config.

You can download this from the links @ http://www.last.fm/forum/34905/_/135053

Occasionally the config panel will get hidden behind the MM app window, if the MM window is made smaller you can usually then click on the config panel to bring it to the front where you can change and save your settings. Alternative way is to use ALT+TAB to bring back focus to config panel.

----

'''Version 2: gen_wa2_scrobbler.dll (v 2.x.x)'''

This is the offical current style of last.fm plugins. This plugin utilizes a 'tray application' which gives some additional metadata info and includes the last.fm radio player for streaming radio.

The last compatible version for v2 plugins is [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], newer plugins are currently incompatible with MediaMonkey.

To configure the version 2 style, you must open the tray application and configure through it's options. The plugin does not have any self configure, nor will it function without the tray application installed and running (normally the plugin will start the tray app automatically).

The latest official plugins are always available at Last.FM http://www.last.fm/download/ keeping in mind that while the latest tray app should work, plugins newer than [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45] will not.

To install, make sure you have the [http://www.last.fm/download/ TRAY APP] already installed, then run the plugin installer [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], simply point the installer to the mediamonkey folder instead of the winamp folder.

----

'''Version 3: gen_LastFMScrobbler.dll [http://www.mediamonkey.com/forum/viewtopic.php?t=26404 Peke's Last.FM Scrobbler Plugin] (beta)'''

See forum thread for details and download

User Auto-Organize File Masks Examples

2008-02-26T20:20:43Z

Teknojnky: /* Post your favorite auto-organize masks and an example path/filename. */

== Post your favorite [http://www.mediamonkey.com/sw/webhelp/frame/source/configuring%20directory%20and%20file%20formats.htm auto-organize masks] and an example path/filename. ==

<code>\Music\A\A Perfect Circle\2004 - eMOTIVe\02 - A Perfect Circle - Imagine.mp3

\Music\Z\ZZ Top\1983 - Eliminator\01 - ZZ Top - Gimme All Your Lovin'.mp3

\Music\_Soundtrack\2006 - V for Vendetta\09 - Cat Power - I Found a Reason.mp3

\Music\_Techno\1991 - XL Recordings- The Second Chapter\07 - Cubic 22 - Night in Motion (Original mix).flac

\Music\_Various\2007 - Endzeit Bunkertracks, Act 3 (disc 2- Torture session)\01 - Faderhead - Dirtygrrrls - Dirtybois (Modulate mix).flac

</code>

----

<code>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</code>

User Auto-Organize File Masks Examples

2008-02-26T20:14:12Z

Teknojnky:

== Post your favorite auto-organize masks and an example path/filename. ==

<code>\Music\A\A Perfect Circle\2004 - eMOTIVe\02 - A Perfect Circle - Imagine.mp3

\Music\Z\ZZ Top\1983 - Eliminator\01 - ZZ Top - Gimme All Your Lovin'.mp3

\Music\_Soundtrack\2006 - V for Vendetta\09 - Cat Power - I Found a Reason.mp3

\Music\_Techno\1991 - XL Recordings- The Second Chapter\07 - Cubic 22 - Night in Motion (Original mix).flac

\Music\_Various\2007 - Endzeit Bunkertracks, Act 3 (disc 2- Torture session)\01 - Faderhead - Dirtygrrrls - Dirtybois (Modulate mix).flac

</code>

----

<code>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</code>

Tips & Tricks

2008-02-26T20:01:19Z

Teknojnky:

'''
This page is for tips that make things easy or that are not known by new computer users.
in other words some tips that were from older windows os's that still work on winXp or newer versions of windows.'''

'''[[ Icons tips ]]

'''[[ Song Recording Tips ]]

'''[[ Song Editing Tips ]]

'''[[ System Hardware Tips]]

'''[[ MISC... Tips ]]'''

'''[[ Using MusicBrainz for CD Lookup ]]'''

'''[[Not So Frequently Asked Questions]]'''

'''[[Tagging Search Sites]]'''

'''[[User Auto-Organize File Masks Examples]]'''

User:Teknojnky

2008-02-26T19:58:46Z

Teknojnky:

Hi!

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

Current Auto-Organize mask

<nowiki>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Album>,$if(<Year>,<Year> - )<Album>)\$if(<track#>,<track#> - )<Artist> - <Title>,240)</nowiki>

Previous Auto-Organize mask

<nowiki>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist@1>,$if(<Album Artist>=various,_Various\$if(<Year>,<Year> - )<Album>,$if(<Album Artist>=soundtrack,_Soundtrack\$if(<Year>,)<Album>,$if(<Album Artist>=Techno,_Techno\$if(<Year>,<Year> - )<Album>,<Album Artist@1>\<Album Artist>)))),<Artist@1>)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>\,),<Artist>\)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>,<Album Artist>),<Artist>)$if(<Album>,$if(<Year>, - <Year>) - <Album>$if(<Track#>, - <Track#>,),)$if(<Album Artist>,$if(<Album Artist>=<Artist>, - <Title>, - <Artist> - <Title>), - <Title>),240)</nowiki>

User:Teknojnky

2008-02-22T20:45:47Z

Teknojnky:

Hi!

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

Current Auto-Organize mask

<nowiki>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=various,_<Album Artist>,$if(<Album Artist>=techno,_<Album Artist>,$if(<Album Artist>=soundtrack,_<Album Artist>,<Album Artist@1>\<Album Artist>))),<Artist@1>\<Artist>)\$if(<Year>,<Year> - )$if(<Album>,<Album>)\<Track#> - <Artist> - <Title>,240)</nowiki>

Previous Auto-Organize mask

<nowiki>$left(\Music\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist@1>,$if(<Album Artist>=various,_Various\$if(<Year>,<Year> - )<Album>,$if(<Album Artist>=soundtrack,_Soundtrack\$if(<Year>,)<Album>,$if(<Album Artist>=Techno,_Techno\$if(<Year>,<Year> - )<Album>,<Album Artist@1>\<Album Artist>)))),<Artist@1>)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>\,),<Artist>\)\$if(<Album Artist>,$if(<Album Artist>=<Artist>,<Artist>,<Album Artist>),<Artist>)$if(<Album>,$if(<Year>, - <Year>) - <Album>$if(<Track#>, - <Track#>,),)$if(<Album Artist>,$if(<Album Artist>=<Artist>, - <Title>, - <Artist> - <Title>), - <Title>),240)</nowiki>

ISDBSongData::LastPlayed

2008-02-19T17:18:58Z

Teknojnky: /* Property description */

{{MethodDeclaration|SDBSongData|ISDBSongData|Property Get/Let LastPlayed As Date}}

===Property description===

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBSongData|{{PAGENAME}}]]
[[Category:Interface ISDBSongData|{{PAGENAME}}]]

Some discussion in [http://www.mediamonkey.com/forum/viewtopic.php?t=25687 this thread], in summary use vb datediff() function to compare dates (ie .LastPlayed > x seconds/minutes/hours/days/etc).

Don't forget to take into account if using SQL with MM dates, to adjust for timezone differences between sqlite:

Now = (JulianDay('now','localtime')-2415018.5)

LastTimePlayed = JulianDay(LastTimePlayed)

These are for SQL, not for the 'date' object.

Another good [http://www.mediamonkey.com/forum/viewtopic.php?p=131973#131973 post] regarding dates in MM.

ActiveX Warnings

2008-02-09T01:58:30Z

Teknojnky:

ActiveX warnings: If you have switched "Initialise and script ActiveX controls not marked as safe" in your Local Intranet settings in Internet Explorer, and you are still getting the warning messages - try this:

1) Run regedit.exe

2) Goto HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0

3) Modify key 1201 = 0

This sets your "My Computer" zone setting (which is not displayed in the Internet Options) to Enabled.

See also:

[http://support.microsoft.com/?kbid=315933 MS KB article]

[http://support.microsoft.com/?scid=833633 MS KB article]

ActiveX Warnings

2008-02-09T01:56:01Z

Teknojnky:

ActiveX warnings: If you have switched "Initialise and script ActiveX controls not marked as safe" in your Local Intranet settings in Internet Explorer, and you are still getting the warning messages - try this:

1) Run regedit.exe
2) Goto HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0
3) Modify key 1201 = 0

This sets your "My Computer" zone setting (which is not displayed in the Internet Options) to Enabled.

See also:
[http://support.microsoft.com/?kbid=315933 MS KB article]
[http://support.microsoft.com/?scid=833633 MS KB article]

Introduction To Scripts

2008-02-09T01:44:09Z

Teknojnky:

Scripts are a fundamental feature of MM.
They allow the user to automate MediaMonkey and enhance it with new features as autmated tagging, resuming playback on startup, getting info from the internet.

Scripts are available in the [http://www.mediamonkey.com/forum/viewforum.php?f=2 scripting forum].

== See also==
[[Introduction to scripting]]

[[ActiveX Warnings]]

ActiveX Warnings

2008-02-09T01:43:31Z

Teknojnky:

ActiveX warnings: If you have switched "Initialise and script ActiveX controls not marked as safe" in your Local Intranet settings in Internet Explorer, and you are still getting the warning messages - try this:

1) Run regedit.exe
2) Goto HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0
3) Modify key 1201 = 0

This sets your "My Computer" zone setting (which is not displayed in the Internet Options) to Enabled.

User:Teknojnky

2008-02-09T01:42:20Z

Teknojnky:

Hi!

[[User Wishlists and Feature Requests]]

[[Last.FM Scrobbler Plugin Info]]

[[ActiveX Warnings]]

Talk:SDBSongData

2008-02-08T21:07:35Z

Teknojnky:

Is there a way to programattically get all the 'user' fields or do they all have to be entered manually?

For example, populating a list box of fields... it would seem logical that there is (or should be) an internal list of modifiable fields somewhere.

something akin to

dim obj, fieldlist

set obj = sdb.selectedsonglist.item(0)

set fieldlist = obj.getuserfields 'returns list of all settable user fields

--[[User:Teknojnky|Teknojnky]] 16:07, 8 February 2008 (EST)

Talk:SDBTreeNode

2008-02-08T00:51:48Z

Teknojnky:

How to use the custom properties effectively? --[[User:Teknojnky|Teknojnky]] 19:51, 7 February 2008 (EST)

Talk:Sample Lyricist Tree Node script

2008-02-08T00:40:54Z

Teknojnky:

This sample should probly be updated to use the new event mechanisms if the old ones are deprecated.

Talk:Main Page

2008-02-06T18:54:50Z

Teknojnky:

Talk:ISDBSongData::GetCopy

2008-02-05T18:21:53Z

Teknojnky:

I don't understand what this method does or what it would be used for.

SDBSongData

2008-02-05T18:18:44Z

Teknojnky: /* ISDBSongData members */

{{AutomationObjectsList}}
== CoClass SDBSongData ==

Object with all properties of a track.

To apply changes made to a SongData object, be sure to call one or more of the methods [[ISDBSongData::UpdateAlbum|UpdateAlbum]], [[ISDBSongData::UpdateArtist|UpdateArtist]], [[ISDBSongData::UpdateDB|UpdateDB]] and/or [[ISDBSongData::WriteTags|WriteTags]]. In some cases, you can call the [[ISDBSongList::UpdateAll|UpdateAll]] method of the SongList object containing the SongData object.

=== ISDBSongData members ===

{{MethodsList
|[[ISDBSongData::Album|Album]] |Property Get |
|[[ISDBSongData::AlbumArt|AlbumArt]] |Property Get |
|[[ISDBSongData::AlbumArtistName|AlbumArtistName]] |Property Get/Let |
|[[ISDBSongData::AlbumName|AlbumName]] |Property Get/Let |
|[[ISDBSongData::Artist|Artist]] |Property Get |
|[[ISDBSongData::ArtistName|ArtistName]] |Property Get/Let |
|[[ISDBSongData::Author|Author]] |Property Get/Let |
|[[ISDBSongData::Band|Band]] |Property Get/Let |
|[[ISDBSongData::Bitrate|Bitrate]] |Property Get/Let |
|[[ISDBSongData::Bookmark|Bookmark]] |Property Get/Let |
|[[ISDBSongData::BPM|BPM]] |Property Get/Let |
|[[ISDBSongData::Cached|Cached]] |Property Get/Let |
|[[ISDBSongData::CachedPath|CachedPath]] |Property Get |
|[[ISDBSongData::CalculateGapData|CalculateGapData]] |Method |
|[[ISDBSongData::Channels|Channels]] |Property Get/Let |
|[[ISDBSongData::Comment|Comment]] |Property Get/Let |
|[[ISDBSongData::Conductor|Conductor]] |Property Get/Let |
|[[ISDBSongData::Copyright|Copyright]] |Property Get/Let |
|[[ISDBSongData::Custom1|Custom1]] |Property Get/Let |
|[[ISDBSongData::Custom2|Custom2]] |Property Get/Let |
|[[ISDBSongData::Custom3|Custom3]] |Property Get/Let |
|[[ISDBSongData::Custom4|Custom4]] |Property Get/Let |
|[[ISDBSongData::Custom5|Custom5]] |Property Get/Let |
|[[ISDBSongData::DateAdded|DateAdded]] |Property Get/Let |
|[[ISDBSongData::DiscNumber|DiscNumber]] |Property Get/Let |
|[[ISDBSongData::DiscNumberStr|DiscNumberStr]] |Property Get/Let |
|[[ISDBSongData::Encoder|Encoder]] |Property Get/Let |
|[[ISDBSongData::FileLength|FileLength]] |Property Get/Let |
|[[ISDBSongData::FileModified|FileModified]] |Property Get/Let |
|[[ISDBSongData::GaplessBytes|GaplessBytes]] |Property Get/Let |
|[[ISDBSongData::Genre|Genre]] |Property Get/Let |
|[[ISDBSongData::GetCopy|GetCopy]] |Method |
|[[ISDBSongData::Grouping|Grouping]] |Property Get/Let |
|[[ISDBSongData::ID|ID]] |Property Get/Let |
|[[ISDBSongData::InvolvedPeople|InvolvedPeople]] |Property Get/Let |
|[[ISDBSongData::isBookmarkable|isBookmarkable]] |Property Get/Let |
|[[ISDBSongData::IsntInDB|IsntInDB]] |Property Get/Let |
|[[ISDBSongData::ISRC|ISRC]] |Property Get/Let |
|[[ISDBSongData::LastPlayed|LastPlayed]] |Property Get/Let |
|[[ISDBSongData::Leveling|Leveling]] |Property Get/Let |
|[[ISDBSongData::LevelingAlbum|LevelingAlbum]] |Property Get/Let |
|[[ISDBSongData::Lyricist|Lyricist]] |Property Get/Let |
|[[ISDBSongData::Lyrics|Lyrics]] |Property Get/Let |
|[[ISDBSongData::Media|Media]] |Property Get |
|[[ISDBSongData::MediaLabel|MediaLabel]] |Property Get |
|[[ISDBSongData::MetadataFromFilename|MetadataFromFilename]] |Method |
|[[ISDBSongData::Mood|Mood]] |Property Get/Let |
|[[ISDBSongData::MusicComposer|MusicComposer]] |Property Get/Let |
|[[ISDBSongData::Occasion|Occasion]] |Property Get/Let |
|[[ISDBSongData::OriginalArtist|OriginalArtist]] |Property Get/Let |
|[[ISDBSongData::OriginalLyricist|OriginalLyricist]] |Property Get/Let |
|[[ISDBSongData::OriginalTitle|OriginalTitle]] |Property Get/Let |
|[[ISDBSongData::OriginalYear|OriginalYear]] |Property Get/Let |
|[[ISDBSongData::ParseText|ParseText]] |Method |
|[[ISDBSongData::Path|Path]] |Property Get/Let |
|[[ISDBSongData::PeakValue|PeakValue]] |Property Get/Let |
|[[ISDBSongData::PlayCounter|PlayCounter]] |Property Get/Let |
|[[ISDBSongData::PlaylistOrder|PlaylistOrder]] |Property Get/Let |
|[[ISDBSongData::PostGap|PostGap]] |Property Get/Let |
|[[ISDBSongData::PreGap|PreGap]] |Property Get/Let |
|[[ISDBSongData::Preview|Preview]] |Property Get |
|[[ISDBSongData::PreviewPath|PreviewPath]] |Property Get |
|[[ISDBSongData::Publisher|Publisher]] |Property Get/Let |
|[[ISDBSongData::Quality|Quality]] |Property Get/Let |
|[[ISDBSongData::Rating|Rating]] |Property Get/Let |
|[[ISDBSongData::RatingString|RatingString]] |Property Get/Let |
|[[ISDBSongData::ReadTags|ReadTags]] |Method |
|[[ISDBSongData::RenameByMask|RenameByMask]] |Method |
|[[ISDBSongData::SampleRate|SampleRate]] |Property Get/Let |
|[[ISDBSongData::SongID|SongID]] |Property Get |
|[[ISDBSongData::SongLength|SongLength]] |Property Get/Let |
|[[ISDBSongData::SongLengthString|SongLengthString]] |Property Get |
|[[ISDBSongData::Tempo|Tempo]] |Property Get/Let |
|[[ISDBSongData::Title|Title]] |Property Get/Let |
|[[ISDBSongData::TotalSamples|TotalSamples]] |Property Get/Let |
|[[ISDBSongData::TrackOrder|TrackOrder]] |Property Get/Let |
|[[ISDBSongData::TrackOrderStr|TrackOrderStr]] |Property Get/Let |
|[[ISDBSongData::UpdateAlbum|UpdateAlbum]] |Method |
|[[ISDBSongData::UpdateArtist|UpdateArtist]] |Method |
|[[ISDBSongData::UpdateDB|UpdateDB]] |Method |
|[[ISDBSongData::VBR|VBR]] |Property Get/Let |
|[[ISDBSongData::WriteTags|WriteTags]] |Method |
|[[ISDBSongData::Year|Year]] |Property Get/Let |
}}

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBSongData|{{PAGENAME}}]]

Talk:ISDBDatabase::BeginTransaction

2008-02-05T04:08:57Z

Teknojnky:

Talk:ISDBSongList::Delete

2008-02-05T04:03:15Z

Teknojnky:

What is the best way to use this method?

If I try to delete a track within a loop, the loop does not get the updated .count and it will go out of bounds..

example:

For x = 0 to sdbsonglist.count-1
if sdbsonglist.item(x).rating < 50 then
sdbsonglist.delete(x)
end if
Next

that is a realistic situation when you are checking a track list for certain criteria (ie rating etc) and you want to remove a track without creating a new secondary songlist object.
--[[User:Teknojnky|Teknojnky]] 23:03, 4 February 2008 (EST)