Reply to thread

Message

<blockquote data-quote="Lehmden" data-source="post: 1253744" data-attributes="member: 109222">Hi.As I'm very familiar with Autoit I would use it of course. AutoIt has in-build SQLite support so I directly can read the TVSeries Database and then generate an XML file from the data in the DB. The path to the database can be given as an argument or a setting option. No need to run it from inside a specific folder then...If you don't know AutoIt, it's a basic alike scripting and&nbsp; programming language, very easy to learn and very powerful if you know what you're doing. Originally AutoIt was designed to remote control other Windows applications (Word, Photoshop,...)&nbsp; so it can simulate even mouse clicks in other windows. But as time goes by it has grown to a full blown procedural (opposite to object oriented) programming language incl usage of most Windows API and DLL.&nbsp; You even can compile the script/program to an 32 or 64 bit executable, if you like. The language and it's IDE is completely free. If you may have a look at Media-Buddy, it is written in Autoit and the source code is included in the installer package...An example how easy AutoIt is... I need a helper tool to restart the main program after settings change. It just waits for one second, runs the main program that was given as a command line option and then exit. I first wrote this tool in AutoIt and it needs only 3 lines of code. [code]Sleep(1000)Run($CmdLine[1])Exit[/code]The first line waits for 1000 mSec The second line runs the program given as CL Option No. 1The third line cleanly exits the Tool.Aside this it don't need any extra runtimes or other installation.But this little helper tool very often was wrongly detected as a virus. so I decided to rewrote it in .NET (c#). Here exactly the same functionality (wait 1 second, run the main program and exit) needed 20 (to be exact 19 + 1 empty) lines of code. [code=csharp]using System.Linq;using System.Diagnostics;namespace Restart{&nbsp; &nbsp; class Program&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; static void Main(string[] args)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; System.Threading.Thread.Sleep(1000);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; var exists = args.ElementAtOrDefault(0) != null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (exists)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Process P = new Process();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P.StartInfo.FileName = args[0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P.Start();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/code]Additionally this tool needs a .NET runtime to be installed on the system...But this tool throws not that often a &quot;false positive&quot; so I keep using it..You can use the &quot;official&quot; SQLite Tools:<a href="https://sqlite.org/download.html" target="_blank">SQLite Download Page</a>Here you best refer to the wiki and/or generate some .nfo with Media-Buddy so you can compare what's needed and how it should be named...You also can see how the artwork is named, if you prepare some test episodes in Media-Buddy. Or as above, read the Wiki...I don't remember exactly how the TVSeries DB is structured, so I can't give you much more hints. Simply too long ago.The artwork preparation is simple filecopy and rename... Should be straightforward as soon as you read the internal path and filename from TVSeries db.</blockquote>

[QUOTE="Lehmden, post: 1253744, member: 109222"] Hi. As I'm very familiar with Autoit I would use it of course. AutoIt has in-build SQLite support so I directly can read the TVSeries Database and then generate an XML file from the data in the DB. The path to the database can be given as an argument or a setting option. No need to run it from inside a specific folder then... If you don't know AutoIt, it's a basic alike scripting and programming language, very easy to learn and very powerful if you know what you're doing. Originally AutoIt was designed to remote control other Windows applications (Word, Photoshop,...) so it can simulate even mouse clicks in other windows. But as time goes by it has grown to a full blown procedural (opposite to object oriented) programming language incl usage of most Windows API and DLL. You even can compile the script/program to an 32 or 64 bit executable, if you like. The language and it's IDE is completely free. If you may have a look at Media-Buddy, it is written in Autoit and the source code is included in the installer package... An example how easy AutoIt is... I need a helper tool to restart the main program after settings change. It just waits for one second, runs the main program that was given as a command line option and then exit. I first wrote this tool in AutoIt and it needs only 3 lines of code. [code]Sleep(1000) Run($CmdLine[1]) Exit[/code] The first line waits for 1000 mSec The second line runs the program given as CL Option No. 1 The third line cleanly exits the Tool. Aside this it don't need any extra runtimes or other installation. But this little helper tool very often was wrongly detected as a virus. so I decided to rewrote it in .NET (c#). Here exactly the same functionality (wait 1 second, run the main program and exit) needed 20 (to be exact 19 + 1 empty) lines of code. [code=csharp]using System.Linq; using System.Diagnostics; namespace Restart { class Program { static void Main(string[] args) { System.Threading.Thread.Sleep(1000); var exists = args.ElementAtOrDefault(0) != null; if (exists) { Process P = new Process(); P.StartInfo.FileName = args[0]; P.Start(); } } } } [/code] Additionally this tool needs a .NET runtime to be installed on the system... But this tool throws not that often a "false positive" so I keep using it.. You can use the "official" SQLite Tools: [URL="https://sqlite.org/download.html"]SQLite Download Page[/URL] Here you best refer to the wiki and/or generate some .nfo with Media-Buddy so you can compare what's needed and how it should be named... You also can see how the artwork is named, if you prepare some test episodes in Media-Buddy. Or as above, read the Wiki... I don't remember exactly how the TVSeries DB is structured, so I can't give you much more hints. Simply too long ago. The artwork preparation is simple filecopy and rename... Should be straightforward as soon as you read the internal path and filename from TVSeries db. [/QUOTE]

Verification