[tjpoe]

I wanted to set up XBMC at the office to connect to my home collection. At home, the local mysql DB path is on a local drive: /home/user/movies/Action/
I have the files shared via http so that I can stream them at work, that same folder would be available at http://hostname.com:port/movies/Action/ I have to ports set up properly. I can connect to the DB from the office without issue, and I can connect to the movie collection via HTTP without issue.

I tried to set up advancedsettings.xml for my office machine.

PHP Code:

<advancedsettings>
 <videodatabase>
  <type>mysql</type>
  <host>hostname</host>
  <port>port</port>
  <name>xbmc_video</name>
  <user>xbmc_username</user>
  <pass>xbmc_password</pass>
 </videodatabase>
 <pathsubstitution>
  <substitute>
   <from>/home/user/movies/Action/</from>
   <to>http://hostname:port/movies/Action/</to>
  </substitute>
 </pathsubstitution>
 <loglevel>1</loglevel>
</advancedsettings> 


in the log, i see

15:49:15 T:5112 DEBUG: From: [/home/user/movies/Action/]
15:49:15 T:5112 DEBUG: To: [http://hostname:port/movies/Action/]

so it looks like it works. It will play files without spaces in the names / folder names, but ones with them don't get the %20 in the URL so they fail.

Any ideas?