AnsweredAssumed Answered

Can someone provide and example of an XML format to import excel into AF?

Question asked by joshp on Mar 25, 2020

Here is what I have for a schema:

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AF-data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

<record>
<source>\\ITHCTRLHIST1\AF</source>
<site>ZFS ITHACA SOY PLANT</site>
<dept>PREP</dept>
<area>BEAN CLEANING</area>
<equipment>DC-20100 - SOYBEAN DRAG (FROM STORAGE)</equipment>
<component>01) DOWNTIME</component>
<failuremode>01) Mechanical Downtime</failuremode>
</record>

 

<record>
<source>\\ITHCTRLHIST1\AF</source>
<site>ZFS ITHACA SOY PLANT</site>
<dept>PREP</dept>
<area>BEAN CLEANING</area>
<equipment>DC-20100 - SOYBEAN DRAG (FROM STORAGE)</equipment>
<component>01) DOWNTIME</component>
<failuremode>01) Electrical Downtime</failuremode>
</record>

 

</AF-data>

Outcomes