Tools and other software Batch to update (or clean) my TV recordings folder (1 Viewer)

pünktchen

Portal Pro
October 26, 2010
537
201
Germany Germany
Country flag
Have you changed "RECORDINGS" and "MYSQL" that it fits to your needs?
 

olli14

Portal Pro
December 17, 2008
738
35
Germany Germany
Country flag
Yes I changed recordings to e:\recorded tv. The mysql path should be alright. Mysql is in the path "...Programme\..." but in real it's "...program files\...". Isn't it?
 

pünktchen

Portal Pro
October 26, 2010
537
201
Germany Germany
Country flag
Yes I changed recordings to e:\recorded tv. The mysql path should be alright. Mysql is in the path "...Programme\..." but in real it's "...program files\...". Isn't it?
Yes, it would be "program files". Strange, that it doesn't work for you :unsure: For me it does.
But the xml's of your moved recordings did still exist before trying my batch?

I'm also still trying to get the load_file solution working...
 

pünktchen

Portal Pro
October 26, 2010
537
201
Germany Germany
Country flag
Got it now with the original approach "load_file" and special characters :)

Try the attachement. It should work after correcting the path to your recordings and to your mysql.exe in the CleanupRecordings.bat.

Summary:
First the batch deletes all *xml and jpg files in your recordings folder where no corresponding *.ts file exists.
After that the sql script is executed.
The script renames all "fileNames" from MySQL recording table to *.xml, tries to load the xml file and if it fails, deletes the row.
After that all "fileNames" are renamed back to *.ts.
 

Attachments

olli14

Portal Pro
December 17, 2008
738
35
Germany Germany
Country flag
Will try this evening. In your rar file there is a bat file and a SQL file. Where do I have to place the SQL file?
 

mm1352000

Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    Thanks guys. :)
     

    sbourdon

    Portal Member
    July 10, 2012
    22
    3
    Canada Canada
    I know this is an old thread but I would like to use this script with MediaPortal 1.20 but even after changing the "RECORDINGS" setting, nothing happens...
    Any idea as to what should be updated to make this script compatible with the latest release of MediaPortal?

    Thank you very much!
     

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

    OP Similar threads Forum Replies Date
    G Update von MediaPortal Installationsprobleme? 0
    morpheus_xx [Evaluate] Update to VS 2019? MediaPortal 2 4
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    B MPEM update list never completes. General Support 0
    JJDoherty Updated DTT frequencies for Ireland... Submit: EPG-Grabbers and tuningdetails 1
    Dark Eyes Updated to Windows 10, now TVServer won't work Installation, configuration support 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    M.Hulot Moving Pictures lässt sich nach Windows-Update nicht mehr öffnen Plugins & Erweiterungen 1
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    k12158 [solved] Kein direkter Wechsel von TV-Kanal zu TV-Kanal mehr nach Update? Allgemeines Support- und Diskussionsforum 16
    ajs Mediaportal update to .Net 4.6.2+ MediaPortal 1 13
    Mr6686 [solved] Titan skin broken since update to 1.23 Installation, configuration support 6
    B TV-Server Auto-Update mptvdb after x hours General Support 0
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10
    TLD Windows 10 1903 feature update General Support 3
    azzuro [Pending] Update MP1 to VisualStudio 2019 MediaPortal 1 36
    A Problem Windows 10 64 bit prof. Update auf Version 1903(gelöst) Installationsprobleme? 0
    T No TV after updating Windows 10 to latest Version 1903 / OS build 18362.175 (logs attached) General Support 2
    M [solved] Updated Swedish translation for MP 1.24 Submit: Localization of MediaPortal and DeployTool 0
    framug 1.22.0 BasicHome Editor settings for DefaultWide HD skin not kept when update 1.22 3
    Neoculture Bulk file name update My TVSeries 6
    HTPCSourcer [Evaluate] MP2-Updates do not remove the GUID of previous installs MediaPortal 2 13
    Rob Hexenmeister [solved] Latests Media Handler - Skinning an updating window or control Fanart Handler 26
    H [solved] Problem bei Update auf 1.21 Installationsprobleme? 4
    A VB-IP SPAIN Movistar plus tunning details (Update 26 dec 2018) Submit: EPG-Grabbers and tuningdetails 1
    Similar threads

























    Top Bottom