Knowledge Base Article: Convert Excel Worksheet Data to an XML Data File with an XSD Schema

Convert Excel Worksheet Data to an XML Data File with an XSD Schema

General:11

Convert Excel Worksheet XML Data File XSD Schema CSV

HelpMaster > Desktop > Import/export

General

1/16/2019 11:34:49 AM

1/16/2019 12:23:27 PM

Average Rating (from {{model.ratings}} ratings)
0 See Also Links

Applies to

HelpMaster v10 and above.

Summary

In HelpMaster v10 we introduced the ability to import from XML data files that had been converted from an Excel Worksheet using the Microsoft Excel 2003 XML Tools Add-in. The XML data file format is different from the default SQL Raw XML data import format as follows...

SQL Raw XML Example

<Import_Records>
<row Field1="value" Field2="value" Field3="value" Field4="value" />
<row Field1="value" Field2="value" Field3="value" Field4="value" />
<row Field1="value" Field2="value" Field3="value" Field4="value" />
</Import_Records>

Excel Converted XML Using the XML Tools Add-In Example

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Import xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Row>
<Field1>value</Field1>
<Field2>value</Field2>
<Field3>value</Field3>
</Row>
<Row>
<Field1>value</Field1>
<Field2>value</Field2>
<Field3>value</Field3>
</Row>
<Row>
<Field1>value</Field1>
<Field2>value</Field2>
<Field3>value</Field3>
<Row>
</Import>


To convert an Excel Worksheet to the alternate XML format an XML Schema (*.xsd file) also needs to be created in Excel using the XML Tools Add-In. This XSD file is not used by HelpMaster when performing the import procedure, only the finished XML data file (*.xml file) is required using the XML format above. Follow the steps outlined in the Microsoft Office support article below to install the XML Tools and to convert your Excel Worksheet to an XML data file.

https://support.office.com/en-us/article/Create-an-XML-data-file-and-XML-schema-file-from-worksheet-data-E35400D4-0E10-4669-9A50-59A8C57D677E

Further Information

Please contact Microsoft for any further information about this procedure.

Attachments ({{entity.Attachments.length}})