Technical FAQs

Ask a Question

Using the VIP XML Import Module to Import Data from an Excel Spreadsheet

Goals and Symptoms

The XML Import Module allows importing of XML data from other applications or data sources for use as real-time numeric registers within the VIP.


A typical application might be to import data from an Excel spreadsheet. This data might represent, for example, scheduled production load for an industrial process. This data would be created by another program, or manually by a corporate manager, and the production manager would be responsible for managing loads to this schedule.


ION Enterprise can monitor real time loads and alarm on limits in order to manage loads, but these limits are typically static, or manually adjusted in most applications.

To manually adjust these limits every day, hour or demand interval would be too cumbersome to manage. This example uses the XML Import Module to parse data from an Excel spreadsheet into the VIP. Once available to the VIP, scheduled alarming and control frameworks can be developed to automate the facilitys load management.


Causes and Fixes

See attached document.


(Removed File URL: 186061_10C2/Using_the_VIP_XML_Import_Module_to_Import_Data_from_an_Excel_Spreadsheet.pdf)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/b3c4c0b588e9fa76c125765d0016212e/fl_block_5/0.5C4?OpenElement&FieldElemFormat=gif)

  • (Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/b3c4c0b588e9fa76c125765d0016212e/fl_block_5/0.308C?OpenElement&FieldElemFormat=gif)

    Original article#12366

    All content © 1992-2007 Schneider Electric

Legacy KB System (APS) Data: RESL186061 V2.0, Originally authored by KBAdPM on 07/03/2007, Last Edited by DaMi on 10/28/2009
Related ranges: ION Programming, ION Enterprise V5.5
Was this helpful?
What can we do to improve the information ?