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 |
|---|---|---|---|---|
| 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 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: 41 - 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 |
|---|---|---|---|---|
| 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 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 |
|---|---|---|---|---|
| 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 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 |
|---|---|---|---|---|
| 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 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) |