Accessing database to retreive tag info -Sound Forge - Scripting

Subject:Accessing database to retreive tag info Posted by: jzimmerman Date:7/9/2010 2:49:38 PM Hi, Just a warning, this question requires a bit of exposition before I can get to what I'm actually needing to do. We have a collection of some 3000 or so albums/performances/interviews that have over the years have been digitized and stored away on a file server, mainly as an archive. They now want to use many of these files to stream to patrons in our library. As it has been explained to me, when this project originally began, tags were not really around in the way they are now, hence every album and song is named with what is essentially an id that corresponds with data that now resides in a Microsoft Access database. They never updated how they were doing things. I have been tasked to come up with some relatively easy way to convert the files from their format to real media files that stream easier and to create .ram files while at the same time creating the folders on the new server and putting in tag information for every song. I've figured out how to do pretty much everything except for figuring out how to easily pull the information from the database. The problem is that the only way I have found to do this in C# requires using the System.Data namespace which Sound Forge does not seem to have in its library since it throws an error saying: "The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)" I'm fairly new to both .net and c# so I'm not entirely sure whether it is possible to do this in Sound Forge or if I will have to do something outside of Sound Forge's scripting and I have found nothing, after 4 hours of searching, that would tell me which is correct. It would certainly make my life easier if there was a way to do this in a script for Sound Forge.
Subject:RE: Accessing database to retreive tag info Reply by: ExSonyTJ Date:7/12/2010 10:27:59 AM Sound Forge does not link scripts to the System.Data assembly/namespace, but you can request that it does by adding a config file for your script. If your script is data.cs then create a file called data.cs.config and add an AssemblyReference for the assembly you want to use. If the assembly is global or you are providing a full pathname for the assembly, then set IsLocal to false, if the assembly is in the same folder as your script, and set IsLocal to true. <ScriptSettings> <AssemblyReference IsLocal="false">System.Data.dll</AssemblyReference> </ScriptSettings>
Subject:RE: Accessing database to retreive tag info Reply by: jzimmerman Date:7/13/2010 12:49:23 PM Thanks a bunch, that worked like a charm.

Hi,
Just a warning, this question requires a bit of exposition before I can get to what I'm actually needing to do.

We have a collection of some 3000 or so albums/performances/interviews that have over the years have been digitized and stored away on a file server, mainly as an archive. They now want to use many of these files to stream to patrons in our library. As it has been explained to me, when this project originally began, tags were not really around in the way they are now, hence every album and song is named with what is essentially an id that corresponds with data that now resides in a Microsoft Access database. They never updated how they were doing things.
I have been tasked to come up with some relatively easy way to convert the files from their format to real media files that stream easier and to create .ram files while at the same time creating the folders on the new server and putting in tag information for every song.

I've figured out how to do pretty much everything except for figuring out how to easily pull the information from the database.

The problem is that the only way I have found to do this in C# requires using the System.Data namespace which Sound Forge does not seem to have in its library since it throws an error saying: "The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)"

I'm fairly new to both .net and c# so I'm not entirely sure whether it is possible to do this in Sound Forge or if I will have to do something outside of Sound Forge's scripting and I have found nothing, after 4 hours of searching, that would tell me which is correct. It would certainly make my life easier if there was a way to do this in a script for Sound Forge.