Re: How to change Button text in SRM?
Hi Doug, Thanks for your full description on how to do it the easy AND Supported way. I had to add an additional action Flush MidTier Cache before it was visible, but it really was easy (once you know where to look :-) ). Thanks again! Rehards, Rob. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: security risk with attachment - Any ideas?
Hi, I have found one thread on web http://old.nabble.com/Re:-Virus-Scanning-Remedy-Attachments---p3614885.html Which in short means: We can make use of Filters that fire on Create/Modify that check to see if there is a change in an attachment. The actions taken are 1) Use special run process to Save the attachment to disk PERFORM-ACTION-SAVE-ATTACHMENT 2) Use special run process to Add the attachment just saved back to the system PERFORM-ACTION-ADD-ATTACHMENT Virus checking software on server will check virus for saved attachment and then we can load a Scanned copy of attachment. HTH -- Regards, Ruksana Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: i...@vyomlabs.com || Web Site: www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com Sent: Thursday, August 23, 2012 9:57 PM To: arslist@ARSLIST.ORG Subject: security risk with attachment - Any ideas? HI all, I am hoping that someone else on the list had to face this growing security concern and found a way to do this. This is the concern that came back from a security audit: Attachment are not being scanned at the server level and the application can only rely on the fact that the user may or may not use a scanning system (anti-virus for example). This does not prevent user to willingly add a malicious file. The files should be scanned to stop SVG files to be uploaded at the server level. I know I can have an API that would run on the server and would look at the tickets created and if there is an attachment, to extract it and scan it etc. But any one has a better idea? Or knows of some utility that is already out there that could do this? Thank you, Pascale Kenavo ar wech all If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
WWRUG/ARSlist Awards 2012: Let the Voting Begin!
So, a big round of applause to this years nominees for the ARSlist MVP: Daniel Bloom - yes, I was nominated, I decline the nomination, but thank-you for the gesture Jose Huerto LJ Longwing Jason Miller Voting starts now and ends Friday Sept. 7th at 5pm EST There are over 4000 of you on the list, please lets see some support for those that spend their free time helping others! * Voting is by the Individual REAL person, so redistribution lists don't vote, your identity must be known, and those that have multiple subscriptions still get only one vote * BMCSoftware employees on the ARSlist are eligible to vote * All decisions of myself or the oversight panel are final (if I have to make a controversial decision, I confer with 3 past MVP winners for their opinion) Thursday October 18th at WWRUG12: Award Ceremony during the WWRUG Awards keynote. [no one knows the winner(s) until then, well okay, except me and the plaque company] Please send nominations to d...@wwrug.com Thanks . Daniel Daniel Bloom ARSlist Founder RAC/RSP since 1995 WWRUG Co-Founder Chairman of WWRUG12 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Using overlays in a non-ITSM system.
Hello Listers, MS SQL 2005 MS Windows Enterprise Server 2003 on a virtual machine ARS 7.6.03 Build 001 Though we are not using the ITSM suite here I was wondering if there is any benefits to using either the best practice setting in the Dev Studio or incorporating overlays to my own forms and any additions to BMC system forms ( User, Group, AR System email Messages etc.) I haven't had the chance to take any Developer classes utilizing Overlays, best practices, Panels, Data Visualization and just about anything new in the ARSystem for the last few years. Could it be useful to manage my own updates if I build a core base and then put the customer changes into an overlay or am I wrong about how the overlay is used? Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
SLM issue
Hi listers, need a small clarification, 7.5.00 Patch 006 SW00392339 have an issue here in Incident management. was going through some ticket to be more precise got an issue reported, a ticket was riased with goal time of 8 hrs and was assigned to 1st level with 24hrs clock SLA start when status = assigned ans stops when status= in progress(response) Now the 1st level assigned the ticket after the ticket has gone past goal time Now the ticket is with a new group and for this the business entiry is 9 hrs per day and as per calculation for this group the response shuld show sa Met. Both this SLA's are group as both runs for the same company, priorty and other conditions. Now my question is will the SLA status show as missed and will it change to Met when a new SLA is attached and is well within the time? i doudt it will carry the same status as missed but i do not have a concrete answer for giving the justication. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Using overlays in a non-ITSM system.
Hi, I have used overlays just like you describe. Do my changes in Best Practice Mode, and then propagate the changes to Base Mode when they are approved. Or just delete the oberlays/custom objects that did not get approved. The current main problem with this is that there is no way in Dev Studio to do this. I built RRR|DefBPCU to convert the exported def file instead... The other problem is that you can not work with Deployable Applications in Best Practice Mode... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hello Listers, MS SQL 2005 MS Windows Enterprise Server 2003 on a virtual machine ARS 7.6.03 Build 001 Though we are not using the ITSM suite here I was wondering if there is any benefits to using either the best practice setting in the Dev Studio or incorporating overlays to my own forms and any additions to BMC system forms ( User, Group, AR System email Messages etc.) I haven't had the chance to take any Developer classes utilizing Overlays, best practices, Panels, Data Visualization and just about anything new in the ARSystem for the last few years. Could it be useful to manage my own updates if I build a core base and then put the customer changes into an overlay or am I wrong about how the overlay is used? Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
JOB: Senior Remedy Developer needed - Brooklyn, NY
Looking for Senior Remedy Developer for a full time position with the City of New York, Department of Information Technology Telecommunications. Interested candidates, please send your resume to itrecr...@doitt.nyc.govwith the Subject line Application for Remedy Engineer, Job ID 101662 Below is the job description: *City of New York* *Department of Information Technology Telecommunications* * Job Posting Notice*** * * *Civil Service Title: *Computer Systems Manager * * *Level:*M1** * * *Title Code No: *10050 * * *Salary: *$49,492/$53,373 - $110,000* * * * *Office Title:*Remedy Engineer* * * * *Work location: *Brooklyn, NY* ** * * * *Division/Work Unit: *IT Services * * *Number of Positions: *1 * * *Job ID: *101662* * * * *Hours/Shift: *Day* *- Due to the necessary technical management duties of this position in a 24/7 operation, candidate may be required to be on call and/or work various shifts such as weekends and/or evenings.* * Job Description DoITT is responsible for modernizing, unlocking, and innovating to improve IT infrastructure and service delivery in New York City government. Modernizing by implementing state-of-the-art information technology to improve services to New Yorkers. Unlocking by making government more transparent and accountable to New Yorkers. Innovating by employing cutting-edge tools, methods, and relationships to empower New Yorkers. The successful candidate will serve as a Remedy Engineer reporting to the IT Services division. Responsibilities will include: Manage the development and configuration of the BMC Remedy ITSM 6.x, 7.x (Helpdesk, Change, Request, SLM, Asset) and assist with internal application integration and the migration of additional stakeholders; provide technical leadership and configuration of the BMC tool; develop and implement BMC Remedy ITSM 6.x, 7.x and BMC CMDB; oversee the workflow/process definition in ITIL areas; provide clients with assessment of IT operational maturity and identify targets for process/technology improvement; oversee the definition of technology requirements; prepare recommendations for the implementation of new processes and procedures; provide technical management assistance with system transitions; and manage special technology projects and initiatives as assigned. The position’s responsibilities include commitment to and compliance with the City’s EEO policy. Minimum Qualification Requirements 1. A master's degree in computer science from an accredited college and three years of progressively more responsible, full-time, satisfactory experience using information technology in computer applications programming, systems programming, computer systems development, data telecommunications, database administration, planning of data/information processing, user services, or area networks at least 18 months of this experience must have been in an administrative, managerial or executive capacity in the areas of computer applications programming, systems programming, computer systems development, data telecommunications, data base administration, or planning of data processing or in the supervision of staff performing these duties; or 2. A baccalaureate degree from an accredited college and four years of experience as described in 1 above; or 3. A four-year high school diploma or its educational equivalent approved by a State's department of education or recognized accrediting organization and six years of experience as described in 1 above; or 4. A satisfactory combination of education and experience equivalent to 1, 2 or 3 above. However, all candidates must have at least a four-year high school diploma or its educational equivalent approved by a State's department of education or recognized accrediting organization and must possess at least three years of experience as described in 1 above, including the 18 months of administrative, managerial, executive or supervisory experience as described in 1 above. *NOTE:* The following types of experience are not acceptable: superficial use of preprogrammed software without complex programming, design, implementation or management of the product; use of word processing packages; use of a hand held calculator; primarily the entering or updating of data in a system; the operation of data processing hardware or consoles. Preferred Skills The preferred candidate should have the following: 5+ years experience in BMC Remedy products, including product design, configuration and integration with 3rd party tools; experience with installation and configuration of AR Server group; detailed knowledge of AR System 6.x, 7.x and Remedy ITSM (Helpdesk, Change, Request, SLM, Asset); strong Remedy ITSM workflow and customization experience; proficiency with Remedy ITSM Application Configuration; proficiency with Remedy Mid-Tier 6.x, 7.x; good understanding of complete software life cycle; ability to demonstrate
Auto-Import a Text File
ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. ThanksKevin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!
Following my usual tradition of recording, copying and pasting a spelling error: It is Jose Huerta. My apologies. Dan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom Sent: August 27, 2012 9:14 AM To: arslist@ARSLIST.ORG Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** So, a big round of applause to this years nominees for the ARSlist MVP: Daniel Bloom - yes, I was nominated, I decline the nomination, but thank-you for the gesture Jose Huerto LJ Longwing Jason Miller Voting starts now and ends Friday Sept. 7th at 5pm EST There are over 4000 of you on the list, please lets see some support for those that spend their free time helping others! * Voting is by the Individual REAL person, so redistribution lists don't vote, your identity must be known, and those that have multiple subscriptions still get only one vote * BMCSoftware employees on the ARSlist are eligible to vote * All decisions of myself or the oversight panel are final (if I have to make a controversial decision, I confer with 3 past MVP winners for their opinion) Thursday October 18th at WWRUG12: Award Ceremony during the WWRUG Awards keynote. [no one knows the winner(s) until then, well okay, except me and the plaque company] Please send nominations to d...@wwrug.com Thanks . Daniel Daniel Bloom ARSlist Founder RAC/RSP since 1995 WWRUG Co-Founder Chairman of WWRUG12 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SLM issue
I don't know if i understood well your question, but if the objective is broken it will remain at this status (unless it is restarted, (the check box), in that case I'm not sure what will happen) What I do at these cases is to set one SVT per group. So each group has it's own time counter. It's the only way to see if one group broken the SLA, or both. Jose Manuel Huerta http://theremedyforit.com/ On Mon, Aug 27, 2012 at 3:57 PM, Rajesh Nair rajesh.nair@gmail.comwrote: Both this SLA's are gro ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SLM issue
That make sense., the problem is j am new to this org and i need to have astrong ponit to say that once the status of SLA says mssed, it will be the same even it is assigned to the group w Even if the goal time is not missed as calculated On Aug 27, 2012 7:27 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hi listers, need a small clarification, 7.5.00 Patch 006 SW00392339 have an issue here in Incident management. was going through some ticket to be more precise got an issue reported, a ticket was riased with goal time of 8 hrs and was assigned to 1st level with 24hrs clock SLA start when status = assigned ans stops when status= in progress(response) Now the 1st level assigned the ticket after the ticket has gone past goal time Now the ticket is with a new group and for this the business entiry is 9 hrs per day and as per calculation for this group the response shuld show sa Met. Both this SLA's are group as both runs for the same company, priorty and other conditions. Now my question is will the SLA status show as missed and will it change to Met when a new SLA is attached and is well within the time? i doudt it will carry the same status as missed but i do not have a concrete answer for giving the justication. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SLM issue
Jose Can you tell me more on unless it is restarted On Aug 27, 2012 10:27 PM, Jose Manuel Huerta Guillén arsl...@theremedyforit.com wrote: ** I don't know if i understood well your question, but if the objective is broken it will remain at this status (unless it is restarted, (the check box), in that case I'm not sure what will happen) What I do at these cases is to set one SVT per group. So each group has it's own time counter. It's the only way to see if one group broken the SLA, or both. Jose Manuel Huerta http://theremedyforit.com/ On Mon, Aug 27, 2012 at 3:57 PM, Rajesh Nair rajesh.nair@gmail.comwrote: Both this SLA's are gro _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Kevin, Data Import tool, to the best of my knowledge, does not support pipe delineationso you would need to use some sort of script to convert it to comma delimited. The entire process can be done relatively easily with Perl if you are familiar with it...I'm sure there is a module which will convert the data from one to another for you, and the rename/move/etc would be easy enough as well. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer Sent: Monday, August 27, 2012 10:19 AM To: arslist@ARSLIST.ORG Subject: Auto-Import a Text File ** ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. Thanks Kevin _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Tomcat 7.0.29
I just loaded this in a lab and we are in the process of moving into production. I haven't seen any issues yet. We are having issues getting the isap_redirect to work with IIS 7.5, so if anyone has insight that would be great. For Analytics we ended up running a seperate Tomcat 7.0.29 server and installed it under the Business Objects install directory. During the BOXI install it does ask for the Tomcat 5.5 path. We were able to put the 7.0.29 path and the install went through. When we setup BOXI on the same tomcat as mid-tier it was painfully slow. The difference was night and day with the seperate tomcats, so far no issues on that either. Brian On Thu, Aug 23, 2012 at 9:03 AM, SUBSCRIBE arslist S Fish sf...@attivasoft.com wrote: Has anyone used Tomcat 7.0.29 for their mid-tier in production yet? We have it in a LAB environment with Windows 2008 R2 64-Bit servers with SQL 2008, Java 1.6.0_26 64/32 bit, ARS Server, Atrium, and ITSM 7.6.04 SP2 and have not found any issues yet but there are only a couple of us on there. Just checking if anyone has gone with it in production. I heard one mention it has issues with Business Objects but we have not verified that yet. Also, has anyone security hardened Apache Tomcat 6.x or newer? http://tomcat.apache.org/tomcat-7.0-doc/security-howto.html http://www.mulesoft.com/tomcat-security http://blogs.mulesoft.org/is-your-tomcat-secure/ https://www.owasp.org/index.php/Securing_tomcat Above are some links I have found and will go through and test in our LAB environment but again if someone has performed and can provide some gotchas or lessons learned they would be greatly appreciated... :) TIA, Shane ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Meta-Update can use any delimiter and will log every invocation. Meta-Update can also move the files once imported. For more information, please feel free to contact me on +1 403 240 4377 (MDT / GMT -6) Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:Ben.Chernys_AT_softwaretoolhouse.com Ben.Chernys_AT_softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. 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/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer Sent: August-27-12 10:19 To: arslist@ARSLIST.ORG Subject: Auto-Import a Text File ** ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. Thanks Kevin _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image003.jpg smime.p7s Description: S/MIME cryptographic signature
Re: SLM issue
At the SVT definition, if set at advanced mode there is a check box that you can use: Reset goal: When some conditions are met, the current measure is closed and a new one starting from 0 is created. That means that a single request can create multiple SVT measures. The reset goal condition is defined at the data source. Using the reset goal condition you can measure if one group has taken more than 8 hours to go to In Progress state. But you won't know which group has been. To know it you need separate SVT for each case. Jose Manuel Huerta http://theremedyforit.com/ On Mon, Aug 27, 2012 at 8:02 PM, Rajesh Nair rajesh.nair@gmail.comwrote: Jose Can you tell me more on unless it is restarted ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: CMDB Fields for FTS indexing
Hi, Has anyone encountered the same kind of issue before with FTS enable on CMDB fields. Regards. RK On Sun, Aug 26, 2012 at 5:31 PM, rahul2007k...@gmail.com rahul2007k...@gmail.com wrote: Hi All, Please let me know if anyone has done FTS indexing on CMDB fields like CI ID, CI Name etc. I have currently enable FTS indexes on above fields on BMC.Core:Base_Element form but when ever i search newly created CI I am not able to search it until i re index whole FTS . I have seen that there are some FTS limitation for data re-indexing on join form and need to schedule the data scan for those join forms which causes very high CPU memory utilization. Also the Best practice development mode doesn't allow to modify the fields on join form and i need to switch base development to modify those forms its property which i think is not a good idea. I am not sure how to achieve this on CMDB forms as everything is based on join form structure and its very difficult to enable FTS on all the CMDB classes. Thanks, RK ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Ben, And others. You know who you are. If your contribution to a discussion is buy/use my product, please remember to mention AD in the Subject line. Thanks Dan Disclaimer: I am neither endorsing or being negative about the product with this comment From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: August 27, 2012 2:47 PM To: arslist@ARSLIST.ORG Subject: [SPAM]Re: Auto-Import a Text File ** Meta-Update can use any delimiter and will log every invocation. Meta-Update can also move the files once imported. For more information, please feel free to contact me on +1 403 240 4377 (MDT / GMT -6) Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. 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/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer Sent: August-27-12 10:19 To: arslist@ARSLIST.ORG Subject: Auto-Import a Text File ** ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. Thanks Kevin _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image001.jpg
Re: CMDB Fields for FTS indexing
Not directly on topic, but we've basically put a moratorium on any additional indexing of fields by the FTS engine as it seems to have more than enough trouble handling the load from the base application functionalities with 7.6.04. Careful how much you ask it to index, I know we're not alone as I've seen a number of posts from others having to monkey with the FTS configuration to get this beast to simply do the jobs BMC has asked it to do in the 7.6.04 ITSM apps. We've got all FTS plugins now running on one server per BMC direction and still have hiccups from time to time with it getting choked up. Nate. Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of rahul2007k...@gmail.com Sent: Monday, August 27, 2012 1:55 PM To: arslist@ARSLIST.ORG Subject: Re: CMDB Fields for FTS indexing ** Hi, Has anyone encountered the same kind of issue before with FTS enable on CMDB fields. Regards. RK On Sun, Aug 26, 2012 at 5:31 PM, rahul2007k...@gmail.commailto:rahul2007k...@gmail.com rahul2007k...@gmail.commailto:rahul2007k...@gmail.com wrote: Hi All, Please let me know if anyone has done FTS indexing on CMDB fields like CI ID, CI Name etc. I have currently enable FTS indexes on above fields on BMC.Core:Base_Element form but when ever i search newly created CI I am not able to search it until i re index whole FTS . I have seen that there are some FTS limitation for data re-indexing on join form and need to schedule the data scan for those join forms which causes very high CPU memory utilization. Also the Best practice development mode doesn't allow to modify the fields on join form and i need to switch base development to modify those forms its property which i think is not a good idea. I am not sure how to achieve this on CMDB forms as everything is based on join form structure and its very difficult to enable FTS on all the CMDB classes. Thanks, RK _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Hi, The ARImport .ARM file format support any delimiter. It might be difficult to build a robust 30-minute import using arimportcmd though. You might consider building an API-program to do this, including error handling. C, Java, ARSperl, .Net come to mind. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. ThanksKevin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
We planned an integration using a similar communication link, a file placed at a FTP account. The idea was to integrate with a CMMS. The solution we provided was to create a java script that fired when creating a file at a forlder, read it and sent it using a web service. The java analyst said one day for developing and testing, so I assume it was easy. Fortunately, the IT office declined this integration method and required the CMMS developers to create a web service interface. I think that it would be easier to develop an external agent that uses the API, or if you don't have any API expert, using a web service would be easier. Regards, Jose Manuel Huerta http://theremedyforit.com/ On Mon, Aug 27, 2012 at 9:59 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, The ARImport .ARM file format support any delimiter. It might be difficult to build a robust 30-minute import using arimportcmd though. You might consider building an API-program to do this, including error handling. C, Java, ARSperl, .Net come to mind. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. ThanksKevin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Updating the SVT requests
Hi listers, I need to create a report on daily basis using BOXI. This report reads the SLM:Measurement form and HPD:Help Desk, looking for all measures for open incidents. This report will be generated automatically by night and the PDF sent to a Sharepoint site. Thus, the manager can see at the morning a summary of its service. But I noticed that the SLM:Measurement request do not update so frequently as expected. In fact I have an incident that is not updated for a week, and the SLM:Measurement is also one week old. Do you know how to force to recompute an SLM:Measurement. Thus I could run an escalation two hours before generating the report, recomputing all opened measurements. Regards, Jose Manuel Huerta http://theremedyforit.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Jose I have done something similar. Drop me a line offline and I will give you the details. Shafqat Ayaz From: Jose Manuel Huerta Guillén arsl...@theremedyforit.com To: arslist@ARSLIST.ORG Sent: Monday, August 27, 2012 9:38 PM Subject: Re: Auto-Import a Text File ** We planned an integration using a similar communication link, a file placed at a FTP account. The idea was to integrate with a CMMS. The solution we provided was to create a java script that fired when creating a file at a forlder, read it and sent it using a web service. The java analyst said one day for developing and testing, so I assume it was easy. Fortunately, the IT office declined this integration method and required the CMMS developers to create a web service interface. I think that it would be easier to develop an external agent that uses the API, or if you don't have any API expert, using a web service would be easier. Regards, Jose Manuel Huerta http://theremedyforit.com/ On Mon, Aug 27, 2012 at 9:59 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, The ARImport .ARM file format support any delimiter. It might be difficult to build a robust 30-minute import using arimportcmd though. You might consider building an API-program to do this, including error handling. C, Java, ARSperl, .Net come to mind. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. ThanksKevin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Auto-Import a Text File
Sorry sent the email to the wrong guy! Kevin contact me offline and I will tell you the way I did something similar. Shafqat Ayaz From: Kevin Shaffer kevin_l_shaf...@hotmail.com To: arslist@ARSLIST.ORG Sent: Monday, August 27, 2012 5:18 PM Subject: Auto-Import a Text File ** ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on a network share drive every 30 minutes. The requirement is for me to import these files into a custom form in Remedy. The customer is set on using pipe delimited text files and is not interested in switching over to webservices or pushing the text file into a DB table and then create a View form. The integration must be using pipe delimited text files. Every 30 minutes, one or more files is dropped into a folder, i.e. file A and file B dropped at 12:30; at 1:00 PM file c is dropped in the folder. I must grab the files at 12:30 and import them into a custom form. After they have imported into the custom form, I need to rename the file or move it to another directory so they dont import twice. I then repeat the process at 1:00 PM. Can this be done using ARImport from an escalation or AIE or some other method other than webservices or a View form? Any suggestions would be appreciated. Thanks Kevin _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Using overlays in a non-ITSM system.
The only place it would be useful is when maintaining modifications done to any of the OTB workflow if any such as the core forms and workflow.. Else it won't quite gain you much, at least not in the current versions. There was talk about future versions of overlays that would change in its design, which may benefit an all custom shop, but in its current version, there is no benefit I can think of, since you are the master of it all and are free to add or delete from what you currently have with little or no impact, if done the right way.. Joe -Original Message- From: Reiser, John J Sent: Monday, August 27, 2012 9:35 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Using overlays in a non-ITSM system. Hello Listers, MS SQL 2005 MS Windows Enterprise Server 2003 on a virtual machine ARS 7.6.03 Build 001 Though we are not using the ITSM suite here I was wondering if there is any benefits to using either the best practice setting in the Dev Studio or incorporating overlays to my own forms and any additions to BMC system forms ( User, Group, AR System email Messages etc.) I haven't had the chance to take any Developer classes utilizing Overlays, best practices, Panels, Data Visualization and just about anything new in the ARSystem for the last few years. Could it be useful to manage my own updates if I build a core base and then put the customer changes into an overlay or am I wrong about how the overlay is used? Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy form object and Oracle table relationships
Hi Susan, I agree that what Misi describes is the best way to go about it. Admittedly I have never had to resolve this issue but it is consistent with the other Remedy data translation/transition scenarios. A while back I was talking to a Remedy admin who's DBA told him the DB was Unicode when it wasn't. He installed ARS as Unicode and some time later issues began to arise. BMC's recommendation was to build a new system with matching character sets and to export the data out of the broken system and import into the new system using the AR API (import tool, etc.). Jason On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Susan, Why not remove all complex manual thinking, guessing and planning? 1. Do a fresh install 2. Export your def and import it the new system 3. Copy your data using RRR|Chive 4. Stop your users from accessing the servers, stop escalations, email etc 5. Do a final delta-transfer using RRR|Chive (~1 hour) 6. Switch your users to the new server You might get data that does not fit into the new syst, if you have a lot of 128+ ascii codes in your current data. But step 4 above can be run multiple times, until you have corrected all errors. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi everyone, It seems my life is complicated this week. Again I need to draw on your experiences and I'm looking for your opinions and cautionary statements. Background: We use an outsourcer company to do the bulk of our database work. When we built new servers last year and they build the new oracle 10g databases we didn't notice that they were not Unicode. Apparently the previous ones were, but in actuality we didn't really have a need for it. About 5 years ago we opened a China office requiring all staff to be English proficient so everything was still ok. But now we're finding that customer information which arrives in simplified Chinese, which they translate into English, which then needs to be re-translated back to Chinese to meet government requirements for billing is not as straight forward as it may sound. So they were trying to type more Chinese in and of course since the new server databases were not Unicode it didn't work like it did before. Then to add to the pain, no one said anything. So here we are a year later and now it's a big deal. So, we are endeavoring to change to Unicode. Our approach is to create a new server space, create a new Unicode database, and get the data in there converted, and then install the application again. No upgrades of db or application involved, only the Unicode aspect of it. Well, that sounds so much easier than it's turning out to be. Our dba has run CSSCAN various times and finally came up with a list of forms/fields that have potential problems with the conversion. The current field length is being totally used so in the conversion to Unicode it needs more field length. The dba is suggesting that he just expand the database field lengths with no need to touch the form objects. This sets off all sort of red flags for me. I never let anyone go directly to the database for data updates. Other applications we use can read data but if they need to write there they use the Remedy API. There can be no manipulation of the tables in the database, it must all be done via developer tool. What else is troubling is that in the list of tables/fields that have a problem some tables/fields that should be listed because that's where the data originated and was pushed down from are not listed. Many of the records in question are older and if some data gets 'cut off' or what I used to think truncated meant we can live with that. We're talking several thousand records in 15-25 tables. The dba is proposing the following: I will export the table metadata and data of the tables, listed in the spreadsheet with NLS_LANG set to AMERICAN_AMERICA.WE8ISO8895P1. I will then truncate the tables and drop the tables. The CSALTER program will then be ran against the database. I will then import the table metadata and data, using NLS_LANG set to AMERICAN_AMERICAN.AL32UTF8 This will cause the internal expansion of the column from bytes to chars and some of the tables will fail to import because some of the characters may take up to 3 bytes instead of 1. You said there would be a problem with the forms and I know what you are saying. But if just the lengths of some of the columns change, will that invalidate the forms? So if a column is defined VARCHAR2(50) in the database and the
OT: WWRUG/ARSlist Awards 2012: Let the Voting Begin!
Congratulations Jose Huerta, LJ Longwing and Jason Miller on your nominations and Dan off course although you choose to decline the nomination :-) Joe From: arslist Sent: Monday, August 27, 2012 12:54 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** Following my usual tradition of recording, copying and pasting a spelling error: It is Jose Huerta. My apologies. Dan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom Sent: August 27, 2012 9:14 AM To: arslist@ARSLIST.ORG Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** So, a big round of applause to this years nominees for the ARSlist MVP: Daniel Bloom – yes, I was nominated, I decline the nomination, but thank-you for the gesture Jose Huerto LJ Longwing Jason Miller Voting starts now and ends Friday Sept. 7th at 5pm EST There are over 4000 of you on the list, please lets see some support for those that spend their free time helping others! * Voting is by the Individual REAL person, so redistribution lists don't vote, your identity must be known, and those that have multiple subscriptions still get only one vote * BMCSoftware employees on the ARSlist are eligible to vote * All decisions of myself or the oversight panel are final (if I have to make a controversial decision, I confer with 3 past MVP winners for their opinion) Thursday October 18th at WWRUG12: Award Ceremony during the WWRUG Awards keynote. [no one knows the winner(s) until then, well okay, except me and the plaque company] Please send nominations to d...@wwrug.com Thanks … Daniel Daniel Bloom ARSlist Founder RAC/RSP since 1995 WWRUG Co-Founder Chairman of WWRUG12 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy form object and Oracle table relationships
Jason/Misi, Thanks for your interest. I already knew the answer but was hoping for some 'miracle'. We just basically did the full build new dbs/servers last year when we couldn't make our 7.01 to 7.5 upgrade work. It should be noted that when using oracle you don't actually choose unicode in Remedy, it installs based on how oracle is installed. Wish I had paid more attention to that fact last year. Regarding the import of tables/objects, that was not a pleasant experience. It changes all the table ID's which caused problems in other applications using Remedy. Of course now we have a list of those, guess they can be modified again. Hopefully they took my advice to use table names not ID's. We have a freeze beginning in November during our customer's busy season so we've basically run out of time this year. We'll tackle it next year and since it's a total new install may consider ARS v8.0 right away, and oracle 11g. I was looking at the compatibility chart regarding linux but that seems a little confusing about using that and I haven't checked further. We'd really like to move away from the oracle costs. We're also moving to a new location in April so I'm think we'll be postponed until June/July which may work well with v8. Gives the early adopters time to work out the kinks! Thanks again for your input ... Susan See you at RUG! On Mon, Aug 27, 2012 at 7:18 PM, Jason Miller jason.mil...@gmail.comwrote: ** Hi Susan, I agree that what Misi describes is the best way to go about it. Admittedly I have never had to resolve this issue but it is consistent with the other Remedy data translation/transition scenarios. A while back I was talking to a Remedy admin who's DBA told him the DB was Unicode when it wasn't. He installed ARS as Unicode and some time later issues began to arise. BMC's recommendation was to build a new system with matching character sets and to export the data out of the broken system and import into the new system using the AR API (import tool, etc.). Jason On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Susan, Why not remove all complex manual thinking, guessing and planning? 1. Do a fresh install 2. Export your def and import it the new system 3. Copy your data using RRR|Chive 4. Stop your users from accessing the servers, stop escalations, email etc 5. Do a final delta-transfer using RRR|Chive (~1 hour) 6. Switch your users to the new server You might get data that does not fit into the new syst, if you have a lot of 128+ ascii codes in your current data. But step 4 above can be run multiple times, until you have corrected all errors. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi everyone, It seems my life is complicated this week. Again I need to draw on your experiences and I'm looking for your opinions and cautionary statements. Background: We use an outsourcer company to do the bulk of our database work. When we built new servers last year and they build the new oracle 10g databases we didn't notice that they were not Unicode. Apparently the previous ones were, but in actuality we didn't really have a need for it. About 5 years ago we opened a China office requiring all staff to be English proficient so everything was still ok. But now we're finding that customer information which arrives in simplified Chinese, which they translate into English, which then needs to be re-translated back to Chinese to meet government requirements for billing is not as straight forward as it may sound. So they were trying to type more Chinese in and of course since the new server databases were not Unicode it didn't work like it did before. Then to add to the pain, no one said anything. So here we are a year later and now it's a big deal. So, we are endeavoring to change to Unicode. Our approach is to create a new server space, create a new Unicode database, and get the data in there converted, and then install the application again. No upgrades of db or application involved, only the Unicode aspect of it. Well, that sounds so much easier than it's turning out to be. Our dba has run CSSCAN various times and finally came up with a list of forms/fields that have potential problems with the conversion. The current field length is being totally used so in the conversion to Unicode it needs more field length. The dba is suggesting that he just expand the database field lengths with no need to touch the form objects. This sets off all sort of red flags for me. I never let anyone go directly to the database for data updates.
Re: Remedy form object and Oracle table relationships
Fresh install is always best. I have brought the system over from a copy and it is really amazing that BMC embeds and has so many individual configuration files (I would think progress would bring them to 1 main configuration file) rather than some 35 file system locations / if I include java locations and host names and ip's some 45 or so locations plus several locations in the schemas it is really nutty ! Sent from my iPhone On Aug 27, 2012, at 20:18, Jason Miller jason.mil...@gmail.com wrote: ** Hi Susan, I agree that what Misi describes is the best way to go about it. Admittedly I have never had to resolve this issue but it is consistent with the other Remedy data translation/transition scenarios. A while back I was talking to a Remedy admin who's DBA told him the DB was Unicode when it wasn't. He installed ARS as Unicode and some time later issues began to arise. BMC's recommendation was to build a new system with matching character sets and to export the data out of the broken system and import into the new system using the AR API (import tool, etc.). Jason On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Susan, Why not remove all complex manual thinking, guessing and planning? 1. Do a fresh install 2. Export your def and import it the new system 3. Copy your data using RRR|Chive 4. Stop your users from accessing the servers, stop escalations, email etc 5. Do a final delta-transfer using RRR|Chive (~1 hour) 6. Switch your users to the new server You might get data that does not fit into the new syst, if you have a lot of 128+ ascii codes in your current data. But step 4 above can be run multiple times, until you have corrected all errors. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi everyone, It seems my life is complicated this week. Again I need to draw on your experiences and I'm looking for your opinions and cautionary statements. Background: We use an outsourcer company to do the bulk of our database work. When we built new servers last year and they build the new oracle 10g databases we didn't notice that they were not Unicode. Apparently the previous ones were, but in actuality we didn't really have a need for it. About 5 years ago we opened a China office requiring all staff to be English proficient so everything was still ok. But now we're finding that customer information which arrives in simplified Chinese, which they translate into English, which then needs to be re-translated back to Chinese to meet government requirements for billing is not as straight forward as it may sound. So they were trying to type more Chinese in and of course since the new server databases were not Unicode it didn't work like it did before. Then to add to the pain, no one said anything. So here we are a year later and now it's a big deal. So, we are endeavoring to change to Unicode. Our approach is to create a new server space, create a new Unicode database, and get the data in there converted, and then install the application again. No upgrades of db or application involved, only the Unicode aspect of it. Well, that sounds so much easier than it's turning out to be. Our dba has run CSSCAN various times and finally came up with a list of forms/fields that have potential problems with the conversion. The current field length is being totally used so in the conversion to Unicode it needs more field length. The dba is suggesting that he just expand the database field lengths with no need to touch the form objects. This sets off all sort of red flags for me. I never let anyone go directly to the database for data updates. Other applications we use can read data but if they need to write there they use the Remedy API. There can be no manipulation of the tables in the database, it must all be done via developer tool. What else is troubling is that in the list of tables/fields that have a problem some tables/fields that should be listed because that's where the data originated and was pushed down from are not listed. Many of the records in question are older and if some data gets 'cut off' or what I used to think truncated meant we can live with that. We're talking several thousand records in 15-25 tables. The dba is proposing the following: I will export the table metadata and data of the tables, listed in the spreadsheet with NLS_LANG set to AMERICAN_AMERICA.WE8ISO8895P1. I will then truncate the tables and drop the tables. The CSALTER program will then be ran against the database. I will
Re: WWRUG/ARSlist Awards 2012: Let the Voting Begin!
Congrats to all nominees Jose Huerta, LJ Longwing, and Jason Miller. Regards, Venkat Maddala http://RemediesForRemedy.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, August 27, 2012 8:35 PM To: arslist@ARSLIST.ORG Subject: OT: WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** Congratulations Jose Huerta, LJ Longwing and Jason Miller on your nominations and Dan off course although you choose to decline the nomination :-) Joe From: arslistmailto:arsl...@danielbloom.ca Sent: Monday, August 27, 2012 12:54 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** Following my usual tradition of recording, copying and pasting a spelling error: It is Jose Huerta. My apologies. Dan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom Sent: August 27, 2012 9:14 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin! ** So, a big round of applause to this years nominees for the ARSlist MVP: Daniel Bloom – yes, I was nominated, I decline the nomination, but thank-you for the gesture Jose Huerto LJ Longwing Jason Miller Voting starts now and ends Friday Sept. 7th at 5pm EST There are over 4000 of you on the list, please lets see some support for those that spend their free time helping others! * Voting is by the Individual REAL person, so redistribution lists don't vote, your identity must be known, and those that have multiple subscriptions still get only one vote * BMCSoftware employees on the ARSlist are eligible to vote * All decisions of myself or the oversight panel are final (if I have to make a controversial decision, I confer with 3 past MVP winners for their opinion) Thursday October 18th at WWRUG12: Award Ceremony during the WWRUG Awards keynote. [no one knows the winner(s) until then, well okay, except me and the plaque company] Please send nominations to d...@wwrug.commailto:d...@wwrug.com Thanks … Daniel Daniel Bloom ARSlist Founder RAC/RSP since 1995 WWRUG Co-Founder Chairman of WWRUG12 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy form object and Oracle table relationships
We will gladly adopt early for you :) On Mon, Aug 27, 2012 at 6:01 PM, Susan Palmer suzanpal...@gmail.com wrote: ** Jason/Misi, Thanks for your interest. I already knew the answer but was hoping for some 'miracle'. We just basically did the full build new dbs/servers last year when we couldn't make our 7.01 to 7.5 upgrade work. It should be noted that when using oracle you don't actually choose unicode in Remedy, it installs based on how oracle is installed. Wish I had paid more attention to that fact last year. Regarding the import of tables/objects, that was not a pleasant experience. It changes all the table ID's which caused problems in other applications using Remedy. Of course now we have a list of those, guess they can be modified again. Hopefully they took my advice to use table names not ID's. We have a freeze beginning in November during our customer's busy season so we've basically run out of time this year. We'll tackle it next year and since it's a total new install may consider ARS v8.0 right away, and oracle 11g. I was looking at the compatibility chart regarding linux but that seems a little confusing about using that and I haven't checked further. We'd really like to move away from the oracle costs. We're also moving to a new location in April so I'm think we'll be postponed until June/July which may work well with v8. Gives the early adopters time to work out the kinks! Thanks again for your input ... Susan See you at RUG! On Mon, Aug 27, 2012 at 7:18 PM, Jason Miller jason.mil...@gmail.comwrote: ** Hi Susan, I agree that what Misi describes is the best way to go about it. Admittedly I have never had to resolve this issue but it is consistent with the other Remedy data translation/transition scenarios. A while back I was talking to a Remedy admin who's DBA told him the DB was Unicode when it wasn't. He installed ARS as Unicode and some time later issues began to arise. BMC's recommendation was to build a new system with matching character sets and to export the data out of the broken system and import into the new system using the AR API (import tool, etc.). Jason On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Susan, Why not remove all complex manual thinking, guessing and planning? 1. Do a fresh install 2. Export your def and import it the new system 3. Copy your data using RRR|Chive 4. Stop your users from accessing the servers, stop escalations, email etc 5. Do a final delta-transfer using RRR|Chive (~1 hour) 6. Switch your users to the new server You might get data that does not fit into the new syst, if you have a lot of 128+ ascii codes in your current data. But step 4 above can be run multiple times, until you have corrected all errors. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se . Hi everyone, It seems my life is complicated this week. Again I need to draw on your experiences and I'm looking for your opinions and cautionary statements. Background: We use an outsourcer company to do the bulk of our database work. When we built new servers last year and they build the new oracle 10g databases we didn't notice that they were not Unicode. Apparently the previous ones were, but in actuality we didn't really have a need for it. About 5 years ago we opened a China office requiring all staff to be English proficient so everything was still ok. But now we're finding that customer information which arrives in simplified Chinese, which they translate into English, which then needs to be re-translated back to Chinese to meet government requirements for billing is not as straight forward as it may sound. So they were trying to type more Chinese in and of course since the new server databases were not Unicode it didn't work like it did before. Then to add to the pain, no one said anything. So here we are a year later and now it's a big deal. So, we are endeavoring to change to Unicode. Our approach is to create a new server space, create a new Unicode database, and get the data in there converted, and then install the application again. No upgrades of db or application involved, only the Unicode aspect of it. Well, that sounds so much easier than it's turning out to be. Our dba has run CSSCAN various times and finally came up with a list of forms/fields that have potential problems with the conversion. The current field length is being totally used so in the conversion to Unicode it needs more field length. The dba is suggesting that he just expand the database field lengths with