SetActivityDetailByExcelInput
Description
The timer SetActivityDetailByExcelInput reads an Excel-sheet and manipulates process definitions accordingly. The Excel-sheet can contain the following columns: "Nr.", "Duration", "Resourcesnames", "Start", "Will be informed", "Description". All activity names of the process definition which can't be matched to a line in the Excel-sheet and all lines and the Excel-sheet that couldn't be matched to an activity will be emailed to the address from parameter 3.
Column Name | Explanation |
|---|---|
Nr. | Matching from line to activity. |
Duration | Estimated time to completion (in days). |
Resourcesnames | Email address of the system user to whom all found activities will be assigned. |
Start | The desired starting date. It can be further used in conjunction with the https://tim-doc.atlassian.net/wiki/pages/createpage.action?spaceKey=EN&title=SetMilestonesFromDateFromTaskDescription. |
Will be informed | If an activity is followed by a mail activity with the same name, this mail will be sent to the address in this column. |
Description | All found tasks will receive the description provided in this column. |
Â
The timer will read the first Excel file found in the provided directory.Â
It is important, that all content of the Excel sheet is formatted as text.
Webservice Name
NodeManagerWebservice Method
setActivityDetailByExcelInputÂ
Parameter
Parameter | Description | Valid examples |
|---|---|---|
Definitionsname | A Name of the process definition. |
|
Path | Path to the folder where the Excel-sheet is located. |
|
Email address which will be used for mail activity etc. |
Â
Example
© TIM Solutions GmbH | AGB | Datenschutz | Impressum