|
Step 1
The spreadsheet to be imported must be configured correctly. To do that, it is necessary for its header (first line) to have all fields in the ADINTERFACE table and for it to be saved with an XLS or XLSX extension. Refer to the Warnings on spreadsheet import for the precautions that must be taken when creating the spreadsheet to be imported.
Instead of manually completing every column on the ADINTERFACE table, the system allows downloading a template with these columns previously completed, making it necessary only to add the required information to the body of each used column. To do that, the following buttons of the main screen toolbar can be used (Import Tracking (CM015)) menu:
|
Click on this button to export a template of the (unfilled) Excel spreadsheet to make an import.
|
|
Click on this button to export the records shown in the listing to an Excel spreadsheet for the necessary corrections to be made.
|
Step 2
With the spreadsheet duly configured:
1.
|
Access Tool Import Tracking (CM015) menu.
|
2.
|
After that, click on the button on the toolbar.
|
3.
|
Drag the spreadsheet to the screen that will be opened or click on the field to browse the directories on your computer and select the desired spreadsheet:
▪If the spreadsheet is saved with the correct extension (xls or xlsx) and if it contains all fields in the ADINTERFACE table, the "Excel file validated successfully" message will be displayed. ▪Otherwise, the system will list the errors of the selected spreadsheet. Hover the mouse over the spreadsheet card and select the button to delete it from the import screen. |
4.
|
If the spreadsheet is successfully validated, click on the Import button.
|
|