XLS file structure definition |
The DIINTERFACE table can also be fed through an XLS or XLSX file. To use this feature you need a file with an XLS or XLSX extension whose header (first line) contains all the fields in the DIINTERFACE table. Example of the file in the following figure:
Import and export featuresPlease follow the possible resources to be selected within the import function:
Download spreadsheet templateInstead of filling all columns of the DIINTERFACE table manually, the system allows you to download a ready-made template with these already filled columns, only needing to add the necessary information in the body of each column used. To download the spreadsheet template, navigate to the tracking screen SoftExpert Configuration Tracking Tool Import Tracking (CM015). Within this screen, it is possible to use the (Import template) button to download the template file.
Import file to the systemThere are three different ways to import data to the system through the previously described spreadsheet template. These three approaches are described below:
Upload through the systemTo upload the file, navigate to the tracking screen (SoftExpert Configuration Tool Import Tracking (CM015)). Within this screen use the Import spreadsheet button to upload the file into the system. After that, a screen will open to perform the data import process. Drag the spreadsheet file into the displayed screen or select it using the Select button. If the file to be imported is correct, the following message will be displayed: "Excel file validated successfully". After you have included the file on the screen, use the Import button to complete the import of the data.
Addition through directoryTo perform the spreadsheet file insertion operation via directory insertion, the file must first contain the word seimport in the name.
If you are using the multidatabase, the file name should contain the domain present in the database-config file, followed by the _seimport suffix. In the table below, there are examples for naming names using the "www.softexpert.com" domain as an example.
Spreadsheet upload via webserviceTo use this method, simply perform an HTTP (POST) request to the endpoint https://<domain>/apigateway/se/dataintegration/importjob/upload.php with content of the form-data type (multipart/form-data) and add the spreadsheet (respecting the format described in the previous topics) as a parameter in the respective form.
The key to this parameter must be "userfile". The authentication layer of this endpoint will respect the security rules of the SoftExpert Suite APIGateway (described in the Integration via SOAP web services Technical overview section).
The images below show an example of a request using the Postman application:
|