17.34 ioassetsfieldutil import (importing the definitions of common management fields and additional management fields)

This section describes the ioassetsfieldutil import command, which imports the definitions of common management fields and additional management fields.

Functionality

This command imports the definitions of common management fields and additional management fields from a CSV file. You can use this command to add, update, or delete the definitions of common management fields and additional management fields in a batch operation.

If the command fails to import the definitions because the format of the CSV file is incorrect, the import log file is output. No more than 100 errors in the CSV file format are detected. For details about the actions to be taken when the command fails to import the definitions because the format of the CSV file is incorrect, see 18.6 Troubleshooting problems when an attempt to import the definitions of the common management fields and additional management fields fails.

If you use the ioassetsfieldutil import command to move a department definition, the following information is transferred to the new department:

• The security policy assigned to the previous department

• The agent configurations assigned to the previous department

• Any report data that is associated with the previous department

Execute the command as follows:

• In a single-server configuration: Execute the command on the management server when setup of the management server is complete and when the service on the management server is running.

• In a multi-server configuration: Execute the command on the database server when setup of both the management server and the database server is complete and when the services on both servers are running.

Format

ioassetsfieldutil import -field import-file-name[ -agentupdate timing-for-starting-user-entry][ -encoding character-encoding] [ -c]

Arguments

-field import-file-name

Specify the absolute path (by using 255 bytes or fewer) of the CSV file to be imported.

-agentupdate timing-for-starting-user-entry

Specify the time at which user entry is to start. If you omit this argument, the command is executed according to the setting displayed in Start Date for Entry of User Information that is displayed by choosing Asset Field Definitions from Asset Management in the Settings module.

You can specify the following values:

now

When a user executes the command, a message that prompts the user to enter information is displayed on the user's computer.

"YYYY-MM-DD HH:MM"^#

A message that prompts a user to enter information is displayed on the user's computer at the specified date (according to the local time of the user's computer).

#: YYYY: year, MM: month, DD: day, HH: hour, MM: minute

-encoding character-encoding

Specify a character encoding of the CSV file to be imported. You can use the character encodings shown below. If you omit this argument, the character encoding 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

-c

Specify this argument if you want only to check the format of the CSV file to be imported.

Storage location

JP1/IT Desktop Management-installation-folder\mgr\bin\

Notes

• 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

  • ioutils exportasset

  • ioutils exportdevice

  • ioutils exportdevicedetail

  • ioutils exportfield

  • ioutils exportfilter

  • ioutils exportoplog

  • ioutils exportpolicy

  • ioutils exporttemplate

  • ioutils exportupdategroup

  • ioutils importasset

  • ioutils importfield

  • ioutils importfilter

  • ioutils importpolicy

  • ioutils importtemplate

  • ioutils importupdategroup

  • reorgdb

  • startservice

  • stopservice

  • updatesupportinfo

• Do not execute this command while distribution is being executed. If you do, processing of the service (JP1_ITDM_Agent Control) temporarily stops, and the distribution might be delayed.

Return values

The following table shows the return values of the ioassetsfieldutil import command.

Return value	Description
0	The command finished normally.
1	Import succeeded, but an attempt to restart the agent control service failed.
11	The argument syntax is incorrect.
12	The specified folder is invalid, the disk does not have sufficient free space, or the folder does not exist.
31	Another command is currently executing.
51	You do not have permission to execute this command.
54	Either the management server or the database server is not set up.
80	The format of the file being imported is invalid.
87	An attempt to apply the imported data to the database failed.
101	Command execution failed either because there is insufficient memory or for some other reason.
120	A database access error occurred.

Example

The following example shows how to use this command to import the definitions of common management fields and additional management fields that had been exported to the file common.csv in C:\temp\.

ioassetsfieldutil import -field C:\temp\common.csv

Related Topics:

• 17.1 Executing commands

To Page Top