Bulk file name update

Discussion in 'My TVSeries' started by Neoculture, April 17, 2019.

  1. Neoculture

    Neoculture Portal Pro

    Joined:
    November 20, 2011
    Messages:
    62
    Likes Received:
    3
    Gender:
    Male
    Occupation:
    Senior Analyst
    Location:
    Brisbane
    Ratings:
    +3 / 0
    Home Country:
    Australia Australia
    Show System Specs
    I had a search through the forum and I can't see a thread on this, so...



    I currently have my TV Series on the network under \\Fileserver\TV_Series and then divided into sub-directories based on series name. e.g.:
    \\Fileserver
    \TV_Series
    \A
    \Arrow
    \Season 1
    \Season 2
    \B
    \Babylon 5
    \Season 1
    \Season 2
    \C
    (etc)

    I have a new (bigger) fileserver and the sub-directories are now on \\NAS-002\TV_Series (with the same sub-structures).
    I do not want to have to nuke and reload the data in the plugin (I have been collecting/ripping series for almost 20 years now), so is there any way to update the database so that all of the filenames now point to the new NAS?
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
    You can manually edit the DB3 SQLite database file with an appropriate tool.

    There are multiple tables to update, and knowledge of SQL is required.

    If you are not comfortable with that, then just move the data and do a fresh import.
     
  4. Neoculture

    Neoculture Portal Pro

    Joined:
    November 20, 2011
    Messages:
    62
    Likes Received:
    3
    Gender:
    Male
    Occupation:
    Senior Analyst
    Location:
    Brisbane
    Ratings:
    +3 / 0
    Home Country:
    Australia Australia
    Show System Specs
    I work as an Analyst and Developer for large ingres database systems, so the SQL part doesn't scare me. ^_^ What does scare me is the fact that I do not know the dbms that is being used, how to access it under windows and the table structures.

    Is there a cookbook which explains this?
     
  5. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
    Start Menu, go to All apps, and locate MediaPortal, inside there you'll find a "User Data" link

    Windows Explorer should open, and look for "database" folder, and within it TVSeriesDatabase4.db3

    Or paste the following in your SQLite editor: %ProgramData%\Team MediaPortal\MediaPortal\Database\TVSeriesDatabase4.db3

    My personal preference lies with (SQLite Expert Personal) @ SQLite administration | SQLite Expert

    That should do it :rolleyes:
     
  6. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
    If you want to take it one step further, source-code @ damienhaynes/mptvseries

    The wiki pages just never got imported into Github correctly when Google Code decided to throw in the towel. The web-archive has a decent copy though that partly works. I'm supposed to feel energized enough to assist in getting that to work again, but MP1+MP-TVSeries works fine for me, and I rather use it to watch a program that spend hours/days to get some documentation functional that almost nobody needs :D
     
    • Like Like x 1
  7. Neoculture

    Neoculture Portal Pro

    Joined:
    November 20, 2011
    Messages:
    62
    Likes Received:
    3
    Gender:
    Male
    Occupation:
    Senior Analyst
    Location:
    Brisbane
    Ratings:
    +3 / 0
    Home Country:
    Australia Australia
    Show System Specs
    Yup. And the dedicated forum pointed to by the plugin-entry on the MediaPortal website comes back as 404, so that knowledge is gone as well. <sigh> Anyhoo - not afraid to get my hands dirty, mostly afraid that I don't know what I am doing.
     
  8. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!