Generating a UDTT operation from Excel file

Development tools : Transaction editor : Generating a UDTT operation from Excel file

You can follow this task to create an Operation with Context, Format and Service from an Excel file.

Prerequisites

▪ Prepare the restrictly-structured Excel file. Refer to the sample file from installation package/exceltemplate. Make sure your Excel file has the same structure.

▪ Prepare the type mapping file, and put it in the root directory of your project.

For more information about the generator and how to extend your own generator, see Generator from Excel to Operation.

Procedure

1 Copy the Excel file into the target project.

2 Right-click the project, and then click BTTTools > SDO wizard (XML over HTTP).

3 Select the Excel file, and then select the operation which you want to parse. Each time you can generate only one operation.

This graphic is described in the surrounding text.

4 Either specify the Operation package and class, or keep the default configuration.

▪ The default Operation Package is 'definitions.operations'. To use a different package, click Browse.

▪ The default Implemen Class of Operation is com.ibm.btt.base.BTTServerOperation. To use a different class, type its name or click Browse.

5 If you want service in operation, select Enable Service, and then set the properties of the service.

▪ Select Service Method from two kinds: POST and GET. The default is POST.

▪ Enter the URL.

▪ The default Service Class of Operation is com.ibm.btt.base.Server. To use a different class, type its name or click Browse.

Result

Check the Operation Package. There will be generated transaction file and xml file. Data, Context, Format and service are defined in the transaction file.