WFINSTANCE - Workflow
This import template allows:
- Starting a workflow instance.
- Entering requester¹.
- Filling in form fields¹.
- Inserting data in the form grid¹.
- Filling out instance attributes¹.
For the insertion of each one of these items, the standard documented below must be followed.
Start workflow​
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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 | Code of the system with the automation: 104 - SoftExpert Workflow. |
| FGOPTION | X | NUMERIC | 2 | 1 - Indicates that the record is ready to be imported; 2 - Add new workflow by workflow type; 99 - Add new workflow through parallel import (multithread). |
| NMFIELD01 | X | TEXT | 50 | Model process ID #; or workflow type ID #². |
| NMFIELD02 | X | TEXT | 255 | Instance title. |
| NMFIELD03 | X | TEXT | 50 | Starter user ID. |
| NMFIELD04 | TEXT | 50 | Requester user ID. | |
| NMFIELD05 | TEXT | 50 | Customer ID #. | |
| NMFIELD06 | TEXT | 50 | Customer contact ID #. | |
| NMFIELD07 | NUMERIC | 2 | Does 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. - ² - When FGOPTION is 2, enter the workflow type.
Provide the details of the record when starting.​
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.
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACEDETAIL | x | TEXT | 32 | Code that identifies a child item of the DIINTERFACE. For example:1 - Form field. |
| OIDINTERFACE | X | TEXT | 32 | Code of the parent record related to the instance. DIINTERFACE.OIDINTERFACE |
| NRREGISTER | X | NUMERIC | 2 | Record number. It works as a record grouper when grid is used. |
| FGIMPORTTYPE | X | NUMERIC | 2 | Import type: 1 - Fields; 2 - Grid; 3 - Attributes. |
| NMFIELD01 | X | TEXT | 50 | Form table ID #. Instance attribute ID # (when FGIMPORTTYPE = 3). |
| NMFIELD02 | TEXT | 50 | Form table field ID #. Required only when FGIMPORTTYPE = 1. | |
| NMFIELD03 | TEXT | 255 | Defines whether the record refers to a list of values: 1 - Yes; 2 - No (default value). | |
| NMFIELD04 | TEXT | 255 | Relationship ID #. Required only if the field is a list of values ( NMFIELD03 = 1). | |
| NMFIELD05 | TEXT | 255 | ID # of the field of the related form table. Required only if the field is a list of values ( NMFIELD03 = 1). | |
| NMFIELD06 | TEXT | 255 | Relationship ID #. Required only if the field is a grid ( FGIMPORTTYPE = 2). | |
| NMFIELD07 | NUMERIC | 255 | ID # of the field of the related form table. Required only if the field is a grid ( FGIMPORTTYPE = 2). | |
| NMFIELD08 | TEXT | 255 | Form 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). | |
| VLFIELD01 | NUMERIC | 28.12 | Form table field value (Decimal). Value of numeric-type or currency-type attribute for undetermined, list of values, or multivalued (when FGIMPORTTYPE = 3). | |
| BLFIELD01 | NUMERIC | 19 | Form table field value (Integer) | |
| DTFIELD01 | DATE | Form table field value (Date). Value of date-type attribute for undetermined, list of values, or multivalued (when FGIMPORTTYPE = 3). | ||
| TXFIELD01 | TEXT | Form 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');