Hi,
It has allways worked like that.
However, there is no "delete"-operation performed that triggers filter.
This is just done as a last step on the database-level.
The only filter that triggers are on "merge".
I have talked to engineering in Vancouver, and they agreed that it would
be a good idea to redesign this to prevent the extra database overhead. It
can be a lot if the record contains attachments etc.
In other words, the problem with a push-fields to a separate form has
nothing to do with the way the AR Server "updates" your record on merge.
A staging form will change the operation from "merge" to "modify", but
that will probably not fix your initial problem either.
Best Regards - Misi, RRR AB, http://rrr.se
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
