5.2.2 Collecting from CSV files
Asset Console enables you to acquire asset information from CSV files and insert it into the asset management database in a batch operation. This is called importing.
There are three ways to perform importing:
-
From the Import job menu
-
Using jamCsvImport.bat
-
Using the jamimport command
This section explains the advantages of the various methods of importing. Select the method that will give you the best efficiency on the basis of the information that you want to import.
-
Importing from the Import job menu
You can create import conditions for the CSV file in order to obtain the asset information that you want to register and update the CSV file asset information in a batch operation. You can specify in the conditions the items in the CSV file that are to be assigned to the Asset Console management items.
This method can import from anywhere, as long as it is an environment that can log in to the Asset Console.
You do not have to have knowledge of the CSV file format or of the classes or the relationships among classes in order to update information into the asset management database.
You can also register user reports, job window forms, JP1/IT Desktop Management 2 - Manager management information assignment settings, and import/export conditions.
However, you cannot import multiple CSV files at the same time or both register and delete at the same time.
-
Importing using jamCsvImport.bat
The same processing as when you use the Import job menu can be performed from the command line on the asset management server. This method is useful for automating asset information updating operations because you can update the asset information according to a job category, such as Device information, without being concerned about the CSV file format, the class, or the class relationship. However, processing time is greater than when you use the jamimport command.
With this method, the import conditions cannot be changed or saved.
-
Importing using the jamimport command
A CSV file with asset information to be updated can be created for each class, and the CSV files can be imported in a batch operation without having to accept or reject the contents of the CSV files.
With this method, you can import all object classes and you can import multiple CSV files at the same time. Moreover, each line in a CSV file can contain a register, change, or delete specification.
Because updates can be done in units of classes, data exported for backup can be restored and pinpoint data updates can be used. However, if CSV files are created following the method for data files and there are related classes, the shared property values must be made the same and must be imported at the same time.
For details about each import method, see 9.1 Registering CSV data (importing). For details about the information that can be imported (classes), see 20.1 Organization of classes.