This import template enables to insert/edit/delete:
▪Data of teams; ▪Associate teams with departments, users, and positions; ▪Associate teams with components.
To insert each of these items, it is necessary to follow the standard documented below:
Insert/Edit/Delete teams
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
31 – Insert team;
32 – Edit team;
33 – Delete team.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Team ID # (required field for deletion).
|
NMFIELD02
|
X
|
TEXT
|
255
|
Team name.
|
NMFIELD03
|
X
|
TEXT
|
255
|
New ID # of the team, if you wish to edit it. If the ID # continues the same, enter the current team ID # (required field only for editing).
|
NMFIELD04
|
X
|
TEXT
|
255
|
Create team with:
1 – Departments;
2 – Users;
3 – Positions.
|
NMFIELD05
|
X
|
TEXT
|
255
|
ID # of the (departments, users, positions) that will be associated (separated by “,”). Example: “User1”, “User2”, “User3”.
|
NMFIELD06
|
X
|
TEXT
|
255
|
Code of the components this team will be associated with.
|
Insert teams
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
38 - Insert team;
|
NMFIELD01
|
X
|
TEXT
|
255
|
Team ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Team name.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Code of the components this team will be associated with.
7 - SPC
8 - FMEA
11 - APQP
13 - Audit
15 - Process
16 - Performance
21 - Document
26 - Training
34 - Inspection
36 - MSA
41 - Project
94 - Portfolio
107 - PDM
109 - Asset
146 - Request
149 - Supply
153 - Administration
160 - Incident
174 - Action plan
180 - Storeroom
202 - Problem
205 - Time control
214 - Survey
215 - Risk
227 - Requirement
|
Insert team members
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
39 - Insert members in the team.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Team ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Member type:
1 – Organizational unit;
2 - Position;
3 – Organizational unit /Position;
4 - User.
|
NMFIELD03
|
X*
|
TEXT
|
255
|
Organizational unit ID #. (mandatory when the NMFIELD02 is equal to 1 or equal to 3)
|
NMFIELD04
|
|
TEXT
|
255
|
Consider Organizational Unit sublevels: (By default the value is 2)
1 - Yes;
2 - No.
|
NMFIELD05
|
X*
|
TEXT
|
255
|
Position ID # (mandatory when the NMFIELD02 is equal to 2 or equal to 3)
|
NMFIELD06
|
X*
|
TEXT
|
255
|
User ID # (mandatory when the NMFIELD02 is equal to 4)
|
Delete members in the team
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
40 - Delete team members;
|
NMFIELD01
|
X
|
TEXT
|
255
|
Team ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Member type:
1 – Organizational unit;
2 - Position;
3 – Organizational unit /Position;
4 - User.
|
NMFIELD03
|
X*
|
TEXT
|
255
|
Organizational unit ID #. (mandatory when the NMFIELD02 is equal to 1 or equal to 3)
|
NMFIELD05
|
X*
|
TEXT
|
255
|
Position ID # (mandatory when the NMFIELD02 is equal to 2 or equal to 3)
|
NMFIELD06
|
X*
|
TEXT
|
255
|
User ID # (mandatory when the NMFIELD02 is equal to 4)
|
|