RadioDJ - Free Radio Automation Software Forum

Recent Posts

Pages: 1 [2] 3 4 ... 10
11
You're close.  Make sure In Options (Spanner/wrench icon) > Other Settings Tab that you have the correct Artwork Storage Path set and enabled.  RDJ will automatically look in that folder for Artwork.  So the image filename in Heidi does not need to start with the path to the Artwork Folder.

All my files are .mp3 format, so the query I gave you works for me.  Let's see if we can make it work for you.

I think you will need to do the query twice, once for .mp3 files and once for .m4a files.  If you have any other filetypes, you will need to add a new query for each type, changing the filetype in the query to match the files extension.

Code: [Select]
UPDATE songs
SET `image` = CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(songs.path, '.mp3', 1), "\\", -1),".jpg") WHERE RIGHT (songs.path,3) = 'mp3' AND songs.song_type = 0;
SET `image` = CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(songs.path, '.m4a', 1), "\\", -1),".jpg") WHERE RIGHT (songs.path,3) = 'm4a' AND songs.song_type = 0;

This should fix the damage the previous query did.  Essentially you want the 'image' field in your database to be populated with the song's filename, with .jpg instead of .mp3

Also, when you exported artwork from mp3Tag, in the action, did you first have an action convert the artwork to .jpg type?  This is to make sure all artwork is the same image format.

12
RadioDJ v2 Support Forum / File By Date with multiple files in the same folder
« Last post by StartFM94.2 on April 09, 2020, 07:02:58 PM »
Good evening ladies and gentlemen, hope you all are doing fine and broadcasting wonderful sounds to the world!

I have a question for the more technically able of you:

I have a show that is supplied in segments. I would like to have it imported to the database as File By Date type and use a slightly different mask that I supply in the comment field on the track.

So, I get files called show-200409-p1.flac, show-200409-p2.flac and show-200409-p3.flac and place them in the same folder.

When importing, I do supply a mask "show-"yyMMdd for the first one and it works. When trying to import additional ones, with according masks, "show-"yyMMdd"-p2" etc., they do not get imported.

Is it a limitation by design that only one File By Date can be imported from one folder?

If so, what would be the best way to go around with such automatization idea? Basically, I am trying to get the hosts to supply the show files to ftp, download them automatically (all good up to this point) and then have a playlist with their show with segments in places and music/promos separating them with as little human input as needed.

Thank you for all your thoughts in advance!


13
Ok, so I extracted the artwork from the m4a's using Mp3tag and I named them %_filename%, and put them all into one folder. So for instance the artwork for 'song x.m4a' is 'song x.jpg' and it's in D:\Album Art with all the other jpg's from the m4a's. Then I did some experimenting with the sql query in Heidi. I tried a few things that returned a syntax error, but finally I got this to run, for whatever it's worth (not much apparently):

UPDATE songs
SET `image` = CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(songs.path, '.m4a', 1), "D:\Album Art", -1),".jpg") WHERE songs.song_type = 0;

Looking in Heidi in the data tab under songs, in the image column, I could see that there were now images corresponding to the m4a's, where there used to be something like 'no image.jpg' prior to my running the query. But looking closer, it seemed that at least some, if not all of the images corresponding to my mp3's had been appended with '.mp3' in the jpg file name. In other words, in the image column, where it once would have shown the image for 'song x.mp3' as 'song x.jpg', now it was showing the image as 'song x.mp3.jpg'. Something or other I had done previously seemed to completely break the album art display function in radiodj.

Now no album art images are displaying in radiodj.

I continued to try to peck away at this (like a lot of people right now I have nothing else better to do). I have no idea what I'm doing, but why not experiment? If worse comes to worse I can just delete the database and start again from scratch. It's better than getting COVID-19. Alas I have found no solution, and somewhere along the way a bunch of the m4a images now have '.m4a' appended to the jpg name listed in the image column in Heidi as well. So much for my career as a hacker.  :D

I moved my m4a album art to the folder nestled within the radiodj program folder (C:\radiodj\Album Art), so that folder now contains all of the jpg's for both the mp3's and m4a's, where the image file name for 'song x.mp3' is 'song x.jpg' and the file name for 'song y.m4a' is 'song.y.jpg'. Of course that didn't help the broken album art function, but at least all of the artwork is all in one place and is named similarly.  ::)

Clearly I need some help (people have been telling me this for years). What can I do to fix this fine mess I've made? Thanks for your assistance.
14
RadioDJ v2 Support Forum / Re: Playlist question
« Last post by Jhonny on April 09, 2020, 12:51:51 PM »

I have a show that's pre-recorded sort of, I have a list of songs with the intros and usually added the M3U to Sam using the Event and later removed the tracks afterwards from the datebase. In reviewing the Event setup in RadioDJ I can do a similar setup and the songs are listed in the database, but are not active if I read it correctly, if I am correct I can go in and delete them after the show plays. Or is there a better option to do this?

Thanks for your assistance and I hope everyone is doing well out there.
You don't have to delete the tracks after playing.
Use the playlist builder and make equivalent playlists and save them as radiodj playlists
Maybe you like to us a playlist a other time
In the option playlist you can see all your playlists.And with a event you can play playlist


15
Italian / Re: impstazioni caster fm usando radio dj
« Last post by rss2013 on April 09, 2020, 10:39:19 AM »
Ciao a tutti mi chiamo Vins e sono un nuovo utente su questo forum, spero di aiutare e aiutarmi !
chiedo a tutti voi cortesemente se posso trasmettere su castefm con radio dj o magari consigliarmi
qualcosa di meglio ciao a tutti e grazie!

I use Autopo is good with good prices I think https://streaming.autopo.st/
16
RadioDJ v2 Support Forum / Re: Playlist question
« Last post by Chip Douglas Mosley on April 09, 2020, 06:32:27 AM »
I think I can help you with the second question.

If you have RDJ showing in the hidden icons (that ^ near the clock on the lower right side of your monitor), right click on the icon. You'll find an option to mute the sound in the pull down bar. If you have your speakers set up correctly, this will turn off your computer speakers without effecting the output to Rocket Broadcaster.

Hope this helps, and welcome aboard!
17
Italian / Re: impstazioni caster fm usando radio dj
« Last post by plauri on April 09, 2020, 03:28:31 AM »
Forse intendevi CasterFM, non lo conosco ma mi sembra offrano anche qualcosa di gratuito. Se invece intendi acquistare un qualche piano, da una rapida occhiata, hanno dei prezzi davvero esorbitanti. Assolutamente no. Dai uno sguardo a shoutca.st o iNET4u, sono entrambi inglesi ed hanno i prezzi piĆ¹ bassi sul web. Facci sapere.
18
RadioDJ v2 Support Forum / Playlist question
« Last post by progpalace on April 09, 2020, 02:26:42 AM »
I am new to RadioDJ and I come from using Sam Broadcaster for the last 20 years.
Being new to this I attempted to look for a topic, but nothing came up on this specifically.

I have a show that's pre-recorded sort of, I have a list of songs with the intros and usually added the M3U to Sam using the Event and later removed the tracks afterwards from the datebase. In reviewing the Event setup in RadioDJ I can do a similar setup and the songs are listed in the database, but are not active if I read it correctly, if I am correct I can go in and delete them after the show plays. Or is there a better option to do this?

Also I realize I'm use to the old setup and now I'm using RadioDJ and Rocket Broadcaster, but is there a way to mute the station, but only on the computer and not the stream?

Thanks for your assistance and I hope everyone is doing well out there.
19
Radio Talk / Re: Radio Stations using RadioDJ
« Last post by shadowking46 on April 09, 2020, 01:56:52 AM »
From Halifax, Nova Scotia
Broadcasting Christian Music to the world and beyond
https://heavensradio.ca

Coming Soon to a radio near you. Launch Date: April 25, 2020
20
Thank you so much PROducer! So, in my case the files are not mp3 but rather m4a. I've exported the album art with Mp3tag as .jpgs into a folder and named them %_filename%. I'm a little confused and could use a little guidance as to how I should modify the query you wrote to get it to properly update the database. I presume that I should change 'mp3' to 'm4a'? Where/how do I enter the path? Thanks again.


Here's the SQL I used to do this:
Code: [Select]
UPDATE songs
SET `image` = CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(songs.path, '.mp3', 1), "\\", -1),".jpg") WHERE songs.song_type = 0;
Pages: 1 [2] 3 4 ... 10