Solved

ID3V2 Tags exported to CSV file

Posted on 2004-09-03
3
511 Views
Last Modified: 2006-11-17
Hi All,

Through being A DJ for years, I have converted all my CDs to MP3 and am running digitaly.  What I now need is in 2 parts:

Part 1:

A script or utility that will go through the 15000 plus mp3s and put all the ID3V2 data on each MP3 in a CSV file.
Specific info required in CSV file are the: Artist, Title, Genre, Year, Album Title, Comment and duration fields.
Part 2:

I will then have a database of actual MP3s that I need to compare to the CD database to make sure none were missed, so a utility or script that will compare the 2 databases and return a list of differences.  (IE: if songA is in DatabaseA but not DatabaseB then it's on the list, but song2 being in both is not on the outputted list.)

I am VBScript literate, but anything else will completely lose me, so step by step instructions would be great!

Thanks in Advance
0
Comment
Question by:Ranidae
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Author Comment

by:Ranidae
ID: 11976287
I should add, I usually use MS Excel or Access for the database file.
0
 
LVL 5

Accepted Solution

by:
rsriprac earned 500 total points
ID: 11977121
Use this to rip the tags:

http://www.softpointer.com/tr.htm

Then import to Access.  In the same Access DB link or import your other database of songs to compare.  Then you would do a LEFT JOIN from the the table of your ripped tags to the complete song table.  The column of the songs you are missing will be blinks in one of the column.

-Ram
0
 
LVL 2

Author Comment

by:Ranidae
ID: 11986380
Thanks Ram...

That is one awesome piece of software... wish I'd have known about it 3 months ago when I began ripping these disks!

Haven't done the access DB stuff yet.. but I'm sure it'll work out.

Thanks again
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In this post we will learn different types of Android Layout and some basics of an Android App.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question