DCDOC - Document import
This import template allows inserting:
- Document data.
For the insertion of each one of these items, the standard documented below must be followed.
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 | Code of the system for which the integration will be performed: 73 - Code of the SoftExpert Document component. |
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 - Insert new document; 90 - Insert new document through parallel import (multithread). |
NMFIELD01 | TEXT | 255 | Document ID # (if it is not entered, an ID # will be created automatically). | |
NMFIELD02 | X | TEXT | 255 | Category ID #. |
NMFIELD03 | X | TEXT | 255 | Document title. |
NMFIELD04 | TEXT | 255 | Document author's name (if it is not entered, the record user will be used). | |
NMFIELD05 | TEXT | 255 | Inherit category access: 1 - Inherit; 2 - Do not inherit. (If it is 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 for 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 * | |
NMFIELD12 | NUMERIC | 1 | Inherit category distribution list. | |
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_atribute3=value_of_attribute3 Example with a multivalued attribute: identifier_of_attribute1=value1_of_attribute1 , value2_of_attribute1 , value3_of_attribute1 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 | Path of electronic file1. Can be separated by ";" for multiple files. |
info
Note
-
When file storage for integration with Amazon S3 is enabled, all imports related to the
DIINTERFACE
will use this resource. Therefore, for customers who use SoftExpert Hosting and wish to activate this functionality, we recommend contacting SoftExpert's sales team to request more information about theSFTP
service. -
For on-premise customers who need to know the correct location to make electronic files available for import, refer to the following article: Loading data into the interface article.
-
Languages marked with an asterisk are only available in databases with
UTF-8
encoding.