Thank you Kelly. That's a much better answer than what BMC EIE Support was giving. Since the destination form that they were looking at only had three integer fields on it, that's all that they could see in that menu and that's what they expected me to see also. In their defense, they are otherwise helping a great deal.
As it turns out, there is a not-null unique column in my source table and using that for the Key field appears to have solved the duplicate record problem. Now it appears that the records aren't being updated correctly, so I may have to use the "...Only if Values Change" option after all. Drew -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kelly Deaver Sent: Friday, February 29, 2008 6:03 AM To: [email protected] Subject: Re: EIE Option question The system CAN generate the field but I like to control this myself. Create an integer field on the form you are mapping to(or Base Element if you are using it on a lot of CMDB mappings). Use that field to store the change value (a check-sum calculated by the value of all data in your mapped fields. If the sum changes, an updated/modify is needed) --------------------- Kelly Deaver [EMAIL PROTECTED] > -------- Original Message -------- > Subject: EIE Option question > From: Drew Shuller <[EMAIL PROTECTED]> > Date: Wed, February 27, 2008 9:16 am > To: [email protected] > > My EIE job pulls in duplicate records every time it runs. We think the > culprit is the fact that our key fields are also used in the field > mapping. In this case, what we need on the vendor side is a non-null > sequential number field to act as a PK. > > But what if we can't do that? How do you use "Update AR System Date > Only If Values Change" on the Options tab. Whenever I select this, a field > appears that contains the text "<system generated>." Does this mean that > Remedy will generate a field for me. A menu is attached to that field that > apparently looks at numeric fields only on my destication form. > > Drew > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
