That should read "throw an error"
You could use a secondary form to hold the import data. Then they could be compared to existing data in a join form or just through (got it right this time;^) workflow. I do this to import asset records when the inventory sweep occurs. --- 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:[email protected]] On Behalf Of Reiser, John J Sent: Wednesday, April 29, 2009 10:40 AM To: [email protected] Subject: Re: Searching for Duplicate Values Try using a unique index in the ARSystem for the form. Then the import will through an error for duplicate records. --- 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:[email protected]] On Behalf Of Pierson, Shawn Sent: Tuesday, April 28, 2009 11:06 AM To: [email protected] Subject: Re: Searching for Duplicate Values I agree with those telling you to use SQL, and if you want to perform an update via Remedy, create a view of that SQL and put a View Form on top and use an Escalation to perform the updates. However, you are getting into some tricky areas though. If they are truly duplicates, you should at some point delete one and make sure that you leave the "correct" one, e.g. the one that has things related to it. Also, can't the import process be set to update matching requests instead of blindly creating new ones? I populate my people data via an integration I built with Active Directory so I haven't tried doing what you are. ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] On Behalf Of John Quinn [[email protected]] Sent: Monday, April 27, 2009 6:21 PM To: [email protected] Subject: Searching for Duplicate Values ** Hi Listers! I have a need to find duplicate values on the People record (ITSM 7.0.1). In particular, I'm looking to find last names that are the same. We are uploading new records using the Data Management Tool and the new accounts will be used to replace the old. I can't delete the old records, so I plan to set the Profile Status of the old records to 'Offline'. Does anyone know of a search string that I can use in Advanced Search to locate those duplicate values? Thanks! John Quinn Pegasus Solutions ITSM Development ________________________________ Windows Live(tm) SkyDrive(tm): Get 25 GB of free online storage. Check it out. <http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_skydrive_04200 9> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Private and confidential as detailed here <http://www.sug.com/disclaimers/default.htm#Mail> . If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
