Excel to activity
Create activities using values from an Excel spreadsheet. You can download this system service from Grexx Marketplace.
This is a composite system service that consists of the following system services:
Input
Use a casetype activity to add inputs to the Start Systemservice Excel to activity form.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| Activity ID | Case ID | Yes | ID of the activity to create. |
| Case ID of activity | Case ID | No | Case on which the activity should be performed. Default: current case ID. |
| Column without header prefix | String | No | If First row contains headers is false (see below) columns are provided with a header automatically. This header consists of a prefix and a sequence number (for example, column_1, column_2...). Default: column_ |
| File | File | Yes | Excel file containing the activity details. |
| First row contains headers | Boolean | No | Default: false |
| Keep empty lines | Boolean | No |
In order to map data from the Excel sheet to the correct attributes on the activity form, attributes must be given an external reference that matches a column name from the first line of the Excel sheet. If the Excel sheet does not contain any column names and therefore the field First row contains headers is false, an attribute can still refer to an Excel sheet column by using the standard external reference: column_1, column_2, column_3 etc. When you create or edit an attribute, you can specify the external reference under Advanced.
Output
Outputs are added to the Result Systemservice Excel to activity form when the Systemservice Excel to activity case is closed.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| Error message(s) | String | No | Result message(s). |