Skip to main content
Version: 2.2.1

WFINSTANCE - Workflow

This import template allows:

  • Starting a workflow instance.
  • Entering requester¹.
  • Filling form fields¹.
  • Inserting data in form grid¹.
  • Filling out instance attributes¹.

For the insertion of each one of these items, the standard documented below must be followed.

Start workflow​

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system that has automation:
104 - SoftExpert Workflow.
FGOPTIONXNUMERIC21 - Indicates that the record is ready to be imported.
99 - Add new workflow through parallel import (multithread).
NMFIELD01XTEXT50Model process ID #.
NMFIELD02XTEXT255Instance title.
NMFIELD03XTEXT50Starter user ID
NMFIELD04TEXT50Requester user ID.
NMFIELD05TEXT50Customer ID #.
NMFIELD06TEXT50Customer contact ID #.
NMFIELD07NUMERIC2Does it have details:
1 - Yes;
2 - No.
Note: If it is not entered, the default value will be 2.
info

Note:

¹ - They use DIINTERFACEDETAIL; thus, it is not possible to use import via Excel spreadsheet.

Enter record details at the start​

The table below displays an example of the completion of form fields, insertion of records in the form grid, and instance attribute input. In this case, there may be several records for one (1) start. Thus, the OIDINTERFACE code must be entered, indicating to which start this record belongs.

ColumnRequiredTypePrecisionDescription
OIDINTERFACEDETAILxTEXT10Sequential code – Identifies a DIINTERFACE child item. For example:
1 - Form field.
OIDINTERFACEXTEXT10Code of the parent record related to the instance. DIINTERFACE.OIDINTERFACE
NRREGISTERXNUMERIC2Record number. It works as a record grouper when grid is used.
FGIMPORTTYPEXNUMERIC2Import type:
1 - Fields;
2 - Grid;
3 - Attributes.
NMFIELD01XTEXT50Form table ID #.
Instance attribute ID # (when FGIMPORTTYPE = 3).
NMFIELD02TEXT50Form table field ID #.
Required only when FGIMPORTTYPE = 1.
NMFIELD03TEXT255Defines if the record refers to a list of values:
1 - Yes;
2 - No (default value).
NMFIELD04TEXT255Relationship ID #.
Required only if the field is a list of values (NMFIELD03 = 1).
NMFIELD05TEXT255Related form table field ID #.
Required only if the field is a list of values (NMFIELD03 = 1).
NMFIELD06TEXT255Relationship ID #.
Required only if the field is a grid (FGIMPORTTYPE = 2).
NMFIELD07NUMERIC255Related form table field ID #.
Required only if the field is a grid (FGIMPORTTYPE = 2).
NMFIELD08TEXT255Form table field value (Short text).
Value of text-type or time-type attribute for undetermined, list of values, or multivalued (when FGIMPORTTYPE = 3)
.External attribute value (when FGIMPORTTYPE = 3).
VLFIELD01NUMERIC28,12Form table field value (Decimal).
Value of numeric-type or currency-type attribute for undetermined, list of values, or multivalued (when FGIMPORTTYPE = 3).
BLFIELD01NUMERIC19Form table field value (Integer)
DTFIELD01DATEForm table field value (Date).
Value of date-type attribute for undetermined, list of values, or multivalued (when FGIMPORTTYPE = 3).
TXFIELD01TEXTForm table field value (Long text).
Value of memo-type attribute for undetermined (when FGIMPORTTYPE = 3).

INSERT command example:​

Input field(50)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, NMFIELD08) VALUES (1, 1, 1, 'form1', 'inp50', 'Form01 Field inp50');

Input field (255)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, NMFIELD08) VALUES (2, 1, 1, 'form1', 'inp255', 'Form01 Field inp255');

Number field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, BNFIELD01) VALUES (3, 1, 1, 'form1', 'nrfield1', 50);

Decimal field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, VLFIELD01) VALUES (4, 1, 1, 'form1', 'vlvalue1', 49.99);

Time field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, NMFIELD08) VALUES (5, 1, 1, 'form1', 'hrtime1', '11:11');

Date field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, DTFIELD01) VALUES (6, 1, 1, 'form1', 'dtdate1',TO_DATE('2019-10-01', 'yyyy/mm/dd'));

Checkbox field (Boolean)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, BNFIELD01) VALUES (7, 1, 1, 'form1', 'fgcheck1', 1);

Radio field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, BNFIELD01) VALUES (8, 1, 1, 'form1', 'nrradio1', 2);

Long-text field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, TXFIELD01) VALUES (9, 1, 1, 'form1', 'txvalue', 'Text,text, text, text, text...');

List of values field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD08) VALUES (10, 1, 1, 'form1','1', 'rlis1form1', 'txt50', 'C01');

Add row to form grid​

Input field(50)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, NMFIELD08) VALUES (13, 1, 2, 1, 'form1', 'rgrid1form1', 'inp50', 'Row 01 Grid 01 Form 01 Field inp50');

Input field (255)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, NMFIELD08) VALUES (14, 1, 2, 1, 'form1', 'rgrid1form1', 'inp255', 'Row 01 Grid 01 Form 01 Field inp255');

Number field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, BNFIELD01) VALUES (15, 1, 2, 1, 'form1', 'rgrid1form1', 'nrfield1', 25);

Decimal field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, VLFIELD01) VALUES (16, 1, 2, 1, 'form1', 'rgrid1form1', 'vlvalue1', 29.99);

Time field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, NMFIELD08) VALUES (17, 1, 2, 1, 'form1', 'rgrid1form1', 'hrtime1', '1:11');

Date field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, DTFIELD01) VALUES (18, 1, 2, 1, 'form1', 'rgrid1form1', 'dtdate1', TO_DATE('2019-01-01', 'yyyy/mm/dd'));

Checkbox field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, BNFIELD01) VALUES (20, 1, 2, 1, 'form1', 'rgrid1form1', 'fgcheck1', 1);

Radio field

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, BNFIELD01) VALUES (21, 1, 2, 1, 'form1', 'rgrid1form1', 'nrradio1', 2);

Text field (4000)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD07, TXFIELD01) VALUES (22, 1, 2, 1, 'form1', 'rgrid1form1', 'txtext1', 'Row 01 Grid 01 Form 01 Text field 4000');

List of values field 1

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NRREGISTER, NMFIELD01, NMFIELD06, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD08) VALUES (23, 1, 2, 1, 'form1', 'rgrid1form1', '1', 'rlis1grid1form1', 'nmvalue1', 'A01');

Example of instance attribute completion​

Undetermined (Text)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (24, 1, 3, 'UNDETERMINED-TEXT', 'Undetermined Text');

Undetermined (Time)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (25, 1, 3, 'UNDETERMINED-TIME', '1234:56');

Undetermined(Numeric)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (26, 1, 3, 'UNDETERMINED-NUMERIC', 1234.56);

Undetermined (Currency)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (27, 1, 3, 'UNDETERMINED-CURRENCY', 123456.78);

Undetermined (Memo)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, TXFIELD01) VALUES (29, 1, 3, 'UNDETERMINED-MEMO', 'Undetermined Memo');

List of values (Text)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (30, 1, 3, 'LIST-OF-VALUES-TEXT', 'List of values Text');

List of values (Time)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (31, 1, 3, 'LIST-OF-VALUES-TIME', '1234:56');

List of values (Numeric)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (32, 1, 3, 'LIST-OF-VALUES-NUMERIC', 1234.56);

List of values (Currency)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (33, 1, 3, 'LIST-OF-VALUES-CURRENCY', 123456.78);

List of values (Date)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, DTFIELD01) VALUES (34, 1, 3, 'LIST-OF-VALUES-DATE', TO_DATE('2020- 11-14', 'yyyy/mm/dd'));

Multivalued (Text)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (35, 1, 3, 'MULTIVALUED-TEXT', 'Multivalued Text 1');

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (36, 1, 3, 'MULTIVALUED-TEXT', 'Multivalued Text 2');

Multivalued (Time)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (37, 1, 3, 'MULTIVALUED-TIME', '1111:11'); INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (38, 1, 3, 'MULTIVALUED-TIME', '2222:22');

**Multivalued (Numeric) **

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (39, 1, 3, 'MULTIVALUED-NUMERIC', 11.11); INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (40, 1, 3, 'MULTIVALUED-NUMERIC', 22.22);

Multivalued (Currency)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (41, 1, 3, 'MULTIVALUED-CURRENCY', 111.11); INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (42, 1, 3, 'MULTIVALUED-CURRENCY', 222.22);

Multivalued (Date)

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, DTFIELD01) VALUES (43, 1, 3, 'MULTIVALUED-DATE', TO_DATE('2020-11-14', 'yyyy/mm/dd'));

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, DTFIELD01) VALUES (44, 1, 3, 'MULTIVALORADO-DATA', TO_DATE('2020-11-15', 'yyyy/mm/dd'));

External attribute

INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (45, 1, 3, 'EXTERNAL-ATTRIBUTE', 'External attribute');