XML and XLSX Templates

XFRACAS provides an XML document type definition (DTD) for each type of record you can import or export. These are installed in the "DTD" folder on the web server (e.g., C:\inetpub\wwwroot\XFRACAS\ DTD).

• For descriptions of the XML elements and attributes, see XFRACAS XML Import Business Logic (*.pdf).
• For instructions on how to build an XML template for data mapping, see XFRACAS Data Import Guide (*.pdf).

XML Templates

Below are example files for some of the more common import scenarios. You may be able to save time by downloading and adapting these files to import your own data.

• XFRACASXMLTemplate_PartsExample.xml
• XFRACASXMLTemplate_SerialIncidentExample.xml
• XFRACASXMLTemplate_SimpleIncidentExample.xml
• XFRACASXMLTemplate_UserExample.xml

XSLX Templates

You also have the option to import some record types (parts, issues) from Excel.

Starting in Version 2021, the XLSX part import templates include a “Use Existing” column where you can specify whether to use an existing part or create a new one.

• To use information for an existing part, enter “Yes” in this column. In this case, XFRACAS will search for the part based on the part name and number in the import template.
• To create a new part and add it to the system template, enter “No” (or leave this column blank).

Note: This feature was already available in the XML templates but has been added to the XLSX templates for Version 2021.

• XFRACASImportTemplate_Parts.xlsx
  (XFRACASImportTemplate_Parts_Example.xlsx)

• XFRACASImportTemplate_Issues.xlsx
  (XFRACASImportTemplate_Issues_Example.xlsx)

See Tips for Importing Serialized Systems to learn more about using Excel import templates.

IMPORTANT: In order to use Excel templates, the web server must be configured to recognize the *.xlsx file type. For details, consult the Implementation Guide.

Additionally, when you import an *.xlsx file to XFRACAS, the machine where the source file resides must have Microsoft Office installed. If it does not, you will receive an error notifying you that the content type is not supported.