The Data Plug-in adds more flexible import and export possibilities to Servoy via scripting.

With this version of the Plug-in you can work with:

• CSV (comma delimited) files
• DBF files
• XML (native) files
• TXT (tab delimited) files
• QuickBooks contacts
• Excel files (update and new)
  

Exporting data can be done from a 2D array (arrayname[][]), a dataset or a foundset

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.

It is not only possible to read and write an Excel sheet as an array of data but it is also possible to update an Excel sheet.
When using the readWorkBook and writeWorkBook methods it is possible to read and write a single cell, without touching/removing the available formatting and functions.
Since version 3.3 it is also possible to create a new Excel sheet with (limited) formatting properties.

The Plug-in 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.

• To script the import of data.
• To script the export of data.
• To import data fast.
• To automatically type cast (convert the import & export) data.

In fact whenever a user needs to import data on a regular basis the Data Plug-in will be a great help.

		Smart client	Web client	Headless client
3.x.x	1.5 +	1	1	1
4/5	1.5 +	1	1	1
1 Use version 3.x of the Data Plug-in for Servoy 3.x.

When you start using one or more of our Plug-ins and Beans, Free or Commercial, you need to install them into your Servoy Application Server directory.

To avoid surprises and stress during (or after) the installation process we advise you to read the below instructions, watch the video's and import the sample solution.

Servoy 4 Eclipse
Installation of our Plug-ins and Beans is done by making use of our IT2BE Manager tool.
IT2BE Manager can be used to manually install, uninstall, upgrade, downgrade, archive and unarchive all our Components.
To get a full understanding of IT2BE Manager you can read more about it in the Manager Manual.

Written Instructions for Installation and a License request are available in the above manual.

After installing our Components you can find our sample solutions in the ~/application_server/solutions/it2be-examples folder.
You can also download the sample solutions from the Downloads section.


Servoy 3.x
To make the installation and update process of our Plug-ins and Beans as easy as possible we have developed the Update Manager.
The Update Manager is also what you will actually download and install before you can really install a Plug-in or a Bean.
To get a full understanding of the Update Manager you should read the documentation.

The documentation can be downloaded from the Downloads section.
Installation instructions are available in our Knowledgebase in the category Frequently Asked Questions

You can find our sample solutions in the ~/solutions folder.

License Agreement
Use of our plug-ins and beans is always subject to our Terms and Conditions and License agreement that accompany the components.
The agreements may also be found here and here.
To use the Plug-ins and Beans you need a valid license (Trial license or otherwise).

Licenses for Servoy 4/5
New Customers
To install our Components for Servoy 4/5 you need our IT2BE Manager Application that you can download from the downloads section.
We suggest that you also read our IT2BE Manager Manual that you can download here.
.
Returning Customers
To update or upgrade our Components for Servoy 4/5 you need our IT2BE Manager Application that you can download from the downloads section.
We suggest that you also read our IT2BE Manager Manual that you can download here.
.
License files:
When you sent your request the confirmation email that you receive will include 2 files.
The .xml file is the file that contains your Developer License Key. You need to import into your Servoy Developer environment (see above instructions). You are never allowed to deploy your Developer License.
The .txt file contains a license string for each Component. The license string should be included in your Servoy Solution before you call the Component for the first time.

Licenses for Servoy 3.x
New Customers:
If you have not already purchased an IT2BE Plug-in or Bean License,
go to the download section to download the Installer for the Update Manager.
Run the Installer and install the Update Manager in the Servoy directory of your choice.
Start Servoy Developer and navigate to 'Tools/IT2BE Update Manager'.
Check the "Update" checkbox for the IT2BE Plug-in(s) and/or Bean(s) of your choice.
Select the "Update" button and wait for the Component(s) to download.

Returning Customers:
If you have already purchased an IT2BE Plug-in or Bean License, go to the contact pages to apply for an IT2BE Trial License - doing so will prevent any conflict with existing IT2BE Component Licensing.

License jars:
For each component you will receive 2 license jars. These jars are loaded into the it2be-developer and it2be-runtime subfolders under the plugins folder of Servoy.
The ${product}-developer.jar license jar is there for your development environment. You are never allowed to deploy these license jars.
The ${product}-runtime.jar license jar is the jar you are allowed to deploy when your license grants you these rights.

Developer Manual:
Don't forget to read the IT2BE Developer Manual.
You can find it in the ~/docs folder (after downloading the installer) or you can download it here.

How to buy a license
After clicking the button of your selection you will be brought to the secure website of Share*it.
Here you can add the Component to your shopping cart and continue shopping or check out to do your payment.
After your payment you will receive a confirmation email and we will send you the license files as soon as possible. Normally within 2 working days.