Author Topic: Move Reports From Sam Broadcaster  (Read 2929 times)

NounosSon

  • Guest
Move Reports From Sam Broadcaster
« on: January 08, 2014, 03:29:32 AM »
Is there a way to move the music logs and reports from Sam Broadcaster to RadioDJ?

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4392
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Move Reports From Sam Broadcaster
« Reply #1 on: January 08, 2014, 08:35:58 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.
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

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

RadioDJ is the Swiss Army Knife of radio playout software

RadioDJ is my favourite software EVER!

AndyDeGroo

  • Guest
Re: Move Reports From Sam Broadcaster
« Reply #2 on: January 09, 2014, 04:24:00 AM »
Quote
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

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4392
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Move Reports From Sam Broadcaster
« Reply #3 on: January 09, 2014, 12:53:38 PM »
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:
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

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

RadioDJ is the Swiss Army Knife of radio playout software

RadioDJ is my favourite software EVER!

AndyDeGroo

  • Guest
Re: Move Reports From Sam Broadcaster
« Reply #4 on: January 09, 2014, 05:48:10 PM »
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

  • Hero Member

  • Offline
  • *****
  • 4006
  • Personal Text
    Peace, enjoy life, last sleep is longer than live!
    • Jhonny's RadioDJ tutorials.
Re: Move Reports From Sam Broadcaster
« Reply #5 on: January 09, 2014, 06:25:39 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, I do tuts. ( ͡° ͜ʖ ͡°) visit  https://radiodj.info

Testing RadioDJ v2.0.2.0 Beta

AndyDeGroo

  • Guest
Re: Move Reports From Sam Broadcaster
« Reply #6 on: January 10, 2014, 04:37:45 AM »
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!