Job Management Partner 1/Asset Information Manager Planning and Setup Guide

[Contents][Glossary][Index][Back][Next]

7.1.2 Notes on the import operation

This section provides additional information about creating CSV files and about specifying import conditions.

Organization of this subsection
(1) Non-editable properties
(2) Importing classes with ID
(3) Importing properties that can be specified using only alphanumeric characters
(4) Specifying the properties for user extension
(5) Importing object classes that are associated by the matching key property
(6) Update control during import operation
(7) Specification of CreationClassName
(8) Using Microsoft Excel for editing CSV files

(1) Non-editable properties

The Update ID managed item (UpdateInd property) is information that is used by the asset management system; it should not be edited. If information loaded from JP1/Software Distribution is imported using the jamimport command for updating and an invalid value was specified for Update ID, the information might be deleted the next time information is loaded from JP1/Software Distribution.

To avoid such a situation, it is recommended that when loading inventory information from JP1/Software Distribution after executing an import, all information be loaded irrespective of the update date.

When installed software information (InstalledInfo) is collected from JP1/Software Distribution inventory information, the date that is used to determine whether to update is determined from Update ID. Keep in mind that this value cannot be changed from a window operation after registering. When importing, do not specify anything for Update ID.

The following values are used for Update ID for installed software information.

Code Meaning
1 JP1/Software Distribution system information
2 JP1/Software Distribution installation package information
3 JP1/Software Distribution software inventory information
(blank) Information input by an Asset Information Manager window operation

(2) Importing classes with ID

When importing other than exported data, to import a class with an ID, such as Asset ID or Contract ID, specify the ID in the range 10001 to 1000000000. Each specified ID must be unique. If a specified ID is not within this range, it may duplicate a value assigned automatically by Asset Information Manager, thereby resulting in an error.

Specify an ID within the range from 10001 to 1000000000 for the following properties:

(3) Importing properties that can be specified using only alphanumeric characters

To import the following properties, their values must be specified using alphanumeric characters:

(4) Specifying the properties for user extension

For some managed items, items have been prepared for adding as needed. These are items (properties) for which the name includes UserProperty.

For such a user extension item, add a managed item in the Customize window and then specify the value to be managed.

For details about adding managed items, see 9.2 Changing managed items (Customize Managed Items).

(5) Importing object classes that are associated by the matching key property

When importing using the jamimport command, and when importing object classes that are associated by the matching key property, make sure that all have the same key property value.

For an object class that is always paired with asset information, such as hardware information, make sure that part of the hardware information and asset information is imported.

(6) Update control during import operation

Class properties include information (Update control) that determines whether the update operation is to be allowed when an attempt is made to update the same information more than once.

If exported data is imported and the same information had been updated after the export operation, the value of this Update control has changed. Therefore, the data cannot be imported with the value used during the export operation.

To overwrite the data to be imported whether any change has been made since the export operation, delete the Update control column (UpdateTime) and then import the data.

(7) Specification of CreationClassName

If you use the jamimport command to import data, make sure that you specify the object class name in the CreationClassName property of each object class.

(8) Using Microsoft Excel for editing CSV files

When editing CSV files to be registered in Asset Information Manager, if you use Microsoft Excel to open the files directly, the beginning 0 is automatically deleted from numerical values that begin with 0, such as codes and IDs. As a result, these values may be updated into those different from the original. Therefore, when using Microsoft Excel, use the Import Text File command to set the column data format to Text, and then load and edit the file.