McBlunas-Home-Theater-DB-Tool

Command export excel

The purpose of command export excel is to export the Home Theater database to Excel -tableStyle is to change the Excel table style-workbookUri is the output location of the Excel file #1 auto mode -autoBackupUri has to point to the root of the user partition of your Zidoo Player where e.g. folder Download is located-zidooHostname … Read more

McBlunas-Home-Theater-DB-Tool

Command restore

The purpose of command restore is to restore a Home Theater backup archive (ztb) and optional restore the Home Theater poster directory C:\zidoo-hometheater-x.x.x\hometheater.cmd restore -h McBluna’s Home Theader DB ToolUsage: HomeTheater restore [-hV] [-clearImages] [-images] -backupName=String (-config | ([-imageUri=URI] -zidooHostname=String                           -autoBackupUri=URI))restore a Home Theater backup archive (ztb)  -h, –help   … Read more

McBlunas-Home-Theater-DB-Tool

Command nfo

The purpose of command nfo is to transfer data from nfo files into the Home Theater database -deviceId get the id of the device you want to update from tab DEVICE_INFO column _id -sourceId get the id of the source you want to update from tab SOURCE_INFO column _id -nasUri is the location for the … Read more

McBlunas-Home-Theater-DB-Tool

Memory usage

In case you experience an exception regarding memory usage you can decrease or increase the setting yourself by editing the command script. hometheater.cmd @ECHO OFF CHCP 65001> nul 2>&1 TITLE McBluna’s Home Theader DB Tool x.x.x SET jre=OpenJDKxxU-jre_x64_windows_hotspot_16.0.1_9.zip IF EXIST %jre% ( 7za.exe x -y %jre%> nul 2>&1 DEL %jre% 7za.exe> nul 2>&1 ) jdk-16.0.1+9-jre\bin\java.exe … Read more

McBlunas-Home-Theater-DB-Tool

Config file

Download empty config file: The tool checks this location for the Home Theater DB Tool config file This is an example of a config file For Windows file system you have to replace all single backslashes \ by a double backslash \\ in the config file. command export excel C:\zidoo-hometheater-x.x.x\hometheater.cmd export excel -playerId 2 -h McBluna’s Home … Read more

McBlunas-Home-Theater-DB-Tool

Enabling ANSI colors in Windows

By default McBluna’s Home Theater DB Tool uses ANSI colors* for output. To disable ANSI colors please edit the cmd or shell file and remove -Dpicocli.ansi=true. To use ANSI colors in the Windows cmd requires setting VirtualTerminalLevel via registry editor [HKEY_CURRENT_USER\Console]”VirtualTerminalLevel”=dword:00000001 Or you install Windows Terminal from Microsoft Store

McBlunas-Home-Theater-DB-Tool

How to start

Before you start you should have read my Guide How to backup your Home Theater data and the section Test Environment to get an idea what the tool is doing. For all database operations you need a backup file of your Home Theater library. Version 1.1.0 introduced an auto backup mode. Export to Excel Export … Read more

McBlunas-Home-Theater-DB-Tool

Test environment

I’ve setup an test environment with dummy files K:\Test K:\Test\Movies K:\Test\TV Shows K:\Test\Movies\Rogue One – A Star Wars Story dolby.5.1.iso K:\Test\Movies\Solo – A Star Wars Story dtshd.5.1.iso K:\Test\Movies\Star Wars Collection K:\Test\Movies\Star Wars Collection\Star Wars Episode I – The Phantom Menace.iso K:\Test\Movies\Star Wars Collection\Star Wars Episode II – Attack of the Clones.iso K:\Test\Movies\Star Wars Collection\Star Wars … Read more

McBlunas-Home-Theater-DB-Tool

URI File Naming

All filenames are treated as URIs. One of the consequences of this is you have to encode the ‘%‘ character using %25. All ‘\‘ will be automatically replaced by ‘/‘. Depending on the filesystem additional characters are encoded if needed. This is done automatically, but might be reflected in the filename. Supported File Systems Local … Read more

McBlunas-Home-Theater-DB-Tool

Command Line Interface (cli)

synopsis description command1command2 a single commandhometheater.cmd command1 … <parameter> a command parameterhometheater.cmd command1 <parameter> -option=value-option value a required optionhometheater.cmd command1 -option=value [-option=value][-option value] an optional option -flag a boolean optionhometheater.cmd command1 -flag ‘ ‘ blank between options / groups logical operator and between options or group of options ‘|’ pipe between options / groups logical … Read more