I've been making an import tool to grab audio from a commercial system and migrate into Rivendell which means I've been looking at the database quite closely. I think a bit of creative field use could work without changing the database structure.
For starters, each cut has: * 12 CHAR ISRC * 32 CHAR ISCI * 64 CHAR DESCRIPTION Each Cart: * 12 CHAR ISRC * 64 CHAR LABEL * 64 CHAR CLIENT * 64 CHAR AGENCY * 64 CHAR PUBLISHER * 64 CHAR COMPOSER * 255 CHAR USER_DEFINED * text NOTES From my point of view, using NOTES or USER_DEFINED makes sense? Notes by itself can store 2^16 (I think) bytes of text which is approx 64K of text. Would none of that work? On Mon, 08 Aug 2011 17:34:33 +0100, VE4PER/Andy <[email protected]> wrote: > Not looking good for a quick and easy solution then after reading these > articles. > > Maybe best solution is to see if the RD db tables can be amended in > structure and then design a php http based database tool, initially > outside of Rd if needed quickly, then maybe incorporated into it at a > later release! > > Should be able to design a php form to allow the updates by volunteer > level skills and with it's multiplicity of interfaces to different types > of db's and coding maybe even give one some connectivity to freedb.org > or muscibrainz as well. > > for what it is worth my additional $0.02. > > Likely have to be someone with php coding proficiency as everybody else > is likely busy keepin' on keepin' on just keeping track of changes with > no hard copies on the shelf to refer to. > > > > > > On 08/08/2011 03:01 PM, Daniel Roviriego wrote: >> Hi.. >> >> A bit off-topic mas the history goes on, lots has happened: >> >> Oracle has donated the open office code to apache foundation..real it >> all in here: >> >> http://www.h-online.com/open/features/OpenOffice-splits-and-pirouettes-1270296.html >> >> As for the Microsoft Access usage, I think we could have a web tool >> for all those specific Rivendell mysql usage, though, I don know >> where to begin its architecture.. >> >> my 0.02 >> cheers >> >> 2011/8/8 VE4PER/Andy <[email protected] <mailto:[email protected]>> >> >> On 08/08/2011 02:27 PM, Cowboy wrote: >> > On Monday 08 August 2011 09:39:15 am you wrote: >> > >> >> Open office base has been taken over by Oracle/Sun and >> likely any new >> >> addons like form/report design will be a "premium pay for >> add-on" to the >> >> basic freebie package. >> > That's not exactly true. >> > >> > Open Office is a fork of the Sun Microsystems Star Office >> package, >> > as contributed to the Open Source community *BY* Sun >> Microsystems. >> > >> > I wouldn't be at all surprised to see this sort of thing in >> Star Office >> > first, but Sun has been quite good at supporting their Open >> Office as well. >> > >> ORACLE bought out Sun, and some of the coders/developers that >> supported >> the original OpenOffice project weren't happy with the new thrust to >> charge for premium add-ons, hence their desire to leave and start >> up the >> Libre-Office project. >> >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> <mailto:[email protected]> >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> >> >> >> >> -- >> Daniel Roviriego >> (21) 35920701 >> (21) 99561654 >> M2D multi_meios >> >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ####################### Scanned by MailMarshal ####################### #################################################################################################################################################################################################################### Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 #################################################################################################################################################################################################################### _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
