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	Primary key - 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 the SFTP 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.