How can I add the Title & Artist to Microsoft Excel

Started by Sharkbait, July 14, 2010, 03:20:59 AM

Previous topic - Next topic

Sharkbait

How can I add the Title & Artist to Microsoft Excel
can someone give me the step by step please and when I safe it as DJ Sharkbait CSV
and some of the Artist dont show up at all when I add it to my music database on my djwebsite  :angry1: :ohmy: :unsure:


Thanks
DJ Sharkbait
Sharkbait Radio Station
where we play the hottest hits

Jumpin' Jeff

Are you actually trying to export the artist and title information from OtsAV to CSV?
Jeff Main

You can please some of the people some of the time, all of the people some of the time, some of the people all of the time, but you can never please all of the people all of the time. 
Abraham Lincoln
 
OtsAV license holder for life.
PDI: OtsAV TV Broadcaster PARC-KHY7

Sharkbait

Are you actually trying to export the artist and title information from OtsAV to CSV? Yes I am and how can I do that

Darryl

Try this:
1. Run OtsAV
2. Show the Media Libary (View -> List Display -> Show Media Library on Right)
3. Choose "[All Items]" from the Media Library drop down list.
4. Right click and choose "Select" then "All".
5. Right click and choose "Export" then "As CSV File..."
6. Enter the filename to save it to (remember the folder where you are saving it)
7. Open the .CSV file in Excel (or OpenOffic Calc)

I can't remember the exact format of the export (I think there is more than just artist and title), so delete any columns that you are not interested in.  You can also add a header row by inserting a row at the top of the file and entering Artist and Title in the appropriate columns.

If you get stuck, try to indicate exactly where in the process it went wrong and what actually happened - for example, if you get an error message, make a note of the error message.

Have fun,
Darryl.
OtsAV: PDI PAAA-BFDR

Version 3.0.8.0 of the Karaoke Hoster is available now - http://sourceforge.net/projects/karaokehoster

Checkout my CDG Editor - repair badly ripped CDG Karaoke files with ease: http://sourceforge.net/projects/cdgeditor/

Now Playing in OtsAV - https://sourceforge.net/projects/nowplayinginots/ - Show your Windows Live Messenger contacts what you are listening to in OtsAV.

Ed

Will this export a list of all the artist - title in the media library? I have over 10,000 tunes

Jigger

Ron
PDI PAAA-BE42 x 2 OtsAV Pro
PDI PBQ4-BH3P x 1 OtsAV Pro

milky

I had a feeling that the csv option was only available on some products.
OtsDJ           PDI = PAAA-BHVP,  PBQN-3658
S & L               PDI = PAAA-BK27 x 2
Studio             PDI = PAAA-BL38