Have to change in both cut and cart tables likely using mysql. or
mysqladmin; but maybe check with Fred about how RD tracks the next cart
number when assigning new carts to system.
If it justs reads the last highest number from existing database then
might work, but if it is tracking it somewhere else with a different
pointer, doing it transparently in the db directly might mess up the
autoincrementing for cart numbering when creating new carts using normal
RD builtin apps.
On 11-12-22 04:42 PM, Hoggins! wrote:
Hello,
We have two main groups for our music. One is the default (MUSIC), and
another one is used only for shows (MUSIC_EMIS). Presenters add their
own music in that group. MUSIC has a numbering range of 010001-040000,
and MUSIC_EMIS has 070001-090000. This group is not used in scheduling.
Sometimes, we consider that music added to a specific show should go
to the daily playlists for rotation. So we just move carts from
MUSIC_EMIS to MUSIC.
However, we would like to be able to renumber those carts
*transparently*, from time to time. Because now, MUSIC contains carts
from its own range, and carts from other ranges. I assume there is no
tool that would be able to renumber all carts according to the group
they belong to. So I'm thinking of creating scripts that would hack
into the database to do that.
But before going into this, has anyone ever tried to do something
similar ?
And in what tables should I modify the cart numbers to maintain a
consistant schema ?
Thanks !
Hoggins!
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
