Importing IBM Control Desk Incidents data for AIOPs

You can now import IBM Control Desk Incidents data in the JSON format and then using Python, execute Parser to parse the JSON output in the required format. Refer Importing IBM control Desk Incidents data for AIOPs for a detailed description.

1. Log in to the IBM Control Desk classic GUI, go to the System Configuration > Migration > Object Structures.
2. Click New Object Structure from the Common Actions section of the navigation bar to create a new Object Structure.
3. Enter the name in the Object Structure, for example, ICDINCIDENTAl, and select INTEGRATION in the Consumed By box.
4. Click New Row and add objects such as INCIDENT, SOLUTION, WORKLOG, or RELATEDRECORD.
5. Once you have added objects, click Add/Modify Application Export Support from the More Actions section of the navigation bar to enable the object structure for exporting and importing.
6. In Add/Modify Application Export Support window, click New Row and select INCIDENT for the Application column and click OK.
7. Click Exclude/Include Fields from the More Actions section of the navigation bar to exclude Fields as necessary, and click OK to continue.
8. Grant security access for import/export functionality.
   1. Log in to IBM Control Desk and from the navigation bar click Security > Security Groups.
   2. Select the group to which the user belongs to for example MAXADMIN.
   3. In the Application tab, select Incident in the Description column.
   4. Grant access for the Application Export.
9. Restart your Server.
10. Now you can perform exporting of data directly from the enabled application. Navigate to Service Desk > Incidents and Select Records that to be Exported.
11. Once the incident records are selected, click Application Export from the Common Actions section of the navigation bar.
12. Select the Object Structure that you created above in step 3, for example, ICDINCIDENTAI to export the data.
13. Expand Export configuration to select the format of the data and select JSON File option.
14. Once you click OK in the Application Export window, you will get a pop-up to download the JSON file in the zip file. Click OK to save the JSON file that contains all the incident records.
15. Download jason_parser.zip from page https://www.ibm.com/support/pages/node/6383258 and extract the folder.
16. Place the JSON file downloaded in step 15 in the extracted jason_parser folder.
17. Follow the below steps and open a command prompt from the jason_parser folder where you placed the JSON file along with parser.py and config files.
    • Go to the jason_parser folder.
    • Click on the location bar of Windows Explorer and remove the path details.
    • Type cmd in the location bar of Windows Explorer and press the Enter key.
    • The command prompt will open in the folder.
    • Using python, execute the below command:

      python.exe parsor.py "C:\<jason_parser>\<JSON file name>.json"

      For example:

      C:\jason_parser>python.exe parsor.py "C:\jason_parser\<JSON file name>.json"

    Note: Make sure you have python installed on your machine.
18. Once the script is completed successfully, you will get the below message on the screen.

    “Script completed successfully Please check output folder for generated json”

19. Check the output folder that contains Output.json in the same directory where you have executed the python script (in this case jason_parser folder).