Skip to main content
Version: 2.2.0

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​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
31 - Insert team;
32 - Edit team;
33 - Delete team.
NMFIELD01XTEXT255Team ID # (field required for insertion and deletion).
NMFIELD02XTEXT255Team name.
NMFIELD03XTEXT255New 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).
NMFIELD04XTEXT255Create team with:
1 - Departments;
2 - Users;
3 - Positions.
NMFIELD05XTEXT255ID # of the departments, users, positions that will be associated (separated by β€œ,”). Example: β€œUser1”, β€œUser2”, β€œUser3”.
NMFIELD06XTEXT255Code of the components with which this team will be associated.

Insert teams​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
38 - Insert team.
NMFIELD01XTEXT255Team ID #.
NMFIELD02XTEXT255Team name.
NMFIELD03XTEXT255Code 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​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
39 - Insert members in the team.
NMFIELD01XTEXT255Team ID #.
NMFIELD02XTEXT255Member type:
1 - Organizational unit;
2 - Position;
3 - Organizational unit/Position;
4 - User.
NMFIELD03XTEXT255Organizational unit ID # (required when the NMFIELD02 is equal to 1 or equal to 3)
NMFIELD04TEXT255Consider Organizational Unit sublevels: (By default the value is 2)
1 - Yes;
2 - No.
NMFIELD05XTEXT255Position ID # (required when the NMFIELD02 is equal to 2 or equal to 3)
NMFIELD06XTEXT255User ID (mandatory when NMFIELD02 is equal to 4)

Delete team members​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
40 - Delete members from the team.
NMFIELD01XTEXT255Team ID #.
NMFIELD02XTEXT255Member type:
1 - Organizational unit;
2 - Position;
3 - Organizational unit/Position;
4 - User.
NMFIELD03XTEXT255Organizational unit ID # (required when the NMFIELD02 is equal to 1 or equal to 3)
NMFIELD05XTEXT255Position ID # (required when the NMFIELD02 is equal to 2 or equal to 3)
NMFIELD06XTEXT255User ID (mandatory when NMFIELD02 is equal to 4)