3.13 Exporting Item information to a CSV file
JP1/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 Item information to 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.
Note that, when using an Item storage database, you can output not only the Item information of managed Items but also the Item information of stored Items to CSV files.
For how to output Item information to CSV files from the List of item search results window, see the description of the procedure to output Item information to CSV files in the JP1/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 12. Commands.