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, 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___ > > > > > > > __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"
