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\com.bmc.arsys.studio.api_90\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;
   com.bmc.arsys.apiext.data.DataImport [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 DataImport.sh file in the ARSystemHome/api/lib directory.
3. Set the following environment variables in the DataImport.sh 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:

     #!/bin/sh
     APIDROP=ARSystemHome/api/lib
     JAVA_HOME=${JAVA_HOME:-jdkPath}
     export JAVA_HOME
     PATH=$JAVA_HOME/bin:$PATH:$APIDROP
     export PATH

     Note

     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/arapi*_build009.jar:$APIDROP/log4j-1.2-17.jar:$APIDROP/arapiext91_build001.jar
   com.bmc.arsys.apiext.data.DataImport ${1+"$@"}

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