Quick Import

If you need to perform quick data migration between instances without additional field mapping configuration, you can use the quick import engine.

The quick import unlike usual data import inserts records to the database directly, while the standard import method allows you to configure additional settings and scripts, for example, business rules.

Quick import functionality is available for importing only non-versioning tables (that have the Is VCS enabled checkbox cleared). If you try to import any versioning table, the records from the imported file will be skipped with the message in the Main Log (sys_log) table:
Is not possible to import to the {table_name} table.
You cannot perform quick import to the VCS Record (sys_vcs_record) table.

Role required: admin.

Imported data should fit the format below:

Import data format

{
    "article": [
        {
            "state": "1",
            "service": null,
            "number": "ART0000035",
            "sys_id": 159497384530294161,
            "metainfo": null,
            "object_category": null,
            "sys_updated_at": "2020-07-17 08:17:25",
            "body": null,
            "sys_db_table_id": 156846397908814773,
            "content_item_class": 157935401911817831,
            "sys_created_at": "2020-07-17 08:17:25",
            "sys_updated_by": 155931135900000001,
            "sys_created_by": 155931135900000001,
            "published_at": "2020-07-17 08:17:25"
        }
    ],
    "itsm_incident": [
        {
            "active": true,
            "sys_updated_at": "2020-06-18 23:24:13",
            "sys_created_at": "2020-06-18 23:24:13",
            "wf_executing_activity": null,
            "number": "INC0000351",
            "description": null,
            "urgency": "1",
            "impact": "1",
            "assignment_group": null,
            "sys_db_table_id": 156950677111866258,
            "display_name": "INC0000351 asd",
            "subject": "asd",
            "company": null,
            "service": 158825569619498427
        }
    ]
}

The main object keys are tables system names. The value is the records objects array.
Every record object contains keys matching the column system names of the table and the database relevant attribute value.

You can create a file that contains data to import by exporting the table records list.

To process quick import, complete the steps below:

Navigate to any table list view.
Click the column title area and select Import from JSON in the context menu.
Select JSON files.

Note that the target table should be mentioned within the file. New records will not be added in the list view where you perform the quick import.

Within the importing process, the import engine checks whether the ID of the record attribute values match with the ones in the imported object. If such a record exists in the target table, then the existing record will be updated; otherwise, a new record is created. For example: when records with a new ID attribute value are imported or records are without the sys_id: value pair.

After import processing, every file will have a Main Log (sys_log) record with Quick Import value in the Source column. The link to the Import log records will appear in the informational message in the lower right corner.

These records will have information about import results. For example:

Message

Import result for knowledge_base_category.json
Total: 55
Inserted: 45
Updated: 10
Skipped: 0

The field validation on the server-side is not taken into account when the quick import is used.

That is, you can import records with empty mandatory fields or with non-unique values in the fields that have the Unique checkbox selected.

Note that after importing with these parameters, you will not be able to update records until you normalize data and re-import it.

Page tree

Quick Import