[Announcement] Data Plug-in 50% discount until June 30

Classic Servoy
1

Starting today our Data Plug-in will be available with a 50% discount on all licenses (including upgrade licenses) until the end of June 2011.

What can you do with the Data Plug-in:
The Data Plug-in allows you to read, write and manipulate Excel spreadsheets into your Servoy solution without needing Microsoft Excel.

Since version 3.3 it is also possible to create a new Excel sheet with formatting properties.

With a so called ‘FormattedDataset’ you can:

set cell formatting
set column formatting
set borders
add formula’s
etc.

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.

Additional to reading, writing and updating Excel files you can also you can work with:

CSV (comma delimited) files
DBF files
XML (native) files
TXT (tab delimited) files

You can find more information about the Data Plug-in on our website: Servoy Plugins: Largest provider of Servoy Plug-ins! Commercial & Free plugins.

How do you buy the discounted license :
To buy licenses you select the tab ‘Buy Now’ and select the ‘Buy Now’ button that represents the license of your choice.
This will bring you to our store (powered by Share-it!).

When you select the ‘Add to cart’ button you can continue shopping ( please do so :) ).
When you select ‘Buy now !’ you are brought to the ‘Customer Information’ page. Here you can also add the Coupon Code ‘JUNEPROMO’.

The Coupon Code will give you a 50% discount on all licenses for the following Servoy components:

Data Plug-in
DDE Plug-in
Exchange Plug-in
LDAPclient Plug-in
Outlook Plug-in
Word Plug-in

The discount does not apply to the subscription fees!

I sure hope you like this deal!

2

Including today you have another 3 days to decide what Plug-in(s) you want to buy using our discount offer.

You can buy licenses for our Data Plug-in, DDE Plug-in, Exchange Plug-in, LDAPclient Plug-in, Outlook Plug-in and Word Plug-in with a 50% discount until the end of June 2011.

3

Hi Marcel.

I’m thinking about creating a utility to let the users download a copy of their data. It is an application in the cloud and I just want to send each tenant their own data in DBF format. Does the plugin create the DBF estructure or it must exist? Could you show me an example?

Thanks.

4

The Plug-in creates the DBF structure.

The best thing you can do to make sure you make the right decision is to download the Plug-in and a trial license (both using our Components Manager) and run the sample solution that is included.

A piece of code taken from the sample solution is below.

I hope that this helps :)

function button_write_dbf()
{
	//Get a dataset based on a query on the example (crm) database
	//and it2be_companies/contacts tables
	var query = "SELECT c.firstname, c.lastname, o.company_name, o.description FROM it2be_contacts AS c, it2be_companies AS o WHERE c.it2be_companiesid=o.it2be_companiesid";
	var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, null, 1000);

	if (!dataset.getMaxRowIndex()) {
		plugins.dialogs.showErrorDialog("Error...", "There are no records!", "OK");
		return;
	}
	
	var file = plugins.file.showFileSaveDialog();

	if (file) {
		var filename = file.getAbsoluteFile();
		var header = ["firstname", "lastname", "company", "description"];
		var selection = new Array();
		for (var i = 1; i <= dataset.getMaxRowIndex(); i++) {
			var row = dataset.getRowAsArray(i);
			selection[i - 1] = row;
		}

		filename = plugins.it2be_data.dbf().write(filename, header, dataset);
	}
}