Are you using the "Replace Old Record with New Record" or the "Update Old Record with New Data" option?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Tuesday, May 06, 2008 12:51 PM To: [email protected] Subject: Re: AR Import into SIT:Site I'll probably just have to create a staging form and then push it over with a filter/escalation later. I just can't do it during business hours today, which is what I was hoping for. Thanks Misi -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Tuesday, May 06, 2008 12:37 PM To: [email protected] Subject: Re: AR Import into SIT:Site Hi, I guess you could temporarily disable either the filter or the index, and then fix up your related data after the import... Best Regards - Misi, RRR AB, http://rrr.se > Hey everyone > > I'm trying to use AR Import to get about 1800 sites updated with the > correct address and zip code. I'm doing an update, so I have the Site > ID field in the .csv. When I try and do the import, I get the error: > > The value(s) for this entry violate a unique index that has been > defined for this form -- SIT:Site Alias entry:STA000000006378 fields: > 1000000074 1000000078 7 1000000078 179 (ARERR 382) > > The unique index must be the Site ID, since when doing an update the > Import tool "actually deletes the record and then reinserts it to > perform the "update." " The system tries to push 'new' information to > Site Alias and causes the error since the Site ID already exists > there. > > Is there a way to force this import through? > > Thanks, > Chris > > DB SQL 2005 > ITSM 7.0 p3 > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
