Local scrapping with TMM's nfo

I did the same as you: unzip, modify the database, rezip and restore, except that the restoration gives me an error... really weird...

 

What did you modify?

 

film genres (action, animation, fantasy, etc.) . I updated all movie genres in tinymanager

 

You'll have to bear with me - I don't use TMM - so do you edit the database itself in TMM?

There's a table "Genres" which defines the genres available and then these are applied in other tables as references - my guess is that a relational link is broken somewhere...

 

Hello. Is the "McBluna's Home Theater 3.8.0" application compatible with the HT5 and the UHD 3000 Pro? I'm getting quite a few errors when opening and connecting...

File attached

 

With my non Pro UHD3000 and HT5 it is working. But in your logs are some samba authentification errors. Can you access the shares on the Zidoo from your pc?
In my case i had to set a password on the zidoo samba server.
And i do not use the gui, because it most times did not find my zidoo. I use a commandline like this:

Code:

@echo off
cd /d d:\programme\zidoo-hometheater
set z=\\zidoouhd3000\Share
set s=Filme_1-4
set n=\\192.168.178.37\share\Video_1-4
set i=2

echo Update Filme_1-4
call hometheater nfo -nasUri %n%\%s% -sourceId %i% -zidooHostname zidoouhd3000 -autoBackupUri %z%\Storage -imageUri %z%\Storage\.HomeTheater -mediainfo nfo -tmdbApiKey xxx -tmdbLanguage de-DE -msifUri \\server\share\$Filmreihen

 

Hello. The code works without errors, but nothing changes in the end (the genres of the films remain identical to the original scrap and do not change to those in the NFO from TMM)

 

The safest way is to male a reset of HT, set poster directory to user defined storage://, i also delete every images in Backdrops/Logos/Posters in .Hometheater, and see the examples of my settings. Then define the sources but do not scrap. Now i make a Backup with McBluna to get the source ID for the sources from the excel sheet. In my script this is the variable i.
I do not recommend mixing Mc Bluna scan with Zidoo scans.

 

I have this error after launching the script (linked):

 

Never saw such an error. Can you show your script?

 

yes, sure

Code:

@echo off
title HomeTheater - NFO vers Zidoo

:: Variables
set z=file:///L:/
set s=FILMS_00
set n=file:///N:/
set i=1
set key=2a9495937db91292d56d08bdxxxx

echo.
echo Vérification de l'accès à L:\Storage...
dir L:\

echo.
echo ===== Lancement de HomeTheater =====
call "%~dp0hometheater.cmd" nfo ^
  -nasUri %n%/%s% ^
  -sourceId %i% ^
  -zidooHostname 192.168.1.23 ^
  -autoBackupUri %z% ^
  -imageUri %z%\.HomeTheater ^
  -tmdbApiKey %key% ^
  -tmdbLanguage fr-FR

echo.
echo ===== Terminé =====
pause

 

To what have you mapped L and N?
In my example script is n pointing to the share on my NAS with the movies and z is pointing to the internal Zidoo storage where the database and the images in .Hometheater are found.
msifUri is the share with TMM informations for moviesets and it is only necessary if you have set it also in TMM, but i think it should also work without this parameter.
Even i you have mapped L and N, you can try the URI form.

 

T and N are well mapped. What do you mean by "msifUri is the share with TMM informations for moviesets and it is only necessary if you have set it also in TMM"

 

With this in TMM

i get in TMM one folder for every movie set, with an image for the poster and fanart and a NFO file. With the msifUri parameter you get them also in HT. Without it, HT is downloading the images it likes.

Have you tried "set z=L:\" and "set n=N:\" or the form "\\...\..."?

 

Have you included the folder storage in your mapping for z?
I used -autoBackupUri %z%\Storage -imageUri %z%\Storage\.HomeTheater and z=\\zidoouhd3000\Share.

 

I just changed my code, but I still have the same error : "org.hibernate.exception.GenericJDBCException: could not execute statement [[SQLITE_CONSTRAINT_NOTNULL] A NOT NULL constraint failed (NOT NULL constraint failed: VIDEO_INFO.AUDIO_INDEX)] [insert into "VIDEO_INFO" ("ADDED_TIME","AGGREGATION_ID","DEVICE_ID","DURATION","LAST_WATCH_TIME","MEDIA_INFOS","MEDIA_JSON","MEDIA_JSON_TAG","MODIFIED_TIME","PLAY_POINT","SOURCES","STATE","TYPES","URI") values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]".

Here is the code:

Code:

@echo off
title HomeTheater - NFO vers Zidoo

:: Variables
set z=\\SHARE_SAMBA\Share
set s=FILMS_00
set n=file:///N:/
set i=1
set key=2a9495937db91292d56d08bdc77e0db0

echo.
echo ===== Lancement de HomeTheater =====
call "%~dp0hometheater.cmd" nfo ^
  -nasUri %n%/%s% ^
  -sourceId %i% ^
  -zidooHostname SHARE_SAMBA ^
  -autoBackupUri %z%\Storage ^
  -imageUri %z%\Storage\.HomeTheater ^
  -tmdbApiKey %key% ^
  -tmdbLanguage fr-FR ^
  -msifUri G:\Collections

echo.
echo ===== Terminé =====
pause

at the zidoo, I just added the source without scrapping it

 

You can try adding this to the first call of the script " -clearFullDatabase -clearImages" after the msifUri line. I am not sure if n with file://.. is correct, i would try N:\ (or \\server\share) and -nasUri %n%\%s%.
I always try to set paths that are valid and identical on any system.

 

I just redid the code but still the same

 

last idea: export the Zidoo database and check in table SOURCE_INFO if the _id for the movie source is really 1. If you want to send the excel sheet: in the sheet SOURCE_INFO are the userid and maybe password for your NAS be visible, so edit this.

Code:

set z=\\SHARE_SAMBA\Share
set backupdir=c:\temp
call hometheater backup -zidooHostname SHARE_SAMBA -autoBackupUri %z%\Storage -backupOutputUri %backupdir%

rem read the name of the last backup file
set backupFile=
for /F "eol=| delims=" %%i in ('dir "%backupdir%\*.ztb" /A-D /B /O-D /TW 2^>nul') do set "backupFile=%%i" & GOTO FoundFile
:FoundFile

echo Excel Export
call hometheater export excel -backupUri %backupdir%\%backupFile% -workbookUri %backupdir% -tableStyle TableStyleMcBluna

 

Here is the PDF file from the created Excel file (source_info)