In SimpleOne, you can export lists into Excel and JSON formats for the sake of further deploying data on other instances.
To export a list, please complete the steps below:
- Navigate to the list you need to export.
(Optional) Customize it using the List layoutLayout in the hamburger menu
Tooltip onlyIcon true appendIcon info-filled linkTextColor blue To see the exporting list, please add a new List view in the List layoutLayout.
In the hamburger menu
, change the View to the new one.
or the Personal list layout to have just the needed set of columns displayed in the preferred order. In contrast to the Personal list layout, you need to have admin privileges to customize the List layoutLayout.
- Filter out a list with Condition Builder if necessary.
- Right-click on one of the column headings to call the context menu
- Select Export to Excel or Export to JSON in the context menu.
After that, the file will be downloaded to your computer.
| Note | ||
|---|---|---|
| ||
Please note that if you export data from a dictionary, do this with the relevant list view. If an exported dictionary list view contains an incomplete column set, the final data may be inconsistent after importing on a target instance. |
| Tip |
|---|
Excel and JSON types of files have different data structures that they return. For example, Export to JSON downloads all values of the Reference type, including IDs by default. To export fields of the Reference type to Excel correctly, the ID should be shown in order to be exported. These values can be displayed on the list view with Dot-walking. For example:
|
Export data format (JSON)
Here you can find an example of the record exported in JSON format.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
{
"itsm_incident": [
{
"sys_created_by": 155931135900000001,
"caller": 155931135900000001,
"sla_due": null,
"comments": null,
"sys_created_at": "2020-09-07 08:43:02",
"due_date": null,
"impact": "1",
"parent_id": null,
"priority": "1",
"state": "-2",
"sys_updated_at": "2020-09-07 08:43:25",
"sys_updated_by": 155931135900000001,
"urgency": "1",
"closed_by": null,
"contact": null,
"screenshot": null,
"subject": "test",
"active": true,
"additional_comments": null,
"attention_required": true,
"company": null,
"display_name": "INC0000322 test",
"sys_id": 159946818218525099,
"watcher_list": null,
"assigned_user": 157416146011669937,
"description": "",
"number": "INC0000322",
"assignment_group": 157417569011449935,
"opened_by": null,
"escalation": null,
"closed_at": null,
"opened_at": "2020-09-07 08:43:01",
"subcategory": null,
"master_incident": null,
"infrastructure_incident": false,
"resubmission": null,
"category": null,
"reject_count": null,
"chronology": "",
"knowledge": false,
"major_incident": false,
"slave_incidents": "",
"copy_cis_to_originators": false,
"agent_satisfaction": null,
"actual_end_datetime": null,
"planned_start_datetime": null,
"resolved_at": null,
"caused_by_changes": "",
"level_of_dependency": null,
"solved_by_changes": "",
"service_satisfaction": null,
"contact_type": "10",
"related_cis": "157477515313727442",
"closure_notes": "",
"complete_originators": false,
"related_incidents": null,
"related_problems": "",
"planned_end_datetime": null,
"related_articles": "",
"resolved_by": null,
"actual_start_datetime": null,
"has_breached": false,
"related_inquiry": null,
"closure_code": null,
"known_error": null,
"rererer": null,
"nenenenenen": null,
"steps_to_reproduce": "",
"short_description": null,
"work_notes": null,
"wf_executing_activity": null,
"service": 157416651911910348,
"sys_db_table_id": 156950677111866258,
"followers_list": ""
}
]
} |