Hi, We are able to import with the same mapping file and data file using Import tool. We want to import through Command line to schedule a regular job. Moreover if we use 'cat' command to access my csv, it worked. So might not think there would be access problems.
Please suggest if something else I need to check. Regards, Vidhi From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kendhammer, Mike Sent: Wednesday, February 23, 2011 8:13 PM To: arslist@ARSLIST.ORG Subject: Re: Issue facing with dataimport utility - ARS 7.5 ** Vidhi, The only other things that come to mind are... - Do you have proper access to the .csv file and - Could there be something set incorrectly in your .armx file? Here is the .armx file that we use... <?xml version="1.0" encoding="UTF-8"?><importmapping> <options> <datahandling badrecords="SKIP" duplicaterecords="GEN_NEW_ID" stripleading="false" striptrailing="false" transactionSize="0" truncate="true"/> <timehandling amSymbol="" ampmSuffix="true" dateFormat="" dateSeparator="" dateTimeFormat="" pmSymbol="" timeFormat="" timeSeparator="" use24Hour="false"/> <realnumberhandling decimalSeparator="" digitgroupSeparator=""/> <flags allowTooFew="false" allowTooMany="false" disablePattern="false" disableRequired="true" forceoverride="false" multimatch="USEFIRST" suppressDefaults="false" suppressFilters="false"/> </options> <sourcefile filename="/u01/prodftp/prod/in/remedy/statusForRemedy.csv" seperator="," titles="false" type="CSV"/> <destinationserver name="hdtrnd"/> <formmappings> <formmap fileform="" serverform="CDS:CustomerProgramStatus"> <mapping field="536870916"> <normal fieldid="2" tokenIndex="2" type="FIELDID"/> </mapping> <mapping field="536870917"> <normal fieldid="0" tokenIndex="0" type="FIELDID"/> </mapping> <mapping field="536870915"> <normal fieldid="1" tokenIndex="1" type="FIELDID"/> </mapping> </formmap> </formmappings> </importmapping> Mike From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Vidhi Sharma Sent: Tuesday, February 22, 2011 11:23 PM To: arslist@ARSLIST.ORG Subject: Re: Issue facing with dataimport utility - ARS 7.5 ** Hi Mike, Thanks for your response. We tried the same command but still getting the error: ERROR - Cannot import, exception occured while importing /usr/bmc/importTest/ Import_Test.csv Regards, Vidhi From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kendhammer, Mike Sent: Wednesday, February 23, 2011 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Issue facing with dataimport utility - ARS 7.5 ** Hi Vidhi, Here is the command that we use on HP-UX, Oracle 11g system... /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 $Short Description$ -x hdtrnd -M /u02/apps/remedy/arHome/arcmds/CDSCust.armx -l /u02/apps/remedy/ar/db/import2.log -o /u01/prodftp/prod/in/remedy/statusForRemedy.csv Maybe this will help? Mike From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Vidhi Sharma Sent: Tuesday, February 22, 2011 5:43 AM To: arslist@ARSLIST.ORG Subject: Issue facing with dataimport utility - ARS 7.5 ** Hi, We are on AR server 7.5.00 Patch 004 OS - Solaris DB - Oracle 11g We need to schedule a job using dataimport utility. We are trying to execute the command through shell: /usr/jdk/instances/jdk1.5.0/jre/bin/java -cp /usr/bmc/ARSystem/api/lib/arapi75.jar:/usr/bmc/ARSystem/api/lib/log4j-1.2.14.jar:/usr/bmc/ARSystem/api/lib/arapiext75.jar com.bmc.arsys.apiext.data.DataImport -u arimport -p "password" -M /usr/bmc/importTest/ARMX.armx -l /usr/bmc/importTest/logFile.txt On execution of this command, following logs are created: INFO - AR System Import Tool 7.5.00 Feb 22, 2011 4:59:01 PM INFO - Starting import of /usr/bmc/importTest/Import_Test.csv ERROR - Cannot import, exception occured while importing /usr/bmc/importTest/ Import_Test.csv We have tried with both non-administrator and administrator users. Please suggest how to proceed further to successfully import of file. Regards, Vidhi Sharma ________________________________ ::DISCLAIMER:: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ----------------------------------------------------------------------------------------------------------------------- _attend WWRUG11 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 WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 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 WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"