ADMTEAM - Team import
This import template allows:
- Inserting/editing/deleting team data.
- Associating teams with departments, users, and positions.
- Associating teams with components.
To insert each of these items, the standard documented below must be followed:
Insert/Edit/Delete teamsβ
Column | Required | Type | Precision | Description |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
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 # (field required for insertion and 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 # remains the same, enter the current team ID # (field required for editing only). |
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 with which this team will be associated. |
Insert teamsβ
Column | Required | Type | Precision | Description |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
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 with which this team will be associated: 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 |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
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 # (required 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 # (required when the NMFIELD02 is equal to 2 or equal to 3) |
NMFIELD06 | X | TEXT | 255 | User ID (mandatory when NMFIELD02 is equal to 4) |
Delete team membersβ
Column | Required | Type | Precision | Description |
---|---|---|---|---|
CDINTERFACE | 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 | Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 40 - Delete members from 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 # (required when the NMFIELD02 is equal to 1 or equal to 3) |
NMFIELD05 | X | TEXT | 255 | Position ID # (required when the NMFIELD02 is equal to 2 or equal to 3) |
NMFIELD06 | X | TEXT | 255 | User ID (mandatory when NMFIELD02 is equal to 4) |