A delete of a site record causes a delete of the related site alias records - check the filters! An Update is an Update with no delete. Don't use the replace option myself but that may cause a delete. Then again, I very rarely use the import tool.
One thing I do use is logging... (eh Misi?) Have you turn on logging and then read the logs to see what the problem is? I expect it is quite a simple problem at the root of your woes. /Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: May 6, 2008 10:15 PM To: arslist@ARSLIST.ORG Subject: Re: AR Import into SIT:Site The record delete must be a v7 change (Import v6 help does not mention it). I might have expected ARS to delete the record when choosing Replace in the Preferences, but I would not have expected the system to do a delete on Update (since on Update only the fields being imported are replaced). Good luck on the staging form tonight. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Tuesday, May 06, 2008 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: AR Import into SIT:Site Hey Fredrick, I'm trying to update old record with new data. According to the help file ("actually deletes the record and then reinserts it to perform the "update."), it still deletes and recreates the record when that happens, so record number 1 is deleted, a new record number 1 is created with the updated information, and then workflow is firing that pushes information to site alias fires where there is already a record number 1. Unfortunately that stops the import. Tonight I'll make a staging form and import to it, then push the data over, I was just hoping I could do it more easily. Chris -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, May 06, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: Re: AR Import into SIT:Site 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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" ________________________________________________________________________ _______ 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"
