Convert XAF to Excel

This article illustrates how to create an Excel workbook containing the contents from one or many Dutch XML Audit Files (also known as “XAF“ files) using Invantive Runtime.

Instructions

Follow the steps below to create an Excel workbook:

  • Read and approve the agreement.
  • Place all XAF files to use in a folder or folder hierarchy.
  • Open the database group “XML Audit Files“ (red 1 in picture below).

  • Choose the XAF version of your files (red 2).
  • Specify the folder as “XML Directories“ (red 3). Multiple folders can be specified, separated by a comma.
    For example, when you have a single XAF file c:\temp\xaf\Auditfile-31-2020.xaf, use the folder c:\temp\xaf as value for “XML Directories”.
  • Click on “Connect“ (red 4).
  • A number of XAF plug-ins are automatically installed in %USERPROFILE%\\invantive\\plugins.
  • A list of plug-ins is shown in the screen.
  • Choose the plug-in with a name starting with “Extract contents“ (red 5):

image

  • Choose the output folder (red 6):

image

  • Execute the conversion (red 7).
  • The output is stored as one table per data sets (red 8):

image