RadioDJ - Free Radio Automation Software Forum

Move Reports From Sam Broadcaster

NounosSon

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?

Offline DJ Garybaldy

  • *****
  • 4326
  • 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/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

AndyDeGroo

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!

Offline DJ Garybaldy

  • *****
  • 4326
  • 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/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

AndyDeGroo

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.

Offline Jhonny

  • *****
  • 3930
  • 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

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!