Remedy Performance Security and arimportcmd issue
Hello All, We are encountering a very strange issue with Remedy Performance Security and arimportcmd and were wondering if anyone on this list has dealt with this issue and know the fix for it. Our environment: Server OS: HP-UX B.11.31 Database: Oracle 10.2.0.4.0 - 64bi Database Client Libraries: Oracle 11.2.0 Remedy version: 7.6.04 SP4 201209051922 Remedy Encryption: Remedy Performance Security (Data Key Algorithm: AES (128), Public Key Algorithm: RSA 1024-bit, FIPS is not enabled) Here is the background of our issue. We run an arimportcmd via scripts to import csv data in to Remedy data tables. When we have the Encryption Set to Required they all fail and give us the following error: Unable to load mappings from file. However, when we set the Encryption to Disabled the arimportcmd works just fine and processes as expected. My Question: Do I need to set in the PATH or the LD_LIBRARY_PATH the path to the lib directory for the Remedy Performance Security, which would be /appl/Remedy/PerformanceSecurity/BMCPerformanceSecurityInstallJVM/lib or is there some other files we need to reference or some other settings in the scripts to enable this to work with the Encryption Set to Required? Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: Picture (Device Independent Bitmap) 1.jpg
Re: Remedy Performance Security and arimportcmd issue
Seems like Linux… (maybe some other Unix … they all have this concept) I usually use something called strace to see what is happening. I suspect if you tried strace … you will see a bunch of searching for a specific library… then after a bunch of internal file not found… you will see it exit. That may shed some light. http://linux.die.net/man/1/strace -John On Wed, Jun 5, 2013 at 11:18 AM, Pruitt, Christopher (Bank of America Account) christopher.pru...@hp.com wrote: ** Hello All, We are encountering a very strange issue with Remedy Performance Security and arimportcmd and were wondering if anyone on this list has dealt with this issue and know the fix for it. Our environment: Server OS: HP-UX B.11.31 Database: Oracle 10.2.0.4.0 - 64bi Database Client Libraries: Oracle 11.2.0 Remedy version: 7.6.04 SP4 201209051922 Remedy Encryption: Remedy Performance Security (Data Key Algorithm: AES (128), Public Key Algorithm: RSA 1024-bit, FIPS is not enabled) Here is the background of our issue. We run an arimportcmd via scripts to import csv data in to Remedy data tables. When we have the Encryption Set to “Required” they all fail and give us the following error: “Unable to load mappings from file”. However, when we set the Encryption to “Disabled” the arimportcmd works just fine and processes as expected. My Question: Do I need to set in the PATH or the LD_LIBRARY_PATH the path to the lib directory for the Remedy Performance Security, which would be /appl/Remedy/PerformanceSecurity/BMCPerformanceSecurityInstallJVM/lib or is there some other files we need to reference or some other settings in the scripts to enable this to work with the Encryption Set to “Required”? *Christopher Pruitt* Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 *HP Enterprises Services **christopher.pru...@hp.com **www.hp.com* http://www.hp.com/ *Confidentiality Notice:* This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _ARSlist: Where the Answers Are and have been for 20 years_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Picture (Device Independent Bitmap) 1.jpg
Re: arimportcmd 7.1 verses 7.6.04
Yes, But you will probably put it in a separate bin71-directory, with the required dlls/libs. You might also need to changed LD_LIBRARY_PATH before you call it on Unix/Linux. First you should try and run the 7.1 version and manually to see if it resolves your problem. Best Regards - Misi, RRR AB, http://rrr.se Are you saying copy the arimportcmd from the 7.1 server to the 7.6.04 server? Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, March 11, 2013 12:55 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd 7.1 verses 7.6.04 Hi, Why not use the old arimportcmd against the new server? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: arimportcmd 7.1 verses 7.6.04 - RESOLVED
We finally found the issue. It turns out our SA blocked our server account's access to the /sbin/sh file and the script could not execute. Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ [HP_logo] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Steve Kallestad Sent: Monday, March 11, 2013 3:30 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd 7.1 verses 7.6.04 ** Error 38 happens when a filter is doing set fields $PROCESS$ and the process isn't returning a value. I would hope in your import log there's some more information - like which filter is actually causing the problem. I imagine that the 7.1 import tool will give you the same problem. I have seen this issue occur when the number of processes running on a server has reached it's limit. (because the processes being run were not exiting cleanly. If there is no further message in the import log, I would try to run a small import the same way with server side logging turned on to track down the offending filter. For a large and regular batch job, I would re-qualify the filter so that my import could set a flag and disable it, then make handle whatever it was trying to accomplish in a bulk transaction after the batch was complete. On Mon, Mar 11, 2013 at 10:23 AM, Pruitt, Christopher (Bank of America Account) christopher.pru...@hp.commailto:christopher.pru...@hp.com wrote: ** I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.commailto:christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.png
arimportcmd 7.1 verses 7.6.04
I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: Picture (Device Independent Bitmap) 1.jpg
Re: arimportcmd 7.1 verses 7.6.04
Hi, Why not use the old arimportcmd against the new server? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: arimportcmd 7.1 verses 7.6.04
Hi Chris, Maybe the issue isn't actually with the ARImport. Did you track down in the filter log the filter / action that is kicking out the error? If it's a process call it could be something at the server level or maybe something in the new version (7.6.04) filters that is expecting something the 7.1 version didn't. - Original Message - From: Christopher Pruitt (Bank of America Account) christopher.pru...@hp.com To: arslist@ARSLIST.ORG Sent: Monday, March 11, 2013 1:23:15 PM Subject: arimportcmd 7.1 verses 7.6.04 ** I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: arimportcmd 7.1 verses 7.6.04
Are you saying copy the arimportcmd from the 7.1 server to the 7.6.04 server? Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, March 11, 2013 12:55 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd 7.1 verses 7.6.04 Hi, Why not use the old arimportcmd against the new server? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: arimportcmd 7.1 verses 7.6.04
Error 38 happens when a filter is doing set fields $PROCESS$ and the process isn't returning a value. I would hope in your import log there's some more information - like which filter is actually causing the problem. I imagine that the 7.1 import tool will give you the same problem. I have seen this issue occur when the number of processes running on a server has reached it's limit. (because the processes being run were not exiting cleanly. If there is no further message in the import log, I would try to run a small import the same way with server side logging turned on to track down the offending filter. For a large and regular batch job, I would re-qualify the filter so that my import could set a flag and disable it, then make handle whatever it was trying to accomplish in a bulk transaction after the batch was complete. On Mon, Mar 11, 2013 at 10:23 AM, Pruitt, Christopher (Bank of America Account) christopher.pru...@hp.com wrote: ** I was hoping someone can point me in the correct direction. We have several dozen scripts we run on our servers that do data imports using the arimportcmd. We have been running these scripts, in some capacity, for over 9+ years without issue. However, we upgraded one of our servers to 7.6.04 and now everyone of these scripts fail to run using the arimportcmd. I have been digging through all the documentation I can for 7.6.04 and have searched the BMC Knowledgebase, and even tried doing Google searches trying to see why the arimportcmd just stopped working. The error we are seeing in the filter log is Error while performing filter action: Error 38 We format the arimportcmd as follows: passing in the variable values arimportcmd -r $RPC_NUMBER -x $SERVER_NAME -u $USER_NAME -p $PASSWORD -m $MAPPING_FILE_NAME -d $MAPPING_DIR -o $LOAD_HOME/$FILE_TYPE/$DATA_FILE -l $LOG_FILE_NAME /dev/null 21 *Christopher Pruitt* Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 *HP Enterprises Services **christopher.pru...@hp.com **www.hp.com* http://www.hp.com/ *Confidentiality Notice:* This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
arimportcmd / dataimport thread anyone ever find a resolution for unix/linux?
I am going through the pains of discovering that the dataimport tool is not on linux (only arimportcmd). I saw a thread on the arslist that said they were trying to transfer the java libraries from their windows machine to unix and setting up the data import utility that way. I never saw the results (from the threads I saw). Has anyone done it already and what were the steps you went through to get it working? Thanks, Sean ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd / dataimport thread anyone ever find a resolution for unix/linux?
Sean, It's not documented (Integration Guide) - only the MS Windows implementation. BMC support on the issue is iffy. Some techs are aware, others aren't. That said, the 3 jar files referenced in the Integration Guide are available on the Unix server (Solaris in our case, I presume Linux is the same). The files are: arapi7603_build001.jar log4j-1.2.14.jar arapiext7603_build001.jar We were able to get it working via the following command (Set Fields w/ $PROCESS$ in our case): /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 -p pp -M /u01/ar/import/maps/testimportunix.armx -l /u01/ar/import/logs/import2.log Note: -Our AR install directory is /u01/ar -vssinms84 is our server name -I've substituted our userid and password (, pp) -subdirectory /u01/ar/import is home-grown; these files can be stored wherever you want In the end, it works much like arimportcmd did. 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 Garrison, Sean (Norcross) Sent: Wednesday, October 13, 2010 1:19 PM To: arslist@ARSLIST.ORG Subject: arimportcmd / dataimport thread anyone ever find a resolution for unix/linux? ** I am going through the pains of discovering that the dataimport tool is not on linux (only arimportcmd). I saw a thread on the arslist that said they were trying to transfer the java libraries from their windows machine to unix and setting up the data import utility that way. I never saw the results (from the threads I saw). Has anyone done it already and what were the steps you went through to get it working? Thanks, Sean _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
RESOLVED: arimportcmd / dataimport (ARS 7.5 and 7.6.3)
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 -p pp -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 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
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 ___ 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)
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
Re: arimportcmd woes on Solaris. no error, no import
Rabi, I know this may not be ideal, but you may want to upgrade your arimportcmd fileas you know, you can easily use a newer client on an older server7.1 was the last version with the arimportcmd, or you could use the new version in 7.5they might fix the problem you are having as it may be a client issue -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Wednesday, June 30, 2010 9:37 AM To: arslist@ARSLIST.ORG Subject: arimportcmd woes on Solaris. no error, no import Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
arimportcmd woes on Solaris. no error, no import
Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd woes on Solaris. no error, no import
There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 woes on Solaris. no error, no import
Guys, We've had this discussion many times in the past. Run a dos2unix over the mapping file to get rid of the DOS line endings. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com Ben.Chernys _AT_ softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: June 30, 2010 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 woes on Solaris. no error, no import
Rick, I tried -L for logging, as suggested on a post somehere...didn't work. Anybody knows what the flag may be? Nothing in the manual. Can anybody give me a command line that's working for them...in solaris? Preferably with v 6.x of arimportcmd. Thanks. --- On Wed, 6/30/10, Rick Cook remedyr...@gmail.com wrote: From: Rick Cook remedyr...@gmail.com Subject: Re: arimportcmd woes on Solaris. no error, no import To: arslist@ARSLIST.ORG Date: Wednesday, June 30, 2010, 11:40 AM ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 woes on Solaris. no error, no import
If you don't have dos2unix you can do the same thing inside vi on the Unix box. :%s/Ctrl-VCtrl-M//g (Yes that is colon followed by a percent sign, followed by a lowercase s, followed by a slash, followed by a Control V, followed by a Control M, then 2 slashes and a lowercase g) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Wednesday, June 30, 2010 11:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** Guys, We've had this discussion many times in the past. Run a dos2unix over the mapping file to get rid of the DOS line endings. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: June 30, 2010 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import-File-Format: 2 Import-Field-Titles: 1 Import-Field-Separator: Bad-Record-Handling: 0 Duplicate-Id-Handling: 0 Import-Log-Filename: /opt/remedy/local/arimport.log Strip-White-Space: 1 Truncate-Values: 0 Disable-Required-ness: 0 Disable-Pattern: 0 Allow-Too-Many-Fields: 1 Allow-Too-Few-Fields: 1 Mapping: 736871090=$BUILDING$ Mapping: 736870988=$EXTENSION$ Mapping: 24004=$FNAME$ Mapping: 736870963=$FLOOR$ Mapping: 24003=$LNAME$ Mapping: 736871176=$MAC$ Mapping: 8=$NOTES$ Mapping: 736870971=$TYPE$ Mapping: 736870964=$ROOM$ Mapping: 7=Active Mapping: 24000=$ID$ Mapping: 736871107=0 end Used for nightly import of extension data into Remedy What's going on? I'm about to write a Perl script to take the csv and loop around doing create_entry. Don't want to. TIA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd woes on Solaris. no error, no import
I tried the import on my Windows PC using Windows verison of arimportcmd, with the same result...log file is there with those 4 lines and nothing happens. I tried the same mapping on the same PC using Remedy Import. It works. About Windows vs Unix bin vs text...I am aware of the difference and I transferred the file to Solaris using text mode. At any rate, above experiment rules out line ends as the issue. What's the deal with arimportcmd?? It reads the mapping, then writes the header on the right log file...then decides to take a vacation??? Sucks. --- On Wed, 6/30/10, Grooms, Frederick W frederick.w.gro...@xo.com wrote: From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: arimportcmd woes on Solaris. no error, no import To: arslist@ARSLIST.ORG Date: Wednesday, June 30, 2010, 1:35 PM If you don't have dos2unix you can do the same thing inside vi on the Unix box. :%s/Ctrl-VCtrl-M//g (Yes that is colon followed by a percent sign, followed by a lowercase s, followed by a slash, followed by a Control V, followed by a Control M, then 2 slashes and a lowercase g) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Wednesday, June 30, 2010 11:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** Guys, We've had this discussion many times in the past. Run a dos2unix over the mapping file to get rid of the DOS line endings. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: June 30, 2010 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site has no useful bugs on this topic. A few reports of similar issues closed with user error. I triple checked myself, but I swear there is no error on me today. My command line: /opt/remedy/bin/arimportcmd -u Test User -p password -x remedy.company.edu -d /opt/remedy/local/misc -m ARMappingForVOIPPhExtDumpImport My mapping file (/opt/remedy/local/misc/ARMapping.arm): - ARMappingForVOIPPhExtDumpImport SchemaName: CU:Phone-StagingFormForImport ServerName: remedy.company.edu Import-Filename: /opt/remedy/local/PhoneExtensionDump.csv Import
Re: arimportcmd woes on Solaris. no error, no import
We call a cmd file to perform the import. Within the file is the line below. C:\Program Files\AR System\us194ap39\arimportcmd.exe -u user -p password -x server.tycoelectronics.com -a 5213 -l f:\logs\nnmeventdbimport.log -M C:\Program Files\AR System\us194ap39\Importmap\nnmeventdb.arm Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Wednesday, June 30, 2010 1:58 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import I tried the import on my Windows PC using Windows verison of arimportcmd, with the same result...log file is there with those 4 lines and nothing happens. I tried the same mapping on the same PC using Remedy Import. It works. About Windows vs Unix bin vs text...I am aware of the difference and I transferred the file to Solaris using text mode. At any rate, above experiment rules out line ends as the issue. What's the deal with arimportcmd?? It reads the mapping, then writes the header on the right log file...then decides to take a vacation??? Sucks. --- On Wed, 6/30/10, Grooms, Frederick W frederick.w.gro...@xo.com wrote: From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: arimportcmd woes on Solaris. no error, no import To: arslist@ARSLIST.ORG Date: Wednesday, June 30, 2010, 1:35 PM If you don't have dos2unix you can do the same thing inside vi on the Unix box. :%s/Ctrl-VCtrl-M//g (Yes that is colon followed by a percent sign, followed by a lowercase s, followed by a slash, followed by a Control V, followed by a Control M, then 2 slashes and a lowercase g) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Wednesday, June 30, 2010 11:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** Guys, We've had this discussion many times in the past. Run a dos2unix over the mapping file to get rid of the DOS line endings. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: June 30, 2010 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above. Else it just completes running with no output, no import, nothing. My version is...ahem...6.3. Server patch 25, arimportcmd...I believe is patch 19. Support site
Re: arimportcmd woes on Solaris. no error, no import
Set API and SQL logging on the server, so you'll see what calls were made before it took its vacation. That may give you a clue. Also, you can run client logging with ARAPILOGGING=1 in the shell before executing the arimportcmd. API logging is an environment var and will cause two files to be generated in the current working directory. Works same in Windows and Unix. The files are not wonderful but they will at least let you know what API calls were made. Cheers Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: June 30, 2010 7:58 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import I tried the import on my Windows PC using Windows verison of arimportcmd, with the same result...log file is there with those 4 lines and nothing happens. I tried the same mapping on the same PC using Remedy Import. It works. About Windows vs Unix bin vs text...I am aware of the difference and I transferred the file to Solaris using text mode. At any rate, above experiment rules out line ends as the issue. What's the deal with arimportcmd?? It reads the mapping, then writes the header on the right log file...then decides to take a vacation??? Sucks. --- On Wed, 6/30/10, Grooms, Frederick W frederick.w.gro...@xo.com wrote: From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: arimportcmd woes on Solaris. no error, no import To: arslist@ARSLIST.ORG Date: Wednesday, June 30, 2010, 1:35 PM If you don't have dos2unix you can do the same thing inside vi on the Unix box. :%s/Ctrl-VCtrl-M//g (Yes that is colon followed by a percent sign, followed by a lowercase s, followed by a slash, followed by a Control V, followed by a Control M, then 2 slashes and a lowercase g) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Wednesday, June 30, 2010 11:14 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** Guys, We've had this discussion many times in the past. Run a dos2unix over the mapping file to get rid of the DOS line endings. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting begin_of_the_skype_highlighting +49 171 380 2329 end_of_the_skype_highlighting GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: June 30, 2010 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd woes on Solaris. no error, no import ** There is a flag to turn logging on - sometimes that can be helpful. Also, I believe that 6.3 had a syntax bug in the documentation for the arimport. It's been a while, so I don't remember exactly what was wrong, but you might look at a more recent version to get updated syntax to try. Rick On Wed, Jun 30, 2010 at 11:37 AM, Rabi Tripathi ars_l...@yahoo.com wrote: Hi all, I have a .arm mapping file that works fine when used with the GUI version of the tool (Remedy Import) to import a csv file into a form. I take the mapping file to a Solaris box, change two path parameters in the file (import file, log file), and it doesn't work. On the Solaris box, I see that the mapping file was read by arimportcmd because it spits out log text to a file as specified in the Import-Log-Filename: parameter in the mapping file. This is the log file content (4 lines): AR System Import Tool Wed Jun 30 00:55:45 2010 How useful! arimportcmd completes running right away, no message on the screen, no import. I verified that the path to the import file is right, permissions are right. I made sure that the mapping file transfer from Windows to Unix was right (tried both text vs bin format) I can't even begin to troubleshoot, because it won't tell me what's wrong. Well, I did try troubleshooting by specifying the import and log files as well as the form name on the command line... ...by messing up various pieces of info on the command line and on the mapping file (username, password, server name, mapping name, directory) to cause it to give me error, some error, any error! Nothing. It won't ever complain of anything! If it can, it spits out the log as above
Re: arimportcmd going away for solaris with 7.5 - any replacement ideas ?
You can use the dataimport java api, and you can still use your current mapping files. It is explained at page 218 in BMC Remedy Action Request System 7.5.00 Integration Guide This is an example on Windows: -- set CUR_DIR=%~dp0 SET ARJARPATH=C:\Program Files\BMC Software\ARSystem\dataimporttool\plugins\com.bmc.arsys.studio.api_7.5.0\lib SET JAVA=C:\Program Files\Java\jre6\bin\java.exe SET ARIMPORT=com.bmc.arsys.apiext.data.DataImport -Xms64m -Xmx512m rem Set the classpath to include all the required jar files SET CLASSPATH=%CUR_DIR%;%ARJARPATH%\arapiext75.jar;%ARJARPATH%\arapi75.jar;%ARJARPATH%\log4j-1.2.14.jar SET MAPPINGDIR=c:\temp SET REMEDYSERVER=server SET ARSPROG=%JAVA% %ARIMPORT% -x %REMEDYSERVER% -u username -p password -m import -d %MAPPINGDIR% -f Jarl:Import REM SET ARSPROG=%JAVA% %ARIMPORT% %* -M c:\temp\mapping.arm %ARSPROG% - Regards, Jarl 2010/5/20 Paul Killion gp-nt.3...@inbox.com: arslisters, with 7.5, there is no Unix arimportcmd executable to automate bringing in data from cron scripts, batch processing of alarms, A/D people loading. With Solaris as the OS for remedy server, what have others decided to use for importing data. Remedy has told us us to use the WindowsOS arimport.exe program. Not to easy to automate and not a good platform for us. 7.1 arimportcmd fails to run, complains of wrong libraries, failing to start. - roll out custom solaris api interface ? - javascript api ?? - utilize cmdb import functions from cvs files ?? ideas ??? Thanks. PK FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
arimportcmd going away for solaris with 7.5 - any replacement ideas ?
arslisters, with 7.5, there is no Unix arimportcmd executable to automate bringing in data from cron scripts, batch processing of alarms, A/D people loading. With Solaris as the OS for remedy server, what have others decided to use for importing data. Remedy has told us us to use the WindowsOS arimport.exe program. Not to easy to automate and not a good platform for us. 7.1 arimportcmd fails to run, complains of wrong libraries, failing to start. - roll out custom solaris api interface ? - javascript api ?? - utilize cmdb import functions from cvs files ?? ideas ??? Thanks. PK FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: arimportcmd going away for solaris with 7.5 - any replacement ideas ?
Meta-Update runs on Sun Solaris, Linux, as well as Windows and can be used to automate imports. Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Paul Killion Sent: May 20, 2010 10:44 PM To: arslist@ARSLIST.ORG Subject: arimportcmd going away for solaris with 7.5 - any replacement ideas ? arslisters, with 7.5, there is no Unix arimportcmd executable to automate bringing in data from cron scripts, batch processing of alarms, A/D people loading. With Solaris as the OS for remedy server, what have others decided to use for importing data. Remedy has told us us to use the WindowsOS arimport.exe program. Not to easy to automate and not a good platform for us. 7.1 arimportcmd fails to run, complains of wrong libraries, failing to start. - roll out custom solaris api interface ? - javascript api ?? - utilize cmdb import functions from cvs files ?? ideas ??? Thanks. PK FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 going away for solaris with 7.5 - any replacement ideas ?
Hi, Try putting the 7.1 libraries with your old arimportcmd-version and point your LD_LIBRARY_PATH to them. This configuration should work fine at least up to version 7.6 of the AR Server. Probably much linger than that. Best Regards - Misi, RRR AB, http://rrr.se arslisters, with 7.5, there is no Unix arimportcmd executable to automate bringing in data from cron scripts, batch processing of alarms, A/D people loading. With Solaris as the OS for remedy server, what have others decided to use for importing data. Remedy has told us us to use the WindowsOS arimport.exe program. Not to easy to automate and not a good platform for us. 7.1 arimportcmd fails to run, complains of wrong libraries, failing to start. - roll out custom solaris api interface ? - javascript api ?? - utilize cmdb import functions from cvs files ?? ideas ??? Thanks. PK FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARIMPORTCMD Problem with accentuation
arimportcmd is using your charset, hence writes OK to arimport.log, while arserver side looks like is in en_US, thus sql log printing will not print these characters. - a.g.bryan.14 On Thu, Aug 13, 2009 at 8:35 PM, Hellyson helly...@gmail.com wrote: ** I have a problem when I try to import some data with accentuation using arimporcmd command at the MS-DOS Here, in Brazil, we use accentuation (^,~,´, etc) in some words, when i try to import a csv file, in the arimport.log displays the correct data, but in the arsql.log displays the wrong data. Example: Log of Import Marcão;5/7 - 11/7/2009;SextaAusência;;; Log of SQL: SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC I did the test on my machine, development server and approval server. Operation System: Windows DB: Microsoft SQL Server 2003 ARS Server Version: 7.1.00 Patch 002 Hellyson helly...@gmail.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ARIMPORTCMD Problem with accentuation
I have a problem when I try to import some data with accentuation using arimporcmd command at the MS-DOS Here, in Brazil, we use accentuation (^,~,´, etc) in some words, when i try to import a csv file, in the arimport.log displays the correct data, but in the arsql.log displays the wrong data. Example: Log of Import Marcão;5/7 - 11/7/2009;SextaAusência;;; Log of SQL: SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC I did the test on my machine, development server and approval server. Operation System: Windows DB: Microsoft SQL Server 2003 ARS Server Version: 7.1.00 Patch 002 Hellyson helly...@gmail.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: ARIMPORTCMD Problem with accentuation
it looks like your csv file is UTF-8 encoded. But arimportcmd is expecting a file encoded in your native codepage. (CP1252) Try to open the file in notepad and in the Save As Dialog choose ANSI encoding and save the file. HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Hellyson Gesendet: Donnerstag, 13. August 2009 17:06 An: arslist@ARSLIST.ORG Betreff: ARIMPORTCMD Problem with accentuation ** I have a problem when I try to import some data with accentuation using arimporcmd command at the MS-DOS Here, in Brazil, we use accentuation (^,~,´, etc) in some words, when i try to import a csv file, in the arimport.log displays the correct data, but in the arsql.log displays the wrong data. Example: Log of Import Marcão;5/7 - 11/7/2009;SextaAusência;;; Log of SQL: SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC I did the test on my machine, development server and approval server. Operation System: Windows DB: Microsoft SQL Server 2003 ARS Server Version: 7.1.00 Patch 002 Hellyson helly...@gmail.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
Data Import using arimportcmd -- Linux O/S
Hi All, We have to import data into one of our Remedy application every night. For that I have built one Escalation with necessary information Such as mapping file info and directories information where i am going to place mapping file and data file. The problem is Remedy does support only few formats Such as .CSV, .XML, .arx., .asc and our AR Server is running on Linux O/S and since we can’t place a CSV file in Linux server and it does support only ASCII text files format, if client wants to provide the data in the form of a CSV file how to import that data into Remedy? Any ideas and help would be greatly appreciated. Thanks SPrasad -- View this message in context: http://www.nabble.com/Data-Import-using-arimportcmdLinux-O-S-tp22375892p22375892.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Data Import using arimportcmd -- Linux O/S
I'm not fully understanding why you say you can't place a csv file on Linux...that statement doesn't make sense to me. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SPrasad Sent: Friday, March 06, 2009 9:32 AM To: arslist@ARSLIST.ORG Subject: Data Import using arimportcmd -- Linux O/S Hi All, We have to import data into one of our Remedy application every night. For that I have built one Escalation with necessary information Such as mapping file info and directories information where i am going to place mapping file and data file. The problem is Remedy does support only few formats Such as .CSV, .XML, .arx., .asc and our AR Server is running on Linux O/S and since we can't place a CSV file in Linux server and it does support only ASCII text files format, if client wants to provide the data in the form of a CSV file how to import that data into Remedy? Any ideas and help would be greatly appreciated. Thanks SPrasad -- View this message in context: http://www.nabble.com/Data-Import-using-arimportcmdLinux-O-S-tp22375892p 22375892.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Data Import using arimportcmd -- Linux O/S
CSV is a form of ASCII text file. All you do is format it properly, and put the .csv extension. If your configuration doesn't allow files with CSV extension, then you have a different issue, which is not Remedy related. Perhaps you can format in XML and import that way. XML is a form of ASCII text file, with the .XML extension. I am not an Linux expert, but I don't think CSV or XML are excluded. Is it possible I'm mis understanding your issue? Thanks, Mark From: Action Request System discussion list(ARSList) on behalf of SPrasad Sent: Fri 3/6/2009 11:31 AM To: arslist@ARSLIST.ORG Subject: Data Import using arimportcmd -- Linux O/S Hi All, We have to import data into one of our Remedy application every night. For that I have built one Escalation with necessary information Such as mapping file info and directories information where i am going to place mapping file and data file. The problem is Remedy does support only few formats Such as .CSV, .XML, .arx., .asc and our AR Server is running on Linux O/S and since we can't place a CSV file in Linux server and it does support only ASCII text files format, if client wants to provide the data in the form of a CSV file how to import that data into Remedy? Any ideas and help would be greatly appreciated. Thanks SPrasad -- View this message in context: http://www.nabble.com/Data-Import-using-arimportcmdLinux-O-S-tp22375892p22375892.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Data Import using arimportcmd -- Linux O/S
Hi SPrasad If you are on Linux - chances are you are also using an Oracle database? If so, take a look at External Tables http://www.psoug.org/reference/externaltab.html for a way to read CSV files directly into the Oracle Database and then perhaps have a VIEW Form looking directly at the external table or a separate table which would be fed using something like:- Truncate table db_table; Insert into db_table as Select * from external table; You would create the original db_table as :- create table db_table as select * from ext_table; You could then iterate over the entries in either of these tables and perform what you want with it. Hope that helps Kindest Regards David Morgan Senior Technical Consultant Tiberone Technologies Limited Golden Cross House 8 Duncannon Street London WC2N 4JF Ph: +44 (0) 207 484 5069 Fax: +44 (0) 870 8310 381 Mob: +44 (0) 7876 450102 www.tiberone.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: 06 March 2009 16:53 To: arslist@ARSLIST.ORG Subject: Re: Data Import using arimportcmd -- Linux O/S CSV is a form of ASCII text file. All you do is format it properly, and = put the .csv extension. =20 If your configuration doesn't allow files with CSV extension, then you = have a different issue, which is not Remedy related. Perhaps you can = format in XML and import that way. XML is a form of ASCII text file, = with the .XML extension. =20 I am not an Linux expert, but I don't think CSV or XML are excluded. =20 Is it possible I'm mis understanding your issue? Thanks, Mark From: Action Request System discussion list(ARSList) on behalf of = SPrasad Sent: Fri 3/6/2009 11:31 AM To: arslist@ARSLIST.ORG Subject: Data Import using arimportcmd -- Linux O/S Hi All, We have to import data into one of our Remedy application every night. = For that I have built one Escalation with necessary information Such as = mapping file info and directories information where i am going to place mapping = file and data file. The problem is Remedy does support only few formats Such = as .CSV, .XML, .arx., .asc and our AR Server is running on Linux O/S and = since we can't place a CSV file in Linux server and it does support only ASCII text files format, if client wants to provide the data in the form of a = CSV file how to import that data into Remedy? Any ideas and help would be greatly appreciated. Thanks SPrasad -- View this message in context: = http://www.nabble.com/Data-Import-using-arimportcmdLinux-O-S-tp223758= 92p22375892.html Sent from the ARS (Action Request System) mailing list archive at = Nabble.com. _= __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
arimportcmd question
Greetings listers, We recently swapped our application server as the older was at end of lease. This was a like for like swap except that the newer box has twice the processing power of the old one. Everything seems completely normal but one thing; our nightly data imports (from various sources) have slowed to a crawl. For example, I have a nightly load of sector information of around 19k-20k records. This import used to load in around 14-15 minutes but is now taking better than 2 hours. I have tried various logging to try and catch the problem but so far I have found nothing. The speed issue (or lack thereof) seems to be the same whether it's running from the command line or through the actual import tool. None of the files have changed in size or format, the scheduling of the imports is the same as it was on the old server. Has anyone ever experienced anything like this? Thank you. AR Server 6.3 P23 Win 2003 MSSQL 2000 Randy Mckinnish Technical Systems Developer Compass Group The Americas Division DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Chris, It may be a typo... but where is the -x flag? arimportcmd -u user_name [-p password] -x server_name [-w external_authentication_string] [-r rpc_number] [-a port_number] [-l log_file_path] [-e duplicate_field] [-n suppress_filters] [-t multi_match_option] [-o data_file_name] [-f destination_form_name] [-v force_override] [ -M fully_qualified_mapping_file_name ] OR [ -m mapping name -d Mapping directory ] Use either a combination of -m and -d, or -M, to specify the mapping to use. You cannot use both the combination of -m and -d with -M; they are mutually exclusive. FWIW: The v7.1 doc (Pg 206 of Integrating-710.pdf) seem to suggest that -x is optional when using a mapping file. However I suspect that is only true when using the -M option. ( But I may be interpolating to much on these features. YMMV.) And the Importing without mapping appears to indicated that -x is required. So maybe it is just a bug that the server name is not used from the mapping file? Anyways.. It just a WAG.. ( It is really hard to guess what could be wrong when there is no reported error. Did the log file have anything in it? ) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Aug 18, 2008 at 4:34 PM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Carey is right on -x flag. The Load Mappings failed means one of 2 things: either the mapping file wasn't found in the command line or there is something wrong in the mapping file. I've had better success with using the command line in specific ordered format and quotes: arimportcmd.exe -u ** -p -x server -a 51000 -d F:\Program Files\AR System\HOME\ARCmds -l arlog.txt -m ImportComputerData The second thing to check is the contents of ImportComputerData. - The name of the mapping has to be used (first line in the file) - The import data file mentioned in the mapping has to be accessible to the command. Sometimes adding the -o parameter before the -d parameter helps to indicate if this is the problem. - The mappings have to be correct or you will get this error. - I always make the -m parameter the last item on the command line as it is extremely picky HTH, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 19, 2008 4:13 AM To: arslist@ARSLIST.ORG Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Chris, It may be a typo... but where is the -x flag? arimportcmd -u user_name [-p password] -x server_name [-w external_authentication_string] [-r rpc_number] [-a port_number] [-l log_file_path] [-e duplicate_field] [-n suppress_filters] [-t multi_match_option] [-o data_file_name] [-f destination_form_name] [-v force_override] [ -M fully_qualified_mapping_file_name ] OR [ -m mapping name -d Mapping directory ] Use either a combination of -m and -d, or -M, to specify the mapping to use. You cannot use both the combination of -m and -d with -M; they are mutually exclusive. FWIW: The v7.1 doc (Pg 206 of Integrating-710.pdf) seem to suggest that -x is optional when using a mapping file. However I suspect that is only true when using the -M option. ( But I may be interpolating to much on these features. YMMV.) And the Importing without mapping appears to indicated that -x is required. So maybe it is just a bug that the server name is not used from the mapping file? Anyways.. It just a WAG.. ( It is really hard to guess what could be wrong when there is no reported error. Did the log file have anything in it? ) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Aug 18, 2008 at 4:34 PM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Also, make sure the syntax you're using corresponds to the version of ARS you're using - there are some slight but important differences (i.e. the -M flag). Check the docs for YOUR version to be sure of the syntax. Rick On Tue, Aug 19, 2008 at 7:33 AM, Janie [EMAIL PROTECTED] wrote: Carey is right on -x flag. The Load Mappings failed means one of 2 things: either the mapping file wasn't found in the command line or there is something wrong in the mapping file. I've had better success with using the command line in specific ordered format and quotes: arimportcmd.exe -u ** -p -x server -a 51000 -d F:\Program Files\AR System\HOME\ARCmds -l arlog.txt -m ImportComputerData The second thing to check is the contents of ImportComputerData. - The name of the mapping has to be used (first line in the file) - The import data file mentioned in the mapping has to be accessible to the command. Sometimes adding the -o parameter before the -d parameter helps to indicate if this is the problem. - The mappings have to be correct or you will get this error. - I always make the -m parameter the last item on the command line as it is extremely picky HTH, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 19, 2008 4:13 AM To: arslist@ARSLIST.ORG Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Chris, It may be a typo... but where is the -x flag? arimportcmd -u user_name [-p password] -x server_name [-w external_authentication_string] [-r rpc_number] [-a port_number] [-l log_file_path] [-e duplicate_field] [-n suppress_filters] [-t multi_match_option] [-o data_file_name] [-f destination_form_name] [-v force_override] [ -M fully_qualified_mapping_file_name ] OR [ -m mapping name -d Mapping directory ] Use either a combination of -m and -d, or -M, to specify the mapping to use. You cannot use both the combination of -m and -d with -M; they are mutually exclusive. FWIW: The v7.1 doc (Pg 206 of Integrating-710.pdf) seem to suggest that -x is optional when using a mapping file. However I suspect that is only true when using the -M option. ( But I may be interpolating to much on these features. YMMV.) And the Importing without mapping appears to indicated that -x is required. So maybe it is just a bug that the server name is not used from the mapping file? Anyways.. It just a WAG.. ( It is really hard to guess what could be wrong when there is no reported error. Did the log file have anything in it? ) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Aug 18, 2008 at 4:34 PM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Hi, I just want to add that the you can get the load mapping failed error in some other cases. I have, for example, seen this when the password or login name was incorrect... This may not apply to the version you are using. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Carey is right on -x flag. The Load Mappings failed means one of 2 things: either the mapping file wasn't found in the command line or there is something wrong in the mapping file. I've had better success with using the command line in specific ordered format and quotes: arimportcmd.exe -u ** -p -x server -a 51000 -d F:\Program Files\AR System\HOME\ARCmds -l arlog.txt -m ImportComputerData The second thing to check is the contents of ImportComputerData. - The name of the mapping has to be used (first line in the file) - The import data file mentioned in the mapping has to be accessible to the command. Sometimes adding the -o parameter before the -d parameter helps to indicate if this is the problem. - The mappings have to be correct or you will get this error. - I always make the -m parameter the last item on the command line as it is extremely picky HTH, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 19, 2008 4:13 AM To: arslist@ARSLIST.ORG Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Chris, It may be a typo... but where is the -x flag? arimportcmd -u user_name [-p password] -x server_name [-w external_authentication_string] [-r rpc_number] [-a port_number] [-l log_file_path] [-e duplicate_field] [-n suppress_filters] [-t multi_match_option] [-o data_file_name] [-f destination_form_name] [-v force_override] [ -M fully_qualified_mapping_file_name ] OR [ -m mapping name -d Mapping directory ] Use either a combination of -m and -d, or -M, to specify the mapping to use. You cannot use both the combination of -m and -d with -M; they are mutually exclusive. FWIW: The v7.1 doc (Pg 206 of Integrating-710.pdf) seem to suggest that -x is optional when using a mapping file. However I suspect that is only true when using the -M option. ( But I may be interpolating to much on these features. YMMV.) And the Importing without mapping appears to indicated that -x is required. So maybe it is just a bug that the server name is not used from the mapping file? Anyways.. It just a WAG.. ( It is really hard to guess what could be wrong when there is no reported error. Did the log file have anything in it? ) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Aug 18, 2008 at 4:34 PM, Moore, Christopher Allen [EMAIL PROTECTED] wrote: ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
I am digging through this error on 6.3 and I found that if I try to load the mapping from the Import Tool I am getting the same error message. So, I am trying to recreate the mapping to see where the problem is. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Moore, Christopher Allen Sent: Monday, August 18, 2008 1:34 PM To: arslist@ARSLIST.ORG Subject: Loading Mappings failed: The import was not attempted- arimportcmd from the command line ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Instead of -m and -d try using -M to indicate the full path and name of the arm file. For example: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -M F:\Program Files\AR System\HOME\ARCmds\ImportComputerData.arm --- J.T. Shyman _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Monday, August 18, 2008 4:34 PM To: arslist@ARSLIST.ORG Subject: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
A couple of other things to check firstly see if you can change to the directory via dos using the syntax you are using,sometimes you might need to truncate the directory path, if that is the problem I would suggest creating a directory called something like c:\import and renaming the import file to something less than 8 characters. It looks like it is not finding your import file, so there is either a problem with the path or the file name thanks shafqat --- On Mon, 8/18/08, J.T. Shyman [EMAIL PROTECTED] wrote: From: J.T. Shyman [EMAIL PROTECTED] Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line To: arslist@ARSLIST.ORG Date: Monday, August 18, 2008, 9:45 PM ** Instead of -m and -d try using -M to indicate the full path and name of the arm file. For example: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -M F:\Program Files\AR System\HOME\ARCmds\ImportComputerData.arm” --- J.T. Shyman From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Monday, August 18, 2008 4:34 PM To: arslist@ARSLIST.ORG Subject: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here’s the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He’s called BMC support (Friday) but nothing from them yet, and he’s seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only “some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck...” Thanks, Chris__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
Along the same lines, alternatevely instead of renaming the directory, write the path in a 8.3 format.. you can get a 8.3 format name of a directory by a dir /x on the dos command prompt by using the x switch.. Joe - Original Message From: Shafqat Ayaz [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 18, 2008 5:39:23 PM Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line ** A couple of other things to check firstly see if you can change to the directory via dos using the syntax you are using,sometimes you might need to truncate the directory path, if that is the problem I would suggest creating a directory called something like c:\import and renaming the import file to something less than 8 characters. It looks like it is not finding your import file, so there is either a problem with the path or the file name thanks shafqat --- On Mon, 8/18/08, J.T. Shyman [EMAIL PROTECTED] wrote: From: J.T. Shyman [EMAIL PROTECTED] Subject: Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line To: arslist@ARSLIST.ORG Date: Monday, August 18, 2008, 9:45 PM ** Instead of -m and -d try using -M to indicate the full path and name of the arm file. For example: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -M F:\Program Files\AR System\HOME\ARCmds\ImportComputerData.arm” --- J.T. Shyman From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Monday, August 18, 2008 4:34 PM To: arslist@ARSLIST.ORG Subject: Loading Mappings failed: The import was not attempted- arimportcmd from the command line Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here’s the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He’s called BMC support (Friday) but nothing from them yet, and he’s seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only “some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck...” Thanks, Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Loading Mappings failed: The import was not attempted- arimportcmd from the command line
1.Add the arimportcmd.exe directory path to the environment variables...like java class path.. 2.goto run-cmd-arimportcmd directory and run the import command it work surely Pargeter, Christie :CO IS wrote: I am digging through this error on 6.3 and I found that if I try to load the mapping from the Import Tool I am getting the same error message. So, I am trying to recreate the mapping to see where the problem is. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Moore, Christopher Allen Sent: Monday, August 18, 2008 1:34 PM To: arslist@ARSLIST.ORG Subject: Loading Mappings failed: The import was not attempted- arimportcmd from the command line ** Hey list- A co-worker of mine was trying to run arimportcmd.exe from the command line to import a file and got the following error: Loading Mappings failed: The import was not attempted Here's the line he used: arimportcmd.exe -u ** -p -a 51000 -l arlog.txt -m ImportComputerData -d F:\Program Files\AR System\HOME\ARCmds He's called BMC support (Friday) but nothing from them yet, and he's seen a reference that running arimportcmd from the command line stopped working properly at ~7.0 p2. Does anyone have any information about this error? I did see an older post on the list from 2005 doing something similar in 6.3, but there was no resolution there. Only some of us on the list have reverted back to using the 5.x Import tool to perform our imports. OK, I'm going to attempt to use a 5.x version of arimportcmd to see if it will work. Wish me luck... Thanks, Chris __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/Loading-Mappings-failed%3A-The-import-was-not-attempted--arimportcmd-from-the-command-line-tp19039570p19044614.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
See...now that is what I was thinking...instead of forcing their users to go through the conversion process, especially considering that they know the file will be generated on Windows, to just write their app to handle that situation, but alas... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Thursday, May 08, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** Fair enough. I'm certainly not offended and hope I haven't offended anyone! I presume that support is quite frustrating from the stories I have heard. I personally try not to use it (pointing out bugs is a chargeable service after all) and have been quite impressed with the support I have had from BMC when I have needed it. And, these days anyhow, I make my living by using, configuring, talking about, and servicing BMC's products. And I AM a great believer in Documentation bugs after all! As for how hard it is to fix: I was going to say it's one line, but I'm glad I checked: It's about 9 lines (including three lines of comments and two extra lines for spacing for old mainframe style source files or four lines actual c) every place they read a line from a file. And here it is: // delete lf and crlf if (strlen(pBf) pBf[strlen(pBf)-1] == '\n') pBf[strlen(pBf)-1] = '\0'; if (strlen(pBf) pBf[strlen(pBf)-1] == '\r') pBf[strlen(pBf)-1] = '\0'; // handle a windows only eof in cc 1 of an empty // line or as the last character of a text line if (strlen(pBf) == 1 pBf[0] == 0x1a) pBf[0] = '\0'; if (strlen(pBf) 1 pBf[strlen(pBf)-1] == 0x1a) pBf[strlen(pBf)-1] = '\0'; I wonder how the import tool will handle a Windows CSV on the Unix platform? No doubt you will have tested that in your travails - as an aside I just looked up that word for its spelling and though it had originated from the French but was amused to note: ...[Middle English from Old French travail, travaillier, ultimately via medieval Latin trepalium 'instrument of torture', from Latin tres 'three' + palus 'stake'] - perhaps a tad more literal in your case! Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 9:10 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** I only tagged it as a rant because of how frustrated I was with their response, or lack of concern for their customer. I wasn't till I replied back telling them that it wasn't good enough that 'I' knew it, that it needed to be updated in the documentation that they created a documentation defect to ensure no one else has to go through those 2 weeks of hassle... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Thursday, May 08, 2008 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** This is normal with almost all tools - BMC or otherwise. I specifically check for both types of line endings in Meta-Update (so that any CSV or Meta-Update script created on any platform can run on any platform) but that is not the norm. Try a makefile with Windows line returns; try a compiler's source file, and on and on. There is no need for a rant. Most people with Unix familiarity do ascii file conversions as a matter of course. Now that you know, it is no problem for you either. BTW, some file in Windows also contain an end of file marker as the last byte (Ctrl Z). This also causes Unix tools grief. dos2unix also eliminates these as DOS ascii mode ftp transfers and the like. The mapping file is an ASCII file. It can be used on any platform as long as the normal ascii file transfer mechanisms are used. Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 8:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major
Re: RANT: arimportcmd
LJ, Sorry for the slow response, but I have been away from email for a few days. This thread has shown that you were not the first customer to stumble over this problem. ( ITIL: A problem is a reoccurring incident that one or more customers has over time.) The idea that the docs are cheaper to fix has been suggested, and I do not agree with that idea. The docs are easier to fix, but the total cost of the decision would still be on going. It is clearly possible for a software tool to identify the format of the file and adjust it's parsing for the format. (Just as Meta-Update claims to do.) It would even be possible to be more radical and switch the file format to a more standard, platform independent and stable format like XML too. I wonder how much it costs BMC to have tech support spend hours (or days? or weeks?) trying to troubleshoot a FTP file conversion(or not converted) problem? Good luck guys trying to get someone who does not understand what an ASCII file format is to tell you over the phone that when they transferred the file to the Unix server if it was auto converted. I have been in that chair, it is not an easy or quick task to achieve. Not to mention that the user might have actually used any number of clients/protocols to actually move the file from one to the other. sneaker net [due to network security design/requirements], scp, sftp, ftp, http [wget from the command line], etc... I wonder how much it costs customers, in terms of confidence in the BMC product line, when a simple thing like file format based on OS line endings prevent the tools from working as expected? Is this a common trait for Enterprise class software? I would bet that if BMC could find all of the incidents and add up all of the time that tech support has already spent on this issue that half of that time could have made the necessary change to the arimportcmd tool source. (But then again, maybe BMC's programmers are not as fast, with what appears from the outside to be a simple change, as we would want them to be.) LJ, I think you are very justified for this being a RANT. And if it were me. knowing how many other customers have been impacted by this problem over the years, I would insist that the incident be left open until the problem is fixed. BMC will define that as updating the docs and that is their prerogative. But you should keep the clock ticking on that incident until the problem is corrected. Push them to update all the docs, for all currently supported versions. (The same problem exists in all of them.) Maybe if we ( I take this approach from time to time with incidents that BMC wants to dismiss into doc bugs.) take the time to show BMC how much the details hurt us, by helping them to measure the amount of time their customers wait for simple things then maybe someday, someone will see those details in the Tech support numbers and understand that changing the docs is not cheaper. Rather, the next phone call might have the same problem and cost BMC yet again, because they choose a easy way out by requiring the customer to be smarter instead of requiring their software to be smarter. But maybe I am just stuck on that soapbox with you. We feel your pain. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, May 8, 2008 at 2:59 PM, LJ Longwing [EMAIL PROTECTED] wrote: ** they opened a documentation defect (SW00295365) to indicate that a conversion is needed to use it on non Windows workstationsI know this would have saved me A LOT of work if it had been documented before... snip From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which
RANT: arimportcmd
I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
LJ, I understand what you're saying, however, if they automatically scrubbed it, then it wouldn't work with windows :-) I guess they need to add a simple checkbox, and if you check it, then they scrub it. The simplest way (but wouldn't work for anyone who has already downloaded the documentation) is an update to the documentation. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
I went through this same scenario four or five years back with an ARM to be used on Solaris. After several of their cleanings I finally just VI'd the file to remove the control characters that were causing the problem. It was tedious and time-consuming at best. Luckily, once it works, it works forever. Seems to me that use of arimportcmd was covered on the absolute last page of the Advanced Admin Guide for whatever rev I was using (5 I think), and the documentation was sketchy at best, as was their help. Nice to see that some aspects of Remedy Tech Support policy have remained consistent though... David M Clark Remedy Programmer/Analyst LJ Longwing [EMAIL PROTECTED] 5/8/2008 1:05 PM I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
This is normal with almost all tools - BMC or otherwise. I specifically check for both types of line endings in Meta-Update (so that any CSV or Meta-Update script created on any platform can run on any platform) but that is not the norm. Try a makefile with Windows line returns; try a compiler's source file, and on and on. There is no need for a rant. Most people with Unix familiarity do ascii file conversions as a matter of course. Now that you know, it is no problem for you either. BTW, some file in Windows also contain an end of file marker as the last byte (Ctrl Z). This also causes Unix tools grief. dos2unix also eliminates these as DOS ascii mode ftp transfers and the like. The mapping file is an ASCII file. It can be used on any platform as long as the normal ascii file transfer mechanisms are used. Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 8:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
LJ, I see your point, but the good news is that there's no reason that you couldn't copy the mapping files to the server, manually edit them to remove the line feeds, and run arimportcmd from there. It's the .csv files that are constantly changing, not the .arm files. They should be static enough to make this process almost one-time. Rick On Thu, May 8, 2008 at 11:05 AM, LJ Longwing [EMAIL PROTECTED] wrote: ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
they opened a documentation defect (SW00295365) to indicate that a conversion is needed to use it on non Windows workstationsI know this would have saved me A LOT of work if it had been documented before... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, May 08, 2008 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** LJ, I understand what you're saying, however, if they automatically scrubbed it, then it wouldn't work with windows :-) I guess they need to add a simple checkbox, and if you check it, then they scrub it. The simplest way (but wouldn't work for anyone who has already downloaded the documentation) is an update to the documentation. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
I only tagged it as a rant because of how frustrated I was with their response, or lack of concern for their customer. I wasn't till I replied back telling them that it wasn't good enough that 'I' knew it, that it needed to be updated in the documentation that they created a documentation defect to ensure no one else has to go through those 2 weeks of hassle... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Thursday, May 08, 2008 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** This is normal with almost all tools - BMC or otherwise. I specifically check for both types of line endings in Meta-Update (so that any CSV or Meta-Update script created on any platform can run on any platform) but that is not the norm. Try a makefile with Windows line returns; try a compiler's source file, and on and on. There is no need for a rant. Most people with Unix familiarity do ascii file conversions as a matter of course. Now that you know, it is no problem for you either. BTW, some file in Windows also contain an end of file marker as the last byte (Ctrl Z). This also causes Unix tools grief. dos2unix also eliminates these as DOS ascii mode ftp transfers and the like. The mapping file is an ASCII file. It can be used on any platform as long as the normal ascii file transfer mechanisms are used. Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 8:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
I've discovered (the hard way) that BMC uses Windows almost exclusively for their development efforts and their day-to-day operations. They're not particularly keen on supporting *nix for any of their applications: they do it because it makes money to sell to a wider range of customers. While they do a rather good job testing their applications on the more popular combinations of *nix systems, *nix is not really not the forte of their support techs. Since you have the power of the command line, you are savvy enough to think around these issues where BMC hasn't done so yet. Jennifer From: LJ Longwing Sent: Thu 08-May-08 14:59 To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd This is a multi-part message in MIME format. --=_NextPart_000_0050_01C8B10B.5B6A7840 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit they opened a documentation defect (SW00295365) to indicate that a conversion is needed to use it on non Windows workstationsI know this would have saved me A LOT of work if it had been documented before... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, May 08, 2008 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** LJ, I understand what you're saying, however, if they automatically scrubbed it, then it wouldn't work with windows :-) I guess they need to add a simple checkbox, and if you check it, then they scrub it. The simplest way (but wouldn't work for anyone who has already downloaded the documentation) is an update to the documentation. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
Honestly, I agree with both parties. Sometimes I am a fence sitter. But erally they could jsut update the program to check the end of the first line, and either clean the program before loading it, or clean it as loading it. It doesn't seem to me that it would be a major challenge. However, I understand that their position is that it is cheaper to train the handful of people that run into this issue. I don't believe this to be a new policy and I don't see it changing anytime soon. We will just have to accept it. Maybe we should have a central repository of all these little items that can be handled easily with a little knowledge that as a community we keep updated. I am sure Mr. Reinfeldt or someone else would be willing to host it. Heck, we could even use wikipedia. Maybe we need a Remepedia? Any ideas, suggestions? Brian On Thu, May 8, 2008 at 2:13 PM, Jennifer Meyer [EMAIL PROTECTED] wrote: ** I've discovered (the hard way) that BMC uses Windows almost exclusively for their development efforts and their day-to-day operations. They're not particularly keen on supporting *nix for any of their applications: they do it because it makes money to sell to a wider range of customers. While they do a rather good job testing their applications on the more popular combinations of *nix systems, *nix is not really not the forte of their support techs. Since you have the power of the command line, you are savvy enough to think around these issues where BMC hasn't done so yet. Jennifer -- *From:* LJ Longwing *Sent:* Thu 08-May-08 14:59 *To:* arslist@ARSLIST.ORG *Subject:* Re: RANT: arimportcmd This is a multi-part message in MIME format. --=_NextPart_000_0050_01C8B10B.5B6A7840 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit they opened a documentation defect (SW00295365) to indicate that a conversion is needed to use it on non Windows workstationsI know this would have saved me A LOT of work if it had been documented before... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, May 08, 2008 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** LJ, I understand what you're saying, however, if they automatically scrubbed it, then it wouldn't work with windows :-) I guess they need to add a simple checkbox, and if you check it, then they scrub it. The simplest way (but wouldn't work for anyone who has already downloaded the documentation) is an update to the documentation. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation
Re: RANT: arimportcmd
This is a difference between Unix/BSD/Linux and Windows/cpm. It applies to most, if not all, plain text files transported between the two platforms. An alternative is to use a binary format for the arm file, which has it's own set of consequences. You can correct this easily on the unix host using tr, vi, sed, etc.: cat infile | sed -e 's/^M$//g' outfile ^M is entered using CTRL-V CTRL-M Axton Grams On Thu, May 8, 2008 at 2:05 PM, LJ Longwing [EMAIL PROTECTED] wrote: ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows platforms. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RANT: arimportcmd
Not to keep adding to this thread but this is not entirely correct. BMC uses Windows for their GUI development. Their server development (and all related binaries) are definitively on done with equal effort on Unix as well as (now) Windows. Remedy server started only on Unix after all. On the subject of a Wiki, Axton is running one now: www.arswiki.org Perhaps a page breaking down common problems as a thesaurus might? Although, again, ASCII files by definition, need a translate when moving from Unix to Windows and vice versa. (Imagine the translate to mainframes!) Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jennifer Meyer Sent: May 8, 2008 9:14 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** I've discovered (the hard way) that BMC uses Windows almost exclusively for their development efforts and their day-to-day operations. They're not particularly keen on supporting *nix for any of their applications: they do it because it makes money to sell to a wider range of customers. While they do a rather good job testing their applications on the more popular combinations of *nix systems, *nix is not really not the forte of their support techs. Since you have the power of the command line, you are savvy enough to think around these issues where BMC hasn't done so yet. Jennifer _ From: LJ Longwing Sent: Thu 08-May-08 14:59 To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd This is a multi-part message in MIME format. --=_NextPart_000_0050_01C8B10B.5B6A7840 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit they opened a documentation defect (SW00295365) to indicate that a conversion is needed to use it on non Windows workstationsI know this would have saved me A LOT of work if it had been documented before... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Thursday, May 08, 2008 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** LJ, I understand what you're saying, however, if they automatically scrubbed it, then it wouldn't work with windows :-) I guess they need to add a simple checkbox, and if you check it, then they scrub it. The simplest way (but wouldn't work for anyone who has already downloaded the documentation) is an update to the documentation. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, May 08, 2008 1:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform.. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform'I'm curious if anyone on HPUX or AIX has to go through this conversion, and if so, did you figure it out on your own or did you get told this by support, and is anyone else annoyed about the fact that the documentation is misleading at best, and completely wrong at worst. I think that at a minimum they should either create the file so it's readable on all platforms they support, or update the documentation to indicate that some type of conversion needs to be performed to be able to use it on non Windows
Re: RANT: arimportcmd
Fair enough. I'm certainly not offended and hope I haven't offended anyone! I presume that support is quite frustrating from the stories I have heard. I personally try not to use it (pointing out bugs is a chargeable service after all) and have been quite impressed with the support I have had from BMC when I have needed it. And, these days anyhow, I make my living by using, configuring, talking about, and servicing BMC's products. And I AM a great believer in Documentation bugs after all! As for how hard it is to fix: I was going to say it's one line, but I'm glad I checked: It's about 9 lines (including three lines of comments and two extra lines for spacing for old mainframe style source files or four lines actual c) every place they read a line from a file. And here it is: // delete lf and crlf if (strlen(pBf) pBf[strlen(pBf)-1] == '\n') pBf[strlen(pBf)-1] = '\0'; if (strlen(pBf) pBf[strlen(pBf)-1] == '\r') pBf[strlen(pBf)-1] = '\0'; // handle a windows only eof in cc 1 of an empty // line or as the last character of a text line if (strlen(pBf) == 1 pBf[0] == 0x1a) pBf[0] = '\0'; if (strlen(pBf) 1 pBf[strlen(pBf)-1] == 0x1a) pBf[strlen(pBf)-1] = '\0'; I wonder how the import tool will handle a Windows CSV on the Unix platform? No doubt you will have tested that in your travails - as an aside I just looked up that word for its spelling and though it had originated from the French but was amused to note: ...[Middle English from Old French travail, travaillier, ultimately via medieval Latin trepalium 'instrument of torture', from Latin tres 'three' + palus 'stake'] - perhaps a tad more literal in your case! Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 9:10 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** I only tagged it as a rant because of how frustrated I was with their response, or lack of concern for their customer. I wasn't till I replied back telling them that it wasn't good enough that 'I' knew it, that it needed to be updated in the documentation that they created a documentation defect to ensure no one else has to go through those 2 weeks of hassle... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Thursday, May 08, 2008 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: RANT: arimportcmd ** This is normal with almost all tools - BMC or otherwise. I specifically check for both types of line endings in Meta-Update (so that any CSV or Meta-Update script created on any platform can run on any platform) but that is not the norm. Try a makefile with Windows line returns; try a compiler's source file, and on and on. There is no need for a rant. Most people with Unix familiarity do ascii file conversions as a matter of course. Now that you know, it is no problem for you either. BTW, some file in Windows also contain an end of file marker as the last byte (Ctrl Z). This also causes Unix tools grief. dos2unix also eliminates these as DOS ascii mode ftp transfers and the like. The mapping file is an ASCII file. It can be used on any platform as long as the normal ascii file transfer mechanisms are used. Cheers Ben _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: May 8, 2008 8:06 PM To: arslist@ARSLIST.ORG Subject: RANT: arimportcmd ** I just got done working with BMC regarding a mapping problem and I'm not liking their answer. I wanted to poll the community to test the waters for this in case I need to open an RFE to make things work the way they say they are supposed to work I created an ARM file from the windows tool, just like the docs say to, and transferred it to a Suse Linux box, and couldn't get the arimportcmd tool to work properly, after several back and forths with support, they gave me a 'working' arm file, after several hours of trying to figure out what the difference was, I came down to the fact that for the Linux version of the import tool you need to run a dos2unix conversion (remove the hex 0D from the CRLF). When I commented that I shouldn't need to run any conversions on the ARM I was told point blank that the difference between how windows and Unix store text files is beyond BMC's support realm and that I simply needed to perform the conversion myself. My problems with this are several, but the major one of which is that the documentation states Importing with mapping refers to running the BMC Remedy Import CLI by using a mapping created in BMC Remedy Import. The mapping must be created on Windows because that is the only environment BMC Remedy Import runs on interactively. After it is created, the mapping can be used on any platform. I take this to mean that I don't need to convert anything to use it, because it 'can be used on any platform
Re: Problem getting arimportcmd to execute in an escalation
Barb I once had a problem when the data file I was trying to import was on a network share. I had to copy it to the remedy server and also had to place it in the root C:\. If I placed it in any other folder it would not work. Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barbara Siebert Sent: Saturday, April 26, 2008 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem getting arimportcmd to execute in an escalation
I have found that what works on the command line doesn't necessarily work from Remedy, I have found that to test what Remedy does if you log onto the box in question, and go Start|Run, type your command into the run box and hit enter, that's the approximate equal to what Remedy does on a windows box -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barbara Siebert Sent: Saturday, April 26, 2008 8:54 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem getting arimportcmd to execute in an escalation
Brian, The escalation worked when I moved the file from the network shared to the C:\ Thanks to all for your replies. Liz -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Monday, April 28, 2008 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Barb I once had a problem when the data file I was trying to import was on a network share. I had to copy it to the remedy server and also had to place it in the root C:\. If I placed it in any other folder it would not work. Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barbara Siebert Sent: Saturday, April 26, 2008 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem getting arimportcmd to execute in an escalation
That could be a simple answer, when your running the escalation, the user running the escalation (the same one running the remedy service) likely doesn't have the network drive mapped, so maybe instead of x:\ you could use \\server\share -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Monday, April 28, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Brian, The escalation worked when I moved the file from the network shared to the C:\ Thanks to all for your replies. Liz -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Monday, April 28, 2008 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Barb I once had a problem when the data file I was trying to import was on a network share. I had to copy it to the remedy server and also had to place it in the root C:\. If I placed it in any other folder it would not work. Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barbara Siebert Sent: Saturday, April 26, 2008 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem getting arimportcmd to execute in an escalation
***In the creation of the batch file below (the cut paste of the command line you gave the list), I noticed the misplaced quote! C:\ should be C:\. That could be your problem. In any event, here's the response I was writing at the time: There are two possible errors that can happen when the ARS server (or client for that matter) fires a process on your behalf: #1 The OS fails to initiate the process #2 The Process Is initiated but fails or returns an error #1 is generally an environment issue: path not right, file name not right, OS permissions not right, etc #2 can also be an environment issue such as cwd or the current working directory, and environment variables, oaths etc not right. It can also be something else: bad program, bad data, etc. You don't say which of the two is happening. ARS server logging will tell you what happened (though admittedly not as clearly as one might want). *** Sorry folks! This is Windows specific :) Unix would - of course - be more concise. *** *** Windows Tipp: Download and install cygwin.com *** If you want to determine that your process was fired (ie #1 is NOT happening), change your process from the import command to a batch file that logs and fires the import command: *** Caution: make directory c:\Logs\ *before* executing the batch file *** File x.cmd: Remjust set the date and time into out log file! for /f usebackq %%x in (`date /t`) Do set wDte=%%x for /f usebackq %%x in (`time /t`) Do set wTme=%%x Echo %wDte% %wTme% Firing arimportcmd.exe -x -x -x -x ... c:\Logs\xx.log C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log c:\Logs\xx.log Rem above line keeps the output from the arimport command (#2) Echo %wDte% %wTme% Firing completed for arimportcmd.exe -x -x -x -x ... c:\Logs\xx.log pause Echo c:\Logs\xx.log Echo The absence of the file c:\Logs\xx.txt (please do change names) - and ensure the directory c:\Logs\ exists!!! - is proof of an environment problem. The command line is specified in such a way so that the OS cannot initiate the new process. The presence of the file proves that the OS did indeed find the batch file. The contents of the file should tell you what's wrong with the environment (your running working directory - which could be added to the trace) for finding the arm etc. That's it from a sunny warm spring day in Muenchen! Ben Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 162 175 0956 GMT + 1 + [ DST ] Email: mailto:[EMAIL PROTECTED] Web: http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Barbara Siebert Sent: April 26, 2008 4:54 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When
Re: Problem getting arimportcmd to execute in an escalation
Hi LJ, Thanks for your reply. I know that Liz tried the cmd /c with her arimportcmd and still had no luck. Just for the record, her environment is Windows 2003, ARS 7.1, Oracle 10g, (and not that it matters but ITSM 6 and CMDB 2). Any other ideas? Thanks, Barb Siebert QMX Support Services From: Action Request System discussion list(ARSList) on behalf of LJ Longwing Sent: Fri 4/25/2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: Problem getting arimportcmd to execute in an escalation ** On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
arimportcmd - suse
This is a bug. Simple as that. The message is from glib (nice or what?). No code (programme) should EVER perform a free on freed memory and that is what glib has detected. Use and older version or go to Windows and run it on Windows. Make a support ticket with BMC to get it fixed. One would have hoped they would have caught it. Note that if your input arguments are invalid or incomplete, the code path taken in the program changes, so external environmental factors can cause the bug to not appear. None the less, it is ALWAYS a bug when a double free happens. I am not sure why you would want to point the path the the cmdbExtLoader area, but the effect should be the same. If you did copy all shared objects, ensure you copied the correct versioned one. Again, even the above are external environment factors. The bug is simply that a double free has been coded. Cheers Ben Chernys Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 162 175 0956 GMT + 1 + [ DST ] Email:mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web: http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd http://www.softwaretoolhouse.com/products/SthMupd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: April 24, 2008 10:47 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd - suse ** What would I expect to find in that path? I have loaded all of the shared libraries into a specific directory, and added that to the library path, and am not getting any errors regarding required libraries being missing. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Thursday, April 24, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd - suse ** Hello LJ, There is syntactical information regarding the arimportcmd command on the AR Admin Help. So I wont talk about the syntax or parameters or thier values. I am sure you must have already checked it out. But as a pre-requisite to the arimport cammand, I would provide the following commands at command line: export LD_LIBRARY_PATH=/var/tmp/cmdbExtLoader/server/bin/ export LIBPATH=/var/tmp/cmdbExtLoader/server/bin/ Of course, these paths may be slightly different on your system, but you can easily locate them and setting these environment variables. The commandline arimport command would return an error for me if I did not set these environment variables in advance. Check this out and let me know if it works or otherwise. Thanks Regards, Abhijit Oak Wipro Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, April 25, 2008 1:59 AM To: arslist@ARSLIST.ORG Subject: arimportcmd - suse ** Trying to run an import using arimportcmd on suse linux and getting weird errors that I can't find documented anywhere *** glibc detected *** ./arimportcmd: double free or corruption (fasttop): 0x0829ee40 *** we have tried to run this as root and local user so I don't think its a permissions issue, we have tried every combination of command line parameters, but all of them that should work end up with this error, and a 'Memory Map'. I got this file out of the 7.1 server install, along with all of the required libraries. Any experience running this product in this environment? Any help is appreciated __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access
Problem getting arimportcmd to execute in an escalation
I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd - suse
Thank you for your input, I figured it was a bug, but wanted to check with someone other than official channels, I did open a ticket through support, but we all know how well that usually goes, I found that if I did it without the mapping, and imported an ARX file instead, it worked fine, so I'm going to end up going that way instead of fighting the uphill battle of waiting for a fix, but I fully intend on pushing the fix till its working the way its supposed to. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Thursday, April 24, 2008 10:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd - suse ** This is a bug. Simple as that. The message is from glib (nice or what?). No code (programme) should EVER perform a free on freed memory and that is what glib has detected. Use and older version or go to Windows and run it on Windows. Make a support ticket with BMC to get it fixed. One would have hoped they would have caught it. Note that if your input arguments are invalid or incomplete, the code path taken in the program changes, so external environmental factors can cause the bug to not appear. None the less, it is ALWAYS a bug when a double free happens. I am not sure why you would want to point the path the the cmdbExtLoader area, but the effect should be the same. If you did copy all shared objects, ensure you copied the correct versioned one. Again, even the above are external environment factors. The bug is simply that a double free has been coded. Cheers Ben Chernys Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 162 175 0956 GMT + 1 + [ DST ] Email:mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web: http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd http://www.softwaretoolhouse.com/products/SthMupd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: April 24, 2008 10:47 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd - suse ** What would I expect to find in that path? I have loaded all of the shared libraries into a specific directory, and added that to the library path, and am not getting any errors regarding required libraries being missing. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Thursday, April 24, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd - suse ** Hello LJ, There is syntactical information regarding the arimportcmd command on the AR Admin Help. So I wont talk about the syntax or parameters or thier values. I am sure you must have already checked it out. But as a pre-requisite to the arimport cammand, I would provide the following commands at command line: export LD_LIBRARY_PATH=/var/tmp/cmdbExtLoader/server/bin/ export LIBPATH=/var/tmp/cmdbExtLoader/server/bin/ Of course, these paths may be slightly different on your system, but you can easily locate them and setting these environment variables. The commandline arimport command would return an error for me if I did not set these environment variables in advance. Check this out and let me know if it works or otherwise. Thanks Regards, Abhijit Oak Wipro Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, April 25, 2008 1:59 AM To: arslist@ARSLIST.ORG Subject: arimportcmd - suse ** Trying to run an import using arimportcmd on suse linux and getting weird errors that I can't find documented anywhere *** glibc detected *** ./arimportcmd: double free or corruption (fasttop): 0x0829ee40 *** we have tried to run this as root and local user so I don't think its a permissions issue, we have tried every combination of command line parameters, but all of them that should work end up with this error, and a 'Memory Map'. I got this file out of the 7.1 server install, along with all of the required libraries. Any experience running this product in this environment? Any help is appreciated __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended
Re: Problem getting arimportcmd to execute in an escalation
On windows boxes I have had the best result with a command of cmd /c command so in your case cmd /c C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Liz Sent: Friday, April 25, 2008 8:37 AM To: arslist@ARSLIST.ORG Subject: Problem getting arimportcmd to execute in an escalation ** I am able to use arimport tool to load the saved .arm file and successfully import the data into the table. However, when I use arimportcmd to import the data thru an escalation, nothing happens. I don't get an error, the log file is empty and no data is imported. The escalation run process command I am using is: C:\path name\arimportcmd -m value found in first line of .arm file -d path name where the .arm file can be found -u Demo -p -l c:\BP.log I have verified that arimportcmd resides at the path name. I have verified the path name of the arm file. The userid and password are valid. When the escalation runs, the escalation log shows it completed. The log file BP.log is empty and the table arimportcmd should populate is empty. I get no error messages. When I copy the escalation run process command above and paste it in the DOS command line, press enter, the table is populated and the c:\BP.log file shows it ran successfully. What command is missing from the escalation run process to get the escalation to import the data? Liz __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
arimportcmd - suse
Trying to run an import using arimportcmd on suse linux and getting weird errors that I can't find documented anywhere *** glibc detected *** ./arimportcmd: double free or corruption (fasttop): 0x0829ee40 *** we have tried to run this as root and local user so I don't think its a permissions issue, we have tried every combination of command line parameters, but all of them that should work end up with this error, and a 'Memory Map'. I got this file out of the 7.1 server install, along with all of the required libraries. Any experience running this product in this environment? Any help is appreciated ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd - suse
Hello LJ, There is syntactical information regarding the arimportcmd command on the AR Admin Help. So I wont talk about the syntax or parameters or thier values. I am sure you must have already checked it out. But as a pre-requisite to the arimport cammand, I would provide the following commands at command line: export LD_LIBRARY_PATH=/var/tmp/cmdbExtLoader/server/bin/ export LIBPATH=/var/tmp/cmdbExtLoader/server/bin/ Of course, these paths may be slightly different on your system, but you can easily locate them and setting these environment variables. The commandline arimport command would return an error for me if I did not set these environment variables in advance. Check this out and let me know if it works or otherwise. Thanks Regards, Abhijit Oak Wipro Technologies From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, April 25, 2008 1:59 AM To: arslist@ARSLIST.ORG Subject: arimportcmd - suse ** Trying to run an import using arimportcmd on suse linux and getting weird errors that I can't find documented anywhere *** glibc detected *** ./arimportcmd: double free or corruption (fasttop): 0x0829ee40 *** we have tried to run this as root and local user so I don't think its a permissions issue, we have tried every combination of command line parameters, but all of them that should work end up with this error, and a 'Memory Map'. I got this file out of the 7.1 server install, along with all of the required libraries. Any experience running this product in this environment? Any help is appreciated __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd - suse
What would I expect to find in that path? I have loaded all of the shared libraries into a specific directory, and added that to the library path, and am not getting any errors regarding required libraries being missing. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Thursday, April 24, 2008 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd - suse ** Hello LJ, There is syntactical information regarding the arimportcmd command on the AR Admin Help. So I wont talk about the syntax or parameters or thier values. I am sure you must have already checked it out. But as a pre-requisite to the arimport cammand, I would provide the following commands at command line: export LD_LIBRARY_PATH=/var/tmp/cmdbExtLoader/server/bin/ export LIBPATH=/var/tmp/cmdbExtLoader/server/bin/ Of course, these paths may be slightly different on your system, but you can easily locate them and setting these environment variables. The commandline arimport command would return an error for me if I did not set these environment variables in advance. Check this out and let me know if it works or otherwise. Thanks Regards, Abhijit Oak Wipro Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, April 25, 2008 1:59 AM To: arslist@ARSLIST.ORG Subject: arimportcmd - suse ** Trying to run an import using arimportcmd on suse linux and getting weird errors that I can't find documented anywhere *** glibc detected *** ./arimportcmd: double free or corruption (fasttop): 0x0829ee40 *** we have tried to run this as root and local user so I don't think its a permissions issue, we have tried every combination of command line parameters, but all of them that should work end up with this error, and a 'Memory Map'. I got this file out of the 7.1 server install, along with all of the required libraries. Any experience running this product in this environment? Any help is appreciated __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
Rick, Do you have a special character in the password? That may be throwing the command line interpreter off. I've gotten into the habit of always putting quotes around my password; even if it doesn't have a special character. You might also try using the parameters to specify the mapping file and its directory separately (-m and -d) instead of the parameter to specify it all together (-M). Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, March 27, 2008 11:24 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Well, I'm not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I'll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Thursday, March 27, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 5:34 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter
Re: arimportcmd error
Rick, Two problems my colleague Jayson has discovered If the encrypted password has a / in it, the import fails. There may be other potential characters that cause a problem. If the server is NOT registered with the portmapper and you try and us a mapping, the import fails. Regards, Chad Whilding 937-320-3475 Computer Sciences Corporation Registered Office: 2100 East Grand Avenue, El Segundo California 90245, USA Registered in USA No: C-489-59 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Roger Medsker [EMAIL PROTECTED] OMTo Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: arimportcmd error ORG 03/28/2008 08:52 AM Please respond to [EMAIL PROTECTED] RG ** Rick, Do you have a special character in the password? That may be throwing the command line interpreter off. I’ve gotten into the habit of always putting quotes around my password; even if it doesn’t have a special character. You might also try using the parameters to specify the mapping file and its directory separately (-m and –d) instead of the parameter to specify it all together (-M). Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, March 27, 2008 11:24 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Well, I’m not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I’ll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Thursday, March 27, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M
Re: arimportcmd error
If the server isn't registered with the port mapper I believe you can pass the port number using the -a parameter. --- J.T. Shyman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chad M Whilding Sent: Friday, March 28, 2008 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error Rick, Two problems my colleague Jayson has discovered If the encrypted password has a / in it, the import fails. There may be other potential characters that cause a problem. If the server is NOT registered with the portmapper and you try and us a mapping, the import fails. Regards, Chad Whilding 937-320-3475 Computer Sciences Corporation Registered Office: 2100 East Grand Avenue, El Segundo California 90245, USA Registered in USA No: C-489-59 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Roger Medsker [EMAIL PROTECTED] OMTo Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: arimportcmd error ORG 03/28/2008 08:52 AM Please respond to [EMAIL PROTECTED] RG ** Rick, Do you have a special character in the password? That may be throwing the command line interpreter off. I've gotten into the habit of always putting quotes around my password; even if it doesn't have a special character. You might also try using the parameters to specify the mapping file and its directory separately (-m and -d) instead of the parameter to specify it all together (-M). Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, March 27, 2008 11:24 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Well, I'm not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I'll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Thursday, March 27, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself
Re: arimportcmd error
Rick, Have you looked at the help information in the Admin tool? Just go search arimportcmd or look at Using the BMC Remedy Import CLI. Maybe that will help. I can't offer anymore than that as I have never used the tool that way. Personally, I would just write a perl script that would load the data into the database and use a view form. Good Luck, Brian On Fri, Mar 28, 2008 at 11:06 AM, Rick Cook [EMAIL PROTECTED] wrote: ** Nope - the password is password. Portmapper is in place. Rick On Fri, Mar 28, 2008 at 5:52 AM, Roger Medsker [EMAIL PROTECTED] wrote: ** Rick, Do you have a special character in the password? That may be throwing the command line interpreter off. I've gotten into the habit of always putting quotes around my password; even if it doesn't have a special character. You might also try using the parameters to specify the mapping file and its directory separately (-m and –d) instead of the parameter to specify it all together (-M). Roger *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 11:24 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Well, I'm not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I'll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Shafqat Ayaz *Sent:* Thursday, March 27, 2008 9:17 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat *Rick Cook [EMAIL PROTECTED]* wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 5:34 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path
Resolved: arimportcmd error
OK, I think I'm onto something here. The command works just fine with the 7.1 version of arimportcmd (against either a 6.3 or 7.1 server), but the same command using the same files reports an error on the 6.3 version of arimportcmd. Since I can't think of a reason that the 7.1 version would introduce problems even against a 6.3 server, we're going to resolve the issue by using the newer version of arimportcmd. Thanks to all who offered some great suggestions. Rick On Fri, Mar 28, 2008 at 10:26 AM, Brian Goralczyk [EMAIL PROTECTED] wrote: ** Rick, Have you looked at the help information in the Admin tool? Just go search arimportcmd or look at Using the BMC Remedy Import CLI. Maybe that will help. I can't offer anymore than that as I have never used the tool that way. Personally, I would just write a perl script that would load the data into the database and use a view form. Good Luck, Brian On Fri, Mar 28, 2008 at 11:06 AM, Rick Cook [EMAIL PROTECTED] wrote: ** Nope - the password is password. Portmapper is in place. Rick On Fri, Mar 28, 2008 at 5:52 AM, Roger Medsker [EMAIL PROTECTED] wrote: ** Rick, Do you have a special character in the password? That may be throwing the command line interpreter off. I've gotten into the habit of always putting quotes around my password; even if it doesn't have a special character. You might also try using the parameters to specify the mapping file and its directory separately (-m and –d) instead of the parameter to specify it all together (-M). Roger *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 11:24 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Well, I'm not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I'll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Shafqat Ayaz *Sent:* Thursday, March 27, 2008 9:17 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat *Rick Cook [EMAIL PROTECTED]* wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27
Re: arimportcmd error
Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008 10:03 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 5:34 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.1/1346 - Release Date: 3/27/2008 10:03 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 5:34 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 4:51 PM *To:* arslist@ARSLIST.ORG *Subject:* arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 5:34 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Rick Cook *Sent:* Thursday, March 27, 2008 4:51 PM *To:* arslist@ARSLIST.ORG *Subject:* arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 5:34 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arimportcmd error
Well, I'm not sure which tree we need to bark up. The command does not work either in workflow or on the command line. I'll check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Thursday, March 27, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 5:34 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd parameter for the schema, so I don't know what it's complaining about. Any ideas to help us out? We verified the paths, file names, etc., and all names match exactly, including case. Rick __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. _ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try http
Re: arimportcmd error
Rick i presume that the error you are getting is in the error log, what kind of error do you get from the command line when you type the command in? thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}st1\:*{behavior:url(#default#ieooui) } Well, Im not sure which tree we need to bark up. The command does not work either in workflow or on the command line. Ill check the version tomorrow, but I had the same error last week and I KNOW the versions were the same, down to the patch. Wish I could remember what I did to resolve it last week. The only thing of which I am 100% sure is that the mapping file is good. Rick - From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Thursday, March 27, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Hi Rick i maybe barking up the wrong tree altogether, but I have got a suspicion that your arimportcmd and the version of ARS are not the same. have you tried being in the directory that arimport.exe resides in and running the command? so go to the c:program files\arsystem\admin directory and try running the command from a DOS box, does that work properly? is so then there is a problem with your mapping file, try the command without a mapping file, you will need an arx or xml file for that, but it will at least tell you if there is a problem with the command itself or the format. let me know if you can generally if you have the command and associated files and the mapping file with the import file in the same directory and you run the import command from there, it should work thanks shafqat Rick Cook [EMAIL PROTECTED] wrote: ** Also tried this: C:\Program Files\AR System\Admin\arimportcmd -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Same error. Rick On Thu, Mar 27, 2008 at 3:45 PM, Rick Cook [EMAIL PROTECTED] wrote: C:\Program Files\AR System\Admin\arimportcmd.exe -u user -p password -M C:\Mappings\Findings.arm -l C:\Mappings\logfile.log Rick On Thu, Mar 27, 2008 at 3:40 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Could you let us know what the import command that you typed looks like? If its complaining about the command, maybe there must be something in there that is offending its syntax? I've got feed like that from support ranging from have you read the manual to you should go for training when I was working on the RKM product.. Almost every other ticket I raised on RKM ended up being a software bug. So I'm hardly likely to consider spending $$$'s for training myself on something that is flaky in the first place! To add to that the documentation on that product is far from 100% accurate.. Even the screen shots on some places are inconsistent to what you actually see when you install the product (Version 7.1 patch 1 of RKM).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 5:34 PM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd error ** Thanks, Joe. It will take the long format as long as the string is in quotes - it worked for me yesterday. I'll keep that suggestion in my back pocket, though, in case nothing else works. Your response was much more helpful than the initial one from Support, which was basically some script monkey in India saying RTFM. Gee, I hadn't thought of that. If there was any troubleshooting data in the docs or the KB, I wouldn't have needed to make a ticket. sigh... Rick On Thu, Mar 27, 2008 at 2:12 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Try putting a 8.3 format DOS path in the path instead of the regular windows path.. If all else as you say is correct, it may be not liking the long path format if you have it set like that.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Thursday, March 27, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: arimportcmd error ** First, I can't believe that there are no Remedy KB entries for arimportcmd. None. Wow. We are attempting to use arimportcmd in an Active Link to import a small number of records into a form. We have a mapping file that works just fine in the Import Tool. When we attempt to run it from the Active Link or the command line, using the same user/pw and mapping file, we get an error that says that the Import command line is missing the schema option or has a wrong format. There isn't even an arimportcmd
Re: EIE vs. arimportcmd flat file import performance
Joe, If you look at the log files generated it: - parses the flat data flat file - gets the .tbl file containing the data mapping definition - does some analysis of each field in the data mapping definition - does some analysis of each field in the CMDB that is referred to - creates the records in the CMDB The analysis takes place for each record in the data file. It's a few months since I was last involved in this but the precessing seemed unnecessarily thorough at the time. Interestingly, we could have used CMDB web services which was much faster (similar to the Import Tool) Cheers Peter Peter, When you state 'see all the processing it's doing to get the data mapped', what exactly do you mean. What does it do? Searches against tables with large volumes of data? Run external scripts / commands / utilities and wait for their output? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Peter Romain Sent: Tuesday, October 02, 2007 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: EIE vs. arimportcmd flat file import performance I did some initial testing of EIE into CMDB 2 and found it much slower (about 1/3 the speed). When you look at the logs and see all the processing it's doing to get the data mapped from the flat files then you can understand why! However, by careful splitting of the data it is possible to use multiple parallel EIE data imports to speed things up. It is also possible to run multiple EIE daemons and direct the data at these to further improve performance. There is a white paper on EIE performance tuning. I guess it comes down to how many records, where they will go (CMDB is particularly slow), how much time you can allow and how complex you want the import to be. I doubt you'll get away without testing. Cheers Peter We are strategizing a way to import a large number of records on a routine basis. I'll just skip all the details since they really are not relevant to the core question: Has anyone compared import speed between the EIE and using the old school arimportcmd command line process in order to import a flat file? I am just curious to see if there is a big advantage in speed either way. There certainly advantages to both tools for doing this particular data import but I have no idea how the speed compares and I don't have the EIE installed on this server (and I'd rather not if I don't have to). William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.39/1044 - Release Date: 10/2/2007 11:10 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: EIE vs. arimportcmd flat file import performance
If analyzing a flat file is what is taking time, then I'm afraid there is nothing you can do to speed up that.. Having said that.. what sort of analysis does it perform? Does it compare the information in the flat file against information that may already be within the database? Is that what usually takes time? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Peter Romain Sent: Wednesday, October 03, 2007 3:37 AM To: arslist@ARSLIST.ORG Subject: Re: EIE vs. arimportcmd flat file import performance Joe, If you look at the log files generated it: - parses the flat data flat file - gets the .tbl file containing the data mapping definition - does some analysis of each field in the data mapping definition - does some analysis of each field in the CMDB that is referred to - creates the records in the CMDB The analysis takes place for each record in the data file. It's a few months since I was last involved in this but the precessing seemed unnecessarily thorough at the time. Interestingly, we could have used CMDB web services which was much faster (similar to the Import Tool) Cheers Peter Peter, When you state 'see all the processing it's doing to get the data mapped', what exactly do you mean. What does it do? Searches against tables with large volumes of data? Run external scripts / commands / utilities and wait for their output? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Peter Romain Sent: Tuesday, October 02, 2007 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: EIE vs. arimportcmd flat file import performance I did some initial testing of EIE into CMDB 2 and found it much slower (about 1/3 the speed). When you look at the logs and see all the processing it's doing to get the data mapped from the flat files then you can understand why! However, by careful splitting of the data it is possible to use multiple parallel EIE data imports to speed things up. It is also possible to run multiple EIE daemons and direct the data at these to further improve performance. There is a white paper on EIE performance tuning. I guess it comes down to how many records, where they will go (CMDB is particularly slow), how much time you can allow and how complex you want the import to be. I doubt you'll get away without testing. Cheers Peter We are strategizing a way to import a large number of records on a routine basis. I'll just skip all the details since they really are not relevant to the core question: Has anyone compared import speed between the EIE and using the old school arimportcmd command line process in order to import a flat file? I am just curious to see if there is a big advantage in speed either way. There certainly advantages to both tools for doing this particular data import but I have no idea how the speed compares and I don't have the EIE installed on this server (and I'd rather not if I don't have to). William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.0/1046 - Release Date: 10/3/2007 10:08 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
EIE vs. arimportcmd flat file import performance
We are strategizing a way to import a large number of records on a routine basis. I'll just skip all the details since they really are not relevant to the core question: Has anyone compared import speed between the EIE and using the old school arimportcmd command line process in order to import a flat file? I am just curious to see if there is a big advantage in speed either way. There certainly advantages to both tools for doing this particular data import but I have no idea how the speed compares and I don't have the EIE installed on this server (and I'd rather not if I don't have to). William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: EIE vs. arimportcmd flat file import performance
Peter, When you state 'see all the processing it's doing to get the data mapped', what exactly do you mean. What does it do? Searches against tables with large volumes of data? Run external scripts / commands / utilities and wait for their output? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Peter Romain Sent: Tuesday, October 02, 2007 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: EIE vs. arimportcmd flat file import performance I did some initial testing of EIE into CMDB 2 and found it much slower (about 1/3 the speed). When you look at the logs and see all the processing it's doing to get the data mapped from the flat files then you can understand why! However, by careful splitting of the data it is possible to use multiple parallel EIE data imports to speed things up. It is also possible to run multiple EIE daemons and direct the data at these to further improve performance. There is a white paper on EIE performance tuning. I guess it comes down to how many records, where they will go (CMDB is particularly slow), how much time you can allow and how complex you want the import to be. I doubt you'll get away without testing. Cheers Peter We are strategizing a way to import a large number of records on a routine basis. I'll just skip all the details since they really are not relevant to the core question: Has anyone compared import speed between the EIE and using the old school arimportcmd command line process in order to import a flat file? I am just curious to see if there is a big advantage in speed either way. There certainly advantages to both tools for doing this particular data import but I have no idea how the speed compares and I don't have the EIE installed on this server (and I'd rather not if I don't have to). William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.39/1044 - Release Date: 10/2/2007 11:10 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
arimportcmd
Good day all, I am attempting to run an arimportcmd in a filter with mapping, but I seem to be hitting it wrong Should I use quotes? Do I need the full path for the arimportcmd? Win2k ARS 6.3 p 18 Thanks for any help Theo No error : arimportcmd -u User -p Password -m CiscoImport_DEV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: arimportcmd
Theo, A few things to help you understand what is going on here. :) Try running these commands, instead of the arimportcmd command to get your bearings: dir c:\dir.log set c:\set.log That should produce two files. dir.log and set.log . They will tell you the working directory and the environment settings that the ARS server uses for any forked processes. Then I would also suggest that you use an output setting for arimportcmd. That would be a -l (lowercase L) with the full path to a file name that should be used to log the output from the process. This might give you a clue as to what the problem is too. But my bet is that you need to fully qualify the path to the exe. You likely also need to use the -d option to tell the exe where to find the mapping file. However you definitely would need to supply a -o setting to tell it what file to import. (-u -p -m is simply not enough information for the program to do anything) Ref:AdvancedGuide-630.pdf page 559. HTH. ARS101 -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 2/8/07, Simmons, Theodore J. [EMAIL PROTECTED] wrote: Good day all, I am attempting to run an arimportcmd in a filter with mapping, but I seem to be hitting it wrong Should I use quotes? Do I need the full path for the arimportcmd? Win2k ARS 6.3 p 18 Thanks for any help Theo No error : arimportcmd -u User -p Password -m CiscoImport_DEV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
arimportcmd
Hello, I am using arimportcmd in an escalation and it Works when the file is in the remedy Server, but when the file is in another machina not in local it doesn't work and the log has the next message: Specified import file is not a regular text file. f:\zto_0002.csv Loading Mappings failed: The import was not attempted Specified import file is not a regular text file. f:\zto_0002.csv The user of Windows, who logs on the remedy service to star it, has another user with the same name and the same password in the machine where is the file. Any ideas. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
arimportcmd using the -e option
Hi all, I have a people form containing the (unique indexed) login name of all employees plus some fields like email address and phone number. I'm trying to daily import a HR-department supplied CSV-file into my system containing people informatie like the previously mentioned fields. That particular file I like to import into my system using arimportcmd version 6.3.0 using the -e option. My login name field is configured to have DBID: 24005. Command: E:\Program Files\AR System\Admin\arimportcmd.exe -u importuser -p importpassword -x server -m CDS -d E:\Program Files\AR System\Home\ARCmds -e 24005 -D 4 -t 3 -l E:\Program Files\AR System\Home\ARCmds\import.log. What I expect is the import using the 24005 field as duplicate and therefore updating existing records, but all I see is the attempt of creating new records (which fails, since the login name field is unique indexed). Can someone assist me on this? Regards, Patrick Simon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: arimportcmd using the -e option
I just had a ticket with Remedy Support on another issue, but all the -e option is cause duplicates to be rejected. It will not merge the existing records. The only way to do that is to create a second form and then use arimportcmd to import to that form and have a filter with a push action to update the records you want. If you can have the import file have the same entry id number you can update all of the records and only have one record in the other form. In our system we import the records and they all have the entry id of 001. Then we have a filter that pushes the data to the form we want. It runs on a merge. Hope this helps. ** Patrick Simon [EMAIL PROTECTED] Jan 11, 2007 7:59 AM Hi all, I have a people form containing the (unique indexed) login name of all employees plus some fields like email address and phone number. I'm trying to daily import a HR-department supplied CSV-file into my system containing people informatie like the previously mentioned fields. That particular file I like to import into my system using arimportcmd version 6.3.0 using the -e option. My login name field is configured to have DBID: 24005. Command: E:\Program Files\AR System\Admin\arimportcmd.exe -u importuser -p importpassword -x server -m CDS -d E:\Program Files\AR System\Home\ARCmds -e 24005 -D 4 -t 3 -l E:\Program Files\AR System\Home\ARCmds\import.log. What I expect is the import using the 24005 field as duplicate and therefore updating existing records, but all I see is the attempt of creating new records (which fails, since the login name field is unique indexed). Can someone assist me on this? Regards, Patrick Simon __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are