Is it possible to write a script that pulls data from an Excel file? I usually get data from an xml file (or through DB Dips via ODBC) but am not sure if it's the same process for getting data from an excel file. Is this even do-able?
Also, I heard that pulling or writing data to an xml file that resides outside of the IPCCX server is no longer supported? This true? I know some of these might not be do-able anymore in 8X but am curious about 7X for now.
Microsoft Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format.Excel 2007 usesOffice Open XMLas its primary file format, an XML-based format that followed after a previousXML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.
So perhaps the newer versions can be read via XML, but I have not personally tried this.
As for reading documents off other servers, hosting them via a web service is always a clean solution:
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.