Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
68 lines (48 sloc) 2.42 KB

#QAFE Book

qafelogo

Importing data into a datagrid

In the datagrid component, there is a possibility to import data from a CSV file. In this how-to, we will explain how to do that.

Creating a datagrid

In QAML, first create a datagrid in the presentation tier. As seen in the example below, we have a button and a datagrid with 2 columns defined in a verticallayout

On the datagrid we see a multitude of attributes where the following two are used to determine import behaviour.

  • import - allow importing of data into the datagrid
    • possible values are "true" and "false". The default value is "false"
  • import-action - specifies if the imported data needs to replace existing data, or be appended.
    • possible values are "set" and "add". The default value for this attribute is "set".
<application-mapping xmlns="http://qafe.com/schema"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://qafe.com/schema http://www.qafe.com/schema/application-mapping.xsd">
	<presentation-tier>
		<view>
			<window id="window1" displayname="Hello World" width="500"  height="700">
				<rootpanel id="myRootPanel" width="400" height="300">
					<verticallayout>
						<button id="loadDataBtn" displayname="Load data" />
					    <datagrid id="datagrid" import="true" import-action="add">
					    	<column displayname="id" name="ID" id="idCol"/>
					    	<column displayname="name" name="NAME" id="nameCol" />
					    </datagrid>
					</verticallayout>
				</rootpanel>
			</window>
		</view>
	</presentation-tier>
</application-mapping> 

The code above will result in the following output: datagrid

Importing data

To import data, have a CSV file ready to be imported. Note that the datagrid component tries to match headers in the CSV to the name attribute in the column definition, so they should be the same.

An example of a valid CSV would be:

ID;NAME

10;apple

11;pear

12;orange

13;banana

14;pineapple

The delimiter is configurable during runtime of the QAFE application.

When importing the CSV, depending on the import-action attribute on the datagrid, the data will either be set (meaning that the existing data will be overidden) or appended.

If the import-action is not specified, but import is set to "true", the data will be set by default.

You can’t perform that action at this time.