Export script xls with all options??

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

LO

Export script xls with all options??

Post by LO » Sun Feb 29, 2004 12:52 pm

Hello

I was wondering. Is there a script to make exportfiles in xls. That include all possible options in MM like BPM, Custum 1, 2, 3 and type.

Because i tried to rewrite the script, but i don't have a clue how this works.

LO

Lowlander
Posts: 46275
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Read this

Post by Lowlander » Sun Feb 29, 2004 12:57 pm

There is no such script yet for xls (there is one for html), but this topic covers all the accesible objects in MM http://www.songs-db.com/forum/viewtopic.php?t=1654
Last edited by Lowlander on Mon Jul 19, 2004 12:44 pm, edited 2 times in total.
Lowlander (MediaMonkey user since 2003)

pah68
Posts: 1496
Joined: Wed Apr 07, 2004 5:26 pm
Location: Sydney, Australia

Post by pah68 » Sat Jul 17, 2004 7:13 pm

Dud link.

I too am looking for something to export the entire database to Excel.

Does anything exist yet?

Guest

Post by Guest » Thu Jul 29, 2004 7:39 pm

The links working again.

Still hoping for an Excel script to export ALL data.

ZeusRex

Gettling all data to Excel

Post by ZeusRex » Tue Oct 05, 2004 9:19 am

Here's a solution that I put in another post.

Copy and paste this into Notepad:

XLODBC
1
DSN=MediaMonkey;DBQ=D:\My Music\MediaMonkey\MediaMonkey.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
SELECT Albums.*, Artists.*, Songs.*, Genres.*, Medias.*, Memos.* FROM (Medias INNER JOIN (((Albums INNER JOIN Artists ON Albums.IDArtist = Artists.ID) INNER JOIN Songs ON Albums.ID = Songs.IDAlbum) INNER JOIN Genres ON Songs.Genre = Genres.IDGenre) ON Medias.IDMedia = Songs.IDMedia) INNER JOIN Memos ON Songs.ID = Memos.IdSong;



Replace the file name "D:\My Music\MediaMonkey\MediaMonkey" with the name of your MM database. It will probably be in a different location.

Save the file as "SelectAll.DQY". The .DQY extention is for query files for Excel.

Close Notepad and double-click the SelectAll.dqy file. It should open in Excel. A dialog should open saying that no data connection could be made. No problem. Click OK and another dialog will open, "Select Data Source". Click New -> User Data Souce -> Next -> Select Microsoft Access Driver -> Next -> Finish. A new dialog will open called ODBC Microsoft Access Setup.

For the Data Source Name, enter "MediaMonkey". Then click "Select", and browse for your MM database. Once it shows in the lefthand panel, select it and click OK. You've now created the database connection.

Click OK to the Select Data Source Window, and OK to the Login Panel. The results of the query should appear in Excel.

If all works you should have almost all of the data from MediaMonkey on the spreadsheet.

Now, you can format the information how you want it. In Excel, click Data -> Import External Data -> Data Range Properties. In the dialog, select "Refresh Data on File Open" and "Remove external data from worksheet before saving". This will clear the spreadsheet of all data when you save it and refresh the data everytime you open it. Always up to date. Also be sure that Preserve Column Sort and Preserve Cell Formatting are selected. Close the dialog.

Now, you can hide some columns (you'll probably have lots of irrelevent data), and put the columns in the order you want.

Save the spreadsheet. Everytime you open it now it will load the query and the data from MM.

Hope this works for you.

Post Reply