will this read the monkey's database file?

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: will this read the monkey's database file?

by rovingcowboy » Mon May 08, 2006 11:38 pm

i have no idea what they are?

i think 401 is what makes the list sort from top down with the oldest days at the top.

and i think 32 is what makes the play count sort from the top down with the highest count at the top?

well wait a minute? maybe the Asc is Ascending?

i know the limitTop is the number of songs and it has to have the 1 or 0 for on and off.

the number 777 is the number of songs it is checking through.

maxmb is the size you want to keep the playlist at which is i guess used
for burning the playlist.

and maxlen is the the number of minutes you want to show on the playlists.

value is the number of days i am having it check for

as to the rest of the stuff it is unknown or unknown as to why it is there?


i know this code when put in to the database does work in making an auto playlist that has 59 minutes of songs minus 30 to 60 seconds depending on the length of the songs. and it has only the highest play count songs showing and only for the last 7 days.

to my disapointment as per my previous message it does only take the top songs in the list to make the playlist out of it does not randomize the 777 songs to make the list. :(

but i don't have the gold version which all this code would not be needed if i did have it. this code needing put in for the top of the charts list is only needed if you have the free version.

don't make the top of the charts list in monkey and then try to edit the code for it. because it won't work you need to add the code in the database to make the playlist then it works.

but this is all i know about it since i am not a programmer and i advise you only to do the things steegy and i have posted to do if you are not any programmer also.. as this is monkeys database and you could mess up your whole music librairy if you mess with other things in it, or atleast that is a save thing to think for a non programmer. 8)

Anybody know the numeric codes for the various conditions?

by gnorts » Mon May 08, 2006 8:02 pm

For example, it looks like 401 is less-than-or-equal-to and 32 is greater-than...but is it that simple? And what's the entire list of available condition operators?

Thanks!

by Guest » Sat Apr 08, 2006 7:33 am

oh okay on the 2 of the mdb's?

but i have 3 of the mdb's on all my cmputers?

the one in the my documents, monkey..

and the one in the program files medaia monkey.

and then the active one is in

c:\program files\media monkey\data\

and it has the ldb and another monkey.mdb.mdb

in the same folder?

as i said all the computers here have that set up and i did not change the orgianl locations? :o

i even did a clean wipe out of monkey on the win98 and reinstalled it.
and that setup is still there?

oh well now i know where the active mdb file is 8)


i have adjusted the code you gave me some more
and i am now using this

Code: Select all

[Common] 
QueryVersion=1 
QueryType=2 

[Adv] 
ConditionsCount=2 
OrdersCount=2 
LimitTop=1 
Top=777
LimitMB=1
MaxMB=650 
LimitLen=1
MaxLen=59

[AdvCond1] 
DBField=Songs.LastTimePlayed 
Condition=401 
Value=7

[AdvCond2]
DBField=Songs.PlayCounter
Condition=32
Value=0

[AdvSO1]
Order=Songs.PlayCounter
Asc=0

[AdvSO2]
Order=Songs.LastTimePlayed
Asc=1
I am not sure why the max mb's is there so i left them alone
but i did set the top number of songs for more then i play a week
so it can choose from all of them to keep the max time of the play list to around 59 minutes.

it may only take the first 16 to 17 songs to keep it that long
but after all the time i spent on this don't spoil it for me :lol:
let me find that out and get disapointed later. 8) :roll:


roving cowboy / keith hall
not logging in just wanted to post this.
[/b]

by Steegy » Sat Apr 08, 2006 4:04 am

Great!

For your information: Normally MediaMonkey has 2 database files (MediaMonkey.mdb).
On normal setups, the clean (default) database is in the program folder (c:\program files\mediamonkey), and the real database (which is originally created from the default database) is in the My Music subfolder (My Documents\MyMusic\MediaMonkey). The latter is the one normally used.

As you probably know, the database can be placed somewhere else if you change (or add) an entry to the configuration file accordingly.
I think all this info can also be found in the help file, and in the readme.txt file.

BTW: One trick to know if a database file is active is to look if it also has a ldb file in the same folder. E.g. when MediaMonkey is active, there's a MediaMonkey.ldb in the same folder as the MediaMonkey.mdb file. When MediaMonkey (and the database) closes, the ldb file is deleted.

Cheers
Steegy

by rovingcowboy » Sat Apr 08, 2006 3:20 am

Yahoooooooieeee!!!!!!!!!!!

fianlly got it to work. have the playlist in the tree now.

all i had to do was put the code in just like you said.

all the trouble i had was in knowing which mdb file to put it in?

just why are there 3 locations for the files to be in and each one has different amounts of tables in?

:o :-?

8) :D
i even got to poking around in the other memo areas and copied the code for the playcounter in the top 50's list and added it to the code you gave me now it also puts the songs in the list of most played to least played.

good deal on that code steegy thanks.

by Teknojnky » Fri Apr 07, 2006 2:48 pm

20$ is like 2 days worth of food, just go on a diet and feed the monkey instead!

:o

by Guest » Fri Apr 07, 2006 1:58 pm

yes i am doing the changes with media monkey closed.

it just will not add the playlist to the tree.

i am tired of trying this i need some sleep. maybe i will get back and try it later on but i am not getting any results now.

i put the information in just the same way you say to do.
i guess it just don't like me messing with the database. :(

rovingcowboy / keith

by Steegy » Fri Apr 07, 2006 4:04 am

You are editing the database while MM is closed, right?

Do you have MSN Messenger or so, so we can do this step by step? (if so, you can pm the address to me)

It is possible to insert these values through a script, but it should be more possible to do this through an MDB editing program.

Cheers
Steegy

by rovingcowboy » Fri Apr 07, 2006 1:06 am

it is just not working on this winXp it will not show any new playlists in the folder tree.

i have been doing it and doing it. over and over and rebooting and i am just not getting it to show any playlists. does the monkey have to be the gold version? :(


i just tried again while online and logged in here.

still does not show any playlists. :o :(

by Steegy » Thu Apr 06, 2006 3:16 pm

The text box is for the QueryData field.
Double click the rectangular box (within the new row and in the QueryData column) to edit the value in it as "MEMO". It will open the text box so you can paste the code and apply. Changes are automaticly saved so don't search for a "save (as...)" option, because it's not there.

by rovingcowboy » Thu Apr 06, 2006 6:53 am

the text box showed me no text at all until i put your code in? :o :-?

by Steegy » Wed Apr 05, 2006 5:20 pm

It really doesn't matter what program you use. You just need a program that can do it, and that's easy and free.

I didn't test the "MDB viewer plus" program, but when I look at the screenshots (website found with Google), it looks like a nice application. So this program will probably work very good as well.
As reference: http://www.alexnolan.net/software/mdb_viewer_plus.htm

Screenshot from the DB-Tool program:
Image

It adds the "jkgjhfhjfg" autoplaylist correctly to MM. I used the values that I posted in the other thread. Be careful, the text box you see in the screenshot contains more text than is displayed...

Result in MM:
Image

Cheers
Steegy

by Guest » Wed Apr 05, 2006 3:34 pm

i tried it here on the winxp several times.

i can not get any playlist to show?

it takes it in the database but it does not show any playlist in the tree.

i even changed the date on the clock ahead eight days.

and it still did not show a playlist in monkeys tree?

what did i do wrong?

roving cowboy / keith hall.

not logged in again.

by Guest » Wed Apr 05, 2006 8:22 am

steegy?

some one sent me the MDB viewer plus program and said it is the simplest one to use just start and click on the tabs and lines to get what you want to edit in the mdb no trouble with it at all no install no registry mess up or stuff like that?

i am not sure which one to use now. as you said not to restart the program you found and not to let it start server?

the sever thing seems strange to me? but the whole database thing is strange to me?

just wanted to give you this info and let you know what is going on now?

i have not done anything yet.

roving cowboy / keith hall

not logged in.

by rovingcowboy » Wed Apr 05, 2006 4:54 am

oh wow i did not mean for anyone to start testing just because i was asking?
:o
thanks a lot for that.? :wink: 8)

i am getting it now.

i see i can install it on win 98 and that is where the database is.

so i will have to do that later it will take a day or so to try it.

the warning i have for the virus scann just came on my computer i have to get off line while it does that for a couple hours on this one.

i will copy the infor you gave me and try it on the win 98 later.
thanks again for doing the unexpected testing for me. 8) :)

put your self up for a double bonus of good luck. :)

Top