This import template makes it possible to:
▪Start a workflow instance; ▪Enter requester1; ▪Fill in form fields1; ▪Input data in the form grid1; ▪Input instance attributes1.
To insert each of these items, it is necessary to follow the standard documented below.
Start workflow
|
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 with the automation:
104 – SoftExpert Workflow.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
1 - Indicates that the record is ready to be imported.
99 - Add new workflow through parallel import (multithread).
|
NMFIELD01
|
X
|
TEXT
|
50
|
Model process 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.
|
Fill out record details in the start
The table below displays an example of filling out form fields, adding records to the form grid and filling out instance attributes. 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.
Start workflow (DIINTERFACEDETAIL)
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACEDETAIL
|
x
|
TEXT
|
10
|
Sequential code – Identifies a lower level item to DIINTERFACE. For example:
1 - Form field.
|
OIDINTERFACE
|
X
|
TEXT
|
10
|
Code of the upper level record related to the instance. DIINTERFACE.OIDINTERFACE
|
NRREGISTER
|
X
|
NUMERIC
|
2
|
Record number. Works as a record grouper when using a grid.
|
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 #.
Only necessary when FGIMPORTTYPE = 1.
|
NMFIELD03
|
|
TEXT
|
255
|
Defines if the record refers to a list of values:
1 - Yes;
2 – No (default value).
|
NMFIELD04
|
|
TEXT
|
255
|
Relationship ID #.
Only necessary if the field is a list of values (NMFIELD03 = 1).
|
NMFIELD05
|
|
TEXT
|
255
|
Related form table field ID #.
Only necessary if the field is a list of values (NMFIELD03 = 1).
|
NMFIELD06
|
|
TEXT
|
255
|
Relationship ID #.
Only necessary if the field is a grid (FGIMPORTTYPE = 2).
|
NMFIELD07
|
|
NUMERIC
|
255
|
Related form table field ID #.
Only necessary if the field is a grid (FGIMPORTTYPE = 2).
|
NMFIELD08
|
|
TEXT
|
255
|
Form table field value (Short text).
Value of the text or time type attribute for indeterminate, 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 the numeric or currency type attribute for indeterminate, 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 the date type attribute for indeterminate, list of values or multivalued (when FGIMPORTTYPE = 3).
|
TXFIELD01
|
|
TEXT
|
|
Form table field value (Long text).
Value of the memo type attribute for indeterminate (when FGIMPORTTYPE = 3).
|
Example of an INSERT command:
Input (50) field
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE,NMFIELD01, NMFIELD02, NMFIELD08) VALUES (1, 1, 1, 'form1', 'inp50', 'Form01 Field inp50');
|
Input (255) field
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 (Boolean) field
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 a line to the form grid:
Input (50) field
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 (255) field
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 (4000) field
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 Field Text 4000');
|
List of values 1 field
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
Indeterminate (Text)
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (24, 1, 3, 'INDETERMINATE-TEXT', 'Indeterminate Text');
|
Indeterminate (Time)
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, NMFIELD08) VALUES (25, 1, 3, 'INDETERMINATE-TIME', '1234:56');
|
Indeterminate (Numeric)
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (26, 1, 3, 'INDETERMINATE-NUMERIC', 1234.56);
|
Indeterminate (Currency)
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, VLFIELD01) VALUES (27, 1, 3, 'INDETERMINATE-CURRENCY', 123456.78);
|
Indeterminate (Memo)
INSERT INTO DIINTERFACEDETAIL (OIDINTERFACEDETAIL, OIDINTERFACE, FGIMPORTTYPE, NMFIELD01, TXFIELD01) VALUES (29, 1, 3, 'INDETERMINATE-MEMO', 'Indeterminate 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, 'MULTIVALUED-DATE', 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');
|
|