I have tried 0.2.3.1 and it doesn't import m3u playlists for me. When I press the [Open] button after I have selected the m3u file the script immediatly returns to the Playlist sub-menu.
It can list one of my two existing playlists - so thats a good start. The one it lists is one that I imported with different script (but it failed to save any songs into the list). If I try to export this empty playlist I get "An error was encountered." I manually added a couple of tracks to the playlist via the PMS web interface, then tried the export again. Your script said it was successful, but I dont know where it exported the file too so haven't been able to confirm.
The m3u I am trying to import is in the same folder as the script. It is in ANSI format. All the songs are listed in the format: \\Server\Share\\\\ - .mp3
Just leaving a quick reply and a big THANK YOU! Exactly what I was looking for.
One minor sidenote (in case this hasn't been mentioned): Plex can only handle m3u-playlists with absolute filepaths. Playlists with relative paths will be imported sucessfully and show up as empty. Prefixing every line with the missing part of the path corrects this behavior. Additionly, playlist names containing ä, ö or ü did not work for me. Examples below.
Doesn't work:
Playlist name: gemütlich
Paths in playlist file: Music\Generic Artist\Generic Song.mp3
Does work:
Playlist name: gemuetlich
Paths in playlist file: D:\ServerFolders\Music\Generic Artis\Generic Song.mp3
I have tried 0.2.3.1 and it doesn't import m3u playlists for me. When I press the [Open] button after I have selected the m3u file the script immediatly returns to the Playlist sub-menu.
Something is up with MortScript. It appears to be placing a limit on the size of my script. I am right at that edge so it is ignoring certain code. Looks like I have to split my script into multiple scripts now. Weird, I have been using MortScript for years and have never run into this problem.
It can list one of my two existing playlists - so thats a good start. The one it lists is one that I imported with different script (but it failed to save any songs into the list). If I try to export this empty playlist I get "An error was encountered." I manually added a couple of tracks to the playlist via the PMS web interface, then tried the export again. Your script said it was successful, but I dont know where it exported the file too so haven't been able to confirm.
That is the correct error message for exporting an empty playlist. I will change it so it is more descriptive. The successful one should have been placed into a folder called "Exported Playlists" relative to the location of the script.
The m3u I am trying to import is in the same folder as the script. It is in ANSI format. All the songs are listed in the format: \\Server\Share\\\\
As long as you do not have foreign characters, ANSI is fine. Is this path the same as in Plex? It needs to be identical.
I have tried 0.2.3.1 and it doesn't import m3u playlists for me. When I press the [Open] button after I have selected the m3u file the script immediatly returns to the Playlist sub-menu.
Something is up with MortScript. It appears to be placing a limit on the size of my script. I am right at that edge so it is ignoring certain code. Looks like I have to split my script into multiple scripts now. Weird, I have been using MortScript for years and have never run into this problem.
It can list one of my two existing playlists - so thats a good start. The one it lists is one that I imported with different script (but it failed to save any songs into the list). If I try to export this empty playlist I get "An error was encountered." I manually added a couple of tracks to the playlist via the PMS web interface, then tried the export again. Your script said it was successful, but I dont know where it exported the file too so haven't been able to confirm.
That is the correct error message for exporting an empty playlist. I will change it so it is more descriptive. The successful one should have been placed into a folder called "Exported Playlists" relative to the location of the script.
I found this folder and it had a correctly formatted m3u playlist in it :)
The m3u I am trying to import is in the same folder as the script. It is in ANSI format. All the songs are listed in the format: \\Server\Share\\\\
As long as you do not have foreign characters, ANSI is fine. Is this path the same as in Plex? It needs to be identical.
Yes they are the same paths as will be in the PMS database.
I've only found one of my m3u playlists that won't import now. Have made sure it has valid file paths, is in ANSI format. Just creates an empty playlist. Odd. Don't worry about it. It's not an important one to me. Other lists that I really wanted have imported fine.
Just for you user's information, it seems there is a bug (feature?) that prevents the PMS Web and PHT user interface from loading a playlist that has more than approx 150 remote tracks listed in it. By 'remote' I mean tracks that are on a server other than the PMS - e.g. of the format \\Server\share\path rack etc.
Thanks for the feedback. Do you have any non alpha-numeric characters in the filename or in the first file in the list? Maybe there is a character that is a SQlite reserved character. I checked for the apostrophe which I know causes problems but I did not check for others.
Thanks also for the tip on the limit. I do not use network paths so I have not run into this issue.
No, there wasn't anything odd like that. I added another few random tracks to the list and saved it with a new file name (ANSI format) and the imported it - and it worked. Weird.
I am desperately crawling the forum looking for a way to change my library icons. I got so excited when I downloaded this but quickly turned to sadness when I saw this:
EDIT: I just needed to run the initial MSCR file first. And I managed to change the icon, I love how it does it on the fly. No PMS reboot necessary.
MovieFan, just want to say big Thank you for your time and effort in creating this. The community here is really amazing.
Each table would be written as a csv file in the folder with the filename being the table name with csv extension (sorry i am thinking only of windows - but would be equivalent)
Options on export: Character set - default presumably would be utf-8
Delimeter character ? Need to be unique - presumably safest is Tab
With that available one can then use Excel vba to get all csv sheets into a workbook and manipulate, link tables, analyze in excel
Each table would be written as a csv file in the folder with the filename being the table name with csv extension (sorry i am thinking only of windows - but would be equivalent)
Options on export: Character set - default presumably would be utf-8
Delimeter character ? Need to be unique - presumably safest is Tab
With that available one can then use Excel vba to get all csv sheets into a workbook and manipulate, link tables, analyze in excel
Yeah, this can be done, it is actually pretty easy. SQLite has a built in export to csv feature. I use it as part of my playlist import routine. This is on my "to do" list. Just need to get off my butt to put it in.
Thanks to you MovieFan, my libraries never looked any better. Just need to make myself a Talk Shows icon and I'm set :D
Yes sir! Btw, I'm a UI Designer so if you ever wanted to overhaul your GUI and make it more Plex-y I would love to design it for you. Completely free of charge, I just would like to give back to this community in however way I can.
The popup is the command prompt running the SQL statement. Either something is wrong so that the SQL command could not run or the statement returned no data.
Open up the script in the error message in notepad or other file viewer. Go to line 66.
RunWait(strCmd, "/c " & strSqlBat)
Change the /c to /k. This will cause that popup window to stay open. If you see a blank command window with just the prompt, that means the statement ran fine but returned 0 results. If you see an error, let me know what that error is.
