Navigation:  Integration via database > Published interfaces > Kanban >

TSKTASKINSERT – Create task

Previous  Top  Next

This import template makes it possible to insert:

Kanban tasks.

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert/Edit

Column

Required

Type

Precision

Description

OIDINTERFACE

X

TEXT

32

Sequential code - Identifies an item to be imported into SoftExpert Suite.

FGIMPORT

X

NUMERIC

2

Import status:

1 – New;

2 – In progress;

3 – Finished;

4 – Error;

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

275 – Code of component SoftExpert Kanban.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 – Insert task;

2 – Edit task.

NMFIELD01

 

TEXT

255

Task ID #: composed of the workspace prefix and the task order.

NMFIELD02

X

TEXT

255

Workspace prefix

NMFIELD03

X

TEXT

255

Task type

NMFIELD04

X

TEXT

255

Priority

NMFIELD05

X

TEXT

255

Title

NMFIELD06

 

TEXT

255

Deadline. Must be entered in the YYYY-MM-DD format.

NMFIELD07

X

TEXT

255

Reporter user ID #

NMFIELD08

 

TEXT

255

Responsible user ID #

NMFIELD09

X

TEXT

255

ID # of the user who created the task

NMFIELD10

 

TEXT

255

Sprint title

NMFIELD11

 

TEXT

255

Task estimate

NMFIELD12

 

TEXT

255

Planned start date. Must be entered in the YYYY-MM-DD format.

DSFIELD01

 

TEXT

4000

Description

DSFIELD02

 

TEXT

4000

Example:

identifier_of_attribute1=value_of_attribute1;

identifier_of_attribute2=value_of_attribute2;

identifier_of_attribute3=value_of_attribute3.

 

Example with a multivalued attribute:

identifier_of_attribute1=value1_of_attribute1,value2_of_attribute1,value3_of_attibute1

Note: For attributes with a numeric value, the decimal place separator must be '.'.

For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.