You'll probably have to use MySQL to edit the imported from bit out. Make a backup of your database first!
Then run: mysql -u root -p That will get you logged into mysql assuming its localhost (add -h ip/hostname if its on another server). Then start the mysql fu: USE Rivendell; update CART set TITLE = replace(TITLE, 'Imported From', ''); You'll also have to amend the CUT table if I remember rightly: update CUTS set DESCRIPTION = replace(DESCRIPTION, 'Imported From', ''); QUIT; Refresh rdlibrary (usually open/close or just change the groups so the display changes). This shouldn't damage your tables but if you have a song with "Imported From" as a legitimate title it will be blanked out so be careful. You can be more specific if you're slightly paranoid by adding a where clause to only alter fields where Imported From is the start of the field e.g.: update CART set TITLE = replace(TITLE, 'Imported From', '') where TITLE like 'Imported From%'; Its probably wise to do this although the query will be slower as you're guaranteeing only those that start with the words Imported From will be changed. Regards, Wayne -----Original Message----- From: [email protected] on behalf of Geoff Barkman Sent: Mon 03/12/2012 21:07 To: User discussion about the Rivendell Radio Automation System Subject: Re: [RDD] Retitling Carts Brought In By RDImport Hi alan There is also options when your bulk importing using the command line on rdimport. I can't remember if I added them on the wiki page on rdimport or not. To get the rdimport option look at rdimport --help on the command line Cheers again Geoff barkman On Dec 4, 2012 9:58 AM, "Geoff Barkman" <[email protected]> wrote: > Hi alan > In the group options in rdadmin for the group. It will have imported from > %f in the Meta information. Change that to %a - %t and without the imported > from part. If there is m3u info in an mp3 it overwrites it I believe, but > otherwise it puts in the imported from part etc. > Many thanks > Geoff Barkman > On Dec 4, 2012 7:23 AM, "Alan Peterson" <[email protected]> > wrote: > >> This no doubt has been documented somewhere but it is eluding me... >> >> If I bring in a large number of song files via RDImport, what can I do >> during/after importation to remove the "Imported From" notation in the >> Title? Is there a box to check, a script to run, a MySQL command to be >> invoked? >> >> Thanks very much. >> >> AP >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> > wrote: ####################### 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 ############
<<winmail.dat>>
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
