Author Topic: Move Reports From Sam Broadcaster  (Read 2142 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
  • *****
  • 3589
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
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.
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

Currently Beta Testing 2.0.1.4

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
  • *****
  • 3589
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
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:
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

Currently Beta Testing 2.0.1.4

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
  • *****
  • 3252
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • 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.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Testing 2.0.1.4

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!