9.18 Migrating Item data from a system other than JP1/Service Support
You can migrate Item data that was used in a system other than JP1/Service Support by using the jssitemimport or jssitemimportEx command. Before you migrate Item data, you need to output the Item data to a CSV file, and change the format of the CSV file to the format of the file for Item information entries or the file for extended Item information entries.
To migrate Item data from a system other than JP1/Service Support:
-
Output Item data to a CSV file.
In preparation, output the Item data to be migrated to a CSV file.
Create a CSV file with one of the following character encodings:
-
In a Japanese environment: MS932
-
In an English environment: ISO-8859-1
-
In a Chinese environment: GB18030
-
-
Change the format of the CSV file for Item data to the format of the file for Item information entries or the file for extended Item information entries.
Change the format of the CSV file for Item data so that it can be used as the Item data in the Item management database of the migration-destination. For details, see File for Item information entries (Optional) or File for extended Item information entries (Optional) in Chapter 13. Definition Files.
-
Prepare the code mapping file.
When you execute the jssitemimport command, use the code mapping file, as necessary, to convert the values of the following elements to the corresponding codes:
Severity, Impact level, Priority, Item type, Problem domain, Occurred type, Cause, Result, Solution category, Workaround type, Scale of change
If you have not customized an Item form, you can use the code mapping file provided with JP1/Service Support. If you have customized an Item form, prepare a code mapping file dedicated to the Item form. For details about code mapping files, see Code mapping file (jp1imss_itemimport_codemap.conf) in Chapter 13. Definition Files.
-
Stop all JP1/Service Support services except the JP1/Service Support - DB Server service.
Stop the services in the following order when you execute the jssitemimport command:
1. JP1/Service Support - Task Service service
2. JP1/Service Support - Web Service service
3. JP1/Service Support service
Keep the JP1/Service Support - DB Server service running.
If you execute the jssitemimportEx command, you do not have to stop the services.
-
Execute the jssitemimport or jssitemimportEx command.
To migrate Item data, execute the jssitemimport command if you created a CSV file with the format of the file for Item information entries. To migrate data after you created a CSV file with the format of the file of extended Item information entries, execute the jssitemimportEx command. While the command is executing, do not execute or terminate commands for maintaining the Item management database. Also, do not start or stop JP1/Service Support services. For details about the jssitemimport command, see jssitemimport (imports Item information) in Chapter 12. Commands. For details about the jssitemimportEx command, see jssitemimportEx (imports extended Item information) in Chapter 12. Commands.
-
Start the JP1/Service Support services.
If you stopped the services in step 4, start the services in the following order:
1. JP1/Service Support service
2. JP1/Service Support - Web Service service
3. JP1/Service Support - Task Service service