Integrating XML Documents
Data can be imported into QAD Enterprise Edition from an external customer system in a number of ways:
• In Excel files, using the Excel integration function available for many components. This function is mainly used for static components, such as GL accounts or cost centers (but can also be used for journal entries).
The Excel integration function lets you export existing static components to an Excel spreadsheet. You use the spreadsheet as a template in which to enter new data, and re-import the data as new data objects. For more information on Excel integration, see
Introduction to QAD Enterprise Applications User Guide.
• As XML files, using the XML Daemon or QXtend Inbound functions. This technique is mainly used for dynamic components, such as transactions.
The Excel and XML-based functions convert the imported file to an Enterprise Application business object, such as a business relation or customer invoice, which can then be processed by standard Enterprise Financials applications. The imported file must contain essential data and conform to a set file structure in order to be processed successfully as a Financials business object.
Each component has an XML schema file, which describes the structure of its data. The structure of XML documents must conform to the schema file of the business component to which they will be converted. You must therefore prepare your document carefully before beginning the integration process.