FYI for those following this: The above query does not work as intended. The schema here appears to be LENGTH = END_POINT - START_POINT but more importantly that LEGNTH != the actual length of the file. You can verify this by running:
SELECT START_POINT, END_POINT, LENGTH FROM CUTS WHERE CART_NUMBER = 045757; Or similar. Then open RDLibrary and EDIT->Edit Markers and change the "Cut End" setting. Running the query above for a second time will show you that the LENGTH field in the database has been altered. So where is the true LENGTH stored? 1. In the WAV file only (as RDLibrary "Edit Markers" does open the actual WAV file, so it could feasibly retrieve the information there) 2. Somewhere else in the database I haven't found If 1 is the case, this may be a "painful and slow PHP script fix" fix. Can anyone offer wisdom here? On Mon, Dec 2, 2013 at 10:48 PM, Max Goldstein, Operations Director < [email protected]> wrote: > I've modified the SQL directly before. It hadn't quite clicked that you > can use LENGTH on the right side of an equals sign. Thanks for the query. > > Thanks, > > Max Goldstein > Operations Director > WMFO Medford > > > On Mon, Dec 2, 2013 at 10:13 PM, Karl Koscher <[email protected]> wrote: > >> Probably the easiest (but somewhat hackish) way to do it is directly from >> the mysql CLI. Grab the password from /etc/rd.conf, and do the following: >> >> $ mysql -u rduser -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 17818 >> Server version: 5.5.34-0ubuntu0.12.04.1-log (Ubuntu) >> >> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input >> statement. >> >> mysql> use Rivendell; >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Database changed >> mysql> update CUTS set START_POINT = 0, END_POINT = LENGTH where >> CART_NUMBER >= 10010 and CART_NUMBER <= 10178; >> Query OK, 168 rows affected (0.09 sec) >> Rows matched: 168 Changed: 168 Warnings: 0 >> >> mysql> quit >> Bye >> >> >> Of course, you'll probably want to change the start and end cart numbers. >> >> >> >> >> On Mon, Dec 2, 2013 at 6:38 PM, Max Goldstein, Operations Director < >> [email protected]> wrote: >> >>> Good to hear nothing was permanently lost. If we wanted to push the >>> Start and Stop markers to the ends of every cut/cart in a particular group >>> as a batch operation, what do you suggest? >>> >>> Thanks, >>> >>> Max Goldstein >>> Operations Director >>> WMFO Medford >>> >>> >>> On Mon, Dec 2, 2013 at 11:44 AM, Andy Sayler <[email protected]> wrote: >>> >>>> Thanks, Fred! >>>> >>>> >>>> On Mon, Dec 2, 2013 at 9:42 AM, Fred Gleason >>>> <[email protected]>wrote: >>>> >>>>> On Dec 2, 2013, at 10:49 08, Andy Sayler <[email protected]> wrote: >>>>> >>>>> > I think the issue for us is that it seems to be set to -30 dBFS by >>>>> default (i.e. if you don't use the auto trim flag at all). Can anyone >>>>> confirm that? >>>>> >>>>> Yes, that is correct for versions through v2.5.5. >>>>> >>>>> >>>>> > Also, does the auto trim setting actually affect the output wav >>>>> file, or just it just affect metadata (e.g. by setting a cutoff in the >>>>> database, etc). Asked another way, is there a way to adjust/undo the >>>>> auto-trim setting for tracks that have already been imported? >>>>> >>>>> It affects only the positioning of the Start and Stop markers. The >>>>> underlying audio for the entire track as input is intact in the audio >>>>> store. >>>>> >>>>> So yes, this can be changed in RDLibrary to ‘get back’ the missing >>>>> fades. >>>>> >>>>> Cheers! >>>>> >>>>> >>>>> >>>>> |-------------------------------------------------------------------------| >>>>> | Frederick F. Gleason, Jr. | Chief Developer >>>>> | >>>>> | | Paravel Systems >>>>> | >>>>> >>>>> |-------------------------------------------------------------------------| >>>>> | Call on God, but row away from the rocks. >>>>> | >>>>> | -- Indian proverb >>>>> | >>>>> >>>>> |-------------------------------------------------------------------------| >>>>> >>>>> _______________________________________________ >>>>> Rivendell-dev mailing list >>>>> [email protected] >>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Rivendell-dev mailing list >>>> [email protected] >>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>> >>>> >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> [email protected] >>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>> >>> >> > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > -- Nicholas Andre [email protected] Willy Kite [email protected] Assistant General Managers WMFO 91.5 Medford www.wmfo.org
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
