Hello !
I didn’t see any topic concerning my request…
I’m really considering buying mAirList since I’m switching my mixer to a D&R Airlite (it seems that integration with mAirList is great, impressive).
I’m currently using RadioDJ and I have a lot of songs and jingles with cue points (hooks (in and out), intro, next and stop). I don’t really want to make it all over again.
Is it possible to import RadioDJ database to mAirList (just for the songs, events and settings would be re done by myself) ?
It’s a MySQL database…
I sent you the mail.
It’s a dump executed through the RadioDJ database manager (with the “backup” fonctions") but if it’s not enough I could send you a backup made with HeidiSQL or anything else.
Thanks, managed to load it into my MySQL server. The table structure is pretty straightforward, except for the very strange way in which the cue points are stored. But other developers will probably say the same about my xmldata trick in mAirListDB
Anyway, converting the entire database with all aspects will probably be a bit too complicated. But it should probably be enough to have the list of songs with all of their attributes and cue points, right?
Okay, songs’ attributes as you said and cue points are just what I want.
There are .wfrm files along songs in their folders if we choose to backup cue points in ID3 of tracks. It’s a sort of backup in case of a DB crash. I can also send you one if you want.
No… But I asked on the RadioDJ forum just now.
Tried to open it with Notepad++ without success too…
It’s 4096 octets, maybe that could be a starting point…
Is SQL import too complicated ?
Okay, it seems that they don’t want to answer this question (answers are not showing how WFRM files are made).
I’ve found this: https://github.com/AndisGrossteins/SAMBC2RadioDJ
Maybe it’ll help (I don’t know) ?
EDIT: I’ve found this too: http://www.radiodj.ro/community/index.php?topic=4832.0
EDIT 2: here is an example how cue points are implemented in file tags (MusicIP PUID):
&sta=0,450090702947846&int=4,90340136054422&hin=129,318843537415&hou=139,451451247166&xta=233,005351473923&end=233,702993197279&fin=0&fou=0,697641723356014
Sta for start, int for intro, hin for hook in, hou for hook out, xta for next start, end for… end ? and fou I don’t know
Ok, so the cue points are also stored in the ID3 tags? Can you send me a sample audio file so I can have a look? And what about the other formats (WAV, AAC, etc.) - do they have a similar tag?
Generally, I am looking for a conversion method that can be applied by the user (you) on his own in a simple manner. It would be very easy for me to write a Perl script etc. that reads the SQL and creates a CSV file from it to be imported into mAirList. But I’m afraid the majority of the mAirList users don’t know how to use Perl scripts…
My first idea was to write an SQL query that creates the CSV file (MySQL can create CSV files!). But the problem is the way that the cue markers are stored in the RadioDJ database. It’s in the same format that you mentioned, a single SQL column, with one long string with the values separated by the “&” character. It’s near impossible to write an SQL query that splits this into separate columns.
So right now I see two possible solutions:
Add support for reading the RadioDJ-style MuscIP tags.
Write a mAirList script that access the MySQL database directly, parses the cue markers, and updates the records in the mAirListDB.
I am trying to insert additional songs in Radiodj, but I get no error and the songs are not in the database. I tried to insert folders and by individual song title without success. Am I doing something wrong?
You don’t happen to have any information about the structure, do you?