Please do not use PM. There is nothing private in this conversation. If you go private, you prevent other people from following and learning.Can you send me a PN in german and give me some hints?
That was my idea. Unfortunately "load_file" seems to have a problem if "fileName" has special characters like german Umlauts.The leading thought to make this conversation private was that no one has interest to my speciale problem. I thought. But you are right. Maybe someone is out there
maybe you had the same idea as I have now. I have a batch file that can delete all XML files, jpg files, txt files and so on where no corresponding ts files exists.
So I will test this:
1. I delete all XML files where no corresponding ts file exists.
2. I open the recording table and use this command: select replace('filename','.ts','.xml');
3. Then I use this command: DELETE FROM Recording WHERE LOAD_FILE(fileName) IS NULL;
4. Then I use this command: select replace('filename','.xml','.ts');
I will tell you about the result.
Or did you had another idea, mm1352000?
Yes, I am interested in a batch script to do this. Like you, I run my own batch script to re-arrange recordings (move them to appropriate locations in the "Videos" section), but I have to remember to start MP and manually use the "Clean Up" function. A neater solution would be for my script to issue some command to perform the clean up.The leading thought to make this conversation private was that no one has interest to my speciale problem. I thought. But you are right. Maybe someone is out there
@echo off chcp 1252 set RECORDINGS=D:\Aufnahmen set MYSQL=C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe setlocal enabledelayedexpansion for /R %RECORDINGS% %%i in (*.xml) do ( if not exist "%%~dpi%%~ni.ts" ( set FILENAME=%%~dpi%%~ni.ts set FILENAME=!FILENAME:\=\\! echo SET CHARACTER SET 'latin1';> cleanup.sql echo DELETE FROM `mptvdb`.`recording` WHERE '!FILENAME!' = `fileName`>> Cleanup.sql timeout /t 5 /nobreak "%MYSQL%" --user=root --password=MediaPortal < Cleanup.sql del /f /q "%%~dpi%%~ni.xml" del /f /q "%%~dpi%%~ni.jpg" del /f /q Cleanup.sql ) ) exit
|G||Update von MediaPortal||Installationsprobleme?||0|
|[Evaluate] Update to VS 2019?||MediaPortal 2||4|
|Nach Windows-Updates läuft TV-Plugin nicht mehr||Allgemeines Support- und Diskussionsforum||0|
|B||MPEM update list never completes.||General Support||0|
|Updated DTT frequencies for Ireland...||Submit: EPG-Grabbers and tuningdetails||1|
|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|
|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|
|[solved] Kein direkter Wechsel von TV-Kanal zu TV-Kanal mehr nach Update?||Allgemeines Support- und Diskussionsforum||16|
|Mediaportal update to .Net 4.6.2+||MediaPortal 1||13|
|[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|
|LAVFilter Plugin cannot be updated (MP1.23)||MediaPortal 1 Plugins||10|
|Windows 10 1903 feature update||General Support||3|
|[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|
|1.22.0 BasicHome Editor settings for DefaultWide HD skin not kept when update||1.22||3|
|Bulk file name update||My TVSeries||6|
|[Evaluate] MP2-Updates do not remove the GUID of previous installs||MediaPortal 2||13|
|[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|