New Data plugin available

Classic Servoy
1

IT2Be is proud to announce the immediate availability of the Data plugin. A (trial) license is available at Servoy Components – Plugins, Beans, Web Components, Angular Services & Servoy Developer Consulting

The Data plugin adds import and export possibilities to Servoy via scripting.

With this first version of the plugin you can work with:
CSV files
DBF files
Excel files
XML files
Exporting data can be done from a 2D array (arrayname) or a regular dataset taken from the function databaseManager.getDataSetByQuery(server, query, input, rows).

The header can be retrieved from the input dataset or set seperately via an array. Convenient to create logical headers to the user or use i18n headers.

Importing data returns a 2D array or a (again) a regular dataset.

The plugin also implements a function to execute a query on a database/table without the need of an available form. The function uses a server connection created in the Servoy preferences. There is no need however to enable the server.

2

Great Wo(r)k, Marcel

This part

the plugin also implements a function to execute a query on a database/table without the need of an available form. The function uses a server connection created in the Servoy preferences. There is no need however to enable the server.

could do with a bit more explanation.

Why ? To UPDATE over a non-enabled server connection ? To export from a non-enabled server? Why would you do something like this ?

3

In my case I use this function to interface with a database of third party solutions that are not necessarily part of our solution. Normally you would have to build a form to perform inserts, updates, deletions etc on a table in such database. With this function not anymore.

The reason it is hardly documented is that, while I was polishing it to work, Servoy launched their rawSQL plugin which does appr. the same as this function.