|CITS–XML||CITS–XML Demo spreadsheet||Application Note AP8523|
CITS–XML – Using XML files from suitably configured ERP system outputs to set up CITS test programs.
CITS customers are increasingly wishing to generate CITS test files direct from their ERP systems. This note for IT and test professionals describes the CITS XML test file format – it generates a sample file for proof of concept to guide you on the way to generating your own outputs from an ERP system – thus avoiding the need for manually setting up the CITS test file for each new job.
You should have a working programming knowledge of XML and your ERP system and access to a test engineer with knowledge of how to set a CITS for impedance test in order to interface with your company's ERP systems.
Applicable to: CITS880s version 18:05 and upwards
From CITS Version 18:05 provision is provided for it to read a simple XML file that describes the parameters for 1 (or many tests), thereby giving the ability to import tests from another system. When CITS is installed, documentation describing the structure of the XML file is also installed in the CITS installation root directory (e.g. C:\Program Files (x86)\Polar\CITS880s). This includes a PDF called "Notes on use of Polar XML Interface for CITS", a Test.xml file and a TestXML.cif file.
This AP note elaborates on the contents of the PDF file and provides a sample Excel macro driven spreadsheet to compile and save a single Test XML file.
Each section should be terminated with the appropriate </Tag Name> format.
As the Notes on use of Polar XML Interface for CITS PDF states a simple (but fundamentally useless) XML may look like this :-
<?xml version="1.0" encoding="UTF-8"?> <PolarXML> <Header></Header> <Setup></Setup> <Setup></Setup> <Setup></Setup> </PolarXML>
The above XML file would create 3 empty tests and could be imported into CITS using the File | Open XML File menu. Each section can then have multiple options as defined in the Notes on use of Polar XML Interface for CITS PDF. It is not necessary to use all the described options, only those that are required to define a Test. Any options not explicitly defined will take their default values from the Test Setup Editor (press the Insert key) or the Utilities | Config | General | Edit Default Test.
The downloadable CITS-XML spreadsheet displays the allowable options under each section, lists the criteria for each as a comment against the defined option and also as a double-clickable action on each entry cell where the option to the left has a comment. A double click will open a form with the comment for each option - this makes it easier to read when entering data.
Clicking the Create XML Code button will compile the list of options entered into a XML formatted list under a worksheet called XML.