Import M3U 3.8 - Updated 26/10/2013
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!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Glad I could help.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
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
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
I'll give this some thought!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
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!:)
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!:)
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Re: Runtime error
grmbrand wrote:Hey there--
I installed your script, but when I run it, I see the following:I hit the cancel button on that alert and then I see:Error
There was a problem querying the database:
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern stringI hit the OK button and then I see:Error
Error #-2147418113 - SongsDB.SDBDatabase
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern string
File: "C:\Program Files\MediaMonkey\Scripts\ImportM3U.vbs", Line: 65, Column:19I hit the OK button again and then I am back in MediaMonkey.Error
Error happened during script execution:
22018:[Microsoft][ODBC Microsoft Access Driver] Invalid pattern string
Any ideas? Do I need to update something?
Thanks,
Grmbrand
Assuming you have the latest version, open the script file in a text editor and find line 73...... and insert this line immediately before it...
Then run the script again and when you get the error, let me know the last line in the debug log "ImportM3U.vbs.log".
Code: Select all
Dim sql : sql = "AND (Songs.SongPath LIKE '%\"&line&"')"
Code: Select all
Call debug("Not found: "&mess)
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
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.
bye
Wolfgang
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.
bye
Wolfgang
Thanks. Glad I could help!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 5
- Joined: Fri Apr 07, 2006 1:35 pm
Help with Modification
How would I modify this script to allow for small differences in filename?
The original M3U has filenames as
But the current file name (for some songs, not all) is
(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.
The original M3U has filenames as
Code: Select all
Artist - Title.mp3
Code: Select all
##. Artist - Title.mp3
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.
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...
Then remove the numbers from the string to give you...
This should now ignore numbers as well as punctuation as long as you make sure line 27 reads...
Not a very nice solution but it should work in this case.
Code: Select all
If InStr("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789",UCase(pos)) = 0 Then
Code: Select all
If InStr("ABCDEFGHIJKLMNOPQRSTUVWXYZ",UCase(pos)) = 0 Then
Code: Select all
Dim IgnorePun : IgnorePun = True
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 34
- Joined: Mon Mar 05, 2007 10:58 am
Sooo...is 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?