XML conversion

We use Network Solutions Monster Commerce to host our e-commerce site and they no longer offer an option to export our catalog to specific type of XML Schemas such as the Google Base Schema. They merely offer an export function which allows you to export in CSV or XML. However if I export our 1000+ products to an XML file the field elements names are incorrect and google will certainly reject this file as a valid data feed.

My question is:
is there an easy way to convert my exported XML file that contains all of my products and theres attributes to the google base xml data feed schema (or any xml schema for that matter, such as Shopping.com or Amazon)??

I have tried using Excel 2007 and mapping an XML Map to the work book. (no luck)
I have also tried using Stylus Studio 2008 XML Enterprise using the mapper function (no luck)

Both programs will export the new XML file but only with the first set of records from the source XML file.

Attached code is the google base xml file i want to map and use as a template and the product export xml file (products.txt) is attached and contains a few products that i chose to export as an example.

I know I am missing something really simple and and I know this can be done alot easier than the route I am taking. I am just really frustrated at this point!! HELP!
Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:

[gbase.xml]
 
<?xml version="1.0"?>
<rss xmlns:g="http://base.google.com/ns/1.0" xmlns:c="http://base.google.com/cns/1.0" version="2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <channel>
    <title>Product Catalog Data Feed</title>
    <link>http://www.domain.com</link>
    <description>www.domain.com product feed for Google Base</description>
    
	<item>
      <title></title>
      <description> </description>
      <link></link>
      <g:brand></g:brand>
      <g:condition></g:condition>
      <g:image_link></g:image_link>
      <g:label></g:label>
      <g:manufacturer></g:manufacturer>
      <g:manufacturer_id></g:manufacturer_id>
      <g:model_number></g:model_number>
      <g:price></g:price>
      <g:product_type></g:product_type>
      <g:quantity></g:quantity>
      <g:weight></g:weight>
      <g:suggestedretailprice></g:suggestedretailprice>
      <g:informationlink></g:informationlink>
    </item>
 
	  </channel>
</rss>
 
[/gbase]