Navigation:  Integration via database > Published interfaces > PDM >

ITSECU - Item type security import

Previous  Top  Next

This import template makes it possible to insert:

Data of the item type security.

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert item type security data

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:

107 - Code of component SoftExpert PDM.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

13 - Insert security control for the item type.

NMFIELD01

X

TEXT

255

Item type ID #.

NMFIELD02

X

TEXT

255

Permission group type:

1 - Team;

2 - Department;

3 - Department/Position;

4 - Position;

5 - User;

6 - All.

NMFIELD03

X

TEXT

255

Control to add:

1 - Yes;

2 - No.

NMFIELD04

 

X

TEXT

255

Control to edit:

1 - Yes;

2 - No.

NMFIELD05

X

TEXT

255

Control to delete:

1 - Yes;

2 - No.

NMFIELD06

X

TEXT

255

Security data control:

1 - Yes;

2 - No.

NMFIELD07

X

TEXT

255

Control to list:

1 - Yes;

2 - No.

NMFIELD08

X

TEXT

255

Control to view:

1 - Yes;

2 - No.

NMFIELD09

X

TEXT

255

Permission:

1 - Allow;

2 - Deny.

NMFIELD10

 

TEXT

255

Access type ID #.

Example: If the type is by user, it will be the user ID. If the type is by department, it will be the department ID #.

NMFIELD11

 

TEXT

255

Position ID #. This field will only be used if the type is by department and position. That way, the department will go in the NMFIELD10 field and the position, in this one.