Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Mike, Install the new data import tool on your server and modify your scripts to use its command line version instead of the arimportcmd. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: Wednesday, September 29, 2010 8:37 AM To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
? Mark Walters/BMC replied as well. He says that arimportcmd binary moved to the approval server directory. We hadn't installed the approval server - I was just poking around for stray copies of the binary while considering re-install. p. 239 of 7.6.3 Integration Guide discusses BMC Remedy Data Import utility. Looks like Windows to me (not Solaris). It's a batch file. No language about Unix, a script, or anything like that. I've verified that there's no file named dataimport on our server (in any directory). We captured execution of the installer and I've verified it. I don't see an option to install dataimport tool on the server, only standard server components - server, LDAP, Web Services, Mid Tier, Email, Flashboards, Approval Server, Assignment Engine, SNMP. How do you install dataimport tool on a Solaris server? Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, September 29, 2010 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Mike, Install the new data import tool on your server and modify your scripts to use its command line version instead of the arimportcmd. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: Wednesday, September 29, 2010 8:37 AM To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Hello Mike, In 7.6.03 data imports need to be done using java based import tool. It is available in arsuitekitinstall as one of the components to install Name of the java based jar is arapiext7603build001.jar This will get installed at same level as developer studio in AR System install directory. Hope this helps. Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: Wednesday, September 29, 2010 8:11 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
I would say install it on a client machine, and transfer it to the server..it's all java, and not 'windows' dependent that I know of. Certainly worth a try J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: Wednesday, September 29, 2010 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** ? Mark Walters/BMC replied as well. He says that arimportcmd binary moved to the approval server directory. We hadn't installed the approval server - I was just poking around for stray copies of the binary while considering re-install. p. 239 of 7.6.3 Integration Guide discusses BMC Remedy Data Import utility. Looks like Windows to me (not Solaris). It's a batch file. No language about Unix, a script, or anything like that. I've verified that there's no file named dataimport on our server (in any directory). We captured execution of the installer and I've verified it. I don't see an option to install dataimport tool on the server, only standard server components - server, LDAP, Web Services, Mid Tier, Email, Flashboards, Approval Server, Assignment Engine, SNMP. How do you install dataimport tool on a Solaris server? Mike White EMail michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, September 29, 2010 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Mike, Install the new data import tool on your server and modify your scripts to use its command line version instead of the arimportcmd. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: Wednesday, September 29, 2010 8:37 AM To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Mike, We are on 7.5.0 patch 6. This is the command line that I am trying to use on our HP-UX server. /opt/java1.5/jre/bin/java -cp /u02/apps/remedy/ar/api/lib/arapi75.jar:/u02/apps/remedy/ar/api/lib/log4j-1.2.14.jar:/u02/apps/remedy/ar/api/lib/arapiext75.jar com.bmc.arsys.apiext.data.DataImport -u remedy --p * -x hdtrnt -M /u02/apps/remedy/arHome/arcmds/CDSCust.armx -l /u02/apps/remedy/ar/db/import2.log I created the new armx format file on my PC, then transferred the file to the HP server and I don't recall ever installing anything. However, I am stuck at the moment as the log file is generating the following error... INFO - AR System Import Tool 7.5.00 Sep 14, 2010 7:56:57 AM INFO - Starting import of /u01/prodftp/prod/in/remedy/statusForRemedy.csv ERROR - Cannot import, exception occured while importing /u01/prodftp/prod/in/remedy/statusForRemedy.csv Not sure if this help... Mike From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Wednesday, September 29, 2010 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Hello Mike, In 7.6.03 data imports need to be done using java based import tool. It is available in arsuitekitinstall as one of the components to install Name of the java based jar is arapiext7603build001.jar This will get installed at same level as developer studio in AR System install directory. Hope this helps. Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: Wednesday, September 29, 2010 8:11 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Thanks, Mike. Based on LJ and Abhijeet's input, I'm headed down your path. I'm having trouble understanding Umakant (BMC support), but I think he wants to establish a WebEx session to also work in that direction (i.e. move the java stuff to the server). After installing Developer Suite on a workstation, the jar files are at: C:\Program Files\BMC Software\ARSystem\dataimporttool\plugins\com.bmc.arsys.studio.api_7.6.3.build001\lib So far, I've moved them to a just-created directory on our Solaris server. I need to find out where or figure out what com.bmc.arsys.apiext.data.DataImport is. As it appears in the command line, it looks like an argument to the java binary. The Windows (DOS) batch file looks similar. I've shared all this with support. Failing this, Mike Walters offered an alternative for arimportcmd. Evidently it was moved to the approval server directory. We hadn't installed the approval server (don't use it), but I'm willing to give it a shot (tomorrow, assuming that we're still stuck in java land!). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Wednesday, September 29, 2010 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Mike, We are on 7.5.0 patch 6. This is the command line that I am trying to use on our HP-UX server. /opt/java1.5/jre/bin/java -cp /u02/apps/remedy/ar/api/lib/arapi75.jar:/u02/apps/remedy/ar/api/lib/log4j-1.2.14.jar:/u02/apps/remedy/ar/api/lib/arapiext75.jar com.bmc.arsys.apiext.data.DataImport -u remedy --p * -x hdtrnt -M /u02/apps/remedy/arHome/arcmds/CDSCust.armx -l /u02/apps/remedy/ar/db/import2.log I created the new armx format file on my PC, then transferred the file to the HP server and I don't recall ever installing anything. However, I am stuck at the moment as the log file is generating the following error... INFO - AR System Import Tool 7.5.00 Sep 14, 2010 7:56:57 AM INFO - Starting import of /u01/prodftp/prod/in/remedy/statusForRemedy.csv ERROR - Cannot import, exception occured while importing /u01/prodftp/prod/in/remedy/statusForRemedy.csv Not sure if this help... Mike From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Wednesday, September 29, 2010 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Hello Mike, In 7.6.03 data imports need to be done using java based import tool. It is available in arsuitekitinstall as one of the components to install Name of the java based jar is arapiext7603build001.jar This will get installed at same level as developer studio in AR System install directory. Hope this helps. Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: Wednesday, September 29, 2010 8:11 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Mike, Can you attach / paste file / contents of /u02/apps/remedy/ar/db/import2.log which is the log file generated by the java import tool? Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Wednesday, September 29, 2010 11:47 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Mike, We are on 7.5.0 patch 6. This is the command line that I am trying to use on our HP-UX server. /opt/java1.5/jre/bin/java -cp /u02/apps/remedy/ar/api/lib/arapi75.jar:/u02/apps/remedy/ar/api/lib/log4j-1.2.14.jar:/u02/apps/remedy/ar/api/lib/arapiext75.jar com.bmc.arsys.apiext.data.DataImport -u remedy --p * -x hdtrnt -M /u02/apps/remedy/arHome/arcmds/CDSCust.armx -l /u02/apps/remedy/ar/db/import2.log I created the new armx format file on my PC, then transferred the file to the HP server and I don't recall ever installing anything. However, I am stuck at the moment as the log file is generating the following error... INFO - AR System Import Tool 7.5.00 Sep 14, 2010 7:56:57 AM INFO - Starting import of /u01/prodftp/prod/in/remedy/statusForRemedy.csv ERROR - Cannot import, exception occured while importing /u01/prodftp/prod/in/remedy/statusForRemedy.csv Not sure if this help... Mike From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Wednesday, September 29, 2010 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Hello Mike, In 7.6.03 data imports need to be done using java based import tool. It is available in arsuitekitinstall as one of the components to install Name of the java based jar is arapiext7603build001.jar This will get installed at same level as developer studio in AR System install directory. Hope this helps. Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: Wednesday, September 29, 2010 8:11 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please
Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
Abhijeet, This is what was in that log file. INFO - AR System Import Tool 7.5.00 Sep 14, 2010 7:56:57 AM INFO - Starting import of /u01/prodftp/prod/in/remedy/statusForRemedy.csv ERROR - Cannot import, exception occured while importing /u01/prodftp/prod/in/remedy/statusForRemedy.csv Mike From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Wednesday, September 29, 2010 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Mike, Can you attach / paste file / contents of /u02/apps/remedy/ar/db/import2.log which is the log file generated by the java import tool? Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Wednesday, September 29, 2010 11:47 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Mike, We are on 7.5.0 patch 6. This is the command line that I am trying to use on our HP-UX server. /opt/java1.5/jre/bin/java -cp /u02/apps/remedy/ar/api/lib/arapi75.jar:/u02/apps/remedy/ar/api/lib/log4j-1.2.14.jar:/u02/apps/remedy/ar/api/lib/arapiext75.jar com.bmc.arsys.apiext.data.DataImport -u remedy --p * -x hdtrnt -M /u02/apps/remedy/arHome/arcmds/CDSCust.armx -l /u02/apps/remedy/ar/db/import2.log I created the new armx format file on my PC, then transferred the file to the HP server and I don't recall ever installing anything. However, I am stuck at the moment as the log file is generating the following error... INFO - AR System Import Tool 7.5.00 Sep 14, 2010 7:56:57 AM INFO - Starting import of /u01/prodftp/prod/in/remedy/statusForRemedy.csv ERROR - Cannot import, exception occured while importing /u01/prodftp/prod/in/remedy/statusForRemedy.csv Not sure if this help... Mike From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gadgil, Abhijeet Sent: Wednesday, September 29, 2010 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) Hello Mike, In 7.6.03 data imports need to be done using java based import tool. It is available in arsuitekitinstall as one of the components to install Name of the java based jar is arapiext7603build001.jar This will get installed at same level as developer studio in AR System install directory. Hope this helps. Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: Wednesday, September 29, 2010 8:11 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Take a look in the approval server directory under your 7.6.03 install, you should find an arimportcmd binary in there. I'm not sure why it's no longer in the server/bin directory. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of White, Michael W (Mike) Sent: 29 September 2010 15:37 To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport (ARS 7.5 and 7.6.3) ** Greetings! We're working to upgrade from ARS 7.0.1, patch 7 to ARS 7.6.3 on our Solaris 5.10 server / Oracle 10g database. So far, so good, but arimportcmd seems to have been discontinued. I see in the integration guide that Remedy Import has been replaced by a new Java-based dataimport, but I can't find anything for server-side data imports. Searching arslist archives, I find threads from July for ARS 7.5 that seem to confirm that arimportcmd has been deprecated. I tried to reply directly from it, but botched it somehow. Hopefully this isn't a duplicate (apologies if so). Am I missing something? We have a number of external applications that deposit data files on our server, after which Remedy workflow, and in some cases, Unix shell scripts initiate the server-side imports (arimportcmd in our current version). Is there a way to handle server-side imports in 7.6.3 (or 7.5, for that matter)? Thanks in advance for any help you can offer. Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office
