Mike,
Thanks for sharing this. We followed your lead and got it
working. We're still experimenting with arguments/switches/options, but this
command worked fine on our Solaris (5.10) server:
/usr/jdk/instances/jdk1.5.0/jre/bin/java -cp
/u01/ar/api/lib/arapi7603_build001.jar:/u01/ar/api/lib/log4j-1.2.14.jar:/u01/ar/api/lib/arapiext7603_build001.jar
com.bmc.arsys.apiext.data.DataImport -x vssinms84 -u uuuuuuuu -p pppppp -M
/u01/ar/import/maps/testimportunix.armx -l /u01/ar/import/logs/import2.log
Our AR install directory is /u01/ar.
None of this is documented in the integration guide (7.6.3); it
only discusses data imports from Windows. We used the Unix "find" command to
locate the 3 jar files referenced in the MS Windows (DOS) batch file
(C:\Program Files\BMC Software\ARSystem\dataimporttool\DataImport.bat):
arapi7603_build001.jar
arapiext7603_build001.jar
log4j-1.2.14.jar
These jar files are installed with the server; we didn't need
to FTP them from a Windows pc.
Thanks as well, LJ. This is an extension of what you suggested.
One final thought - a couple of arslist posters recommended a
different approach, using the old arimportcmd. One suggested using 7.1
libraries, and the other suggested installing the approval server (and advised
that the arimportcmd binary had been moved to one of its directories). We
didn't pursue either.
HTH.
Mike White
EMail [email protected]<mailto:[email protected]>
Office 813.978.2192
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Kendhammer, Mike
Sent: Wednesday, September 29, 2010 2:17 PM
To: [email protected]
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:[email protected]] On Behalf Of Gadgil, Abhijeet
Sent: Wednesday, September 29, 2010 11:03 AM
To: [email protected]
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) [[email protected]] On
Behalf Of Walters, Mark [[email protected]]
Sent: Wednesday, September 29, 2010 8:11 PM
To: [email protected]
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:[email protected]] On Behalf Of White, Michael W (Mike)
Sent: 29 September 2010 15:37
To: [email protected]
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 [email protected]<mailto:[email protected]>
Office 813.978.2192
_attend WWRUG10 www.wwrug.com<http://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.
_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"
