Page 2 of 11

Posted: Wed Oct 18, 2006 5:14 am
by bbrodka
Thanks for the loging feature, I am kind of new to the "monkey" but from what I can tell you are hands down the most inovative and active script writer here! You seem to constantly be evolving :)

Posted: Wed Oct 18, 2006 5:29 am
by trixmoto
Well thank you, that's high praise indeed considering the achievements of some of the other scripters in this forum. I have to admit (as you'll see by looking at the comments at the top of my scripts) that we scripters do tend to help each other out, and certainly without some of them many of my scripts would never have got off the ground!

Posted: Wed Oct 18, 2006 7:54 am
by grmbrand
Works like a charm, now. Thanks!

Posted: Wed Oct 18, 2006 8:58 am
by trixmoto
Glad I could help. :D

Posted: Wed Oct 18, 2006 9:30 am
by bbrodka
OK, now that we got loging I can see whats not getting imported
I have another suggestion

Would it be posible to ignore punctuation? This would help improve more positive matches things lile periods and commas etc cause misses in otherwise good matches B-52's B52s B-52s should all be positive matches

Also strip out "THE" for more matches like for example beatles, the / the beatles / beatles all should match

Just throwing it oit there, I don't program so I don't know the posibilities

Posted: Wed Oct 18, 2006 10:36 am
by trixmoto
I'll give this some thought! :)

Posted: Wed Oct 25, 2006 4:07 am
by trixmoto
New version (2.5) has the option to ignore punctuation.

However, any other kind of fuzzy matching is not possible in the scripts current format, because it uses SQL which is not very fuzzy. Hope this is satisfactory!:)

Posted: Wed Oct 25, 2006 4:58 am
by bbrodka

Re: Runtime error

Posted: Tue Nov 21, 2006 1:58 am
by Guest
grmbrand wrote:Hey there--
I installed your script, but when I run it, I see the following:
There was a problem querying the database:
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern string
I hit the cancel button on that alert and then I see:
Error #-2147418113 - SongsDB.SDBDatabase
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern string
File: "C:\Program Files\MediaMonkey\Scripts\ImportM3U.vbs", Line: 65, Column:19
I hit the OK button and then I see:
Error happened during script execution:
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern string
I hit the OK button again and then I am back in MediaMonkey.

Any ideas? Do I need to update something?


Posted: Tue Nov 21, 2006 4:58 am
by trixmoto
Assuming you have the latest version, open the script file in a text editor and find line 73...

Code: Select all

Dim sql : sql = "AND (Songs.SongPath LIKE '%\"&line&"')"
... and insert this line immediately before it...

Code: Select all

Call debug("Not found: "&mess)
Then run the script again and when you get the error, let me know the last line in the debug log "ImportM3U.vbs.log".

Posted: Fri Nov 24, 2006 4:30 am
by wolfzell
Just as promised, a little feedback:

Modified ExportM3U and ImportM3U are now just perfect for my use. Now I have been testing all export/import combinations that I wanted to use and did not encounter any problems.

I now can easily transport all my playlists from my main system (where most files are in .flac-format) to my mediaserver (Firefly serving the Roku Soundbridge) or to my notebook on the road with the attached external harddisk, where the same songs are stored in .mp3-format (managed with MediaMonkey).

Then I can load those playlists and songs to my iPod from the notebook (again using MediaMonkey), this way avoiding repeated long conversion delays when changing the content of the iPod.

Until MediaMonkey may (hopefully) be able to support several files in different storage formats for one database entry, these two scripts are a fine solution for my playlist-needs.

So thank you once more for your help.


Posted: Fri Nov 24, 2006 4:47 am
by trixmoto
Thanks. Glad I could help! :)

Help with Modification

Posted: Tue May 15, 2007 3:35 pm
by mm_user2k6
How would I modify this script to allow for small differences in filename?

The original M3U has filenames as

Code: Select all

Artist - Title.mp3
But the current file name (for some songs, not all) is

Code: Select all

##. Artist - Title.mp3
(where ## is track number)

Thus some songs are not being found, and not being added to playlist. Actual track numbers vary from song to song (obviously).

Unfortunately renaming hundreds of files back to original name would be far to painful. Plus I have a need to retain track # info on affected files.

Posted: Wed May 16, 2007 4:02 am
by trixmoto
Well there's no good way to do this currently, although there's discussion about a script that could do this, but no one's managed to get a working version (although I've tried myself). If it's just track numbers then you could use this script by opening it in a text editor and finding line 123...

Code: Select all

If InStr("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789",UCase(pos)) = 0 Then
Then remove the numbers from the string to give you...

Code: Select all

This should now ignore numbers as well as punctuation as long as you make sure line 27 reads...

Code: Select all

Dim IgnorePun : IgnorePun = True
Not a very nice solution but it should work in this case.

Posted: Wed May 16, 2007 7:38 pm
by vanmeterannie there any way to import an m3u playlist without the songs actually being in the current database? I'm trying to figure out a way to have two databases, and be able to save a playlist from one and open in the other without actually putting the files into the second database. Is this possible?