Navigation:  Integration via database > Published interfaces > Document >

DCDOCELEC - Import of electronic file of documents

Previous  Top  Next

This import template makes it possible to insert:

Data of an electronic file of a document.

 

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

Insert

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:

73 - Code of component SoftExpert Document.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

97 - Inserts a new electronic file.

NMFIELD01

X

TEXT

255

Document ID #.

NMFIELD02

X

TEXT

255

Revision ID #.

NMFIELD03

X

TEXT

255

File name. Add the extension.

E.g.: Document.doc

NMFIELD04

 

TEXT

255

User's reg. code #.

NMFIELD05

X1

TEXT

255

Complete path of the file to be imported2, considering its location regarding the server.

E.g.: C:\Directory\Document.doc

NMFIELD06

 

TEXT

255

Original electronic file compression type.

0 - Uncompressed file.

1 - GZ compression.

2 - ZIP compression.

NMFIELD07

X

TEXT

255

Category ID #.

NMFIELD08

 

TEXT

255

Container structure item ID #.

Mandatory when the document category is configured as a complex file.

NMFIELD75

 

TEXT

255

Upper level interface code. If the upper level interface is not imported successfully, the current interface will not be executed.

FLFIELD01

X1

FILE

 

Content (blob) of the electronic file to be imported.

 

1 - Mandatory for one of these fields to be entered.

2 - When the file storage for integration in Amazon S3 is enabled, all imports related to DIINTERFACE will use this feature. Thus, for customers that use SoftExpert Hosting and that wish to use this feature, we suggest contacting the SoftExpert Sales team to request details on our SFTP service.