Hi Wayne I tried out your Rivendell Hotkeys Java Panel changer applet... it works real well... and it's so easy to use. What part of the world are you in? So I can let the Boss know that Wayne from country name helped me fix it and made the application.
Swapping the 50 banks around only took me about 5 mins... and it was all fixed :) Many thanks Geoff Barkman Dunedin New Zealand On Fri, Aug 31, 2012 at 3:37 PM, Geoff Barkman <[email protected]> wrote: > Hi Wayne > Its incredibly easy. > I made a second Rivendell user with similar privileges to the default > user and a 2 line macro that I have on a handful of my hotkeys banks. > It uses the LO Login macro > Line 1 LO user2 password! > Line 2 LO user password! > > And just replace the word password with your actual password. It takes > about 1 - 2 seconds to refresh your buttons. I have trained all my > operators to never click the button at the point where rdairplay is > transitioning from one song/event to another. The only time it doesn't > work is if you add more hotkey/soundpanels to your rdairplay. > Cheers > Geoff > > On Fri, Aug 31, 2012 at 2:37 PM, Wayne Merricks > <[email protected]> wrote: >> If you don't mind me asking, how did you get the buttons to refresh? Is it a >> MySQL lookup and a whole bunch of Load Panel (PE) macros? >> >> I've been trying to figure that out without having to close and reopen >> airplay for a while. >> >> Cheers, >> >> Wayne >> >> >> -----Original Message----- >> From: [email protected] on behalf of Geoff >> Barkman >> Sent: Fri 31/08/2012 03:16 >> To: User discussion about the Rivendell Radio Automation System >> Subject: Re: [RDD] sound panel / hotkeys swapping >> >> Thats really cool Wayne.... nice job. I'll start with my test db later on >> today. >> >> On Fri, Aug 31, 2012 at 2:07 PM, Wayne Merricks >> <[email protected]> wrote: >>> Hi, >>> >>> The more I thought about this kind of thing, the more I realised I'd need to >>> be able to do what you're attempting so I wrote a little tool in Java >>> (judging by the OSX discussions over here at the moment that will make me >>> unpopular but hey). >>> >>> Heres what you need to do: >>> >>> Fill out the following: >>> >>> 1. The MySQL User name & Password >>> 2. The host name or IP of the MySQL database >>> 3. The name of the Rivendell database >>> 4. The rivendell user name for the panels you want to change (or a host >>> name if you do things that way) >>> >>> I've coded in the usual Rivendell defaults as I got bored of typing them in >>> each time but obviously change these to however your setup is at the moment. >>> >>> 5. Then click on Read Database. >>> >>> All settings accounted for you'll have a list of Panels as seen in the >>> screen shot (http://www.thevoiceasia.com/rivendell/rivpanelmover.jpg). >>> >>> 6. Click the up and down buttons denoted by ^^ and vv because I'm too lazy >>> to make icons to move your selected panel up or down the list. >>> >>> 7. When you're happy hit save. >>> >>> At this point the program simply does the following: >>> >>> 1. Loops through the list and writes them in the proper order with an >>> offset of 10000 (so I don't have to program in lots of swapping and checking >>> for existing records) >>> >>> E.g if you have a modified list of 1, 3, 2; 1 becomes 10000, 3: 10001, 2: >>> 10002. >>> >>> This is two queries that go a bit like this: >>> >>> update PANEL_NAMES set PANEL_NO=10000 where PANEL_NO=1 and >>> OWNER='user';//This avoids overwriting panels for other users or host >>> specific ones >>> update PANELS set PANEL_NO=10000 where PANEL_NO=1 and OWNER='user'; >>> >>> 2. Amends both tables now in the correct order to remove the offset with a >>> simple: >>> >>> update PANEL_NAMES set PANEL_NO=PANEL_NO-10000 where OWNER='user' and >>> PANEL_NO>9999; >>> update PANELS set PANEL_NO=PANEL_NO-10000 where OWNER='user' and >>> PANEL_NO>9999; >>> >>> Thats literally all the thing does. I've uploaded the complete Eclipse >>> project which has all the source code and a version of the standard >>> mysql-connector library bundled with it so it should pretty much run out of >>> the box (you'll have to amend the project Java runtime in the project >>> properties): >>> >>> http://www.thevoiceasia.com/rivendell/rivpanelmover.tar.gz (669KB 99% of >>> which is the mysql lib) >>> >>> Failing that just rip out the src directory and you have your 3 small java >>> source files, libs contains the mysql lib you need to connect or you can >>> download it from here: >>> >>> http://dev.mysql.com/downloads/connector/j/ >>> >>> For the extra lazy I've got a self contained executable jar file: >>> >>> http://www.thevoiceasia.com/rivendell/rivPanelMover.jar (674KB 99% of which >>> is the mysql lib) >>> >>> Please note the code is a bit meh as I originally started the more >>> complicated nested looping of swapping records around until I got bored and >>> did it the easier way it is now so there is some functionality in the helper >>> class that isn't really needed anymore. >>> >>> The jar will run on Windows or variations of nix (should even work on a mac >>> but I haven't got one to test). >>> >>> Any questions let me know, check the source code first and run it on some >>> test db rather than your live machines don't take my word for the fact that >>> it "works". >>> >>> Regards, >>> >>> Wayne >>> >>> >>> >>> -----Original Message----- >>> From: [email protected] on behalf of Geoff >>> Barkman >>> Sent: Thu 30/08/2012 21:41 >>> To: User discussion about the Rivendell Radio Automation System >>> Subject: Re: [RDD] sound panel / hotkeys swapping >>> >>> Hi Wayne >>> Thats the kind of thing I was expecting to do. >>> My wife is an expert on mysql... so I'll get her assistance me thinks. >>> I figured there would be a bit of a shuffle to do. All my panels are >>> user panels ....because that the best way, that I've discovered to >>> have the same panels across my network of 4 rivendell computers. >>> I even made a refresh buttons macro to show any changed buttons across >>> my network on all the machines. >>> Cheers >>> Geoff >>> >>> >>> >>> ________________________________ >>> Scanned by MailMarshal >>> ________________________________ >>> >>> ________________________________ >>> Attention: >>> >>> The information contained in this message is confidential and intended for >>> the addressee(s) only. If you have received this message in error or there >>> are any problems, please notify the originator immediately. The >>> >>> unauthorised use, disclosure, copying or alteration of this message is >>> strictly forbidden. Christian Vision or any of its subsidiaries will not be >>> liable for direct, special, indirect or consequential damages arising from >>> alteration of the contents of this message by a third party or as a result >>> of any virus being passed on. Please note that we reserve the right to >>> monitor and read any e-mails sent or received by the company under the >>> Telecommunications (Lawful Business Practice) (Interception of >>> Communications) Regulation 2000. Christian Vision is registered in England >>> as a limited company 2842414 and >>> >>> as a charity 1031031 >>> >>> ________________________________ >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> [email protected] >>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >>> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> >> >> ####################### >> Scanned by MailMarshal >> ####################### >> >> ############ >> >> Attention: >> >> The information contained in this message is confidential and intended >> for the addressee(s) only. If you have received this message in error >> or there are any problems, please notify the originator immediately. >> The unauthorised use, disclosure, copying or alteration of this message >> is strictly forbidden. Christian Vision or any of its subsidiaries will >> not be liable for direct, special, indirect or consequential damages >> arising from alteration of the contents of this message by a third party >> or as a result of any virus being passed on. Please note that we reserve >> the right to monitor and read any e-mails sent or received by the >> company under the Telecommunications (Lawful Business Practice) >> (Interception of Communications) Regulation 2000. Christian Vision is >> registered in England as a limited company 2842414 and as a charity >> 1031031 >> >> ############ >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
