11.4.4 Importing contract information
Importing contract information in a CSV file allows you to add or collectively edit the contract information.
You can import contract information by using the Import Assets wizard.
- Tip
-
You can also import contract information by executing the ioutils importasset command. The use of this command is recommended when contract information is periodically imported from a CSV file.
The Import Assets wizard relates items in a CSV file to the items managed in JP1/IT Desktop Management 2 after the CSV file is uploaded. In addition, the wizard specifies a key (mapping key) that is used to check whether the information to be imported corresponds to any existing information. After import settings are complete, check the settings, and if there are no problems, import the information.
To import contract information:
-
Display the Assets module.
-
In the menu area, select Contract and then Contract List.
-
Select Import Contract List from Action, and then start the Import Assets wizard.
-
In the What is this Wizard? view, check the import procedure, and then click the Next button.
-
In the Upload CSV file view, specify a CSV file that you want to import, and then click the Next button.
You can download a sample CSV file from this view. Use it as a reference when creating a CSV file.
-
In the Map Fields view, specify Mapping Key, CSV Fields, Header Line, and Import Starting Line, and then click the Next button.
You can also select a template that has already been created from Template Name.
-
In the Save Template dialog box, specify the template name and description, and then click the Yes button.
If you do not want to save the template, click the No button.
-
In the Confirm Settings view, check the settings, and then click the Import button.
If part of the data fails to be imported, details are displayed in Check Result Details. Before importing the data again, we recommend that you first modify the CSV file by checking Check Result Details, and then upload the CSV file again by clicking the Upload and Pre-Check CSV File button. To output the results of the check, click the Export button.
-
In the Complete view, check the import results, and then click the Close button.
The data in the CSV file is imported. To check the import status, click the Go to Last Import Log button.
Check whether the imported information is correctly registered. If an incorrect record exists, modify the CSV file, and then import the information again.
- Tip
-
You can also start the Import Assets wizard from the Settings module by selecting Assets and then Last Import Log. If you started the wizard from the Settings module, in the Upload CSV file view, specify Contact information for Asset Type.
Related Topics: