Tech Tip

If you are using UniVerse or UniData, did you know you can create XML data using your standard LIST and SELECT statements?

LIST CUST NAME ADDRESS PHONE ID-SUPP TOXML

Will create the following:

<?xml version="1.0"?>
<ROOT>
<CUST>
<NAME_MV NAME = "International Spectrum"/>
<ADDRESS_MV ADDRESS = "80 Garden Center, Suite 6"/>
<PHONE_MV PHONE = "720-259-1356"/>
</CUST>
<CUST>
<NAME_MV NAME = "Nathan Rector"/>
<ADDRESS_MV ADDRESS = "Unknown"/>
<PHONE_MV PHONE = "999-999-9999"/>
</CUST>
</ROOT>

If you sent this to a Spooler Hold File, and then copied it out to .XML windows file, you would be able to open the your data in Excel.