Move Reports From Sam Broadcaster

[NounosSon]

Is there a way to move the music logs and reports from Sam Broadcaster to RadioDJ?

[DJ Garybaldy]

Is there a way to move the music logs and reports from Sam Broadcaster to RadioDJ?

I don't think that is possible as the database structure in RadioDJ is different from the SAM  setup.

[AndyDeGroo]

Is there a way to move the music logs and reports from Sam Broadcaster to RadioDJ?

Although it is not easy, it is feasible with some clever fiddling with SQL scripts and such.

If I have time and motivation I'll write a complete migration solution for SAMBC. It depends on how pissed I'll get at Spacial and how much free time I'll have.

Btw: Hi, KingsbridgeRadio!

[DJ Garybaldy]

Although it is not easy, it is feasible with some clever fiddling with SQL scripts and such.

If I have time and motivation I'll write a complete migration solution for SAMBC. It depends on how pissed I'll get at Spacial and how much free time I'll have.

Btw: Hi, KingsbridgeRadio!

Good to see you on here Andy. Even if it takes you a while to do I'm sure a migration tool will be welcomed by most people who want to switch 

[AndyDeGroo]

Good news, everyone;

I've created a PHP script which exports an sql script or inserts history data into RadioDJ table. I need to polish it a bit and test, but for now it works for MySQL to MySQL history migration. I have to test if it works with Firebird.

Few fields are missing from resulting data - id_subcat (sub category reference), disk_no (no disc numbers in SAMDB), original_artist, copyright.

I'll report back here how it goes. If anyone is interested in my script in its current state, please ask here or PM me.

[Jhonny]

I'll report back here how it goes. If anyone is interested in my script in its current state, please ask here or PM me.

I am always interested.
I wonder how you got the script written or created.

Grtz...

[AndyDeGroo]

I give you the SAMBC2RadioDJ version 0.1. Consider it a beta quality software and please don't blame me if it messes up your data. Short docs are in RADME.md.

Back up everything from RDJ tables before using WORK_MODE_INSERT!

I hope this satisfies your curiosity, Jhonny!