parsing from csv
Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are inline: image001.jpg
Re: parsing from csv
Hi, The best way would seem to be the BMC Remedy Import Tool. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: parsing from csv
Hi Rezaul, You can use PERFORM-ACTION-SAVE-ATTACHMENT, save it into a directory from where you can write and read it, then you can try running Atrium integration Engine command 'aiexfer' or AR Import command utility 'arimportcmd' command in a Run Process. Check on how to use either of these commands in their documentation , try both options and check which one suits you performance wise. Cheers, Naveen Haque, Rezaul R wrote: Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 [cid:image001.jpg@01CB18BD.825671E0] E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are - With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/parsing-from-csv-tp29042412p29042581.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
survey related issue
Hi Friends , Where are the survey responses are stored once the survey was responded. RAVI CHANDRA . RAMAGIRI __ Information from ESET NOD32 Antivirus, version of virus signature database 5241 (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: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines
Hi Conny, Will this hack also work on a MS SQL 2005 DB ? We are planning a similar Unicode conversion from ARS 7.0.1 to ARS 7.5 Could you share the additional information to me as well ? Thank you for your help. Regards, Fons ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
AW: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines
Fons, sorry, but my hack has been proved to work on unix. I've never done this on a windows box with MSSQL. The installer for unix-systems is a simple shell script where one can see what's going on behind the scenes. The installer for windows is more like a black box. Furthermore the database migration from nonUnicode to Unicode is a bit more complicated on MSSQL, because you have to alter all the (var)char and text columns to their respective n-types. Sorry Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Fons Bruins Gesendet: Donnerstag, 1. Juli 2010 16:05 An: arslist@ARSLIST.ORG Betreff: Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines Hi Conny, Will this hack also work on a MS SQL 2005 DB ? We are planning a similar Unicode conversion from ARS 7.0.1 to ARS 7.5 Could you share the additional information to me as well ? Thank you for your help. Regards, Fons ___ 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
JOB: Vacancies for Intermediate and Senior Developers at Research In Motion
All, We have various vacancies currently availble for for Intermediate and Senior Developers at Research In Motion. If you are interested in any of our opportunities then please visit: http://www.rim.com/careers - the individual vacancies are listed below: 0906851 - Remedy Systems Developer - Atrium Technologies - CMDB 0906853 - Remedy Systems Developer - Atrium Technologies - CMDB 1003269 - Datasource Developer - Atrium Technologies - Analytics Reporting 0906266 - Remedy Systems Developer - Senior Role 1003223 - Remedy Systems Developer - Senior Role Please apply through http://www.rim.com/careers I'm unable to accept resume's or applications directly. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Webservice error trapping
Hello Listers, ARS 7.1 Midter 7.1 MS SQL Server 2005 MS Windows 2003 enterprise I have made a web service with Get and GetList for a form. I sent the WSDL to the group that wants to query the form. When they search for a value that returns no records it responds with: ?xml version=1.0 encoding=UTF-8? soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Header wsse:Security xmlns:wsse=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd; xmlns:wsu=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd; soapenv:mustUnderstand=1/ /soapenv:Header soapenv:Body soapenv:Fault faultcodesoapenv:Server.userException/faultcode faultstringERROR (302): Entry does not exist in database; /faultstring detail ns1:hostname xmlns:ns1=http://xml.apache.org/axis/;(redacted)/ns1:hostname /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope In the web page it shows as an error message Error retrieving tickets. I think they are using something called iView in a portal web site and displaying the ticket information in a few tables. They have asked me to handle this on the Remedy end and provide a No results. I think that since Error 302 is what the ARSystem generates for API/Webservice calls there isn't much that I can do. Shouldn't they be able to trap this error and display whatever text they want? Or is there something I can add to the WSDL to respond with 0 Records when a query comes up empty? Something in the mapping perhaps? As you can tell I don't speak XML. Thanks in advance for any guidance. --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer 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 wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Mailbox configuration
Hi, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Mailbox configuration
Restart the EMAIL service From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raja V Sent: Thursday, July 01, 2010 9:41 AM To: arslist@ARSLIST.ORG Subject: Mailbox configuration ** Hi, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Mailbox configuration
You need to restart the email engine for this to take effect. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raja V Sent: Thursday, July 01, 2010 6:41 AM To: arslist@ARSLIST.ORG Subject: Mailbox configuration ** Hi, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Mailbox configuration
Hi Listers, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Mailbox configuration
Is your e-mail engine running on a windows server? If so, you would just stop the AR System Email service. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raja V Sent: Thursday, July 01, 2010 9:41 AM To: arslist@ARSLIST.ORG Subject: Mailbox configuration Hi, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Webservice error trapping
John, Because of the limited functionality that Remedy has regarding web services I do not believe there is a way to 'handle it' on the Remedy side. We have a similar integration in which the group consuming my web service captures the error messages and displays something different to the end users. They do keep a log of the actual error for troubleshooting purposes. Good luck with this. Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 http://saintake.t-mobile.com/interfaces/default.aspx From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Thursday, July 01, 2010 8:37 AM To: arslist@ARSLIST.ORG Subject: Webservice error trapping ** Hello Listers, ARS 7.1 Midter 7.1 MS SQL Server 2005 MS Windows 2003 enterprise I have made a web service with Get and GetList for a form. I sent the WSDL to the group that wants to query the form. When they search for a value that returns no records it responds with: ?xml version=1.0 encoding=UTF-8? soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Header wsse:Security xmlns:wsse=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd; xmlns:wsu=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd; soapenv:mustUnderstand=1/ /soapenv:Header soapenv:Body soapenv:Fault faultcodesoapenv:Server.userException/faultcode faultstringERROR (302): Entry does not exist in database; /faultstring detail ns1:hostname xmlns:ns1=http://xml.apache.org/axis/;(redacted)/ns1:hostname /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope In the web page it shows as an error message Error retrieving tickets. I think they are using something called iView in a portal web site and displaying the ticket information in a few tables. They have asked me to handle this on the Remedy end and provide a No results. I think that since Error 302 is what the ARSystem generates for API/Webservice calls there isn't much that I can do. Shouldn't they be able to trap this error and display whatever text they want? Or is there something I can add to the WSDL to respond with 0 Records when a query comes up empty? Something in the mapping perhaps? As you can tell I don't speak XML. Thanks in advance for any guidance. --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer 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 _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: Mailbox configuration
Hi Listers, Thanks for your responses. Thanks Regards, Raja V From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Thursday, July 01, 2010 7:26 PM To: arslist@ARSLIST.ORG Subject: Re: Mailbox configuration ** Is your e-mail engine running on a windows server? If so, you would just stop the AR System Email service. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raja V Sent: Thursday, July 01, 2010 9:41 AM To: arslist@ARSLIST.ORG Subject: Mailbox configuration Hi, I have disabled the outgoing mails in the AR System Email Mailbox Configuration form in Remedy 7.5 server. But still the Emails are getting flowed. I want to stop the flow of Emails, any suggestions on this? Do I have to restart the server after changing the settings? Thanks Regards, Raja V Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Webservice error trapping
Roger, I read in the documentation that for Outgoing XML elements . . . If the number of entries in the base form is less than the minOccurs, AR System returns an error. My SWAG on this is if I set the getListValues minOccurs = 0 then a query that returns no records is not less than 0 and should not throw the Error 302. Once I get a chance to try it out I'll pass it on. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer 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 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Thursday, July 01, 2010 10:11 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Webservice error trapping ** John, Because of the limited functionality that Remedy has regarding web services I do not believe there is a way to 'handle it' on the Remedy side. We have a similar integration in which the group consuming my web service captures the error messages and displays something different to the end users. They do keep a log of the actual error for troubleshooting purposes. Good luck with this. Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 http://saintake.t-mobile.com/interfaces/default.aspx From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Thursday, July 01, 2010 8:37 AM To: arslist@ARSLIST.ORG Subject: Webservice error trapping ** Hello Listers, ARS 7.1 Midter 7.1 MS SQL Server 2005 MS Windows 2003 enterprise I have made a web service with Get and GetList for a form. I sent the WSDL to the group that wants to query the form. When they search for a value that returns no records it responds with: ?xml version=1.0 encoding=UTF-8? soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Header wsse:Security xmlns:wsse=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd; xmlns:wsu=http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd; soapenv:mustUnderstand=1/ /soapenv:Header soapenv:Body soapenv:Fault faultcodesoapenv:Server.userException/faultcode faultstringERROR (302): Entry does not exist in database; /faultstring detail ns1:hostname xmlns:ns1=http://xml.apache.org/axis/;(redacted)/ns1:hostname /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope In the web page it shows as an error message Error retrieving tickets. I think they are using something called iView in a portal web site and displaying the ticket information in a few tables. They have asked me to handle this on the Remedy end and provide a No results. I think that since Error 302 is what the ARSystem generates for API/Webservice calls there isn't much that I can do. Shouldn't they be able to trap this error and display whatever text they want? Or is there something I can add to the WSDL to respond with 0 Records when a query comes up empty? Something in the mapping perhaps? As you can tell I don't speak XML. Thanks in advance for any guidance. --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer 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 _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
Escalation or Filter
Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Escalation or Filter
I believe both would perform equally. However, taking into consideration that escalations should be used at a minimum, I would prefer the first option, i.e; set fields with escalation and push fields with filter. Also,this would help when the escalation queue is longer. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Thu, Jul 1, 2010 at 9:45 PM, Brittain, Mark mbritt...@navisite.comwrote: ** Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer *NaviSite **mbritt...@navisite.com* mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) * * This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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: Escalation or Filter
Hi Mark
There should be no difference. I would prefer to use the escalation to
trigger a filter to do the push, as that allows you to insert validation
workflow etc. if needed. However, in both cases all the activity takes
place on the escalation thread, so you cannot 'offload' activity to other
threads to improve performance.
HTH
David Sanders
Solution Architect
Enterprise Service Suite @ Work
==
tel +44 1494 468980
mobile +44 7710 377761
email david.sand...@westoverconsulting.co.uk
web http://www.westoverconsulting.co.uk
http://www.westoverconsulting.co.uk/
_
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark
Sent: Thursday, July 01, 2010 5:15 PM
To: arslist@ARSLIST.ORG
Subject: Escalation or Filter
Hi All
From a performance perspective which would be better?
Escalation on Form A set field and push fields to create a new record on
Form B
Escalation on Form A set field. Filter on Form A does the push fields to
create a new record on Form B.
ARS 6.3 patch 20
Oracle 9.2
SunOS 5.9
Thanks
Mark
Mark Brittain
Remedy Developer
NaviSite
mbritt...@navisite.com
(315) 453-2912 x5335 (Phone)
(315) 317.2897 (Cell)
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.
_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
A couple of questions that will determine the complexity of the process: Do you have any localized data currently in the database? Particularly CJK data or any other type of multi-byte or localized data? Have clients connected to your remedy server using a localized version of windows and entered/pasted or otherwise inserted localized data into your db? Have you used any non 7-bit ASCII characters in any of your form or workflow definitions (copied any data from word into the notes or change history of any workflow definitions)? What version of ARServer was initially installed when the system was built? What versions of the Remedy User Tool do/have people used (earliest version)? All of the non-Unicode to Unicode upgrades I've done have been from a 6.x o 7.x Remedy server (6.0.1 to 7.0.1 and 6.3 to 7.5), so I can't speak as to how one should upgrade with the versions you are working with. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Tue, Jun 29, 2010 at 6:35 PM, Antonio Monizza antomoni...@gmail.comwrote: ** 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Escalation or Filter
I prefer to use the Escalation sets field and a Filter does the work method. The only real advantage of using this method is that you can test it from the user tool and log the actions locally (instead of having to read server side logs). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, July 01, 2010 11:15 AM To: arslist@ARSLIST.ORG Subject: Escalation or Filter ** Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Escalation or Filter
Yup, Escalation to start the Event, Filter to Perform the Action... On Jul 1, 1:01 pm, Grooms, Frederick W frederick.w.gro...@xo.com wrote: I prefer to use the Escalation sets field and a Filter does the work method. The only real advantage of using this method is that you can test it from the user tool and log the actions locally (instead of having to read server side logs). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, July 01, 2010 11:15 AM To: arsl...@arslist.org Subject: Escalation or Filter ** Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Determining Current Work Week
Hello Listers, I'm a little stumped in trying to determine the best way to go check whether a date/time field falls within the current work week. I thought there would be a week function that return the week number of the calendar year, and I could compare that result with the current date to the specified date. There appears to be no such function. What other options do I have aside from writing and calling a SQL function to check? Thanks, Jon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Pooling for Escalations
Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Determining Current Work Week
You can use the WEEKDAY function to return the weekday of a date/time field (1-7, 1=Sunday). Use it for $TIMESTAMP$ to get current week day. For a quick-n-dirty solution, you could set a date field to: $TIMESTAMP$ - 60 * 60 * 24 * (WEEKDAY($TIMESTAMP$) - 1) This would set the field to the most recent week start date (Sunday), which your target field could be compared to - to see if it's greater than (since). I'd use a date field to force time to 00:00:00. A date/time field would need time delta from midnight stripped (a little fiddling). Mike White EMail michael.wh...@verizon.com mailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jon Chau Sent: Thursday, July 01, 2010 2:46 PM To: arslist@ARSLIST.ORG Subject: Determining Current Work Week ** Hello Listers, I'm a little stumped in trying to determine the best way to go check whether a date/time field falls within the current work week. I thought there would be a week function that return the week number of the calendar year, and I could compare that result with the current date to the specified date. There appears to be no such function. What other options do I have aside from writing and calling a SQL function to check? Thanks, Jon _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: Pooling for Escalations
It has to be 7.1, I am at a client site with 7.0.1 AR and they have No Pooling. On Jul 1, 2:07 pm, Kevin Begosh kbeg...@gmail.com wrote: Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin Begosh ___ 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: Pooling for Escalations
yeah thats what I thought too. I am looking at a 7.5 Patch 4 server though and it is not there. That is why I was asking. On Thu, Jul 1, 2010 at 3:16 PM, Chuck cpg...@gmail.com wrote: It has to be 7.1, I am at a client site with 7.0.1 AR and they have No Pooling. On Jul 1, 2:07 pm, Kevin Begosh kbeg...@gmail.com wrote: Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin Begosh ___ 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 -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Pooling for Escalations
Nevermind, I just looked and realized that the admin version on the desktop was 7.0 so that is why it was not there, sorry :0 On Thu, Jul 1, 2010 at 3:16 PM, Chuck cpg...@gmail.com wrote: It has to be 7.1, I am at a client site with 7.0.1 AR and they have No Pooling. On Jul 1, 2:07 pm, Kevin Begosh kbeg...@gmail.com wrote: Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin Begosh ___ 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 -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Pooling for Escalations
It's 7.1.00 - you can confirm it here (page 6): 06-Aug-2007 What's New: BMC Remedy Action Request System 7.1.00 PDFhttp://documents.bmc.com/supportu/documents/17/53/71753/71753.pdf Multiple escalation pools AR System server now can have multiple escalation pools so that administrators can better control the execution of escalations and the server can execute two or more escalations in parallel. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh Sent: Thursday, July 01, 2010 12:08 PM To: arslist@ARSLIST.ORG Subject: Pooling for Escalations ** Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin 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: Pooling for Escalations
thanks David Kevin On Thu, Jul 1, 2010 at 3:28 PM, Easter, David david_eas...@bmc.com wrote: ** It’s 7.1.00 – you can confirm it here (page 6): 06-Aug-2007 What’s New: BMC Remedy Action Request System 7.1.00 PDFhttp://documents.bmc.com/supportu/documents/17/53/71753/71753.pdf *Multiple escalation pools* AR System server now can have multiple escalation pools so that administrators can better control the execution of escalations and the server can execute two or more escalations in parallel. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kevin Begosh *Sent:* Thursday, July 01, 2010 12:08 PM *To:* arslist@ARSLIST.ORG *Subject:* Pooling for Escalations ** Does anyone know of the top of thier heads when the pooling option came out with ARS? Was it 7.1? evin Begosh _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: ITSM 7.6 install fails
Dennis, In the email below you said you recommend not going to ITSM 7.6 Patch 1 and wait till Patch 2. What about just 7.6? I am in the process of going to 7.6 right now and I am trying to install patch 1 and see all kinds of issues. Kevin Begosh ** ** *Date:* Mon, 26 Apr 2010 13:59:14 -0600 *Reply-To:* arslist@ARSLIST.ORG *Sender:* Action Request System discussion list(ARSList) arslist@ARSLIST.ORG *From:* Dennis Murphree dennis.murph...@raptek.com *Subject:* Re: ITSM 7.6 install fails *In-Reply-To:* 6494c91f2e527248ba672ddc34e5183e6bf...@carsc810103.nanw.ds.army.mil *Content-Type:* text/plain; charset=ISO-8859-1 Tim, I recommend not upgrading to ITSM 7.6 Patch 001 as we are seeing all kinds of issues with this patch. I would wait for Patch002 to come out. Dennis Murphree Remedy Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR US USA IMCOM Sent: Monday, April 26, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] ITSM 7.6 install fails Correction: Upgrading to ITSM 7.6 Patch 1Not Patch 2 Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hulmes, Timothy W Mr CTR US USA IMCOM Sent: Monday, April 26, 2010 11:44 AM To: arslist@ARSLIST.ORG Subject: ITSM 7.6 install fails Hi, Has anyone installed ITSM 7.6 Patch 2 as an upgrade from 7.0.3 patch 9? I get an error when it installs the ITSM Extensions. Install Exit Code: 1 The Run Extensions error(s) are as follows :- ITSM-CMDB extension #1 : Extension upgraded. ITSM-CMDB extension #1 : Extension in running state. Contact BMC Customer Support. Any ideas on how I can get past this hump? Environment ARS 7.5 Patch 4 CMDB 7.6 Patch 1 ITSM 7.0.03 Patch 9 with ITSM compatibility Patch installed SLM 7.6 Patch 1 Windows Server 2003 SQL 2005 Thanks Tim ___ 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 -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Escalation or Filter
I agree with everyone else, mainly because of threading issues. But I guess with 7 you can increase the number of escalation threads. Still, if you have a lot of other escalations, then you could potentially tie up your threads. I run 2 threads just in case something does happen to tie up 1. I do have some escalations that take a while. I was using some escalations to kick of exe files on my server to do jobs, but then I just offloaded those to sql server agent job because the remedy escalations were bogging down at night. Just bear in mind that each thread is a single-file line. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chuck Sent: Thursday, July 01, 2010 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Escalation or Filter Yup, Escalation to start the Event, Filter to Perform the Action... On Jul 1, 1:01 pm, Grooms, Frederick W frederick.w.gro...@xo.com wrote: I prefer to use the Escalation sets field and a Filter does the work method. The only real advantage of using this method is that you can test it from the user tool and log the actions locally (instead of having to read server side logs). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, July 01, 2010 11:15 AM To: arsl...@arslist.org Subject: Escalation or Filter ** Hi All From a performance perspective which would be better? Escalation on Form A set field and push fields to create a new record on Form B Escalation on Form A set field. Filter on Form A does the push fields to create a new record on Form B. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are- Hide quoted text - - Show quoted text - ___ 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: Abydos Designer
Yes. I am. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire Sent: Thursday, July 01, 2010 4:52 PM To: arslist@ARSLIST.ORG Subject: Abydos Designer Is anyone using this product? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Determining Current Work Week
Thanks for that. I also just discovered DATENUM will return the number of the week if I want. On Thu, Jul 1, 2010 at 12:09 PM, White, Michael W (MIKE) michael.wh...@verizon.com wrote: ** You can use the WEEKDAY function to return the weekday of a date/time field (1-7, 1=Sunday). Use it for $TIMESTAMP$ to get current week day. For a quick-n-dirty solution, you could set a date field to: $TIMESTAMP$ - 60 * 60 * 24 * (WEEKDAY($TIMESTAMP$) - 1) This would set the field to the most recent week start date (Sunday), which your target field could be compared to – to see if it’s greater than (since). I’d use a date field to force time to 00:00:00. A date/time field would need time delta from midnight stripped (a little fiddling). Mike White EMail michael.wh...@verizon.com Office 813.978.2192 *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jon Chau *Sent:* Thursday, July 01, 2010 2:46 PM *To:* arslist@ARSLIST.ORG *Subject:* Determining Current Work Week ** Hello Listers, I'm a little stumped in trying to determine the best way to go check whether a date/time field falls within the current work week. I thought there would be a week function that return the week number of the calendar year, and I could compare that result with the current date to the specified date. There appears to be no such function. What other options do I have aside from writing and calling a SQL function to check? Thanks, Jon _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
