Navigation:  Integration via database > Published interfaces > Document >

DCDOC - Document import

Previous  Top  Next

This import template makes it possible to insert:

Data 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.

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

73 - Code of component SoftExpert Document.

FGIMPORT

X

NUMERIC

2

Import status:

1 - New;

2 - In progress;

3 - Finished;

4 - Error.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 - Inserts a new document;

90 - Inserts a new document through parallel import (multithread).

NMFIELD01

 

TEXT

255

Document ID # (if not entered, an ID # will be created automatically).

NMFIELD02

X

TEXT

255

Category ID #.

NMFIELD03

X

TEXT

255

Document title.

NMFIELD04

 

TEXT

255

Name of the document author (if not entered, the record user will be used).

NMFIELD05

 

TEXT

255

Inherit category access:

1 - Inherit;

2 - Do not inherit.

(if not entered, 1 - Inherit will be used)

NMFIELD06

 

TEXT

255

Revision date.

NMFIELD07

X

TEXT

255

Record user ID.

NMFIELD08

 

TEXT

255

First revision ID #.

NMFIELD09

 

TEXT

255

Allows importing documents being indexed.

Note: only for documents whose category has no revision control. (enter value 1)

NMFIELD10

 

NUMERIC

2

Document language:

1 - English (USA)

2 - Portuguese (Brazil)

3 - Spanish

4 - Portuguese (Portugal)

5 - German

6 - French (France)

7 - Romanian *

8 - Chinese *

9 - Italian

10 - Slovak *

11 - English (United Kingdom)

12 - Turkish *

13 - French (Canada)

14 - Russian *

15 - Polish *

16 - Catalan

17 - Danish

18 - Finnish

19 - Japanese *

NMFIELD75

 

TEXT

255

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

DSFIELD01

 

TEXT

4000

Document summary.

DSFIELD02

 

TEXT

4000

Document attributes.

Example:

identifier_of_attribute1=value_of_attribute1;

identifier_of_attribute2=value_of_attribute2;

identifier_of_attribute3=value_of_attribute3

Example with a multivalued attribute:

identifier_of_attribute1=value1_of_attribute1,value2_of_attribute1,value3_of_attibute1

Note: For attributes with a numeric value, the decimal place separator must be '.'. For date fields, the value must have the “Y-M-D”(Year-Month-Day) format

DSFIELD03

 

TEXT

4000

Electronic file path1. May be separated by ";" for multiple files.

 

1 - 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.

 

*Languages checked with an asterisk are only available on databases with UTF-8 encoding.