Re: Dataimport.bat
We do have Java installed, and if we installed it, wouldn't Java put a path in the Path statement? But never-the-less, it's not there so I tried: C:\Program Files (x86)\Java\jre6\bin\client C:\Program Files (x86)\Java\jre6\bin\client\ C:\Program Files (x86)\Java\jre6\bin After each add, I saved the path and got to a cmd prompt and typed in Java and it still giving me this error. Is there anything else I need to add? Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, January 30, 2012 5:27 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Correct ... It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http
Re: Dataimport.bat
FYI, the java.exe file is under C:\Program Files (x86)\Java\jre6\bin Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, January 31, 2012 8:45 AM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** We do have Java installed, and if we installed it, wouldn't Java put a path in the Path statement? But never-the-less, it's not there so I tried: C:\Program Files (x86)\Java\jre6\bin\client C:\Program Files (x86)\Java\jre6\bin\client\ C:\Program Files (x86)\Java\jre6\bin After each add, I saved the path and got to a cmd prompt and typed in Java and it still giving me this error. Is there anything else I need to add? Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, January 30, 2012 5:27 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Correct ... It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http
Re: Dataimport.bat
Found it! It's C:\Program Files (x86)\Java\jre6\bin\ I'll take it from here and see if I can now get this datatool to work. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, January 31, 2012 8:48 AM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** FYI, the java.exe file is under C:\Program Files (x86)\Java\jre6\bin Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, January 31, 2012 8:45 AM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** We do have Java installed, and if we installed it, wouldn't Java put a path in the Path statement? But never-the-less, it's not there so I tried: C:\Program Files (x86)\Java\jre6\bin\client C:\Program Files (x86)\Java\jre6\bin\client\ C:\Program Files (x86)\Java\jre6\bin After each add, I saved the path and got to a cmd prompt and typed in Java and it still giving me this error. Is there anything else I need to add? Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, January 30, 2012 5:27 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Correct ... It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins
Dataimport.bat
I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
Lisa are you typing in the command as you wrote below? open a DOS command box and type java, see what you get. If you get the error you are mentioning then you do not have java installed on the machine you are trying to run the command from. otherwise you will get the help from the java command. As for the import, you can run it from the ..\dataimporttool or the Developer Studio directory, you can also run it from a custom directory but then you have to make a slight change to the bat file. If you are still stuck email me directly and I will walk you through it. thanks Shafqat Ayaz From: Kemes, Lisa lisa.ke...@te.com To: arslist@ARSLIST.ORG Sent: Monday, January 30, 2012 10:01 PM Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn’t have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
Re: Dataimport.bat
Correct ... It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
Re: Dataimport.bat
If you liked using the arimport tool Of old...why don't you use the data import tool now? Dataimporttool.exe? It's a little different...but accomplishes the exact same thing. Just a thought... Bruce Sent from my iPad On Jan 30, 2012, at 5:26 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Correct … It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn’t have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
DataImport.bat file
We are moving from a 7.1p7 server to a 7.6.04 Server (Windows 2008) and used to use the arimportcmd.exe file to import data from our server. I'm reading up on the 7.6.04 Integration Guide and it says to use the DataImport.bat file. Do I actually have to install the Data Import tool on my Application Server or can I just copy and paste this file from my PC (which I did install the Data Import Tool) to our App Server? Thanks! Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DataImport.bat file
I think I answered my own question. Just took a look at the file and it says: This file assumes that it is being launched from the main Developer Studio directory Or dataimporttool directory as well and will fail if launched from somewhere else. So, I'll install the Data Import Tool on our App Server. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, January 17, 2012 2:29 PM To: arslist@ARSLIST.ORG Subject: DataImport.bat file ** We are moving from a 7.1p7 server to a 7.6.04 Server (Windows 2008) and used to use the arimportcmd.exe file to import data from our server. I'm reading up on the 7.6.04 Integration Guide and it says to use the DataImport.bat file. Do I actually have to install the Data Import tool on my Application Server or can I just copy and paste this file from my PC (which I did install the Data Import Tool) to our App Server? Thanks! Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are