Hi Everyone,

Just found this forums and have a problem that I hope someone can resolve for me.

I have a large collection of music which I have been using on a media centre for a while now, but its time to upgrade and update to a newer player, and thats the problem, the old player appears to have RIPPED CD's to the hard drive but named them funny and stored the correct name details and metadata in an XML, so when I now look at the new player I get file name such as AD1346.mp3 instead of the song name which with so many songs is impossible to go through manually.

XML File is like:-


13046

the 13046 is the file name but in reallity the file is called A0013046.mp3

I am looking for somesort of way of getting a rename program to look at this XML, update the filename and metadata to the correct format for a media player

Any Idea's would be greatly appreciated

Chris

Microsoft supplies an object which allows you to extract the information from an XML file. You will need to use VBScript.

Code: [Select]Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.async = False
xmlDoc.load("c:\temp\Songs.xml")

Set colNodes = xmlDoc.getElementsByTagName("Song")
For Each node In colNodes
Set objNamedNodeMap = node.attributes
artist = objNamedNodeMap.getNamedItem("Artist").text
title = objNamedNodeMap.getNamedItem("Title").text
srchArtist = objNamedNodeMap.getNamedItem("SearchArtist").text
srchTitle = objNamedNodeMap.getNamedItem("SearchTitle").text
style = objNamedNodeMap.getNamedItem("Styles").text

For Each child In xmlDoc.documentElement.childNodes
filename = xmlDoc.getElementsByTagName("Audio").item(0).text
Next

WScript.Echo "Artist-" & artist
WScript.Echo "Title-" & title
WScript.Echo "Srch Artist-" & srchArtist
WScript.Echo "Srch Ttirle-" & srchTitle
WScript.Echo "Style-" & style
WScript.Echo "Filename-" & "AD" & filename
Next

The snippet is simply a template. It is based on the information that was posted. It might need tweaking if the XML file has more nodes than posted. I put your song xml data into a file called songs.xml for testing purposes.

There is also a downloadable object named CDDBControl.dll (Google can find it) that can be used to extract the metadata from the music files. Assuming the metadata was updated, this could be used in a Vbscript not using the xml file.

Good luck.


Hi,

Sorry I think I have been missunderstood, the XML File already exists with this data, the problem is that the music files as they are do not include this info, ithey are named things like AD00001.wma, the progeam I have then looks at the XML file to get the artist data etc.

I am looking for a way to reverse this so need something to look at the XML file to get the information, then inject it into the appropriate music file, something like:-

It looks into the XML File and get this:-


13046

Then with this info it looks for music file called AD0013046.wma and renames to artist-song.wma and injects the info also into the file properties for it if this makes sence.

The details in the XML are as above for them music, is it was a small amount I would have done manually, but with 21k I was thinking there has to be a better way

Thanks.1. What is it you want help with, parsing the xml file, or "injecting" the metadata into the wma file? (do you mean tagging it?) Or both?

2. How was the xml file produced? By some program? What is its name?

3. Is each music file associated with 2 lines in the xml file thus:

[line 1]
[line 2] 13046


Hi,

I have the XML Data with all the names and music info layed out as


13046

There are currently 21k files named AD00001.wma up to just below 21k which as missing this info, what I am looking to do is take the information from this XML file and inject it into the music files.

I am looking to use a program called Media Maestro LSX which Can take info from Media Player and Itunes to create a home jukebox, but as it stands media player does not know what these music files are due to the data being held in seperate files, so I need a way to get this info back into the files.

ThanksQuote from: chrism on November 20, 2011, 05:01:33 AM

it looks for music file called AD0013046.wma