17.7 ioutils importassetassoc (importing asset association information)
Functionality
This command imports asset association information to a CSV file.
Each of the following assets can be associated with any one of the assets listed under it for import:
Hardware asset
-
Device
-
Hardware asset
-
Contract
Software license
-
Managed software
-
License to be upgraded
-
Device
-
Contract
Managed software
-
Software
-
Software license
Contract
-
Hardware asset
-
Software license
-
Contract vendor list
- Note
-
Hereafter, an asset association will be expressed as follows:
asset-information -> relevant-asset-information
For example, hardware asset information associated with device information can be expressed as "Hardware asset -> Device."
- Note
-
This command imports all rows, including the first row, as data rows.
When the CSV file contains an invalid value, the corresponding item does not get updated. If you specify the -detaildisplay option as an argument, information regarding the invalid value is printed on the standard output.
Execute this command on the management server.
Format
ioutils importassetassoc -import import-file-name -assoc asset-association-information-to-be-imported[ -encoding character-encoding][ -asset#prefix prefix][ -license#prefix prefix][ -contract#prefix prefix][ -detaildisplay]
Arguments
- -import import-file-name
-
Specify the absolute path (within 259 bytes) of the CSV file to import.
- -assoc asset-association-information-to-be-imported
-
Specify the asset association information to be imported. The following types of asset association information are available:
- asset-device
-
Hardware asset -> Device
- asset-asset
-
Hardware asset -> Hardware asset
- asset-contract
-
Hardware asset -> Contract
- license-mngsoftware
-
Software license -> Managed software
- license-upglicense
-
Software license -> License to be upgraded
- license-device
-
Software license -> Device
- license-contract
-
Software license -> Contract
- mngsoftware-software
-
Managed software -> Software
- mngsoftware-license
-
Managed software -> Software license
- contract-asset
-
Contract -> Hardware asset
- contract-license
-
Contract -> Software license
- contract-vendor
-
Contract -> Contract vendor list
- -encoding character-encoding
-
Specify a character code for assert association information to import. The following types of character codes can be specified. When you do not specify this argument, the character code is set to UTF-8.
-
US-ASCII
-
ISO-8859-1
-
UTF-8
-
UTF-8N
-
UTF-16
-
UTF-16LE
-
UTF-16BE
-
MS932
-
Shift-JIS
-
EUC-JP
-
JIS
-
- -asset#prefix prefix
-
Specify a prefix to be assigned to the asset numbers corresponding to the hardware assets to be imported.
Specify a string of no more than eight ASCII characters except control characters as a prefix. When data with the prefix exceeds the maximum length of data allowed (32 characters), the data items in the corresponding row of the CSV file will not be imported.
When any data items to be imported do not have asset numbers, this argument is ignored.
- -license#prefix prefix
-
Specify a prefix to be assigned to the license numbers corresponding to the software licenses to be imported.
Specify a string of no more than eight ASCII characters except control characters as a prefix. When data with the prefix exceeds the maximum length of data allowed (32 characters), the data items in the corresponding row of the CSV file will not be imported.
When any data items to be imported do not have license numbers, this argument is ignored.
- -contract#prefix prefix
-
Specify a prefix to be assigned to the contract numbers corresponding to the contracts to be imported.
Specify a string of no more than eight ASCII characters except control characters as a prefix. When data with the prefix exceeds the maximum length of data allowed (32 characters), the data items in the corresponding row of the CSV file will not be imported.
When any data items to be imported do not have contract numbers, this argument is ignored.
- -detaildisplay
-
Specify this argument when you want the following messages to be additionally printed to the standard output. For details about what cause these messages to be output, see the JP1/IT Desktop Management 2 Messages. When this argument is specified, the dots that are usually displayed to show the progress of processing do not show up in the window.
-
Detection of invalid values in the imported data (KDEX4476-W)
-
Row numbers corresponding to the error rows (rows that cannot be added or updated) (KDEX4477-W)
-
Storage location
JP1/IT Desktop Management 2-installation-folder\mgr\bin\
You can execute this command without specifying the storage location for the executable file, by using the command prompt provided by JP1/IT Desktop Management 2.
Notes
-
Execute this command when the management server setup is completed and the management server is running.
-
This command cannot be simultaneously executed by multiple users.
-
This command cannot be executed simultaneously with any of the following commands:
-
exportdb
-
importdb
-
ioassetsfieldutil export
-
ioassetsfieldutil import
-
ioutils exportasset
-
ioutils exportassetassoc
-
ioutils exportdevice
-
ioutils exportdevicedetail
-
ioutils exportfield
-
ioutils exportfilter
-
ioutils exportoplog
-
ioutils exportpolicy
-
ioutils exporttemplate
-
ioutils exportupdategroup
-
ioutils exportupdatelist
-
ioutils importasset
-
ioutils importexlog
-
ioutils importfield
-
ioutils importfilter
-
ioutils importpolicy
-
ioutils importtemplate
-
ioutils importupdategroup
-
ioutils importupdatelist
-
reorgdb
-
startservice
-
stopservice
-
updatesupportinfo
-
deletenwgroup
-
deletepackage
-
distributelicense
-
Return value
The following table shows the return values of the ioutils importassetassoc command.
|
Return values |
Description |
|---|---|
|
0 |
The command finished normally. |
|
11 |
The format for specifying the command arguments is invalid. |
|
12 |
The specified folder is invalid, the disk does not have sufficient capacity, or the folder does not exist. |
|
31 |
Another command is being executed. |
|
51 |
You do not have the permissions to execute this command. |
|
54 |
The management server has not been set up. |
|
80 |
The format of the file being imported is invalid. |
|
101 |
Command execution failed because there is not enough memory, or due to some other reason. |
|
120 |
A database access error occurred. |
|
150 |
The command execution was interrupted due to some other error. |
Example
The following example shows use of this command to import the exported Hardware asset -> Device association information (assetdeviceexpo.csv) to C:¥temp¥ with host01 prefixed to the asset numbers.
ioutils importassetassoc -import C:\temp\assetdeviceexpo.csv -assoc asset-device -encoding UTF-8 -asset#prefix host01
Related Topics: