Course Content

Expand All

Import Foundamentals

To configure a new import procedure, please go to the menu: System > Tools > Import.

In the first page after clicking on the menu, you can see a grid of all Imports already configured in your Deepser.

To see the configuration for a specific import, click on the row in the grid. Press ‘Add Import’ to create a new one.

Then we can see the Import configuration form:

The Fields have the following meaning:

FIELDMEANING
NameName of the Import.
ModelModel of the entities that are going to be imported into Deepser (Operations, CI, Companies etc.).
TypeFormat of the source file containing the records to be imported in Deepser.
Has Header (Yes/No)The first row of the file is an header. If Yes, Deepser will ignore the data of the first row of the Excel File.
Cron ExpressionIf the first row of the Excel file is a document header, it cells can be automatically recognaised as entity fields, this comes handy during the binding process
StatusIf Enabled the import will run, otherwise not.
File PathIt is used to upload the source file containing the records to be imported.
Path ExpressionIt is used to dynamically change the name of the file, containing the data to be imported. We will explain this field with an example, below in this document.
Entity – File – CodeIn this field there is the configuration of the ‘File Column – Entity Field’ binding. Entity: Model field; File: File column; Code: script to perform specific manipulations of data on the column value (e.g.: format a date, convert a value, etc.), executed during the cell evaluation.
Before RunCustom PHP code to be executed before the import procedure starts. It is used (see examples below) to pre-load data in memory, in order to avoid subsequent massive SQL queries to the DB. e.g.: Load the content of a DB table inside an Array. This action can then be used during the import, to avoid querying the database for every Excel file row.
Before RowCustom PHP code to be executed before each Excel file row is imported. It is used (see examples below) to dynamically change the values of the row imported. e.g.1: for every row imported we want to set the status as “New”. We can specify that inside this field. e.g.2: we want to load a record of the DataBase instead of importing a new record. We can load the record from the DataBase here, or read the record from the Before Run Array, representing the data on the DB Table.
After RowCustom PHP code executed after each row, as soon as every single record has been saved. It is executed multiple times after every row insert/update.
After RunCustom PHP code executed after all Excel file rows have been imported. It can be useful to perform custom tasks at the end of the import.