17.5  ioutils importasset (Importing hardware asset information)

Functionality

This command imports hardware asset information using a CSV file. For details about hardware asset items and the CSV file description format, see theJob Management Partner 1/IT Desktop Management Overview and System Design Guide.

When a CSV file is imported, hardware asset information is updated with the values set in the CSV file. However, items whose values are empty in the CSV file will not be updated after importing (that is, null values are not overwritten).

Execute this command on the following servers:

• In a single-server configuration system: Management server

• In a multi-server configuration system: Database server

Format

ioutils importasset -import import-file-name -template template-name [ -encoding character-encoding]

Arguments

-import import-file-name

Specify the absolute path (within 259 bytes) of the CSV file to import.

-template template-name

Specify a template to use for importing.

Only the items specified in the template will be imported.

If the specified items in the template do not exist in the import file, importing is performed as follows:

• Non-existent items are treated as omitted, and the values at the time of omission will be set for the asset information when importing is finished. The omitted items are not overwritten when importing overwrites the asset information.

• If a column associated with a mapping key does not exist, an error occurs and importing fails.

-encoding character-encoding

Specify a character encoding for the hardware assert 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

Storage location

JP1/IT Desktop Management-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.

Notes

• Execute this command in the following state:

  In a single-server configuration system: When the management server setup is completed, and the services on the management server have started.

  In a multi-server configuration system: When the management server and database server are already set, and the services on both servers have started.

• 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 exportdevice

  • ioutils exportdevicedetail

  • ioutils exportfield

  • ioutils exportfilter

  • ioutils exportoplog

  • ioutils exportpolicy

  • ioutils exporttemplate

  • ioutils exportupdategroup

  • ioutils importfield

  • ioutils importfilter

  • ioutils importpolicy

  • ioutils importtemplate

  • ioutils importupdategroup

  • reorgdb

  • startservice

  • stopservice

  • updatesupportinfo

Return value

The following table shows the return values of the ioutils importasset 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 or database server has not been set up.
72	The specified template does not exist.
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 hardware asset information file hardwareexpo.csv, which was exported to C:\temp\, using a template specified for importing hardware asset information.

ioutils importasset -import C:\temp\hardwareexpo.csv -template for hardware asset information import-encoding UTF-8

Related Topics:

• 17.1 Executing commands

To Page Top