Thanks for your hard work cjcox. It is appreciated..
+1 (or 7 if my wife and 5 cats can vote)
I understand expensive, but on a computer screen 640 x 480 is so, well, CGA ;-)
I run that when in Windows “safe mode” (honestly, though, no mode is SAFE but that’s what they call it)
I have a pretty potent notebook (i7 quad, 6 gig RAM but I am looking at bumping that up if possible) and my desktop is a 6 core AMD processor, 10 Gig Ram machine that screams along (screaming for Windows) and has no issues with intense processing. It handles SQL just fine as well as graphics work for web sites I deal with. At least with an option if I kill the computer I can always bump it down next pass.
Back slashes are the most evil thing in the universe. Windows folks, even Windows knows they are evil which is why they accept forward slashes. Please don’t make me rewrite all of Python just because you must have evil backslashes. I hope I don’t have to go into painful detail… for now, please trust me, backslashes… just SAY NO! or things are going to break…
Oh… and did I mention just how evil back slashes are? They are evil. There is no debate, feel free to post and whine, but they are evil. If you use them in your paths, you are intentionally breaking things. So let’s do the right thing ok? Let’s not use something that is inherently evil.
The database json file sure lends itself to Excel format or even being displayed in HTML/web format where a person could have a fresh “friendly view” of what is on Tablo according to your script (assuming one refreshes the info locally) and they could simply go down either the Excel file or HTML page, click a show and have it convert just like that. Pretty simple - well, with a few hours time!
I used to have a script that downloaded the antivirus defs for multiple apps, display them in a web page and the corporate employees could click on a link and it would update their A-V app from that web page. The page simply read a text file, a CSV, that another script updated after downloading and extracting the current definitions files. Any time they hit that company’s intranet page it displayed what was currently available for their app and would update for them. Slick - now, how the #$%^ did I ever do that? Don’t ask me to duplicate that! I was another person back then.
But my point is, you’ve got the info local, cached, and in pretty much CSV format, from there you can do almost anything, including display in a web page with links - choose what you want to do, which program to do it to, the options you want, click convert. This could be really “pretty” and usable by even those afraid of things like command lines, scripts and manual queries. Look and choose.
Evil? LOL- there’s a whole lot of Python stuff running in Windows. Other cross-platform languages use them - JAVA for example.
It’s not simple in VBS either but there’s ways around it. And have fun with SPACES in VBS Like using triple double-quotes to CYA.
Frankly so far any python script I’ve tried - yours and the other one here, has worked fine with my paths. But then I often use batch files to launch them and will eventually use VBScript to launch this script and have it prompt me for the arguments to make it really simple. The VBScript will handle the path to Python, your script and pass arguments to the script as needed based on what I want to do.
I prefer it that way because I can pre-define a path ONE TIME and pass it as a variable as many times as i wish in the script. To ensure there’s no typos, I can use option exclusive and DIM them so it will check my use of variables.
There’s always something.
This is why I never finished learning C++ - programming requires a ton of patience, testing, trying again, testing again, and patience is something I was born without and am not capable of. I tried and quit. I also tried to learn Russian - classes given free by my employer, but was never able to get past the first couple of months. No patience to sit still for an hour in class and never did do any homework.
hmmm…wonder why it borked on the run. The error above was when I tried using a manual command put together from the -d output and by removing all the ', and the metadata tags.
I’ll try it again some time as I’d rather run it locally on the NAS.
What is the query to download/convert all recorded files off the tablo?
I am using -q " " and that seems to work for multiple word titles but was wondering if there is a wildcard option. The * character did not seem to work. I want to run the script on a schedule with no clobber.
