This documentation supports the 9.1 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Enabling the Data Import utility

This section contains information about:

Use the Data Import command-line utility (a Java utility) to automate importing data in a multi- or single-threaded environment. (See Importing in a multithreaded environment.)

You can import with or without a mapping file. See Importing with a mapping file and Importing without a mapping file.

To use the Data Import utility on Windows

  1. Open the DataImport.bat file in ARSystemInstallDir/dataimporttool.
  2. Edit the batch file to set the following environment variables:
    • APIDROP — The location where arapiext91_build001.jar and arapi91_build001.jar or newer versions are installed.
    • JAVA_HOME — The location of your JDK (for example, C:\Program Files\Java\<Java_Home_Folder>).
    • Path
      For example:

      set APIDROP=.\plugins\\lib
      if not exist "%JAVA_HOME%" set JAVA_HOME=jdkPath
      set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP%
  3. Add the appropriate options to the command line in the batch file. Make sure the .jar file names in the classpath reflect the appropriate release of BMC Remedy AR System, for example:

    java -classpath %APIDROP%arapi91_build001.jar;%APIDROP%arapiext91_build001.jar; [options]

    For a list of available options, see Data Import command-line utility options.

  4. At the command line, run the batch file.

To use the Data Import utility on UNIX

  1. Navigate to the ARSystemHome/api/lib directory and make sure that the following .jar files, required to run the Data Import Utility, are present in the lib folder:
    • arapi91_build001.jar or arapi91_build002.jar (for Service Pack 1)
    • arapiext91_build001.jar or arapiext91_build002.jar (for Service Pack 1)
    • log4j-1.2.14.jar
  2. Create a file in the ARSystemHome/api/lib directory.
  3. Set the following environment variables in the file:
    • APIDROP — The location where arapiext91_build001.jar and arapi91_build001.jar or newer versions are installed.
    • JAVA_HOME — The location of your JDK (for example, /usr/Java/<Java_Home_Folder>).
    • Path
      For example:

      export JAVA_HOME
      export PATH


      Either execute the following command from the ARSystemHome/api/lib directory or set the Library Path and the Path variable using the following command: export LD_LIBRARY_PATH=$ARINSTALL/api/lib:$ARINSTALL/bin:$LD_LIBRARY_PATH export PATH=$ARINSTALL/api/lib:$ARINSTALL/bin:$PATH

  4. Enter the following command to use the Data Import utility on UNIX:

    exec java -cp $APIDROP/arapi91_build001.jar:$APIDROP/log4j-1.2.14.jar:$APIDROP/arapiext91_build001.jar ${1+"$@"} 

    The use of ${1+"$@"} option allows the command to accept inputs when the script is called.


For a list of available options, see Data Import command-line utility options.

Was this page helpful? Yes No Submitting... Thank you


  1. Peter Lundqvist

    I think that the following names should be changed:

    arapi90_build001.jar -> arapi91_build001.jar
    arapiext90_build001.jar -> arapiext91_build001.jar

    log4j version is still the same.

    Apr 11, 2016 08:04
    1. Prachi Kalyani

      Thank you, Peter for bringing this to our notice. I have updated the topic.



      Apr 11, 2016 08:11
  2. Davin Lindner-green

    Small error on step 4, in the UNIX section - there should be a space between the and the term ${1+"$@"} as in: ${1+"$@"}

    And of course the JAR file names will be different depending on the exact version and build number, but I think that is noted already.


    Sep 05, 2018 02:56