I'm running Coppermine version 1.4.21 with Apache 2 on a Ubuntu 8.04 OS. I have a collection of about 5000 images that I've successfully imported into Coppermine. Each of these photos has a unique filename such as 001.jpg, 002.jpg, etc. I'd like to add descriptive information about each of these photos within coppermine. From a previous image program, I have a single XML file that has a description for each of the 5000 images. Is there a way to take the description from the XML file and somehow merge it into the Coppermine description field so that I don't have to manually cut and paste this information for each image? Here is a sample of the xml file:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE GreenstoneDirectoryMetadata SYSTEM "
http://greenstone.org/dtd/GreenstoneDirectoryMetadata/1.0/GreenstoneDirectoryMetadata.dtd">
<DirectoryMetadata>
<FileSet>
<FileName>001.jpg</FileName>
<Description>
<Metadata name="Title">Northington and Bordeaux Cash Grocery</Metadata>
<Metadata name="Filename">1</Metadata>
<Metadata name="Publisher">Huntsville Arts Commission</Metadata>
<Metadata name="Creator">n/a</Metadata>
<Metadata name="Date">1950</Metadata>
<Metadata name="Place">Sam Houston Avenue</Metadata>
<Metadata name="Type">Image</Metadata>
<Metadata name="Description">Northington and Boudreaux Cash Grocery, west side of Sam Houston Avenue, ca. 1950, present day (2003) location of Sam Houston Antique Mall.</Metadata>
</Description>
</FileSet>
<FileSet>
<FileName>002.jpg</FileName>
<Description>
<Metadata name="Title">President's residence, Sam Houston State Teachers College</Metadata>
<Metadata name="Filename">2</Metadata>
<Metadata name="Publisher">Huntsville Arts Commission</Metadata>
<Metadata name="Creator">n/a</Metadata>
<Metadata name="Date">1940</Metadata>
<Metadata name="Place">Sam Houston State Teachers College
</Metadata>
<Metadata name="Type">Image</Metadata>
<Metadata name="Description">President's residence, Sam Houston State Teachers College</Metadata>
</Description>
</FileSet>