Good day, All.
I searched the forums but didn't seem to have the right keywords to dig this up. I am also new at XmlMapping so may be I am going about it all wrong.
I am starting with a normal spreadsheet without an XmlMap.
I want to (if this is possible), create an XmlMap and output the spreadsheet as an Xml File.
I wrote a schema but it keeps telling me that the sheet is not exportable with my schema.
Anyway, I am starting with hundreds of lines of data in a spreadsheet with No XmlMap. Is it possible (and how do I do it) to create an XmlMap and export my spreadsheet.
Spreadsheet is like this
FieldName,FieldValue,Flag,Dcn,Notes
as the columns and there are about 500 rows.
I built the schema to ignore Notes, because I don't need to export it.
I tried this schema: (Added using the Xml Source Task Pane and dragging elements to the column headers (first row contains column names.)
<?xml version="1.0"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<element name="Root">
<complexType>
<sequence>
<element name="Row" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="Field" type="string" />
<element name="Value" type="string" />
<element name="Flag" type="string" />
<element name="Dcn" type="string" />
</sequence>
</complexType>
</element>
</sequence>
</complexType>
</element>
</schema>
but it failed to export because it is not exportable. Where am I going wrong and is there a good link to a nice tutorial? I keep finding lots of tutorials on how to go from Xml to Spreadsheet but not the other way.
Thanks for any responses.
Patrick
I searched the forums but didn't seem to have the right keywords to dig this up. I am also new at XmlMapping so may be I am going about it all wrong.
I am starting with a normal spreadsheet without an XmlMap.
I want to (if this is possible), create an XmlMap and output the spreadsheet as an Xml File.
I wrote a schema but it keeps telling me that the sheet is not exportable with my schema.
Anyway, I am starting with hundreds of lines of data in a spreadsheet with No XmlMap. Is it possible (and how do I do it) to create an XmlMap and export my spreadsheet.
Spreadsheet is like this
FieldName,FieldValue,Flag,Dcn,Notes
as the columns and there are about 500 rows.
I built the schema to ignore Notes, because I don't need to export it.
I tried this schema: (Added using the Xml Source Task Pane and dragging elements to the column headers (first row contains column names.)
<?xml version="1.0"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<element name="Root">
<complexType>
<sequence>
<element name="Row" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="Field" type="string" />
<element name="Value" type="string" />
<element name="Flag" type="string" />
<element name="Dcn" type="string" />
</sequence>
</complexType>
</element>
</sequence>
</complexType>
</element>
</schema>
but it failed to export because it is not exportable. Where am I going wrong and is there a good link to a nice tutorial? I keep finding lots of tutorials on how to go from Xml to Spreadsheet but not the other way.
Thanks for any responses.
Patrick