JeffNolan1900
Technical User
Hello.
I have an Access Database, like this.
Name Color Body_Type Age
-------------------------------------------
Dog Red Fat Old
Cat Yellow Skinny Young
Using Access to create the XML file from the data. And Using Tranform, I need to specify the xml template.
I need a tranform (.xslt) file that will result in this format:
<Feature Name="Dog" Color="Red">
<Symbology>
<Body Type>Fat</Body Type>
<Age>Old</Age>
</Symbology>
</Feature>
<Feature Name="Cat" Color="Yellow">
<Symbology>
<Body Type>Skinny</Body Type>
<Age>Young</Age>
</Symbology>
</Feature>
---------------------------------
The Body Type and Age are easy.
<Body Type><xls:value-of select="Body_type"></Body Type>
---------------------------------
The Feature Name and Color is where the problems start.
<Feature Name="<xls:value-of select="Name">" Color="<xls:value-of select="Color">">
I know this is the wrong format, but I just provided it as an example. What is the proper format for something like this? Any suggestions on how to do this?
---------------------------------
Thanks so much.
Jeff
I have an Access Database, like this.
Name Color Body_Type Age
-------------------------------------------
Dog Red Fat Old
Cat Yellow Skinny Young
Using Access to create the XML file from the data. And Using Tranform, I need to specify the xml template.
I need a tranform (.xslt) file that will result in this format:
<Feature Name="Dog" Color="Red">
<Symbology>
<Body Type>Fat</Body Type>
<Age>Old</Age>
</Symbology>
</Feature>
<Feature Name="Cat" Color="Yellow">
<Symbology>
<Body Type>Skinny</Body Type>
<Age>Young</Age>
</Symbology>
</Feature>
---------------------------------
The Body Type and Age are easy.
<Body Type><xls:value-of select="Body_type"></Body Type>
---------------------------------
The Feature Name and Color is where the problems start.
<Feature Name="<xls:value-of select="Name">" Color="<xls:value-of select="Color">">
I know this is the wrong format, but I just provided it as an example. What is the proper format for something like this? Any suggestions on how to do this?
---------------------------------
Thanks so much.
Jeff