Bulk file name update (1 Viewer)

Neoculture

Portal Pro
November 20, 2011
62
3
Brisbane
Australia Australia
Country flag
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?
 

RoChess

Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,345
    1,824
    Country flag
    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.
     

    Neoculture

    Portal Pro
    November 20, 2011
    62
    3
    Brisbane
    Australia Australia
    Country flag
    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?
     

    RoChess

    Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,345
    1,824
    Country flag
    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:
     

    RoChess

    Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,345
    1,824
    Country flag
    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
     

    Neoculture

    Portal Pro
    November 20, 2011
    62
    3
    Brisbane
    Australia Australia
    Country flag
    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.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    D Downloading EPG XML file: Installation, configuration support 0
    M [solved] WTV Files does not play on client, MPEG files works well General 1
    bigboss97 Does anyone has a SoundGraph imon remote file for MP2 to share? General 0
    J Help with new grabber file. WebEPG 1
    S [solved] No sound - MKV file MediaPortal 1 Talk 2
    G WTV files General 11
    Golf4 TV-Records werden als Audio-Files importiert ? Allgemeines Support- und Diskussionsforum 0
    azzuro [fixed] [WIP MP2.3] - Audio files not imported to MP MediaPortal 2 18
    HTPCSourcer Media Accessor is flooding logs with files from attached monitor MediaPortal 2 9
    R [will not fix] [MP2-832] MP2.2.2 subtitles not shown for WTV files Submit: Bug Reports 7
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    thepahakurki Trakt error: Invalid or missing file Trakt 8
    M Keymapping Which File To Edit General Support 4
    F No data in "File Details" Moving Pictures 2
    R [solved] Moving pictures importer wont add files from a removable drive. Is there a work around ? Moving Pictures 8
    R Directx 9.0 June 2010 does not install on Windows 10 x64, ends up with weird failure / no debug file Installation, configuration support 0
    B xml file for perfect player Newcomers Forum 1
    K How to enable autoplaying of the next video files in the folder MediaPortal 1 Talk 2
    B Text files attached to videos Watch / Listen Media 10
    ge2301 [fixed] [MP2-807] Problem when switching player in PiP mode with audio files MediaPortal 2 32
    C How do I get MediaPortal to separate recording files by channel and month? General 2
    CyberSimian [Bug] Signed/unsigned error in calculation of file timestamps MediaPortal 1 11
    HTPCSourcer [solved] Sometimes persistent issues when playing specific h264 mkv files MediaPortal 2 18
    J Trying out MP 1 again, have some questions and a few log files Newcomers Forum 5
    Similar threads

























    Top Bottom