INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Export Library to MS Excel or .CSV (Plug-in or part of MJ)  (Read 1441 times)

David

  • Guest
Export Library to MS Excel or .CSV (Plug-in or part of MJ)
« on: September 16, 2002, 07:42:32 am »

Is there any way to Import/Export the Library to Microsoft Excel format or a CSV file.  If not, maybe someone could take up the challange and write a plug-in to convert to/from .JMD format.

My library is large (7,500|PLS| entries and growing as I continue to rip my CD collection) and I am continually finding spelling errors in the ID3 tag info obtained from the CDDB and YADB.  This wreaks havock with King Sparta's Chart Finder plug-in.  Garbage In = Garbage Out when performing matches.

Being able to export to MS Excel would allow me to run a spell check against the Song Title, Artist and Album columns and then re-import the library.  

Process would go something like this:
1) Export .JMD library to Excel or .CSV in MJ
2) Clear Library so it's blank
3) Run spell check
4) Convert Excel file or .CSV back into .JMD format and re-import back into MJ

The .JMD file seems like semi-collon delimmited text but I have not found an easy way using the "Get External Data" wizard in Excel to convert it.


Thanks,
David
Logged

Doof

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 5908
  • Farm Animal Stupid
RE:Export Library to MS Excel or .CSV (Plug-in or part of MJ)
« Reply #1 on: September 16, 2002, 08:39:09 am »

Well, you can export the current playlist (which can be all of Media Library) to an ascii demlimited text file, and then run spell check on that, but there's no way to then reimport that back into MJ.

It would be tricky anyway. Because then MJ's database would be different from the tag info in the actual files, so there would have to then be a mass tag updating.

Plus, I would think a spell checker would return more errors than would be helpful when dealing with band\album names and the like. Not to mention that sometimes, an artist just plain chooses to spell things wrong.
Logged

David

  • Guest
RE:Export Library to MS Excel or .CSV (Plug-in or part of MJ)
« Reply #2 on: September 16, 2002, 09:13:18 am »

That is actually what I am currently doing.  I export the entire library as a playlist in HTML then open it in Excel and run the check.  I've got the custom dictionary all setup so that the spell check is relatively quick and painless.  

The part that is an absolute pain is fixing the tags manually.  

It would be sooooo very easy if I could just export it to .csv and import the corrections back again.

David
Logged

JimH

  • Citizen of the Universe
  • *****
  • Posts: 7604
  • Miller drives a tall-masted tractor on the ocean
RE:Export Library to MS Excel or .CSV (Plug-in or part of MJ)
« Reply #3 on: September 16, 2002, 09:30:49 am »

Export works, import doesn't.

If you turned "track changes" on in Word, it might give you a list you could enter by hand.
Logged
Jim Hillegass
JRiver Media Center / Media Jukebox
Pages: [1]   Go Up