TRTRAININGATTACH - Insertion of attachments into trainings

This import template allows inserting:

• Attachments into a training.

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.
FGIMPORT	X	NUMERIC	2	Import status: 1 - New; 2 - In progress; 3 - Finished; 4 - Error.
CDISOSYSTEM	X	NUMERIC	10	Code of the system for which the integration will be performed: 129 - Code of the Training component.
FGOPTION	X	NUMERIC	2	15 - Adds new attachment to a training.
NMFIELD01	X	TEXT	50	Training ID #.
NMFIELD02	X	TEXT	255	File name with extension.
NMFIELD03		TEXT	255	Attachment name.
NMFIELD04	X¹	TEXT	255	Electronic file path.
DSFIELD01		TEXT	4000	Attachment description.
FLFIELD01	X¹	FILE		Content (blob) of the electronic file to be imported.

info

Note:

• X¹ - One of these fields must necessarily be filled in.

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

• For on-premise customers that need to know the correct location to make electronic files available for import, refer to the Loading data into the interface article: this part explains the process of loading data into the DIINTERFACE table.