Re: [RDD] Rivendell Log Reconcilation or Report

2023-02-11 Thread Eric Adler
>From my local documentation: YESTERDAY ONAIR ONLY: select ELR_LINES.CART_NUMBER, ELR_LINES.EVENT_DATETIME, ELR_LINES.LENGTH, ELR_LINES.TITLE, ELR_LINES.ARTIST, ELR_LINES.ALBUM, ELR_LINES.CUT_NUMBER, CART.GROUP_NAME, CART_SCHED_CODES.SCHED_CODE from ELR_LINES left join CART on

Re: [RDD] Rivendell Log Reconcilation or Report

2023-02-11 Thread David Klann
Hi Ivan, Like Eric, I have a script that I run that "augments" the built-in Rivendell reports (see link below). There are two steps to making Rivendell reports work (apologies if you already know and understand these): - define the reports in RDAdmin > Manage Reports in the box labeled

Re: [RDD] Rivendell Log Reconcilation or Report

2023-02-11 Thread ijames
Eric, Do you have a sample script that you can share Thanks On 2023-02-11 16:06, Eric Adler wrote: I run an sql query as a cron job nightly with csv export that automatically emails. Two really, checking the music flag so the reports go to different people. On Sat, Feb 11, 2023, 3:48 PM

Re: [RDD] Rivendell Log Reconcilation or Report

2023-02-11 Thread Eric Adler
I run an sql query as a cron job nightly with csv export that automatically emails. Two really, checking the music flag so the reports go to different people. On Sat, Feb 11, 2023, 3:48 PM wrote: > > Good Afternoon Community. > I was wondering if any one has have any experience with Generating:

[RDD] Rivendell Log Reconcilation or Report

2023-02-11 Thread ijames
Good Afternoon Community. I was wondering if any one has have any experience with Generating: 1.log reconciliation report. 2. Or Report That tells when the carts ran. I have tried to configure the reports The Rdadmin/Reports/Manage Reports. I don't see anything in rd/admin/ services Does