Re: AR Import into SIT:Site
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:STA6378 fields:
>> 100074 100078 7 100078 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 ac
Re: AR Import into SIT:Site
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:STA6378 fields:
> 100074 100078 7 100078 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"
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:STA6378 fields:
> 100074 100078 7 100078 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"
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:STA6378 fields:
> 100074 100078 7 100078 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"
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:STA6378 fields: > 100074 100078 7 100078 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"
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:STA6378 fields: 100074 > 100078 7 100078 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"
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:STA6378 fields: 100074 > 100078 7 100078 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"
AR Import into SIT:Site
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:STA6378 fields: 100074 100078 7 100078 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"
