I'm looking for the best way to readjust the trim on 280,000 songs because an unnoticed auto trim level was too agressive for a portion of the music in my library.
To do this I have to know the absolute length of the song, and I'm curious if there's an easier way to do that other than to calculate it based on every one of those 280,000 WAV files. I'm getting worried that there is no magical shortcut here. WAV php libraries? On Friday, December 6, 2013, John Anderson wrote: > how about stop bitching, and if your music is that complicated, simply > edit the cuts as you need them... > > Honestly, there are a bunch of us, who use autotrim, and it works > perfectly.. > > I don't know your format, but i've personally used it with talk, Gospel, > funk to 40, and several other formats, without a problem... > > what is your format...and why are you having such a problem? > > > On Friday, December 6, 2013 6:03 PM, WMFO Assistant General Manager < > a...@wmfo.org> wrote: > 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 < > o...@wmfo.org> 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 <super...@uwave.fm> 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 < > o...@wmfo.org> 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 operati > > -- Nicholas Andre n...@wmfo.org Willy Kite wi...@wmfo.org Assistant General Managers WMFO 91.5 Medford www.wmfo.org
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
