Load Tasks (TASKUPLOAD) - INP/79448
Imports tasks from CSV file.
Field | Required | Format | Example | Description |
|---|---|---|---|---|
ST | No, default is 1 | Status | 4 | Status of the task:
|
TITLE | Yes | Text | Title. | Title of the task. |
DESCRIPTION | Text | Description. | Description of the task. | |
CREATEDBY | Partially yes - may be skipped if it will be able to find employee by name or email | Number | 11111 | The PID of the person who created this task. |
CREATEDBYNAME | Text | John | Used to find CREATEDBY if empty, based on first and last name or email. | |
CREATEDBYFIRSTNAME | Text | Doe | Used to find CREATEDBY if empty, based on first and last name or email. | |
CREATEDBYEMAIL | Text | john.doe@mail.com | Used to find CREATEDBY if empty, based on first and last name or email. | |
ASSIGNEDTO | Number | 11111 | The PID of the person who this task is assigned to. | |
ASSIGNEDTONAME | Text | Doe | Used to find ASSIGNEDTO if empty, based on first and last name or email. | |
ASSIGNEDTOFIRSTNAME | Text | John | Used to find ASSIGNEDTO if empty, based on first and last name or email. | |
ASSIGNEDTOEMAIL | Text | john.doe@mail.com | Used to find ASSIGNEDTO if empty, based on first and last name or email. | |
PRIORITY | Number | 2 | Priority of the task:
When skipped default value is 3. | |
DEADLINE | Datetime - yyyy.mm.dd HH:MM:ss | The date and time the task needs to be done. | ||
ISPRIVATE | Integer | 0 | True if this task is only visible to the creator of the task. 0 - False, 1 - True. | |
CREATEDAT | Datetime - yyyy.mm.dd HH:MM:ss | 2020.02.26 12:09:45 | Date and time when the task was created. | |
COMPLETEDAT | Datetime - yyyy.mm.dd HH:MM:ss | 2020.02.26 12:09:45 | Date and time when the task was set to Status 8 - Done. | |
STARTEDAT | Datetime - yyyy.mm.dd HH:MM:ss | 2020.02.26 12:09:45 | Date and time when the task was started. | |
CREATEDINDB | Text | TEM-NO | The database the task was created in. Default will be database, where loading script was started. | |
COMPLETEDBY | Number | 11111 | Reference to the user (PID) who marked this task as done. | |
COMPLETEDBYFIRSTNAME | Text | John | Used to find COMPLETEDBY if empty, based on first and last name or email. | |
COMPLETEDBYNAME | Text | Doe | Used to find COMPLETEDBY if empty, based on first and last name or email. | |
COMPLETEDBYEMAIL | Text | john.doe@mail.com | Used to find COMPLETEDBY if empty, based on first and last name or email. | |
REGISTEREDTIME | Number | 2.5 | Accumulated hours registered on this task. Decimals separated with dot "." and not comma ",". Time will be automatically registered by person, if present, in following order: COMPLETEDBY, ASSIGNEDTO, CREATEDBY. | |
EXTID | Text | ext123 | Identifier of the task in external system. | |
FOLDERID | Text | 1DC95E30-1E74-15EB-B5CC-758A19ED256B | Folder identifier from external system used to map correct folder in Rambase system. | |
QISACTIONSEXTID | Text | extQis123,extQis456,extQis678 | Identifiers to know what QIS to add new created task to as an action. Actions will be created in quality issues which have this EXTID (also imported to Rambase from external system). Multiple references can be defined in one task, separated by comma - see example. |