Monthly Archives: September 2009
Export to Excel / CSV
2Excel on Apache Tomcat Server «·····» 2CSV on .NET Server «·····» Other formats Export to Excel on Apache Tomcat Server Luca Spinelli and Ivan Aguilar from ClearPeaks (www.clearpeaks.com) introduce users to the new export to Excel solution for Xcelsius using … Continue reading
Compatability warning Excel
When using Excel 2007, it is advisable to save the Excel workbook in Excel 2003 format (.xls instead of .xlsx). When you save an Excel 2007 workbook in an Excel 2003 format, the following pop-up box comes up: Make sure … Continue reading
Where Clause
Flynet: WHERE clause is only for parameters, (inner) joins defined in FROM clause.
Source & Output folder
Flynet: Place source files and output folder of your Webservice directly on c drive and not in a “my documents” folder. (in case use of local host and IIS).
Parameter
Flynet: Webservice parameter stated as “in_” en Direction=”IN” string notation = table.fieldname=’~in_name~’ number notation = table.fieldname=~in_name~ List Number parameter type is string thus WHERE table.fieldname in (~in_name~) [Type = "string", Direction ="IN"].
Insert, update and delete statements
Flynet: Insert, update and delete statements work according to same principle as normal select statement.
