Skip to Content

Data Import utility scenarios

The following examples show how you can use the Data Import utility in a multi-threaded environment:

  • In the following example, the -o option specifies the path to the directory that contains the data files to import. All of the data in the files is imported to the specified form.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -f formName -o dataFilePath -l logFilePath

    For example:com.bmc.arsys.apiext.data.DataImport -x machine1 -u joeuser -p 1a2b3c -f HelpDesk -o "C:\files" -l "C:\files\test.log"

    The data in the files in C:\files is imported to the HelpDesk form. A log is created in test.log.

  • In the following example, the -filelist option is used with -o, and only the data files listed are used. All of the data in the files is imported to the specified form.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -f formName -o dataFilePath -filelist listOfFiles -l logFilePath

    For example:com.bmc.arsys.apiext.data.DataImport -x machine1 -u joeuser -p 1a2b3c -f HelpDesk -o "c:\files" -filelist "user.arx, user.csv,abc.xml,xyz.ascii" -l "c:\files\test.log"

    The data in the user.arx, user.csv, abc.xml, and xyz.ascii files in C:\files is imported to the HelpDesk form. A log is created in test.log.

Related topics

Importing-with-the-Data-Import-utility

Data-Import-command-line-utility-options

Importing-data-into-forms-by-using-Data-Import

Scenarios with a mapping file

The following examples show you how you can use Data Import utility with a mapping file:

  • In the following example, the server name, form name, and data file name are optional because the mapping file contains the information:
    com.bmc.arsys.apiext.data.DataImport -u userName -p password -m mappingFileName -d mappingFileDir -l logFile
  • In the following example, the server name, form name, and data file name override the names in the mapping file. When you use the Data Import utility with a mapping file, you can override one or more of those names.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -m mappingFileName -d mappingFileDir -l logFile -o dataFilePath -f formName

Scenarios without a mapping file

Without a mapping file, you must specify the server name and data file name because there is no mapping file to provide such information. The -d and -a options are not shown in the following examples, but if you work with multiple servers on the same computer, you can use -d for duplicate record handling and -a to specify a port number.

The following examples show how you can use the Data Import utility without a mapping file:

  • In the following example, minimal options are used. The dataFilePath specifies the data file with path to import. If there are multiple data sets in the same data file, an import is attempted for all forms.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -o dataFilePath -l logFile
  • In the following example, the formName determines which set of data from the data file is imported to the server. The form name on the server and in the data file must match.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -f formName -o dataFilePath -l logFileName
  • In the following example, an import is being attempted into the form called formA on the server, but the data comes from formB in the data file.
    com.bmc.arsys.apiext.data.DataImport -x serverName -u userName -p password -f "formA=formB" -o dataFilePath -l logFileName

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix Innovation Suite 25.2