9.1.5 File format for importing with the jamimport command

(1) Data files

To import into the asset management database using the jamimport command, you must create data files containing the asset information. The following describes the supported data file format, character encoding, delimiters, and the location of delimiters:

• File format

  Create a data file in CSV format.

• Supported character encoding

  Depending on the system locale of the machine on which the asset management server is installed, the character encoding used for the description differs.

  • Japanese: Shift_JIS encoding

  • English: ASCII encoding

  • Chinese: GBK encoding

• Delimiters and their locations

  Delimit each class data item by a linefeed code (CRLF or LF). Also delimit each class property by a comma (,). There is no limit to the number of classes or properties that can be specified in a data file.

To Page Top

(2) Data files definition file

To import multiple data files in a batch operation, create a data files definition file. The following describes the supported data files definition file format, character encoding, delimiters, and the location of delimiters:

• File format

  Create a data files definition file in text format.

• Supported character encoding

  Depending on the system locale of the machine on which the asset management server is installed, the character encoding used for the description differs.

  • Japanese: Shift_JIS encoding

  • English: ASCII encoding

  • Chinese: GBK encoding

• Delimiters and their locations

  • When importing object classes

    Specify the name of a data file to be imported paired with the corresponding object class name and delimit the pair with a linefeed code (CRLF or LF). Enclose each data file name and object class name in double quotation marks (") and separate the two with a comma.

  • When importing association classes

    Specify the name of a data file to be imported, the corresponding association class name, and the associated two object class names as a set, and delimit the set with a linefeed code (CRLF or LF). Enclose each data file name, association class name, and object class name in double quotation marks (") and separate them with a comma.

The figure below shows how to specify delimiters and their locations.

Figure 9‒1: Specifying delimiters and their locations

To Page Top