Data imports

Import function enables to update data by values from the input file.

Values for import and values for record mapping

We define which values shall be imported in each import. For this purpose Checkbox I is used.

If we want to identify records that are already present in the class and also in the import file, it is necessary to mark columns that will be used for this mapping. These columns will be marked in Checkbox M.

Checkbox P informs that the respective column is mandatory.

Default values

When importing data to the class, we can set also values that shall be entered into attributes not present in the import file. The value can be also defined with functions:

We will use these functions in the control Default value

Import start

Imports can be started manually via page with import list, URL, job, workflow or web services. If we want to use call via URL or web service, we have to explicitly enable that in the import definition.

Example:

http://.../ImportStart.aspx?Id=27 – this link will start import Id 27 from the application located in ObjectGears.cz. The page returns OK, if the import is carried out well, or an error, if the import fails. (Start is enabled only if the user, that is calling this URL,  has appropriate access right.)