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
