2.1.1 Importing data from another system into the asset management database
You can register the data migrated from other systems in a batch operation by importing the data into the asset management database. Provided you are working in a system environment that allows you to log in to Asset Console, you can import data from any location.
You can use the Import window to import data from a CSV file.
The following figure shows the Import window.
|
To import data, you must first create conditions and then import the data based on the conditions. Samples of import conditions are provided for each type of information. For details on the asset types used in these samples, see 4.10.2(1) Selecting the asset type in the Administration Guide.
In addition to using the Import window, you can also import data by executing jamCsvImport.bat or the jamimport command. For details about these data import methods, see 7.1.1 Inport flow in the Planning and Configuration Guide.
The procedure below explains how to import information managed by another system into the asset management database. In the example, the device information being managed includes machine numbers (a unique value assigned to each IT asset), names, PC statuses (Used or Unused), and MAC addresses.
|
-
Create a CSV file.
Only CSV data can be imported into the asset management database. As such, you must first create a CSV file containing the data you want to import. You can use any character strings for the item names in the CSV file. For details about the CSV file format, see 4.10.1(1) CSV file format in the Administration Guide.
The following figure shows an example of a created CSV file.
Figure 2‒3: Example of a created CSV file -
Change the Used and Unused character strings under PC Status.
To unify the statuses with those already being used in Asset Console, the PC statuses Used and Unused in the CSV file must be changed to Active and Stock, respectively.
To inherit the pre-migration names, use the Code window to change the character strings used as the statuses. For details about how to use the Code window, see 4.8.2 Changing a code's display value in the Administration Guide.
-
Create import conditions.
To register data into the asset management database, create import conditions and assign the item names in the CSV file to the managed items. To create import conditions, first click the Pattern button in the Import window to display the Select Category dialog box. After that, select Device information in the Category column. Next, click the Browse button for the managed items to display the Setting Assignment dialog box. In the dialog box, specify the managed item to which information from the CSV file is to be assigned. The following figure shows the Setting Assignment dialog box.
Figure 2‒4: Setting Assignment dialog box When specifying the import conditions, assign information to the managed items as shown below.
Table 2‒1: Settings for assigned items when the conditions are created Managed items
Setting for assigned items
Asset information.Asset No.
Specify Machine No. for CSV items.
Asset information.User name
Specify Name for CSV items.
Asset information.Usage management
Specify Used for Constant value.
Asset information.Status
-
Specify PC Status for CSV items.
-
Select the Assigned items check box, and select Active.
Asset information.Reg. date
Specify 2006/01/01 for Constant value.
Hardware information.MAC address
Specify MAC Address for CSV items.
Note the following when specifying the import conditions:
-
A star (
) indicates an item that must be specified.
-
If each asset is assigned a unique value as its asset number, the value that was used to manage the asset in another system can then be used as the asset number in Asset Console. If you do not register any values, asset numbers are provided automatically.
-
When you import MAC addresses, the management information collected from JP1/IT Desktop Management 2 - Manager is assigned as the information of the imported devices.
For details about how to create import conditions, see 4.10.2 Creating import conditions in the Administration Guide.
After you save the conditions, click the Back button to return to the previous window.
-
-
Import the data.
In the Import window, specify the created conditions, and import the data. For details about how to import data, see 4.10.3 Executing imports in the Administration Guide.
-
Check the import results.
In the Result Import window, check the results of the import operation. For details about how to check the import results, see 4.12 Checking the import results (Result Import) in the Administration Guide.
-
Manage the devices.
By using the Device Totals window, you can calculate the total number of devices you own, change device information from the Batch Update window, and perform other device management operations.
Repeat steps 1 to 4 of the import procedure until you have imported all of the information.