Re: [RDD] RdLibrary - find songs from year

[Morten Krarup Nielsen]

Thanks, I will give it a try today!

2016-08-15 16:08 GMT+02:00 David Klann :
> As of Rivendell 2.10.3, a valid SQL statement to search the CART table
> by year would look something like:
>
> select NUMBER,GROUP_NAME,TITLE,ARTIST,ALBUM,YEAR from CART where YEAR
> like '1990%';
>
> Note the year format "-MM-DD". This is because YEAR uses the MySQL
> "date" data type which includes the month and day. MM and DD default to
> 01 when not specified, but using the "LIKE" comparison operator gets you
> all rows that match the year 1990.
>
> Hope this helps!
>
>   ~David Klann
>
>
> On 08/15/2016 08:12 AM, Morten Krarup Nielsen wrote:
>> Hi.
>>
>> We need to find songs from 1991, 1992 and so on. We have entered the
>> data in RdLibrary, but you can't search for it :-(
>>
>> Is there anyone that now the SQL command to find songs from a specific year?
>>
>> Thank you!
>>
>> Kind regards,
>>
>> Morten
>> ___
>> Rivendell-dev mailing list
>> Rivendell-dev@lists.rivendellaudio.org
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Automation Mode

[John Boles]

Correct, I do want to READ the value of PM
under the ripc commands you use TA! to get the value of it.
John

On Mon, Aug 15, 2016 at 9:52 AM, Fred Gleason 
wrote:

> On Aug 15, 2016, at 09:33, John Boles  wrote:
>
> Then I would propose that it be like TA!
>
> Except of course using PM!
>
> Not following your point here.  It is “like TA” already —i.e. the command
> causes the requested action to happen.
>
> My understanding was that you wanted to *read* the current mode.
>
> Cheers!
>
>
> |--|
> | Frederick F. Gleason, Jr. |  Chief Developer |
> |   |  Paravel Systems |
> |--|
> |  A room without books is like a body without a soul. |
> | -- Cicero|
> |--|
>
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>
>
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Automation Mode

[Fred Gleason]

On Aug 15, 2016, at 09:33, John Boles  wrote:
> Then I would propose that it be like TA!
> 
> Except of course using PM!
> 
Not following your point here.  It is “like TA” already —i.e. the command 
causes the requested action to happen.

My understanding was that you wanted to *read* the current mode.

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  A room without books is like a body without a soul. |
| -- Cicero|
|--|___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

[RDD] Log played two cuts of same cart at the same time!

[Tom Van Gorkom]

On Riv 2.14.1 Has anyone else ever had this condition?  We had various
episodes of a particular short program as multiple cuts in one cart. Some
had the air date set (past, present, and future) and a few new ones did not
yet have an air date set (the student forgot). Somehow AIrplay started
"today's" date cut along with an undated cut at the same time and played
them both over the air until I got connected to fix it.

We wouldn't normally have this condition but just wondering if it was a
rare bug or random glitch.

Tom Van Gorkom
Radio Esperanza Engineering, KRIO AM/FM, KOIR FM
Office: 956-380-8150
Cell: 865-803-7427

Rio Grande Bible Institute
4300 S US Hwy 281
Edinburg, TX 78539
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] RdLibrary - find songs from year

[David Klann]

As of Rivendell 2.10.3, a valid SQL statement to search the CART table
by year would look something like:

select NUMBER,GROUP_NAME,TITLE,ARTIST,ALBUM,YEAR from CART where YEAR
like '1990%';

Note the year format "-MM-DD". This is because YEAR uses the MySQL
"date" data type which includes the month and day. MM and DD default to
01 when not specified, but using the "LIKE" comparison operator gets you
all rows that match the year 1990.

Hope this helps!

  ~David Klann


On 08/15/2016 08:12 AM, Morten Krarup Nielsen wrote:
> Hi.
> 
> We need to find songs from 1991, 1992 and so on. We have entered the
> data in RdLibrary, but you can't search for it :-(
> 
> Is there anyone that now the SQL command to find songs from a specific year?
> 
> Thank you!
> 
> Kind regards,
> 
> Morten
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
> 



signature.asc
Description: OpenPGP digital signature
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] RdLibrary - find songs from year

[Wayne Merricks]

select * from CART where YEAR = 1991;

You'll probably want to do a join on the CUTS table to get the other 
information.


On 15/08/16 14:38, John Boles wrote:

You could of course use the scheduler code if they are defined.

Other than that I don't know how to make RDLibrary search for year but
it made me think of a feature request.

Have the ability to limit searches by field by prefixing some text.

For example:

Artist search:

A: Puddle

Year:

Y: 1992

cart length

L: 3:45


And so on 

John

On 15/08/16 07:12 AM, Morten Krarup Nielsen wrote:

Hi.

We need to find songs from 1991, 1992 and so on. We have entered the
data in RdLibrary, but you can't search for it :-(

Is there anyone that now the SQL command to find songs from a specific year?

Thank you!

Kind regards,

Morten
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev


___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] RdLibrary - find songs from year

[John Boles]

You could of course use the scheduler code if they are defined.

Other than that I don't know how to make RDLibrary search for year but
it made me think of a feature request.

Have the ability to limit searches by field by prefixing some text.

For example:

Artist search:

A: Puddle

Year:

Y: 1992

cart length

L: 3:45


And so on 

John

On 15/08/16 07:12 AM, Morten Krarup Nielsen wrote:
> Hi.
>
> We need to find songs from 1991, 1992 and so on. We have entered the
> data in RdLibrary, but you can't search for it :-(
>
> Is there anyone that now the SQL command to find songs from a specific year?
>
> Thank you!
>
> Kind regards,
>
> Morten
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Automation Mode

[John Boles]

Then I would propose that it be like TA!

Except of course using PM!


Well I am on the topic of feature enhancements:

Would like to see a timing marker.  Where all it does is hold the next
timed event but doesn't do anything but give you a time till.

John

On 15/08/16 07:23 AM, Fred Gleason wrote:
> On Aug 14, 2016, at 10:25, John Boles  > wrote:
>
>> I can track it through the logs but was hoping there is an easier way,
>
> No good way at present.
>
> Cheers!
>
>
> |--|
> | Frederick F. Gleason, Jr. |  Chief Developer |
> |   |  Paravel Systems |
> |--|
> |  A room without books is like a body without a soul. |
> | -- Cicero|
> |--|
>
>
>
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Automation Mode

[Fred Gleason]

On Aug 14, 2016, at 10:25, John Boles  wrote:

> I can track it through the logs but was hoping there is an easier way,

No good way at present.

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  A room without books is like a body without a soul. |
| -- Cicero|
|--|

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

[RDD] RdLibrary - find songs from year

[Morten Krarup Nielsen]

Hi.

We need to find songs from 1991, 1992 and so on. We have entered the
data in RdLibrary, but you can't search for it :-(

Is there anyone that now the SQL command to find songs from a specific year?

Thank you!

Kind regards,

Morten
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev