Re: ODBC -- call failed error bringing data into MS Access
Hi all, Users in general tends to use ODBC for ARS like, let say, any Oracle ODBC. Use only one form (table in ACC, CR or Excel). If there is a need to report on 2 or more forms, build JOIN form in ARS, than make a report on join form. I test my SQL with MSQUERY before using in ACC or XLS. Let say you need to compute an average based on a time interval in ACC. - make a table link in your MDF file - built a temporary table in your MDB file - based on user's choice for time interval import locally data using the 'table link' defined in the first step - compute, using data from the ' temporary table', the requested 'average' Avoid using diary fields in your query. If you must use diary fields, use only one and place it at the end of columns extracted by the query. Start building a query in MSQUERY without autoquery enabled and without dragging all columns in the report area. Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Wednesday, June 30, 2010 6:14 AM To: arslist@ARSLIST.ORG Subject: Re: ODBC -- call failed error bringing data into MS Access Hi Jason, This sounds like an issue caused by MS Access being a lot fussier about column names than ARS. There is a fairly short maximum column name length and many special characters also cause problems. Check the name of the first column that returns the #Name? error. Including the status history field in the query is often a cause of trouble also. Rod On 30/06/2010, Jason Miller jason.mil...@gmail.com wrote: ** Hello everybody, Here is an odd one. I have a user who wants to connect MS Access 2007 via ODBC to do some analysis of records. The SQL query returns the correct number of rows but throws an ODBC -- call failed error and the three columns she is asking for return '#Name?' for all rows. I took a server side API and SQL log and everything checked out there. She sent me the Access DB she and it worked on my PC with a non admin ARS user so we focused on her PC. She had the 7.1 patch 5 User Tool which we upgrade to 7.5 patch 5 during troubleshooting. I also tried with my ARS admin credentials on her machine with no success. I verified that 'Replace . in object names' and 'Use underscores' were checked in her ODBC config. I then remembered that you can run an ODBC trace log. I turned it on, ran her query again and the correct data was returned. For giggles I turned off the trace and #Name? was returned. Turn the ODBC trace back on and the actual data is returned. Has anybody seen this or have any idea why enabling a trace allows the data to make its way into Access? Thanks, Jason App = ARS 7.5 App Server =Windows 2008 64-bit DB = MS SQL 2005 64-bit DB Server Windows 2008 64-bit PC = XP Pro SP3 WUT = 7.1 p5 and 7.5 p5_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 * This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
survey form
Hi , Can anybody tell me what is the form used for survey link, were we can update the link in that form. RAVI CHANDRA . RAMAGIRI __ Information from ESET NOD32 Antivirus, version of virus signature database 5239 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: survey form
Hello Ramagiri, The form name is SHR:Survey. Regards Sucharita From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramagiri Sent: Wednesday, June 30, 2010 4:19 PM To: arslist@ARSLIST.ORG Subject: survey form ** Hi , Can anybody tell me what is the form used for survey link, were we can update the link in that form. RAVI CHANDRA . RAMAGIRI __ Information from ESET NOD32 Antivirus, version of virus signature database 5239 (20100630) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _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: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines
Thanks a lot Conny for your contribution, if I understand well, you're suggesting to 'cheat' the installer making it believe to do an upgrade from 6 to 7. Can you provide some more details on how to do that? Isn't it necessary anymore to 'prepare' the server with environment variables and locales with this procedure? Is there any risk involved such as corruption of structures/data, or ARS not re-starting anymore? Kind Regards, Antonio On Tue, Jun 29, 2010 at 4:46 PM, Conny Martin conny.mar...@t-systems.comwrote: ** Antonio, Simply changing parameters, locale settings etc. won't work. The reason is explained in document BMC Remedy Action Request System 7.1.00 Installing on page 162. The only supported way to upgrade to Unicode is from 6.3 to 7.x But you can do a little hack. In short: 1. UPDATE .control SET dbversion = 21 (21 means ARS 6.3) 2. run arupora (this will update the serialized qualifiers to have the correct byte lengths) 3. UPDATE .control SET dbversion = 23 I can provide you additional information if you're not familiar with the internals of the upgrade process. HTH Kind Regards Conny -- *Von:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *Im Auftrag von *Antonio Monizza *Gesendet:* Dienstag, 29. Juni 2010 15:05 *An:* arslist@ARSLIST.ORG *Betreff:* ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines ** Hello listers, we have a custom application, with ARS 7.1.0 server on AIX machine, installed in NON Unicode mode and pointing to AIX db server with Oracle 9.2, characterset UTF8. So database is already Unicode enabled, ARS is not. We are planning to do a major upgrade: we need to have our ARS server in Unicode mode, then we will point app server to a new db machine with Oracle 10, eventually we want to upgrade to ARS 7.5. Currently we are focusing on the non Unicode to Unicode upgrade step, so we are looking for any valuable advise on the topic. At BMC support they keep on saying that a brand new ARS installation in Unicode mode is needed (i.e. no upgrade), and then def+data must be imported at ARS level Has anyone of you ever tried to upgrade ARS 7.1.0 from non Unicode to Unicode mode ‘simply’ changing parameters and environment variables (LANG and LC_ALL) and locale settings on the ARS application server, acting directly on ar.conf and arsystem files, and then doing a stop/restart of ars server? Should a new installation be inevitable, we really want to avoid using migrator or arimport for data migration (too many forms, too many data…), and use oracle export/import instead of whole arschema: has anyone of you ever tried this option? Any advise and suggestion on this topic is very welcome! Thanks in advance Best Regards, Antonio Monizza _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: How to create ticket in Remedy by sending e-mail or script
Hi, If you have email engine installed and incoming mailbox configured you can achieve this easily. Check out the guide on ARS Email Engine. skrz wrote: Hi, I want to create a ticket in Remedy in fast and simple way: for example, by sending a special e-mail or script, is it possible ? I found some tool - http://www.westoverconsulting.co.uk/utilitiesOutlook.html Does anyone know how to use this template ? Thanks regards Michal [ skrz ] - With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/How-to-create-ticket-in-Remedy-by-sending-e-mail-or-script-tp28896005p29033872.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: incident SLAs
Whenever you are plugging in a Keyword into Remedy fields that are not the Advanced Search bar it always seems to put the \ right after the $ sign. They are basically the same. Thanks Peter Lammey ESPN IT Packaging and Automation 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, June 29, 2010 5:53 PM To: arslist@ARSLIST.ORG Subject: Re: incident SLAs Peter - Thanks for the suggestion. I will test it in Dev. I knew it had to be easier than I thought. What is the difference between $NULL$ and $\NULL$ ? I've seen this before but can't remember exactly. Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Tuesday, June 29, 2010 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: incident SLAs Set your Stop conditions for your Response SLA to the following: 'Status' = Resolved OR 'Status History.In Progress.TIME' != $\NULL$ OR 'Status' = In Progress OR 'Status History.Resolved.TIME' != $\NULL$ This way when the ticket is Resolved or Closed or Cancele or In Progress it stops the clock and determines Measurement status and will stay stopped as long as you have a Status history date for Resolved or In Progress. Thanks Peter Lammey ESPN IT Packaging and Automation 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Tuesday, June 29, 2010 4:12 PM To: arslist@ARSLIST.ORG Subject: incident SLAs I wanted to ping the list to see what others are doing/thinking regarding SLAs and ITSM. We currently have 2 SLAs per incident: response and resolution. - we'll focus on the response SLA for now. As normal, when a ticket is new, the SLAs are attached and are kicked off when the status is Assigned. The response SLA stops when the ticket is set to In Progress. This means that the ticket has been acknowledged. If the ticket is re-assigned to another support group, the status changes back to Assigned and the response SLA starts calculating time again. I have been asked to look at once the response SLA is met once, then don't restart it if the incident is assigned to another support group. Or as some folks put it why have to shoot the duck twice if it's already dead with the first shot. I was thinking of creating a hidden field on the HPD:Help Desk form and having a filter populate this field if the status is In progress. AND adding to the Terms and Conditions of the response service target: AND 'field' = $NULL$. I wanted to check w/ the list if this is a good solution or if I am creating workflow for something that can be done OOB by a setting change. Any comments appreciated. Thanks. Marcelo ARS7.1 P7 ITSM 7.0.03 P6 SLM 7.0 P4 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are Please consider the environment before printing this e-mail. ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How to create ticket in Remedy by sending e-mail or script
I hope this helps anyone searching for this type of help. We used a very simple template like this. Schema: HPD:IncidentInterface_Create Server: remedyserver Login: loginid Password: Action: Submit Format: Short Last Name* !100018!: Guest Company*+ !11!: My Company First Name* !100019!: My Service Type !100099!: 0 Reported Date !100560!: 11/06/2010 3:26 PM Priority !100164!: Medium Status ! 7!: New Weight !100169!: 10 Impact* !100163!: 3-Moderate/Limited Urgency* !100162!: 4-Low Support Company* !100251!: My Company Support Organization* !100014!: Application Support Assigned Group*+ !100217!: Application Support Description !10!: Summary test Reported Source !100215!: Email Product Categorization Tier 1 ! 20003!: Applications Product Categorization Tier 2 ! 20004!: Applications2 Product Categorization Tier 3 ! 20005!: Error z1D_Action ! 100076!: CREATE Details !100151!: [$$Anything within these brackets will be saved as text testing $$] z1D_Activity_Type !301398600!: 16000 !301602600!: 1000 !301329900!: !301398800!: On Jun 30, 8:22 am, NNMN naveen...@gmail.com wrote: Hi, If you have email engine installed and incoming mailbox configured you can achieve this easily. Check out the guide on ARS Email Engine. skrz wrote: Hi, I want to create a ticket in Remedy in fast and simple way: for example, by sending a special e-mail or script, is it possible ? I found some tool - http://www.westoverconsulting.co.uk/utilitiesOutlook.html Does anyone know how to use this template ? Thanks regards Michal [ skrz ] - With Warm Regards, Naveen -- View this message in context:http://old.nabble.com/How-to-create-ticket-in-Remedy-by-sending-e-mai... Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: AR User Tool Deprecated?
You've all been positing a lot of good arguments here. Let me put in my $.02... I've recently become a fan of Google's Chrome browser after yet another piece of malware/spyware waltzed past Internet Explorer and Norton Antivirus on my home pc. Our team is testing ITSM 7.6 on ARS 7.5 right now in preparation for an upgrade. Out of curiosity, I decided to compare the relative merits of the major browsers. I have discovered that Internet Explorer performs at about the same speed as the WUT, but Chrome, Safari, and Firefox move much faster. Also, IE requires a plug-in to get spell-check capabilities which come automatically with the other three browsers, and has to be built or bought for the WUT. Not that there aren't drawbacks to the other browsers: Chrome doesn't play well with Remedy's calendars, and some of the buttons refuse to work at all. (Chrome is not a supported browser.) Firefox does something annoying with scroll bars on unlimited character fields. Safari on a pc hangs up if you're trying to create an incident with decision trees enabled but not defined. (In its defense, Safari for pcs isn't supported, either.) Overall, I'm impressed with the performance of the mid-tier on ARS 7.5. In the past I've developed applications intended for use with the native client, but I think I'm going to change my focus toward the mid-tier in the future. Rather than losing the WUT, I am gaining three fallback browsers and smartphone support without the additional expense of a smartphone-only application. We may even decide to upgrade to ARS 7.6.3, depending on the timing of the release. There are a lot of things to like when you consider not supporting the WUT. Jennifer Meyer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, June 24, 2010 5:22 PM To: arslist@ARSLIST.ORG Subject: Re: AR User Tool Deprecated? Angus...I'm a fan of the native client as well...but tell me thiswould you use Amazon or Ebay if you needed to load a client to get to it? Maybe, maybe not...but I doubt that you WOULDN'T use it if you had to use the web browser, right? The default delivery method for this type of software these days is web...maintaining clients is a royal pain in the ARS (sorry...couldn't resist the pun)...web applications are robust and those apps that rely on client based interactions need to update their interfaces to allow for newer technologies. E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official. ___ 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: Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client
We are still on 6.3, but I did something similar to Gary, with a twist. We have several customers and each customer we record infromation for has their own schema. I created a display only form with a page field and a tab for each customer, a s well as a table, and an AL that refreshes the table regularly. For each tab, I also created a Notify On field so the user could choose when they wanted to be alerted (e.g. if a Priority column has a record with a High Priority value, etc.) and a Warning would pop-up. I also threw in a few other bells whistles - an option for the Managers to select their employees so the manager quickly view what is assigned to each employee, a button to open the selected record from the table, using a table loop in the event multiple records are selected, the ability to modify certain fields within the table (which also grants the ability to users to do a Modify All without actually using Modify All that has caused some issues for us in the past), row counts so the user can see how many in each table, and it seems to be a very handy tool. Hope this helps! Shawn Stonequist EMNS, Inc. ___ 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
Error on creating web service mapping
I'm hoping someone can help me with the following error. Failed to intialize JRE and internal java module (ARERR 7017) What I'm trying to do is reconfigure the input mapping of an existing web service that we currently have. While in the input mapping screen, i click to choose the xml schema and receive the above message. In trying to reasearch the error online, I've come across suggestions to reinstall the admin tool (didn't help) as well as references to KM-00018146 knowedge base article (which unfortunately I cannot access due to issue with Remedy Support website right now). I also get the same error if i make any other change on the web service and try to save it. Any help would be appreciated. Here's some details about our environment: ARS ver 7.0.1 patch 6 OS: Windows DB: MS SQL 2005 Thanks, Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
OT:Job Openings
All, I have received the following job openings. Please contact Jessie Recco. Jessie Recco Technical Recruiter Kforce Professional Staffing Phone: 703.464.6661 Cell: 703.447.5676 Fax: 703.481.3866 jre...@kforce.com JOB 1: Description: Senior REMEDY Developer –Target pay 60-70hr W2 Chantilly, VA Candidates for this position must be able to install, implement and deploy the BMC Remedy ITSM suite of products. The candidate must also be able to modify the ITSM products or create new applications using the ARSystem tool set. Candidate will be expected to work with customers to deliver quality product in the time negotiated. This will require the ability to work independently and in teams, both onsite and from home. Essential Developer Job Functions: • Conducts site assessments and prepares complex design proposals; develops and executes upgrade implementation plans, including equipment procurement, change scheduling, and logistics. • Maintains communications with customers, end users, suppliers, sub-contractors and vendors as appropriate in order to ensure appropriate designs. Researches and gathers information for complex customer requirements. • Applies specialization to conceptualize, design, construct, test and implement portions of business and technical information technology solutions through application of appropriate software development life cycle methodology. • Maintains security, integrity and business continuity controls and documents when designing information technology solutions. • Uses appropriate tools to analyze, identify and resolve business and or technical problems when designing information technology solutions. Recommends new tools or procedures as appropriate. • Assists information engineers when coding, testing, implementing and documenting projects. • Participates in business and technical information technology solution implementations, upgrades, enhancement and conversions. Recommends solutions as appropriate. • Applies metrics to monitor performance and measure key project criteria. • Participates in special studies, marketing efforts and formal proposals. Stays current on emerging tools, techniques and technologies to ensure that customer requirements are met. • Assists in reviewing other system and programming designs to ensure selection of appropriate technology, efficient use of resources and integration of multiple systems and technologies. • May assist and/or provide limited direction to lower level technical personnel. Desirable Qualifications: • Six or more years of Remedy Application Engineering Experience • BMC Remedy ITSM 7.x Training Certifications • BMC Atrium CMDB Skilled Professional Certification • Working knowledge of the ITSM Applications • Perl (ARS Perl, Oracle DBI) • BMC Remedy Distributed Server Option (DSO) • Oracle DB Administration • Solaris, Linux and Windows Administration • Java, Servlet JSP Programming Description: Senior REMEDY Developer (cont.) Basic Qualifications: • Bachelor's degree or equivalent combination of education and experience • Bachelor's degree in computer science, business administration, or related field preferred • Nine or more years of technical consulting or computer science experience • Experience working with technology industry and architecture • Experience working with technical products, vendors, and families of technology • Experience working with mainframes, scheduling software, and other related technologies • Experience working with project management methodology such as Catalyst including budget development, project planning, control and assurance methodologies, project management software and finance and accounting knowledge Other Qualifications: • Strong personal computer and business solutions software skills • Good communication skills to communicate with clients, support personnel, and management • Strong analytical and problem solving skills • Good interpersonal skills to communicate with clients and management • Basic leadership skills • Ability to work in a team environment • Willingness to travel JOB2 REMEDY Developer – target pay 50.00hr W2 Chantilly VA Essential Job Functions: • Remedy Developer will be responsible to support the day-to-day run maintain of the ITSM Remedy solution. • Responsibilities will include configuration and development of Change Management, Incident Management, Asset Management, Knowledge Management, Problem Management and Service Request Management modules. • Assist in the development, change, test and deployment of processes into Remedy and work directly with managers and Remedy System Administrators. • Monitor and manage the operating systems supporting the Remedy servers and back-end databases and web servers. • Create and manage user documentation and provide training to the user community as necessary. • Delivers technological requirements such as server, desktop, local service,
Re: ODBC -- call failed error bringing data into MS Access
Thanks for the feedback Rod. I double checked and the longest column name is 10 characters and there are not any special characters other than the underscore. At this point the query is very straight forward: Request_ID, Vendor, Assign_to_. What also has me stumped is that it works on one machine and not another and also that enabling the Trace log allows it to work correctly on the troubled machine. Jason On Tue, Jun 29, 2010 at 8:13 PM, Rod Harris r...@smapps.com.au wrote: Hi Jason, This sounds like an issue caused by MS Access being a lot fussier about column names than ARS. There is a fairly short maximum column name length and many special characters also cause problems. Check the name of the first column that returns the #Name? error. Including the status history field in the query is often a cause of trouble also. Rod On 30/06/2010, Jason Miller jason.mil...@gmail.com wrote: ** Hello everybody, Here is an odd one. I have a user who wants to connect MS Access 2007 via ODBC to do some analysis of records. The “SQL” query returns the correct number of rows but throws an “ODBC -- call failed” error and the three columns she is asking for return ‘#Name?’ for all rows. I took a server side API and SQL log and everything checked out there. She sent me the Access DB she and it worked on my PC with a non admin ARS user so we focused on her PC. She had the 7.1 patch 5 User Tool which we upgrade to 7.5 patch 5 during troubleshooting. I also tried with my ARS admin credentials on her machine with no success. I verified that ‘Replace “.” in object names’ and ‘Use underscores’ were checked in her ODBC config. I then remembered that you can run an ODBC trace log. I turned it on, ran her query again and the correct data was returned. For giggles I turned off the trace and #Name? was returned. Turn the ODBC trace back on and the actual data is returned. Has anybody seen this or have any idea why enabling a trace allows the data to make its way into Access? Thanks, Jason App = ARS 7.5 App Server =Windows 2008 64-bit DB = MS SQL 2005 64-bit DB Server Windows 2008 64-bit PC = XP Pro SP3 WUT = 7.1 p5 and 7.5 p5_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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ODBC -- call failed error bringing data into MS Access
Hi Daniel, this is great info. I didn't know about MSQUERY. I'll have her try the query in MSQUERY as well as try the step you detailed. Thanks! Jason On Wed, Jun 30, 2010 at 1:45 AM, Daniel Condrea daniel.cond...@orange-ftgroup.com wrote: Hi all, Users in general tends to use ODBC for ARS like, let say, any Oracle ODBC. Use only one form (table in ACC, CR or Excel). If there is a need to report on 2 or more forms, build JOIN form in ARS, than make a report on join form. I test my SQL with MSQUERY before using in ACC or XLS. Let say you need to compute an average based on a time interval in ACC. - make a table link in your MDF file - built a temporary table in your MDB file - based on user's choice for time interval import locally data using the 'table link' defined in the first step - compute, using data from the ' temporary table', the requested 'average' Avoid using diary fields in your query. If you must use diary fields, use only one and place it at the end of columns extracted by the query. Start building a query in MSQUERY without autoquery enabled and without dragging all columns in the report area. Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Wednesday, June 30, 2010 6:14 AM To: arslist@ARSLIST.ORG Subject: Re: ODBC -- call failed error bringing data into MS Access Hi Jason, This sounds like an issue caused by MS Access being a lot fussier about column names than ARS. There is a fairly short maximum column name length and many special characters also cause problems. Check the name of the first column that returns the #Name? error. Including the status history field in the query is often a cause of trouble also. Rod On 30/06/2010, Jason Miller jason.mil...@gmail.com wrote: ** Hello everybody, Here is an odd one. I have a user who wants to connect MS Access 2007 via ODBC to do some analysis of records. The SQL query returns the correct number of rows but throws an ODBC -- call failed error and the three columns she is asking for return '#Name?' for all rows. I took a server side API and SQL log and everything checked out there. She sent me the Access DB she and it worked on my PC with a non admin ARS user so we focused on her PC. She had the 7.1 patch 5 User Tool which we upgrade to 7.5 patch 5 during troubleshooting. I also tried with my ARS admin credentials on her machine with no success. I verified that 'Replace . in object names' and 'Use underscores' were checked in her ODBC config. I then remembered that you can run an ODBC trace log. I turned it on, ran her query again and the correct data was returned. For giggles I turned off the trace and #Name? was returned. Turn the ODBC trace back on and the actual data is returned. Has anybody seen this or have any idea why enabling a trace allows the data to make its way into Access? Thanks, Jason App = ARS 7.5 App Server =Windows 2008 64-bit DB = MS SQL 2005 64-bit DB Server Windows 2008 64-bit PC = XP Pro SP3 WUT = 7.1 p5 and 7.5 p5_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 * This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ___ 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: 7.5 Mid Tier Object List Question
Doug, We have found a bug with the MidTier Object List. We are running MidTier 7.5 Patch 004 against AR System Server 7.1 Patch 007. What we are seeing is the MidTier Object List is showing any form the User has permissions to access. Even the forms that are set with Hidden permissions are being displayed in the MidTier Object List. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: Tuesday, June 22, 2010 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: 7.5 Mid Tier Object List Question Folks, I just want to be clear here... There is no Security through Obscurity concept in the AR System. Permissions control security. You can specify that users either do or do not have access. You can do this at the form level, at the field level, at the row level. If a user does not have access, they cannot see the form/field/row that they don't have access to. No exceptions. No special cases. No difference between clients or custom programs or in any way accessing the system. If there is no permission, they cannot see it. If there is no permission, that item does not exist. In fact, if the user tries to access it by giving a direct URL or by calling it from the API or whatever, they will get an error that says No such object or No matching row. They will not get a it is there but no access message. They will be told that it doesn't exist. There has never been a situation where customers without access to a form, field, or row has gotten access to that item. Now, we come to a control capability that we have to allow control over the visible vs. not visible in a list of forms list property. That is to specify something is visible vs. hidden. This is NOT security. Security is saying the user has or does not have access not whether once they have access, the NAME is visible or hidden. If a user has access, they are allowed to see the form and see the data on the form and access the form and read records and whatever it is from the form. The only thing visible/hidden controls is whether it shows up on the form list you can select from or not by default. Yes, a customer can access a hidden form. That is exactly as planned and it is exactly as your security has specified. You have given that user access. So, they can access the form. If you don't want them to have access to that form, don't give them access to it. Then, they cannot open it no matter what. If they pull data from it in workflow, then they need access to the data. They are pulling data from it so you have given them access. If you don't want them to have access but want data from it, use the Service action of workflow to send the request to the server where the filters run with Admin rights to get data so you can have the user have NO access to the form but use filters to get the data as Administrator and using the Service call get that data back to the client for display on the screen. So, you would have access to the data without every exposing access to the form that contained the data. But, then you would set security to NOT allow access to the form at all for the user and then the user could never open the form or see it or even know it exists unless you gave them the name but then they still couldn't do anything with that name. It is important that you don't mix security -- allowing access -- with the concept of whether you have selected to hide the name of a form by not showing it in the forms list -- visible/hidden capability. There is no implementation of security through obscurity in the system as far as accessing forms or fields or data rows. There is allowing you to hide things so it is not confusing for users to see forms that are not useful to them to open directly. This is true in many applications, there are backend forms to which you need access but to which you are never expected to open directly. So, you need permission, but you don't want them shown in something to pick from. This is an assistance to the user not a security feature. I hope this helps clarify things and helps differentiate between two features that just happen to be set in the same place -- access right -- this is security -- visible/hidden capability on things you have access to -- a UI feature Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Tuesday, June 22, 2010 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: 7.5 Mid Tier Object List Question Yupsecurity through obscurity is not a good security model. If they should have access to the data, there is no issue with them being able to get to it...if not, change the permissions. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Boyd, Rebecca E. Sent: Tuesday, June 22, 2010 12:38 PM To:
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
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
DSO question
Good day fellow listers! I have a quick question for everyone. While I understand the purpose of DSO, I have never actually used it. If there are 2 system, one is ars 6.3 and the other is 7.5. Is there any reason that a DSO link could not be set up between the 2 systems (given the fact that there are field differences in the 2 setups). The desired affect is to allow tickets created on the 7.5 system to also show up on the 6.3 (and vice-versa). Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: DSO question
Hi Warren, I used DSO from a 5.x system to 6.3. So I think the concept would be the same. The sending server uses DSO to talk to the ARServer on the receiving side so as long as you can map the fields through, you should be able to get it working. pritch On Wed, 30 Jun 2010 14:30:00 -0400, Warren Baltimore warrenbaltim...@gmail.com wrote: Good day fellow listers! I have a quick question for everyone. While I understand the purpose of DSO, I have never actually used it. If there are 2 system, one is ars 6.3 and the other is 7.5. Is there any reason that a DSO link could not be set up between the 2 systems (given the fact that there are field differences in the 2 setups). The desired affect is to allow tickets created on the 7.5 system to also show up on the 6.3 (and vice-versa). Warren ___ 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 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: Remedy/Aeroprise and 2048 SSL certificate - Not Trusted message
I don't know why you have this error. You should contact Aeroprise and your security support group. Good luck.. Virgilio Felonia, MCP, ITIL, AIT Sr. Applications Support Analyst|Tools Mgmt|Systems Engineering|Bank of Montreal| Office: 416-502-7197|Cell: 416-996-2182| ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: DSO question
Thanks for the info! On Wed, Jun 30, 2010 at 2:49 PM, pritch pri...@ptd.net wrote: Hi Warren, I used DSO from a 5.x system to 6.3. So I think the concept would be the same. The sending server uses DSO to talk to the ARServer on the receiving side so as long as you can map the fields through, you should be able to get it working. pritch On Wed, 30 Jun 2010 14:30:00 -0400, Warren Baltimore warrenbaltim...@gmail.com wrote: Good day fellow listers! I have a quick question for everyone. While I understand the purpose of DSO, I have never actually used it. If there are 2 system, one is ars 6.3 and the other is 7.5. Is there any reason that a DSO link could not be set up between the 2 systems (given the fact that there are field differences in the 2 setups). The desired affect is to allow tickets created on the 7.5 system to also show up on the 6.3 (and vice-versa). Warren ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
If they always use the same from address couldn't you use that in your filter to say don't process these? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, June 30, 2010 12:58 PM To: arslist@ARSLIST.ORG Subject: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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: deleting assets from CMDB
In our case, I opened the CI in the AST:Class form, then update status to Delete and click SAVE. Then I go to Application Administration Console, Custom Configuration, Asset Management, Advanced Options, open CI Deletion and search for the CI that I have marked for deletion and clicked Delete Selected CI(s). This process will put Yes on the field MarkAsDeleted, and then I sheduled to run OOTB Reconciliation job called BMC Asset - Purge to permanently delete CI's and relationships. Hope this helps. Virgilio Felonia, MCP, ITIL, AIT Sr. Applications Support Analyst|Tools Mgmt|Systems Engineering|Bank of Montreal| Office: 416-502-7197|Cell: 416-996-2182| ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: DSO question
Warren, Don't forget that newer versions (7.x range) require a password. Under connection settings in the AR System Administration: Console of newer 7.x versions. So make sure the 6.3 version can accept the password from a newer version and make sure the 6.3 can send a password to a newer version. There was a period where certain older versions just weren't compatible with newer versions because of this. Regards, Chad Whilding Engineer CSC 3725 Pentagon Blvd., Beavercreek, OH 45431-1706 North American Public Sector | p: +1-937.320-6342 | f:+1-937-320- | cwhild...@csc.com | www.csc.com 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. | | From: | | --| |Warren Baltimore warrenbaltim...@gmail.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/30/2010 02:30 PM | --| | | Subject: | | --| |DSO question | --| ** Good day fellow listers! I have a quick question for everyone. While I understand the purpose of DSO, I have never actually used it. If there are 2 system, one is ars 6.3 and the other is 7.5. Is there any reason that a DSO link could not be set up between the 2 systems (given the fact that there are field differences in the 2 setups). The desired affect is to allow tickets created on the 7.5 system to also show up on the 6.3 (and vice-versa). Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _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
How to refresh data from multiple tables through Escalation
Hi, Need an urgent he for escalation. I have to put an escalation on a radio button, which will refresh the data coming from another form. after every 24 hours Thanks in advance -- Syed Ahsan Raza ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: DSO question
Thanks Chad! On Wed, Jun 30, 2010 at 4:33 PM, Chad M Whilding cwhild...@csc.com wrote: Warren, Don't forget that newer versions (7.x range) require a password. Under connection settings in the AR System Administration: Console of newer 7.x versions. So make sure the 6.3 version can accept the password from a newer version and make sure the 6.3 can send a password to a newer version. There was a period where certain older versions just weren't compatible with newer versions because of this. Regards, Chad Whilding Engineer CSC 3725 Pentagon Blvd., Beavercreek, OH 45431-1706 North American Public Sector | p: +1-937.320-6342 | f:+1-937-320- | cwhild...@csc.com | www.csc.com 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. | | From: | | --| |Warren Baltimore warrenbaltim...@gmail.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |06/30/2010 02:30 PM | --| | | Subject: | | --| |DSO question | --| ** Good day fellow listers! I have a quick question for everyone. While I understand the purpose of DSO, I have never actually used it. If there are 2 system, one is ars 6.3 and the other is 7.5. Is there any reason that a DSO link could not be set up between the 2 systems (given the fact that there are field differences in the 2 setups). The desired affect is to allow tickets created on the 7.5 system to also show up on the 6.3 (and vice-versa). Warren -- Warren R. Baltimore II Remedy Developer 410-533-5367 _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 -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 12:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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: How to refresh data from multiple tables through Escalation
you can do a run process that calls an active link, and in the active link you can refresh the field in question. On Wed, Jun 30, 2010 at 5:00 PM, ahsan raza ahsanahsan1...@gmail.comwrote: ** Hi, Need an urgent he for escalation. I have to put an escalation on a radio button, which will refresh the data coming from another form. after every 24 hours Thanks in advance -- Syed Ahsan Raza _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 12:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hi Kevin, Yes... Company B is a customer and they also use Remedy. So they want to be able to send us email updates to valid INC's on our side. The problem is they have a INC on their side for the same issue they created with us. So their Subject line says INC1234 - Update, etc. INC1234 on our side is a closed invalid INC totally unrelated to their company and their issue. My answer was We HAVE to have the correct INC number for Remedy to correctly find and update the valid INC on our side.We don't care what THEIR INC number is. As long as they send us invalid INC numbers, Remedy can't read their minds. If Company B can't send us the correct INC #, then I am stuck. GIGO - right? :-) Thanks, Jase On Wed, Jun 30, 2010 at 5:47 PM, Kevin Begosh kbeg...@gmail.com wrote: ** so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.comwrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 12:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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_ -- Kevin Begosh _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: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hi Jase, Is there a way you can tell if your record is for Company B then you can say if the INC# provided is matched with a Company B record process that update otherwise report it as an error? Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, June 30, 2010 3:27 PM To: arslist@ARSLIST.ORG Subject: Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hi Kevin, Yes... Company B is a customer and they also use Remedy. So they want to be able to send us email updates to valid INC's on our side. The problem is they have a INC on their side for the same issue they created with us. So their Subject line says INC1234 - Update, etc. INC1234 on our side is a closed invalid INC totally unrelated to their company and their issue. My answer was We HAVE to have the correct INC number for Remedy to correctly find and update the valid INC on our side.We don't care what THEIR INC number is. As long as they send us invalid INC numbers, Remedy can't read their minds. If Company B can't send us the correct INC #, then I am stuck. GIGO - right? :-) Thanks, Jase On Wed, Jun 30, 2010 at 5:47 PM, Kevin Begosh kbeg...@gmail.com wrote: ** so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, June 30, 2010 12:58 PM To: arslist@ARSLIST.ORG Subject: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ -- Kevin Begosh _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 image001.gif
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hi Debra, Thanks for the idea. The problem is the sequential numbering is always going to find an older INC on our side. I have had a couple of ideas since writing my original post. Archiving may handle this - if the old INC on our side doesn't exist on HPD:HelpDesk then that may solve the issue. Has anyone ever considered changing the naming Convention of an INC? i.e. - from INC000 to something else like QTS? The very thought of doing this makes me shiver; considering all the places I am sure INC # is integrated. Just a thought.. :-) Thanks, Jase On Wed, Jun 30, 2010 at 6:31 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Jase, Is there a way you can tell if your record is for Company B then you can say if the INC# provided is matched with a Company B record process that update otherwise report it as an error? Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper *http://www.prn.com * P *Think Green-* please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 3:27 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hi Kevin, Yes... Company B is a customer and they also use Remedy. So they want to be able to send us email updates to valid INC's on our side. The problem is they have a INC on their side for the same issue they created with us. So their Subject line says INC1234 - Update, etc. INC1234 on our side is a closed invalid INC totally unrelated to their company and their issue. My answer was We HAVE to have the correct INC number for Remedy to correctly find and update the valid INC on our side.We don't care what THEIR INC number is. As long as they send us invalid INC numbers, Remedy can't read their minds. If Company B can't send us the correct INC #, then I am stuck. GIGO - right? :-) Thanks, Jase On Wed, Jun 30, 2010 at 5:47 PM, Kevin Begosh kbeg...@gmail.com wrote: ** so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 12:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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_ -- Kevin Begosh _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: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Jase, Have you considered using the Vendor Ticket Number on the Vendor tab to map their incident number to yours? Thad On Wed, Jun 30, 2010 at 3:45 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Debra, Thanks for the idea. The problem is the sequential numbering is always going to find an older INC on our side. I have had a couple of ideas since writing my original post. Archiving may handle this - if the old INC on our side doesn't exist on HPD:HelpDesk then that may solve the issue. Has anyone ever considered changing the naming Convention of an INC? i.e. - from INC000 to something else like QTS? The very thought of doing this makes me shiver; considering all the places I am sure INC # is integrated. Just a thought.. :-) Thanks, Jase On Wed, Jun 30, 2010 at 6:31 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Jase, Is there a way you can tell if your record is for Company B then you can say if the INC# provided is matched with a Company B record process that update otherwise report it as an error? Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper *http://www.prn.com * P *Think Green-* please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 3:27 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hi Kevin, Yes... Company B is a customer and they also use Remedy. So they want to be able to send us email updates to valid INC's on our side. The problem is they have a INC on their side for the same issue they created with us. So their Subject line says INC1234 - Update, etc. INC1234 on our side is a closed invalid INC totally unrelated to their company and their issue. My answer was We HAVE to have the correct INC number for Remedy to correctly find and update the valid INC on our side.We don't care what THEIR INC number is. As long as they send us invalid INC numbers, Remedy can't read their minds. If Company B can't send us the correct INC #, then I am stuck. GIGO - right? :-) Thanks, Jase On Wed, Jun 30, 2010 at 5:47 PM, Kevin Begosh kbeg...@gmail.com wrote: ** so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jase Brandon *Sent:* Wednesday, June 30, 2010 12:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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_ -- Kevin Begosh _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
JOB: Remedy Developer/Architect - 9 Month Contract - San Diego, CA - US Citizens Only
I'm passing this along for a friend in case anyone wants to work in sunny So Cal for 9 months :) - Remedy Developer/Architect (9 month contract) in the San Diego/Orange County, CA area. * Responsible for the Configuration, Development, and Oversight of Remedy 7.x * Responsible for adhering to all ITIL v3 processes during the development of the Remedy System, including the Incident Management, Change Management, Asset Management, Configuration Management, Knowledge Management, Self-Service, and SLA components. Qualifications * 9 years experience in progressively responsible roles associated with IT and a minimum of 3 years Remedy Development experience. * 3.5 years of System Administration experience with Microsoft SQL and / or Oracle. * 5+ years experience providing data base administration support and development for Remedy ITSM 6.x and 7.x. * Experience installing/configuring/upgrading Remedy servers and clients. * Experience in upgrading to 7.x. * Attention to detail is a MUST. * Experience with API connectors, redundant system establishment, and hardware integration with scanners and mobility products. * Expertise in group level security access. * Must have good communication skills and be able to communicate clearly, both orally and in writing. * Must possess good time management, organizational, and presentation skills. * Ability to work in a quickly changing and challenging environment. * Ability to develop and implement standard operating procedures and policies. * Ability to work well within a team and work closely with other members of the organization, e.g., operations staff, software developers, networking team, etc * Must be able to obtain Secret Government clearance. Must be a US Citizen. Desired Skills: * RAC (Remedy Authorized Consultant) . * ITIL v3 certification. * Experience with Business Objects or SharePoint preferred * BS in Computer Science or related discipline If interested please contact Jason Rosenfeld at jason.rosenf...@casktechnologies.commailto:jason.rosenf...@casktechnologies.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
What is the ITSM version ? If you look at the some of the sample Incidents on 7.5 and 7.6, they have a company prefix for the Incident Number which may give you some ideas. Also, you may want to refer section titled Configuring forms to use Unique Prefixes in the white paper that describes how to implement the BMC Remedy Distributed Server Option with the applications in the BMC Remedy IT Service Management Suite. Thanks Mahesh On Wed, Jun 30, 2010 at 10:31 PM, Mahesh mchand...@gmail.com wrote: What is the ITSM version ? If you look at the some of the sample Incidents on 7.5 and 7.6, they have a company prefix for the Incident Number which may give you some ideas. Also, you may want to refer section titled Configuring forms to use unique prefixes in the attached white paper. Thanks Mahesh On Wed, Jun 30, 2010 at 2:58 PM, Jase Brandon jasebran...@gmail.comwrote: ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _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