Loading data into the interface
Our customers and partners are responsible for developing and maintaining the programs that load data into the interface, due to specifications dependent on third-party software.
These programs must read information from a source repository, such as:
- Database.
- XLS, XLSX, CSV, XML files.
After that, they must write this data into the DIINTERFACE or
DIINTERFACEDETAIL interface, available in SoftExpert Suite. In the import
process, users are responsible for deleting processed records and handling
exceptions and errors that occur. In the data export process, third-party
software is responsible for deleting consumed records from the interface.
The system architecture does not store deleted information, whether records already imported or those not yet imported. Thus, once a record is deleted from the system or directly from the interface, there is no repository where the deleted data is kept.
Importing electronic files in SoftExpert Hosting
Customers who use SoftExpert Hosting and wish to use the data interface to
import electronic files into SoftExpert Suite must contact our sales team to
request information about the SFTP (Secure File Transfer Protocol) service.
This service allows for secure transfer of files to the DIINTERFACE table,
following the standard described above.
Our SFTP service offers high security in task transfer, ensuring that your data is protected during the process. Our technical team is available to help you configure and use the service.
Importing electronic files in on-premise environments
For customers who have SoftExpert Suite installed on their own infrastructure,
the files to be imported must be made available on the application server, for
security reasons. These files must be placed in the
../web/wwwroot/temp/.data_integration folder. This folder was created to
ensure that files are only deleted after a successful import into SoftExpert
Suite components.
If the file is stored in another directory, SoftExpert Suite will not be able to access it, which will result in import failures. Additionally, if the file is placed directly in the temp folder, outside of the ./data_integration subfolder, it may be automatically removed by our cleanup routines.