Check out these other Ots related sites as well....
On Facebook OtsUsers | OtsAV | OtsLabs | OtsTurntables
On Twitter OtsAV | OtsLabs | OtsTurntables
Also on YouTube | Official G+ | Our G+ Page
Shared Content
Welcome, Guest. Please login or register.
Ots User Support Forums
>>> Do you wish to join us? <<<
Pages: [1]   Go Down
  Print  
Author Topic: How can I add the Title & Artist to Microsoft Excel  (Read 7830 times)
0 Members and 1 Guest are viewing this topic.
Sharkbait
Guest
« on: July 13, 2010, 10:20:59 pm »

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
Logged
Jumpin' Jeff
Site Administrator
Administrator
Justice League Member
*****

Help Score... 72
Offline Offline

Gender: Male
Posts: 10912



« Reply #1 on: July 14, 2010, 07:03:22 am »

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

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
Guest
« Reply #2 on: July 14, 2010, 09:39:50 am »

Are you actually trying to export the artist and title information from OtsAV to CSV? Yes I am and how can I do that
Logged
Darryl
Pay no attention to the man behind the curtain...
Global Moderator
Justice League Member
*****

Help Score... 22
Offline Offline

Gender: Male
Posts: 3097


« Reply #3 on: July 14, 2010, 10:42:26 am »

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.
Logged

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
Administrator
Justice League Member
*****

Help Score... 38
Offline Offline

Gender: Male
Posts: 4401



« Reply #4 on: January 08, 2015, 10:08:41 am »

Will this export a list of all the artist - title in the media library? I have over 10,000 tunes
Logged
Jigger
Moderator
Global Moderator
Justice League Member
*****

Help Score... 52
Offline Offline

Gender: Male
Posts: 2469


I can clear the floor without any help


« Reply #5 on: January 08, 2015, 12:18:23 pm »

Yes if you follow Darryl's instructions.
Logged

Ron
PDI PAAA-BE42 x 2 OtsAV Pro
PDI PBQ4-BH3P x 1 OtsAV Pro
milky
Administrator
Justice League Member
*****

Help Score... 48
Offline Offline

Gender: Male
Posts: 4913



WWW
« Reply #6 on: January 08, 2015, 01:55:59 pm »

I had a feeling that the csv option was only available on some products.
Logged

OtsDJ           PDI = PAAA-BHVP,  PBQN-3658
S & L               PDI = PAAA-BK27 x 2
Studio             PDI = PAAA-BL38
Pages: [1]   Go Up
  Print  
 
Jump to:  

>>> Trouble? Visit us @ OtsAV Users Support Group on Facebook <<<
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines
XHTML | CSS | Aero79 design by Bloc