Solved

ID3V2 Tags exported to CSV file

Posted on 2004-09-03
3
463 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now