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.

New in Version 2021, the XLSX part import templates now 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.