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"
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 wrote: > From: Grooms, Frederick W > 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///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 > 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 tro
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 wrote: > From: Grooms, Frederick W > 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///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 > 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 comman
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 wrote: > From: Grooms, Frederick W > 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///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 > 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 simila
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///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 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
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 wrote: From: Rick Cook 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 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
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 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
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 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"
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"