Primary key

User who uploaded/created this import

Date when import was created

Date when import was created (XML/JSON serialization, "yyyy-MM-ddTHH:mm:ss.fffZ"). JSON uses this string property (rather than the raw date_creation above) because api/DbImport/... endpoints are plain (non-OData) routes: Json.NET's native DateTimeOffset serialization would otherwise write "+00:00" instead of "Z".

Date when import process started

Date when import process started (XML/JSON serialization, "yyyy-MM-ddTHH:mm:ss.fffZ"). JSON uses this string property (rather than the raw date_start_import above) because api/DbImport/... endpoints are plain (non-OData) routes: Json.NET's native DateTimeOffset serialization would otherwise write "+00:00" instead of "Z".

Date when import process completed

Date when import process completed (XML/JSON serialization, "yyyy-MM-ddTHH:mm:ss.fffZ"). JSON uses this string property (rather than the raw date_end_import above) because api/DbImport/... endpoints are plain (non-OData) routes: Json.NET's native DateTimeOffset serialization would otherwise write "+00:00" instead of "Z".

Total number of lines in import file

Number of lines successfully imported

Indicates if import is ready to be processed

Indicates if import is locked (being processed)

Indicates if import is completed

Additional remarks about the import

Result message of the import process

Name of the template used for this import (ASG-4066). On create, provide the exact name of the template to use when more than one template exists for the import_type; optional when only one template exists (it's used automatically). Maps to the underlying db_import.name column, but is exposed as template_name in the API.

Foreign key to db_file containing the import data

Foreign key to db_file containing error log

Type of import: COMPANY, CONTACT, ARTICLE, EQUIPMENT_MODEL, INSTALLATION, LOCATION, JOB, TASK, WORK_INSTRUCTION_DETAILS, PRODUCT_STOCK

Number of errors encountered during import

Indicates if this is a template import configuration

Percentage of import completion (0-100)

JSON mapping configuration for field mapping

JSON options configuration for import options

Foreign key to db_syncerp_log if import is from ERP sync

Readonly system field managed by database, filled with GetUtcDate when adding, updating

Readonly system field managed by database, filled with GetUtcDate when adding, updating (XML/JSON serialization). JSON also uses this string property so non-OData endpoints (api/DbImport/Stock) output the same "yyyy-MM-ddTHH:mm:ss.fffZ" format as the OData endpoints.