From the Dutch Synology forum I understand that in case of movies split into two files (eg Troy – CD 1.avi and Troy – CD2.avi) with the Pinnacle media server is displayed as one movie (Troy.avi); this is contrary to SwissCenter, where the two files are displayed separately in the menus (for the Dutch reading, see here).
Can this been explained by the fact that SwissCenter streams directly from the web server? And could this be “solved” when video files are streamed through “/stream.php”?
Just curious, regards, Klaas ----------------------------------------- SwissCenter 1.19.2 Simese 1.40 & Apache 2 / PHP 5.2.0 Windows XP & Linux Synology 2.6.15 Synology DS107+ (128) Pinnacle SC200
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1097
Re: split movies - 2008/04/02 18:25>>>From the Dutch Synology forum I understand that in case of movies split into two files (eg Troy – CD 1.avi and Troy – CD2.avi) with the Pinnacle media server is displayed as one movie (Troy.avi); this is contrary to SwissCenter, where the two files are displayed separately in the menus
SwissCenter will also display the two files as one movie. Simply go into the config and change the name name (e.g. Troy.avi) and synopsis info to match and they will be displayed as a single title that will play in order.
I have several movies that are in parts and they display with a single titleShowcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.02 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
Pernod
Admin
Posts: 1141
Re: split movies - 2008/04/02 18:28Was just about to say exactly the same as Stu... basically if the Title and Synopsis are the same for multiple files then when 'Browsing by Title' they will be listed as a single item and played ordered by filename.Player : Netgear EVA700 & Popcorn A-100 Server : Vista SP1 Home Premium (Simese 1.45, SwissCenter current SVN) Spec : Intel C2Q Q6600, 2GB RAM, 1Tb storage.
| | The administrator has disabled public write access.
klaasvaak
User
Posts: 392
Re: split movies - 2008/04/03 15:14Hi guys,
Thanks for your replies and suggestion; it works smoothly, regards, Klaas ----------------------------------------- SwissCenter 1.19.2 Simese 1.40 & Apache 2 / PHP 5.2.0 Windows XP & Linux Synology 2.6.15 Synology DS107+ (128) Pinnacle SC200
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/04/04 05:02Thanks, this works very well for me too.
Is there a way to edit the movie database manually with a text editor/spreadsheet.
I have a lot of movies titles to change and this would work much faster than using the SC browser interfaceSwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
Pernod
Admin
Posts: 1141
Re: split movies - 2008/04/04 06:14Is there a way to edit the movie database manually with a text editor/spreadsheet. What you need is MySQL Tools which you can download from here. Install this and run the MySQL Query Browser, enter the database details:
Server Host: localhost Username: swisscenter Password: swisscenter Default Schema: swiss
Now select the 'movies' table and you can edit the 'title' field.
WARNING: Only use this tool if you are comfortable editing the database. Changing the 'title' is okay but editing other fields in other tables may cause problems!Player : Netgear EVA700 & Popcorn A-100 Server : Vista SP1 Home Premium (Simese 1.45, SwissCenter current SVN) Spec : Intel C2Q Q6600, 2GB RAM, 1Tb storage.
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/04/04 16:32I will try this. But my swisscenter runs on my NAS-CS407 (Thanks to KLaasvaak his manual )
Probably the approach is than a bit different?
I also assume I can make a back up of the database which I can use to replace the one I have edited in case that one is somehow broken?
Thanks!SwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/05/29 18:25I tried to edit the database again using MySQL Query browser (v.1.2.12) but still no luck.
The IP of my NAS on which SC is installed is: 192.168.1.7 The settings I entered in the MySQL Query browser window are:
Server Host: 192.168.1.7 Port: 8080
Username: swisscenter
Password: swisscenter
Default Schema: swiss
The MySQL Query browser starts but nothing really happens. Can anyone advise?
Thanks.SwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
klaasvaak
User
Posts: 392
Re: split movies - 2008/05/31 08:30Not sure whether this is a real help, but I'm using a very simply php-script ("mysql_send.php") to manage the SwissCenter DB. It can run on your DS and you don't need any additional applications.
regards, Klaas ----------------------------------------- SwissCenter 1.20.1 Simese 1.40 & Apache 2 / PHP 5.2.0 Windows XP & Linux Synology 2.6.15 Synology DS107+ (128) Pinnacle SC200
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/07/31 18:56Hello Klaas,
I only see this mail today. Thanks for this I will give it a try. Can you give me some directions as to where to save this file and how to run and use it.
Thx.
WouterSwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
Pernod
Admin
Posts: 1141
Re: split movies - 2008/07/31 19:01I think you're trying to access the database on the wrong port, try 3306.Player : Netgear EVA700 & Popcorn A-100 Server : Vista SP1 Home Premium (Simese 1.45, SwissCenter current SVN) Spec : Intel C2Q Q6600, 2GB RAM, 1Tb storage.
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/08/01 19:22Hi,
I tried this port number and something happens. Now there is an error message.
My current NAS IP is 192.168.1.6 and this is the one I used in the logon screen of MySQL Query Browser (note that the NAS IP used to be 192.168.1.6 but this changed after a restart of the NAS) SwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
klaasvaak
User
Posts: 392
Re: split movies - 2008/08/01 20:23Hi Wouter,
Actually, there's no need to use any port number. I’ve saved this script on the web-drive of my DS with path:
Code:
/volume1/web/tools/mysql_send.php
I run the script by entering the following address in the browser of my PC:
regards, Klaas -----------------------------------------------------------------------------
SwissCenter 1.20.1
Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP
Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15
Synology DS107+ (128), firmware: DSM 2.0-0637
Pinnacle SC200
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/08/02 05:57Hi Klaas,
Thanks for the explanation. More bits and pieces come together. The script works but I am not sure what to do in the "Type in SQL query" (I assumed the database name is "swiss")
This looks like a can ruin the DB if I try the wrong commands. Any tutorial available for this script?
Also, is there a way to back up and restore the DB?
Thanks again
SwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
klaasvaak
User
Posts: 392
Re: split movies - 2008/08/02 06:29Hi Wouter,
Well, of course there’s always a risk of deleting elements of your DB, but the risk is not so big as most of the times you can re-enter missing info again with the script. MySQL commands "DELETE" and "DROP" should be handled with care. I assume it's possible to back-up your DB, but I don't know how.
There are several tutorials available on the net (eg here). But, if you like you can post the actions you want to carry out and I’ll provide you with some example scricpt.
Once again, you can have a look at the php-script in my previous post, which allows you to update your DB automatically
regards, Klaas ----------------------------------------------------------------------------- SwissCenter 1.20.1 Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15 Synology DS107+ (128), firmware: DSM 2.0-0637 Pinnacle SC200
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/08/02 11:45Hi Klaas,
What I am mostly looking for is to rename the titles. Especially to solve the "split movies" issue. This takes so much time to do via the config screen.
Also most titles show up like Season 1/Blake's 7 - The way back]
(While file & folder name are: \Blake's 7\Season 1\Blake's 7 - 1x07 [The way back].avi )
Not sure yet how I can make SC create the right title based on folder and file name. (I read the FAQ's but so far no iprovement)
Bye the way, I tried downloading the other script but the link seems to be broken.
WouterSwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
klaasvaak
User
Posts: 392
Re: split movies - 2008/08/02 12:27Hi Wouter,
Wouter wrote:Bye the way, I tried downloading the other script but the link seems to be broken.repaired
Wouter wrote:What I am mostly looking for is to rename the titles. Especially to solve the "split movies" issue. This takes so much time to do via the config screen.Have a look at the mentioned php-script, line 17 through 23; this will address your points raised as you have to enter the details only once.
Wouter wrote:Not sure yet how I can make SC create the right title based on folder and file name. (I read the FAQ's but so far no iprovement)I'll try to find something on this issue, not sure about the outcome.
regards, Klaas ----------------------------------------------------------------------------- SwissCenter 1.20.1 Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15 Synology DS107+ (128), firmware: DSM 2.0-0637 Pinnacle SC200
| | The administrator has disabled public write access.
Dutchsea
User
Posts: 60
Re: split movies - 2008/08/02 16:09Hi Klaas,
I think I have found what causing this issue with the files names.
My TV series are files as follows:
/volume1/video/series/series name/Season #/series name - {s}x{e} - episode name
(where {s} is the season number and {e} is the episode number)
Examples: /volume1/video/series/House/Season 3/House - 3x11 - Words and Deeds.avi /volume1/video/series/Bones/Season 1/House - 1x03 - A Boy in the Tree.avi /volume1/video/series/Blake's 7/Season 4/Blake's 7 - 4x06 - Headhunter.avi
I use 1 media location for all TV shows: /volume1/video/series
During the media search the files are checked for series name, season number, episode number and episode name, based on the file name and the directories in which the file is stored.
I noticed via the log that the choice of the media location (set in the config menu) determines which directories are used in the check.
In my example using the media location /volume1/video/series the check is based on the sub-directories and file name of /volume1/video/series: series name/Season #/series name - {s}x{e} - episode name
So for /volume1/video/series/House/Season 3/House - 3x11 - Words and Deeds.avi the following path is used in the check:
/House/Season 3/House - 3x11 - Words and Deeds.avi
This is called the "Expressions to test for path" in the log. The 12 ways used to test the expression (the array part in the log) are not compatible with this path. You can notice that in my case the path has the information about the series name (house) twice: once in the directory name (House) and once in the filename (House). Also the season number information is listed twice: once in the directory name (Season 3) ans once in the filename (3x11)
The 12 ways used to test the path (the array) are simply not designed to handle paths with double information.
So what to do (in my case):
A. I can change the media location (in the config menu) to the directory where the files are stored. In my example change it to:
/volume1/video/series/House/Season 3 (used to be /volume1/video/series)
In that case the path used in the check changes to :
House - 3x11 - Words and Deeds.avi (note that the directories house and season 3 are gone)
And this path works fine (fits well with rule 2 of the array check)
It does mean that I need to add separate media locations in the config menu for each each season of all series. This will create a lot of media locations. I hope this does not have an effect on the performance (testing this now)
B. Changing all the files names by deleting the series name and the season number. (And keep the media location: /volume1/video/series)
In my example the file name changes to:
volume1/video/series/House/Season 3/11 - Words and Deeds.avi (note that the series name House and the episode number 3x have been deleted from the file name)
In that case the path used in the check changes to:
House/Season 3/11 - Words and Deeds.avi
This seems to fit well with rule 4 of the array check.
Concluding:
As in my case adding the media locations is much less work compared to changing all files names, I used option A.
I am not sure if this is the way it should work. I dont remember that I had this issues in version 1.20.
Long story but it may help others with the same problem.SwissCenter 1.20.1 Synology CS407 firmware DSM 2.0-0598 Pinnacle SC200 - firmware 21-63 Windows XP SP2 Linux on Synology PHP 5.2.0 MySQL 5.0.51 Apache 2.2.3 (Unix)
| | The administrator has disabled public write access.
Forums 
)