• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

Move Reports From Sam Broadcaster

Started by NounosSon, January 08, 2014, 03:29:32 AM

NounosSon

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

DJ Garybaldy

Quote from: NounosSon on January 08, 2014, 03:29:32 AM
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.
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

AndyDeGroo

QuoteIs 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

Quote from: AndyDeGroo on January 09, 2014, 04:24:00 AM
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  :ok:
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

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

Quote from: AndyDeGroo on January 09, 2014, 05:48:10 PM
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...
R.T.F.M. means to me, Read The Fantastic Messages.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)
The Radiodj tutorials site is now managed by Domstad radio .nl still  Just in English

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!