Chris, Thanks. Some of your notes together with some stuff that Kelly Deaver (thank you Kelly) sent me offline is helping me understand what this is a little more. Until this point I had only a guess of what Response was meant for which was less than 50% correct to be honest. I don't quite like the fact that these functionalities are not documented too well on the EIE and the SQL links admin or dev guides.
I'll have a go at this tomorrow if I have the time. Thank you for your response.. Dan, thank you for maintaining this list! Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Wednesday, July 11, 2007 8:05 PM To: arslist@ARSLIST.ORG Subject: Re: Response tab in the EIE:Datamapping form ** I am using this to "clear" the update flag on the vendor form data. Our eDir LDAP system writes new and updated records to my SQL Server table with a field named RunUpdate set to a value of 1. I use the vendor query to ONLY push records from vendor form to AR form if RunUpdate = 1; then I have the setting in the Response tab reset that value in the vendor table to 0. Future passes of the data exchange skip that record until another update from LDAP sets the RunUpdate flag to 1. It works like a champ, but I had to get some coaching from Doug in support to figure out how to use it. Query Tab - Data Key Query subtab: Vendor Query: RunUpdate = 1 Response tab: AR Resp Field: constant|"0" Vendor Resp Field: RunUpdate Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/ ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, July 11, 2007 2:11 PM To: arslist@ARSLIST.ORG Subject: Response tab in the EIE:Datamapping form ** Listers, I was looking to find documentation on this, but cannot seem to find any references to this on either the eieadmin.pdf guide nor the sqlserver.pdf guide that is installed in the doc subdirectory of the EIE installation path. Does anyone know what exactly this mapping is used for? Does anyone know where to find documentations on it? Thanks Joe No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.4/896 - Release Date: 7/11/2007 4:09 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
