3.13 Exporting Item information to a CSV file
JP1/IM - Service Support provides a CSV output function, which exports Item data to a CSV file. Data of many Items can be saved in a single CSV file. With a listing of Item information in an exported file, you can analyze the occurrence trends of queries or failures. You can also output a CSV file as a backup of Items before maintenance of Item information or when terminating operation of a system or process work board that you are managing.
The CSV output function can output the following types of CSV files:
-
Item details file (output of Item information)
Item details such as the system name, person in charge, and status can be output.
This type of CSV files can be output by using the List of item search results window or the jssitemlist command.
-
Item history file (Item history output)
Item historical information can be output to a CSV file.
This type of CSV files can be output by using the jssitemhistory command.
-
Item information CSV file or related information CSV file (export of extended Item information)
This type of CSV file can be output by using the jssitemexportEx command.
Note that if Item information includes attached files, the attached files are also output.
When you are using the Item storage database in JP1/IM - Service Support Advanced Edition, you can also output information about stored Items to CSV files.
For details about how to output Item information to a CSV file by using the List of item search results window, see the Job Management Partner 1/Integrated Management - Service Support Operator's Guide.
For details about the procedure for outputting a CSV file by using a command (and the file output format), see jssitemlist (outputs a list of Items), jssitemhistory (outputs Item history), or jssitemexportEx (exports extended Item information) in Chapter 11. Commands.