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

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

NodeManager

Webservice Method

setActivityDetailByExcelInput

 

Parameter

Parameter

Description

Valid examples

Parameter

Description

Valid examples

Definitionsname

A Name of the process definition.

  • MyProcessName

  • 8D Problem Solving)

Path

Path to the folder where the Excel-sheet is located.

  • /loom-portal/super-resource/folder

Email

Email address which will be used for mail activity etc.

 

Example