Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[iCamp]

What is the File-->Library->Export to XML feature for?  Those of you who use that feature, what do you do with it?

I was looking for a way to export  my artist, album, track, etc. data to an Excel file (or something).  Perhaps I'm over looking how that is done.  

[nila]

I'm just waiting for: 'Export to SQL'
Then I can integrate all my files with my own custom web frontend and get php to call MC with a command line instruction telling it to export to SQL, then make it read in the file, add it to mySQL, then display all the info - WAHOO!!

lol.

Export to XML is just to give you a way to export that is easily sorted and read - XML is a great format for a lot of different programs etc to read.

[iCamp]

What programs work well with XML?  I know I can view it in my browser but it's totally unorganized.  

I guess there is no way to view my library in Excel?  Bummer.

[aussie1]

1. Select the tracks you wish to copy

2. Choose edit -> Copy  (or hit ctrl-c)

3. Switch to Excel

4. Choose edit -> paste

5. Its easy to get it into a SQL database from there


You can also paste directly into a table in MS Access

[nila]

Ah but that requires you being there to do it.

I want to be able to get a php page call MJ through a command line with a parameter, get it to export all the library then get the php to read in the sql exported file and execute it on the mySQL server to create a mySQL db of all my music which can then be integrated however I want with my website.

Ideally I'd like to be able to just query MC directly as if it was a db, equivalent to mySQL and have it return all the results to my SQL statements


Also, I'd LOVE to be able to import into MJ through SQL as I have a HUGE mySQL db full of data that I'd love to have MC manage but I'm not going to enter it all manually. Way too much for that.