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:

IMPORTANT!

The XLS or XLSX file must contain all fields in the DIINTERFACE table in the header, even if not all of them are used.

Import and export features

	Import data (Import spreadsheet)	Button used to import the spreadsheets into the system.
	Import template (Expose import template spreadsheet)	Button used to download the import template.
	Export data (Export spreadsheet)	Button used to export the spreadsheet to the computer.

Download spreadsheet template

Instead 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 system

There 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 system

To 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 directory

To perform the spreadsheet file insertion operation via directory insertion, the file must first contain the word seimport in the name.

Structure	Example
<seimport>	seimport.xls
<name> + <seimport>	example.seimport.xls
<seimport> + <name>	seimport.example.xls
<name> + <seimport> + <name>	example.seimport.example.xls

IMPORTANT!

<SE_SUITE_HOME> indicates the directory in which SoftExpert Suite is contained.

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.

Structure	Example
<domain> + <seimport>	www.softexpert.com_seimport.xls
<domain> + <seimport> + <name>	www.softexpert.com_seimport.example.xls
<name> + <domain> + <seimport>	example.www.softexpert.com_seimport.xls
<name> + <domain> + <seimport> + <name>	example.www.softexpert_seimport.example.xls

For customers that use SoftExpert Hosting and that wish to use this method of uploading data to the DIINTERFACE table, we suggest contacting the SoftExpert Sales team to request details on our SFTP service. Once this service is acquired, it will be possible to use this mean to deposit load files in the DIINTERFACE table according to the template described above.