I'll try to explain this in detail so that it's easily understood. I sure could use some other eyes on this folks. I need help figuring this one out. Here is the project...

We have your basic Windows 2003 server environment with XP Pro on the workstations. I'm using a program called Tag. Yes I know this site did not develop tag but I'm hoping that this post will get you thinking and hopefully some of you might like the challenge of helping a fellow developer figure out a technical problem.

We have mp3's that all have some specific tags based on date and title for example. They would need to change dynamically on the fly without human intervention. Here is a generic list of tags we typically use.

--artist "Company Name Here"
--title "My Test Title"
--year "2006"
--genre "News or whatever here"
--comment "This is a test comment"

The TITLE, GENRE AND COMMENT would need to change dynamically. The rest are fixed and generic and dont need to change. I have different folders. For example:

C:\Audio\Tagged\Folder One
C:\Audio\Tagged\Folder Two
C:\Audio\Tagged\Folder Three

I have the tag.exe and batch files in C:\Program Files\Tag folder. Here are the batch files I use.

test1.bat

for /f "tokens=1-4 delims=/.- " %%A in ('date /t') do (set Dow=%%A&set MM=%%B&set DD=%%C&set YYYY=%%D)
tag C:\Audio\Tagged\*.mp3 --artist "Company Name Here" --year %YYYY% --genre "News" --title "Some kind of title here" --comment "This is a test comment"

mp3tags.txt (flat file that contains the tags)

--artist "Company Name Here"
--title "My Test Title"
--year "2006"
--genre "News or whatever here"
--comment "This is a test comment"

http://www.flickr.com/photos/ericowens_photography/ (when you get here look for a screen shot of an MP3 Tag toward the bottom.

So if I want this program to run (without human intervention) and put the tags that pertain only to those mp3's that need them how would I do this?

Example: C:\Audio\Tagged\Folder One\test1.mp3 needs...

--artist "Company Name Here"
--title "Specific Title of it's own here"
--year "2006"
--genre "Specific genre of it's own here"
--comment "This is a test comment"

Can this be done with VB Script and if so I need help writing it out. Can SQL Server be used to store the data but then call the script which then executes the Tag.exe program?

Please anyone's thoughts on this would be greatly appreciated.

Thanks in advance

There seems to be many ways that you could do this, depending on your skillset and resources.

I'm at a loss as to what you are really trying to achieve though. How is the title and genre detirmined for each track? Are new tracks periodically created which then need all tags added, or do you have the same MP3 files that need their title and genre changed periodically for some reason?

I'm assuming that you will need 1. a database, 2. an application or script, and 3. a scheduler (possibly part of 2), but without really understanding your requirements, resources, or skills, I don't feel as though I can help any further.

Edit: FYI, an easy way to upload images (rather than ruin your superb photo collection) is to use a service like http://imageshack.us/ .