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"
>
> --
> 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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
