Author Topic: How can I save all my songs in the database?  (Read 5482 times)

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
How can I save all my songs in the database?
« on: October 04, 2015, 02:06:25 AM »
I would like to save all my songs I have in the database in a file that can be either a *.doc or a *.pdf. How can I do it?
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

baba

  • New User

  • Offline
  • *
  • 19
    • Babaganousha Radio [[ Stream Your Dream ]]
Re: How can I save all my songs in the database?
« Reply #1 on: October 04, 2015, 08:44:59 AM »
Hi,

it is possible with a great tool called HeidiSQL (comes with MariaDB http://www.heidisql.com/) and Libre Office https://www.libreoffice.org/.

I made it like this:

  • Open the database with HeidiSQL
  • Select the table songs / select data tab
  • You can now select columns to show and also limit the number to show
  • Now: Tools -> export grid rows - choose csv or html
  • Open the file in Libre Office
  • Export the file as .pdf

 ;)




Proud user of RadioDJ Free Radio Automation Software.
========================================

http://babaganousha.net
Psytrance & Goa 24/7 - Stream Your Dream

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
Re: How can I save all my songs in the database?
« Reply #2 on: October 04, 2015, 12:25:31 PM »
hi Baba,
I already have and use heidiSQL and MariaDB, but where is stored the db file? If I open it from a back up file, where do I select the table song and data tab ?
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

baba

  • New User

  • Offline
  • *
  • 19
    • Babaganousha Radio [[ Stream Your Dream ]]
Re: How can I save all my songs in the database?
« Reply #3 on: October 04, 2015, 02:19:06 PM »
hi Baba,
I already have and use heidiSQL and MariaDB, but where is stored the db file? If I open it from a back up file, where do I select the table song and data tab ?

Hey Plauri,

i assumed you have a running MariaDB  with a RadioDJ database up and running. If you have a complete SQL dump of your RadioDJ database
as a SQL file with all data you should be able to restore your database from that file.

But be careful ... depending on your export options this might destroy your vital data.

AFAIK there is no way to "open" the database files (MYD,MYI,frm) these are binaries.

Proud user of RadioDJ Free Radio Automation Software.
========================================

http://babaganousha.net
Psytrance & Goa 24/7 - Stream Your Dream

Jhonny

  • Hero Member

  • Offline
  • *****
  • 4183
  • Personal Text
    Peace, enjoy life, last sleep is longer than live!
Re: How can I save all my songs in the database?
« Reply #4 on: October 04, 2015, 04:03:57 PM »
I would like to save all my songs I have in the database in a file that can be either a *.doc or a *.pdf. How can I do it?

how a bout a csv file?
You can use the csv exporter plugin.
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 ( ͡° ͜ʖ ͡°)

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
Re: How can I save all my songs in the database?
« Reply #5 on: October 05, 2015, 12:23:11 AM »

i assumed you have a running MariaDB  with a RadioDJ database up and running...

Yes I have it running. But I really don't understand how to do what you suggest. I do database backup on a regular base, but that's all. I'm a bit lost into it.

@Jhonny: same as before. I have looked for csv exporter, I have found it, but don't know how to do it.

@Marius: Can't you add an option in a new Radiodj release which includes a way to save all or part of your songs in an easy way? Thanks
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

FL Coast

  • Sr. Member

  • Offline
  • ****
  • 384
Re: How can I save all my songs in the database?
« Reply #6 on: October 05, 2015, 01:34:28 AM »
plauri, the easiest is as Johnny suggests.  First you must move (or copy) the “Plugin_Exporter.dll and Plugin_Exporter.xml” files from the “Plugin CSV Exporter Folder” inside the “Disabled Plugins Folder” to the “Plugins Folder”.  Now restart RadioDJ.

After the restart click on “Options” then “PlugIns”.  In the list of Plugins find “CSV Exporter” click on it to highlight it and then click on “Show”.  This will open the exporter for you to select what to export.  Just set a path and file name for the file location. Check the fields you want and click “EXPORT”.  Once completed, you can open the file in your favorite spreadsheet program and manipulate the data as you see fit and print the results.

If you have a Large Music File and/or a slow machine, this export could take quite some time.  The exporter ties up RadioDJ so you will not have access to change things.  I have never had it stop playing if set to “AUTODJ” during the export.  To avoid this you could start another instance of RadioDJ for your export session and still have access to your running RadioDJ.  Good Luck.
:)    Play the Music and Have Fun!    :ok:
==================================
 Fun In The Sun,  From the Florida Coast
***************************************************
"It is what we learn after we think we know it all, that counts."
John Wooden 1910 - 2010

Jhonny

  • Hero Member

  • Offline
  • *****
  • 4183
  • Personal Text
    Peace, enjoy life, last sleep is longer than live!
Re: How can I save all my songs in the database?
« Reply #7 on: October 05, 2015, 12:07:19 PM »
Quote
@Jhonny: same as before. I have looked for csv exporter, I have found it, but don't know how to do it.
CSV Exporter.pdf
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 ( ͡° ͜ʖ ͡°)

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
Re: How can I save all my songs in the database?
« Reply #8 on: October 06, 2015, 03:47:10 AM »
It works!  :D I used method FL Coast suggested. +1 to you all

One more: how can I deselect "path" in the database export? I really don't need it
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

FL Coast

  • Sr. Member

  • Offline
  • ****
  • 384
Re: How can I save all my songs in the database?
« Reply #9 on: October 06, 2015, 04:52:29 AM »
It works!  :D I used method FL Coast suggested. +1 to you all

One more: how can I deselect "path" in the database export? I really don't need it
plauri, The Path Field cannot be unchecked as Exporter needs it to find the information, but once you have the CSV File you can open it up in your spreadsheet program and delete that column.  While it is open in the spreadsheet you can also sort the records anyway you want, by Genre, Year, Artist Name, Category, Subcategory, etc.
:)    Play the Music and Have Fun!    :ok:
==================================
 Fun In The Sun,  From the Florida Coast
***************************************************
"It is what we learn after we think we know it all, that counts."
John Wooden 1910 - 2010

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
Re: How can I save all my songs in the database?
« Reply #10 on: October 10, 2015, 03:09:27 AM »
plauri, The Path Field cannot be unchecked as Exporter needs it to find the information, but once you have the CSV File you can open it up in your spreadsheet program and delete that column.  While it is open in the spreadsheet you can also sort the records anyway you want, by Genre, Year, Artist Name, Category, Subcategory, etc.

Well it's not exactly like this: once I have deleted the first column I have the second column with artist name, but if all the artists would be of one world and the title song the same, it would be ok (only two total column). Example: Prince - Kiss. Unfortunately we have: "The Detroit Spinners - Working My Way Back To You", I get 9 columns for this record, you can imagine it's impossible to order them  :bash:   
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

turntable

  • Full Member

  • Offline
  • ***
  • 114
Re: How can I save all my songs in the database?
« Reply #11 on: October 11, 2015, 12:41:06 AM »
Hey plauri,

I think you have imported the csv-file with wrong separation options. I suggest you used "spaces". Take "decimal point" and it will work.
"Decimal point" is the option importing this csv-file into LibreOffice. And it works perfect!
RadioDJ v2.0.0.6
Windows 10 Home | 64 Bit |
Pentium Intel Core i5-8400 | 2.8 GHz | 8 GB RAM
Realtek Audio Controller | 6.0.8924.1
Butt Encoder v0.1.17

FL Coast

  • Sr. Member

  • Offline
  • ****
  • 384
Re: How can I save all my songs in the database?
« Reply #12 on: October 11, 2015, 03:41:23 PM »
When importing the csv file into the spreadsheet, you must use the comma as the separator (Comma Separated Value) .  After the import then you can delete any columns or rows that you want.  To sort the data, highlight the rows you want sorted and highlight all columns with data in them.  Find the sort function in your software and have it sort by the column you want.  The thing is ALL data has to be highlighted for the sort feature to work and keep all of data in its proper row.
:)    Play the Music and Have Fun!    :ok:
==================================
 Fun In The Sun,  From the Florida Coast
***************************************************
"It is what we learn after we think we know it all, that counts."
John Wooden 1910 - 2010

plauri

  • Hero Member

  • Offline
  • *****
  • 1573
    • Funky Corner Radio
Re: How can I save all my songs in the database?
« Reply #13 on: October 12, 2015, 08:49:22 PM »
When importing the csv file into the spreadsheet, you must use the comma as the separator

Yes, the Comma was the answer. I selected it in the spreadsheet and it worked like I wanted. It was simple, of course once you know it  ::)
Funky Corner Radio
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

FL Coast

  • Sr. Member

  • Offline
  • ****
  • 384
Re: How can I save all my songs in the database?
« Reply #14 on: October 12, 2015, 09:01:20 PM »
Yes, the Comma was the answer. I selected it in the spreadsheet and it worked like I wanted. It was simple, of course once you know it  ::)
Knowledge is a beautiful thing.     :cool:  Glade it is working for you.
:)    Play the Music and Have Fun!    :ok:
==================================
 Fun In The Sun,  From the Florida Coast
***************************************************
"It is what we learn after we think we know it all, that counts."
John Wooden 1910 - 2010